public static void DeleteGeneralUse(GeneralUseModel generalUseModel) { using (SQLite.SQLiteConnection connection = new SQLite.SQLiteConnection(generalUseDatabasePath)) { connection.CreateTable <GeneralUseModel>(); connection.Delete(generalUseModel); } }
public static void UpdateDrug(DrugModel selectedDrugModel, string drugName, GeneralUseModel generalUse) { selectedDrugModel.DrugName = drugName; selectedDrugModel.GeneralUse = generalUse.GeneralUse; using (SQLite.SQLiteConnection connection = new SQLite.SQLiteConnection(drugDatabasePath)) { connection.CreateTable <DrugModel>(); connection.Update(selectedDrugModel); } }
public static void UpdateGeneralUse(GeneralUseModel selectedGeneralUseModel, string generalUse) { // Update the general use of the selected general use model selectedGeneralUseModel.GeneralUse = generalUse; using (SQLite.SQLiteConnection connection = new SQLite.SQLiteConnection(generalUseDatabasePath)) { connection.CreateTable <GeneralUseModel>(); connection.Update(selectedGeneralUseModel); } }
public static void AddGeneralUse(string generalUseString) { GeneralUseModel model = new GeneralUseModel(); model.GeneralUse = generalUseString; using (SQLite.SQLiteConnection connection = new SQLite.SQLiteConnection(generalUseDatabasePath)) { connection.CreateTable <GeneralUseModel>(); connection.Insert(model); } }
public static void AddDrug(string drugName, GeneralUseModel generalPurpose) { DrugModel newDrug = new DrugModel(); newDrug.DrugName = drugName; newDrug.GeneralUse = generalPurpose.GeneralUse; newDrug.DateAdded = DateTime.Now; newDrug.LastUpdated = DateTime.Now; using (SQLite.SQLiteConnection connection = new SQLite.SQLiteConnection(drugDatabasePath)) { connection.CreateTable <DrugModel>(); connection.Insert(newDrug); } }