• Home
• Nagru___Manga_Organizer
• SQL

C# Class Nagru___Manga_Organizer.SQL

显示文件 Open project: Nagru/Manga-Organizer Class Usage Examples

Public Methods

Method	Description
BeginTransaction ( ) : int	Starts a new transaction USE WITH CAUTION: SQLite DOES NOT SUPPORT MULTIPLE TRANSACTIONS
CleanUpArtists ( ) : int	Deletes all unused artists from the DB
CleanUpReferences ( ) : int	Re-creates the MangaTag table to remove PK value gaps
CleanUpTags ( ) : int	Deletes all unused tags from the DB
CommitTransaction ( ) : int	Commits the current transaction
Connect ( ) : bool	Opens a connection to the database and imports any previous Manga DB's if possible
ContainsEntry ( string Artist, string Title ) : bool	Returns whether the entry exists in the DB
DeleteManga ( int mangaID ) : bool	Deletes an entry from the database
DeleteTag ( string TagText ) : int	Deletes a tag based on the text passed in
Disconnect ( bool Recycle = false ) : void	Vacuum's the DB and closes the connection
GetAllManga ( string SearchText = null, int MangaID = -1 ) : DataTable	Returns the details of every manga in the database
GetArtists ( ) : string[]	Returns all the artists in the database
GetDefaultType ( ) : string	Returns the default manga category
GetLogContents ( ) : DataTable	Returns the details of everything logged so far
GetManga ( int mangaID ) : DataTable	Returns the full details of a specified manga
GetMangaDetail ( int mangaID, Manga Column ) : string	Returns a single detail of a specified manga
GetMangaTitle ( int mangaID ) : string	Returns the EH formatted title of a Manga
GetSetting ( Setting DBSetting ) : object	Returns a setting from the DB
GetTags ( ) : string[]	Returns all the tags in the database
GetThumbnail ( int MangaID ) : Image	Returns the manga's thumbnail
GetTypes ( ) : string[]	Returns all the manga types in the database
HasThumbnail ( int MangaID ) : bool	Returns true if the entry has a thumbnail for it
IsConnected ( ) : bool	Returns whether or not the DB connection is currently open
LogMessage ( Exception exception, EventType eventType, object Source = null ) : bool	Logs exception details to the DB to support future debugging
LogMessage ( string LogMessage, EventType eventType, object Source = null ) : bool	Logs exception details to the DB to support future debugging
RollbackTransaction ( ) : int	Rollbacks the current transaction
SaveManga ( string Artist, string Title, System.DateTime PublishedDate, string Tags = null, string Location = null, decimal Pages, int PageReadCount = -1, string Type = null, decimal Rating, string Description = null, string URL = null, bool ReadManga = false, int MangaID = -1 ) : int	Insert or updates a manga
SaveReadProgress ( int MangaID, int PageReadCount = -1 ) : int	Stores the last page read of a manga and updates it's read status
SaveThumbnail ( int MangaID, Image image ) : bool	Saves a thumbnail image to the database
UpdateSetting ( Setting DBSetting, object setting ) : bool	Update the indicated setting
VacuumDatabase ( ) : bool	Runs the vacuum command on the database to reduce filesize if possible

Private Methods

Method	Description
SQL ( ) : System	Instantiates the non-static sqlBase that holds the DB connection

Method Details