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);
}
}
