public static int InsertObject(object obj) { int result = 0; if (obj.GetType() == typeof(Project)) { Project objProject = (Project)obj; result = DatabaseFile.GetConnection().Insert(objProject); } else if (obj.GetType() == typeof(Trip)) { Trip objTrip = (Trip)obj; result = DatabaseFile.GetConnection().Insert(objTrip); } else if (obj.GetType() == typeof(Site)) { Site objSite = (Site)obj; result = DatabaseFile.GetConnection().Insert(objSite); } else if (obj.GetType() == typeof(Specimen)) { Specimen objSpecimen = (Specimen)obj; result = DatabaseFile.GetConnection().Insert(objSpecimen); } return(result); }
public static bool CheckExists(object obj, string name) { bool exists = false; if (obj.GetType() == typeof(Project)) { Project objProject = (Project)obj; List <Project> queryResult = DatabaseFile.GetConnection().Query <Project>("select * from Project where ProjectName = '" + name + "'"); if (queryResult.Count > 0) { exists = true; } } else if (obj.GetType() == typeof(Trip)) { Trip objTrip = (Trip)obj; List <Trip> queryResult = DatabaseFile.GetConnection().Query <Trip>("select * from Trip where TripName = '" + name + "'"); if (queryResult.Count > 0) { exists = true; } } else if (obj.GetType() == typeof(Site)) { Site objSite = (Site)obj; List <Site> queryResult = DatabaseFile.GetConnection().Query <Site>("select * from Site where SiteName = '" + name + "'"); if (queryResult.Count > 0) { exists = true; } } else if (obj.GetType() == typeof(Specimen)) { Specimen objSpecimen = (Specimen)obj; List <Specimen> queryResult = DatabaseFile.GetConnection().Query <Specimen>("select * from Specimen where SpecimenName = '" + name + "'"); if (queryResult.Count > 0) { exists = true; } } return(exists); }
public static int GetSpecimenCount() { int count = 0; try { count = DatabaseFile.GetConnection().Query <Specimen>("select * from Specimen").Count; } catch (Exception ex) { Debug.WriteLine(ex.Message); count = 0; } return(count); }
public static List <Site> GetSites(string TripName) { return(DatabaseFile.GetConnection().Query <Site>("select * from Site where TripName = '" + TripName + "'")); }
public static List <Trip> GetTrips(string ProjectName) { return(DatabaseFile.GetConnection().Query <Trip>("select * from Trip where ProjectName = '" + ProjectName + "'")); }
public static List <Project> GetProjects() { return(DatabaseFile.GetConnection().Query <Project>("select * from Project")); }
public static Site GetSiteByName(string name) { List <Site> results = DatabaseFile.GetConnection().Query <Site>("select * from Site where SiteName = '" + name + "'"); return(results.Count > 0 ? results[0] : null); }
public static Trip GetTripByName(string name) { List <Trip> results = DatabaseFile.GetConnection().Query <Trip>("select * from Trip where TripName = '" + name + "'"); return(results.Count > 0 ? results[0] : null); }
public static int GetAllSitesCount() { return(DatabaseFile.GetConnection().Query <Site>("select * from Site").Count); }
public static int GetAllTripsCount() { return(DatabaseFile.GetConnection().Query <Trip>("select * from Trip").Count); }
public static int GetAllProjectsCount() { return(DatabaseFile.GetConnection().Query <Project>("select * from Project").Count); }
public static List <Specimen> GetSpecimen(string SiteName) { return(DatabaseFile.GetConnection().Query <Specimen>("select * from Specimen where SiteName = '" + SiteName + "'")); }