public IEnumerable <MediaType> GetMediaTypes() { SQLiteConnection connection = GetConnectionForTable("azusa.mediaTypes"); SQLiteCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM azusa.mediaTypes"; SQLiteDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { MediaType mt = new MediaType(); mt.Id = dataReader.GetInt32(0); mt.ShortName = dataReader.GetString(1); mt.LongName = dataReader.GetString(2); mt.GraphData = dataReader.GetBoolean(3); mt.DateAdded = dataReader.GetDateTime(4); mt.Icon = dataReader.GetByteArray(5); mt.IgnoreForStatistics = dataReader.GetBoolean(6); if (!dataReader.IsDBNull(8)) { mt.HasFilesystem = dataReader.GetBoolean(8); } yield return(mt); } dataReader.Dispose(); cmd.Dispose(); }
public IEnumerable <FilesystemMetadataEntity> GetFilesystemMetadata(int currentMediaId, bool dirs) { if (getFilesystemMetadataCommand == null) { getFilesystemMetadataCommand = GetConnectionForTable("azusa.filesysteminfo").CreateCommand(); getFilesystemMetadataCommand.CommandText = "SELECT * FROM azusa.filesysteminfo " + "WHERE mediaid = @mediaid " + "AND isdirectory = @isdirectory " + "ORDER BY parent ASC"; getFilesystemMetadataCommand.Parameters.Add("@mediaid", DbType.Int32); getFilesystemMetadataCommand.Parameters.Add("@isdirectory", DbType.Boolean); } getFilesystemMetadataCommand.Parameters["@mediaid"].Value = currentMediaId; getFilesystemMetadataCommand.Parameters["@isdirectory"].Value = dirs; SQLiteDataReader dataReader = getFilesystemMetadataCommand.ExecuteReader(); while (dataReader.Read()) { FilesystemMetadataEntity child = new FilesystemMetadataEntity(); child.Id = dataReader.GetInt64(0); child.MediaId = dataReader.GetInt32(1); child.DateAdded = dataReader.GetDateTime(2); child.IsDirectory = dataReader.GetBoolean(3); child.FullName = dataReader.GetString(4); if (!dataReader.IsDBNull(5)) { child.Size = dataReader.GetInt64(5); } if (!dataReader.IsDBNull(6)) { child.Modified = dataReader.GetDateTime(6); } if (!dataReader.IsDBNull(7)) { child.Header = dataReader.GetByteArray(7); } child.ParentId = dataReader.GetInt64(8); yield return(child); } dataReader.Close(); }
public Media GetMediaById(int o) { if (getMediaByIdCommand == null) { SQLiteConnection connection = GetConnectionForTable("azusa.media"); getMediaByIdCommand = connection.CreateCommand(); getMediaByIdCommand.CommandText = "SELECT * FROM azusa.media WHERE id=@id"; getMediaByIdCommand.Parameters.Add(new SQLiteParameter("@id", DbType.Int32)); } getMediaByIdCommand.Parameters["@id"].Value = o; SQLiteDataReader ndr = getMediaByIdCommand.ExecuteReader(); if (!ndr.Read()) { ndr.Dispose(); return(null); } Media m = new Media(); m.Id = ndr.GetInt32(0); m.RelatedProductId = ndr.GetInt32(1); m.Name = ndr.GetString(2); m.MediaTypeId = ndr.GetInt32(3); if (!ndr.IsDBNull(4)) { m.SKU = ndr.GetString(4); } if (!ndr.IsDBNull(5)) { m.DumpStorageSpaceId = ndr.GetInt32(5); } if (!ndr.IsDBNull(6)) { m.DumpStorageSpacePath = ndr.GetString(6); } if (!ndr.IsDBNull(7)) { m.MetaFileContent = ndr.GetString(7); } if (!ndr.IsDBNull(8)) { m.DateAdded = ndr.GetDateTime(8); } if (!ndr.IsDBNull(9)) { m.GraphDataContent = ndr.GetString(9); } if (!ndr.IsDBNull(10)) { m.CueSheetContent = ndr.GetString(10); } if (!ndr.IsDBNull(11)) { m.ChecksumContent = ndr.GetString(11); } if (!ndr.IsDBNull(12)) { m.PlaylistContent = ndr.GetString(12); } if (!ndr.IsDBNull(13)) { m.CdTextContent = ndr.GetByteArray(13); } if (!ndr.IsDBNull(14)) { m.LogfileContent = ndr.GetString(14); } if (!ndr.IsDBNull(15)) { m.MdsContent = ndr.GetByteArray(15); } m.isSealed = ndr.GetBoolean(16); if (!ndr.IsDBNull(17)) { m.DateUpdated = ndr.GetDateTime(17); } if (!ndr.IsDBNull(18)) { m.FauxHash = ndr.GetInt64(18); } ndr.Dispose(); return(m); }
public Product GetProductById(int id) { SQLiteConnection connection = GetConnectionForTable("azusa.products"); SQLiteCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM azusa.products WHERE id = @id"; cmd.Parameters.Add("@id", DbType.Int32); cmd.Parameters["@id"].Value = id; SQLiteDataReader ndr = cmd.ExecuteReader(); Product result = null; if (ndr.Read()) { result = new Product(); result.Id = ndr.GetInt32(0); result.InShelf = ndr.GetInt32(1); result.Name = ndr.GetString(2); result.Picture = ndr.GetByteArray(3); if (!ndr.IsDBNull(4)) { result.Price = ndr.GetDouble(4); } if (!ndr.IsDBNull(5)) { result.BoughtOn = ndr.GetDateTime(5); } if (!ndr.IsDBNull(6)) { result.Sku = ndr.GetString(6); } if (!ndr.IsDBNull(7)) { result.PlatformId = ndr.GetInt32(7); } if (!ndr.IsDBNull(8)) { result.SupplierId = ndr.GetInt32(8); } if (!ndr.IsDBNull(9)) { result.CountryOfOriginId = ndr.GetInt32(9); } result.Screenshot = ndr.GetByteArray(10); if (!ndr.IsDBNull(11)) { result.DateAdded = ndr.GetDateTime(11); } result.Consistent = ndr.GetBoolean(12); if (!ndr.IsDBNull(13)) { result.NSFW = ndr.GetBoolean(13); } result.Complete = ndr.GetBoolean(14); } ndr.Dispose(); cmd.Dispose(); return(result); }