public static List<Camera> GetCameras(List<int> Ids = null) { List<Camera> Cameras = new List<Camera>(); string selector = DbManager.SelectorBuilder(Ids); SqlConnection con = DbManager.GetConnection(); SqlCommand cmd = new SqlCommand(); cmd = con.CreateCommand(); cmd.CommandText = "SELECT [Id],[ShortName],[LongName],[MaxResolution],[ColorSpaces] FROM [tblCameras] " + selector; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string shortName = reader.GetString(1); string longName = reader.GetString(2); Size maxResolution = Utilities.StringToResolution(reader.GetString(3)); List<ColorSpace> colorSpaces = ColorSpaceController.GetColorSpaces( Utilities.StringToIntList(reader.GetString(4)) ); Cameras.Add(new Camera(id, shortName, longName, maxResolution, colorSpaces)); } con.Close(); return Cameras; }
public static List <Collection> GetCollections(List <int> Ids = null) { List <Collection> collections = new List <Collection>(); string selector = DbManager.SelectorBuilder(Ids); SqlConnection con = DbManager.GetConnection(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT [Id],[CaptureDateTime],[Catalogue],[Object],[ObjectTitle]," + "[NumberFrames],[FileFormat],[ColorSpace],[Camera],[Scope],[Site],[Optics]," + "[Photographer],[Resolution],[Comments],[FilePath],[MetadataFilePath] " + "FROM [tblCollections] " + selector; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); DateTime captureDateTime = reader.GetDateTime(1); Catalogue catalogue = CatalogueController.GetCatalogues(new List <int>() { reader.GetInt32(2) })[0]; int objectId = reader.GetInt32(3); string objectTitle = reader.GetString(4); int numberFrames = reader.GetInt32(5); FileFormat fileFormat = FileFormatController.GetFileFormats(new List <int>() { reader.GetInt32(6) })[0]; ColorSpace colorSpace = ColorSpaceController.GetColorSpaces(new List <int>() { reader.GetInt32(7) })[0]; Camera camera = CameraController.GetCameras(new List <int>() { reader.GetInt32(8) })[0]; Scope scope = ScopeController.GetScopes(new List <int>() { reader.GetInt32(9) })[0]; Site site = SiteController.GetSites(new List <int>() { reader.GetInt32(10) })[0]; List <Optic> optics = OpticsController.GetOptics(Utilities.StringToIntList(reader.GetString(11))); Photographer photographer = PhotographerController.GetPhotographers(new List <int>() { reader.GetInt32(12) })[0]; Size resolution = Utilities.StringToResolution(reader.GetString(13)); string comments = reader.GetString(14); string filePath = reader.GetString(15); string metadataFile = reader.GetString(16); collections.Add(new Collection(id, captureDateTime, catalogue, objectId, objectTitle, numberFrames, fileFormat, colorSpace, camera, scope, site, optics, photographer, resolution, comments, filePath, metadataFile)); } con.Close(); return(collections); }