C# Class vwarDAL.MySqlMetadataStore

Inheritance: vwarDAL.IMetadataStore
Show file Open project: adlnet/3D-Repository

Public Methods

Method Description
AddMissingTexture ( vwarDAL.ContentObject co, string filename, string type, int UVset ) : bool

AddSupportingFile ( vwarDAL.ContentObject co, string filename, string description, string dsid ) : void

AddTextureReference ( vwarDAL.ContentObject co, string filename, string type, int UVset ) : bool

DeleteContentObject ( vwarDAL.ContentObject co ) : void

Dispose ( ) : void
GetAllContentObjects ( ) : IEnumerable

GetAllContentObjects ( string UserName ) : IEnumerable
GetContentObjectById ( string pid, bool updateViews, bool getReviews = true, int revision = -1 ) : vwarDAL.ContentObject

GetContentObjectCount ( string identity ) : int
GetContentObjectsByField ( string field, string value, string identity ) : IEnumerable
GetContentObjectsByKeywords ( string keywords, string identity ) : IEnumerable
GetObjectsWithRange ( string query, int count, int start, SortOrder order, string username ) : IEnumerable

IncrementDownloads ( string id ) : void

InsertContentObject ( vwarDAL.ContentObject co ) : void

InsertContentRevision ( vwarDAL.ContentObject co ) : void

InsertReview ( int rating, string text, string submitterEmail, string contentObjectId ) : void

KillODBCConnection ( System myConn ) : bool
MySqlMetadataStore ( string connectionString ) : System

RemoveAllKeywords ( vwarDAL.ContentObject co ) : bool

RemoveKeyword ( vwarDAL.ContentObject co, string keyword ) : bool

RemoveMissingTexture ( vwarDAL.ContentObject co, string filename ) : bool

RemoveSupportingFile ( vwarDAL.ContentObject co, string filename ) : bool

RemoveTextureReference ( vwarDAL.ContentObject co, string filename ) : bool

UpdateContentObject ( vwarDAL.ContentObject co ) : void

Private Methods

Method Description
FillCommandFromContentObject ( vwarDAL.ContentObject co, System.Data.Odbc.OdbcCommand command ) : void

FillContentObjectFromResultSet ( vwarDAL.ContentObject co, System.Data.Odbc.OdbcDataReader resultSet ) : void

FillContentObjectLightLoad ( vwarDAL.ContentObject co, System.Data.Odbc.OdbcDataReader resultSet ) : void

GetConnection ( ) : System.Data.Odbc.OdbcConnection
LoadKeywords ( System.Data.Odbc.OdbcConnection conn, string PID ) : String

LoadMissingTextures ( vwarDAL.ContentObject co, System.Data.Odbc.OdbcConnection connection ) : void

LoadReviews ( vwarDAL.ContentObject co, System.Data.Odbc.OdbcConnection connection ) : void

LoadSupportingFiles ( vwarDAL.ContentObject co, System.Data.Odbc.OdbcConnection connection ) : bool

LoadTextureReferences ( vwarDAL.ContentObject co, System.Data.Odbc.OdbcConnection connection ) : void

SaveKeywords ( System.Data.Odbc.OdbcConnection conn, vwarDAL.ContentObject co, int id ) : void

setContentObjectCount ( System.Data.Odbc.OdbcConnection conn, string identity ) : void

Method Details

AddMissingTexture() public method

public AddMissingTexture ( vwarDAL.ContentObject co, string filename, string type, int UVset ) : bool
co vwarDAL.ContentObject
filename string
type string
UVset int
return bool

AddSupportingFile() public method

public AddSupportingFile ( vwarDAL.ContentObject co, string filename, string description, string dsid ) : void
co vwarDAL.ContentObject
filename string
description string
dsid string
return void

AddTextureReference() public method

public AddTextureReference ( vwarDAL.ContentObject co, string filename, string type, int UVset ) : bool
co vwarDAL.ContentObject
filename string
type string
UVset int
return bool

DeleteContentObject() public method

public DeleteContentObject ( vwarDAL.ContentObject co ) : void
co vwarDAL.ContentObject
return void

Dispose() public method

public Dispose ( ) : void
return void

GetAllContentObjects() public method

public GetAllContentObjects ( ) : IEnumerable
return IEnumerable

GetAllContentObjects() public method

public GetAllContentObjects ( string UserName ) : IEnumerable
UserName string
return IEnumerable

GetContentObjectById() public method

public GetContentObjectById ( string pid, bool updateViews, bool getReviews = true, int revision = -1 ) : vwarDAL.ContentObject
pid string
updateViews bool
getReviews bool
revision int
return vwarDAL.ContentObject

GetContentObjectCount() public method

public GetContentObjectCount ( string identity ) : int
identity string
return int

GetContentObjectsByField() public method

public GetContentObjectsByField ( string field, string value, string identity ) : IEnumerable
field string
value string
identity string
return IEnumerable

GetContentObjectsByKeywords() public method

public GetContentObjectsByKeywords ( string keywords, string identity ) : IEnumerable
keywords string
identity string
return IEnumerable

GetObjectsWithRange() public method

public GetObjectsWithRange ( string query, int count, int start, SortOrder order, string username ) : IEnumerable
query string
count int
start int
order SortOrder
username string
return IEnumerable

IncrementDownloads() public method

public IncrementDownloads ( string id ) : void
id string
return void

InsertContentObject() public method

public InsertContentObject ( vwarDAL.ContentObject co ) : void
co vwarDAL.ContentObject
return void

InsertContentRevision() public method

public InsertContentRevision ( vwarDAL.ContentObject co ) : void
co vwarDAL.ContentObject
return void

InsertReview() public method

public InsertReview ( int rating, string text, string submitterEmail, string contentObjectId ) : void
rating int
text string
submitterEmail string
contentObjectId string
return void

KillODBCConnection() public static method

public static KillODBCConnection ( System myConn ) : bool
myConn System
return bool

MySqlMetadataStore() public method

public MySqlMetadataStore ( string connectionString ) : System
connectionString string
return System

RemoveAllKeywords() public method

public RemoveAllKeywords ( vwarDAL.ContentObject co ) : bool
co vwarDAL.ContentObject
return bool

RemoveKeyword() public method

public RemoveKeyword ( vwarDAL.ContentObject co, string keyword ) : bool
co vwarDAL.ContentObject
keyword string
return bool

RemoveMissingTexture() public method

public RemoveMissingTexture ( vwarDAL.ContentObject co, string filename ) : bool
co vwarDAL.ContentObject
filename string
return bool

RemoveSupportingFile() public method

public RemoveSupportingFile ( vwarDAL.ContentObject co, string filename ) : bool
co vwarDAL.ContentObject
filename string
return bool

RemoveTextureReference() public method

public RemoveTextureReference ( vwarDAL.ContentObject co, string filename ) : bool
co vwarDAL.ContentObject
filename string
return bool

UpdateContentObject() public method

public UpdateContentObject ( vwarDAL.ContentObject co ) : void
co vwarDAL.ContentObject
return void