public static List <Project> GetProjectsByClientId(int _clientId) { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { return(db.Table <Project>().Where(p => p.ClientId == _clientId).ToList()); } }
public static List <Task> GetTasks() { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { return(db.Table <Task>().ToList()); } }
public static List <Client> GetClients() { // Preconditons: database exists DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { return(db.Table <Client>().ToList()); } }
public static List <Project> GetProjects() { // Preconditon: database exists with Project table DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { return(db.Table <Project>().ToList()); } }
public static void AddClient(Client _newClient) { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { // Precondition: given client ojbect is not null if (_newClient != null) { db.Insert(_newClient); } } }
public static void DeleteProject(Client _client) { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { //Preconditon: client to delete must exist if (_client.Exists()) { db.Delete(_client); } } }
public static void DeleteProject(Project _project) { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { // Precondition: project must already exist if (_project.Exists()) { db.Delete(_project); } } }
public static void AddProject(Project _newProject) { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { // Precondition: new project must not already exist but provided project must if (GetProjectByName(_newProject.Name) == null && _newProject != null) { db.Insert(_newProject); } } }
public static void DeleteTask(Task _task) { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { // Precondtion given task is not null if (_task != null) { db.Delete(_task); } } }
public static Client GetClientById(int _clientId) { DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { // Preconditon: database exists with Client table and row with provided client name try { return(db.Table <Client>().Where(c => c.Id == _clientId).First()); } catch { return(null); } } }
public static Project GetProjectById(int _projectId) { // Preconditon: database exists with Project table and row containing given project Id DatabaseExceptions.ValidateConnectionString(_databaseFile); using (var db = new SQLiteConnection(_databaseFile, true)) { try { return(db.Table <Project>().Where(p => p.Id == _projectId).First()); } catch { return(null); } } }