public bool LoadMedicationSpread()
{
SQLiteDatabase sqlDatabase = null;
try
{
var sql = @"SELECT [Dosage], [FoodRelevance] FROM [MedicationSpread] WHERE [ID] = ? AND [MedicationID] = ?";
string[] values = new string[]
{
ID.ToString(),
MedicationID.ToString()
};
Globals dbHelp = new Globals();
dbHelp.OpenDatabase();
sqlDatabase = dbHelp.GetSQLiteDatabase();
if (sqlDatabase != null)
{
if (sqlDatabase.IsOpen)
{
ICursor medicationItem = sqlDatabase.RawQuery(sql, values);
if (medicationItem.Count > 0)
{
medicationItem.MoveToFirst();
MedicationTakeTime = new MedicationTime();
MedicationTakeTime.LoadMedicationTime(ID);
MedicationTakeReminder = new MedicationReminder();
MedicationTakeReminder.LoadMedicationTime(ID);
if (!MedicationTakeReminder.IsSet)
{
MedicationTakeReminder = null;
}
Dosage = medicationItem.GetInt(medicationItem.GetColumnIndex("Dosage"));
FoodRelevance = (ConstantsAndTypes.MEDICATION_FOOD)medicationItem.GetInt(medicationItem.GetColumnIndex("FoodRelevance"));
}
else
{
dbHelp.CloseDatabase();
return(false);
}
}
dbHelp.CloseDatabase();
}
return(true);
}
catch (Exception e)
{
Log.Error(TAG, "LoadMedicationSpread: Exception - " + e.Message);
if (sqlDatabase != null && sqlDatabase.IsOpen)
{
sqlDatabase.Close();
}
return(false);
}
}
public bool Save(int medicationSpreadID)
{
SQLiteDatabase sqlDatabase = null;
try
{
Globals dbHelp = new Globals();
dbHelp.OpenDatabase();
sqlDatabase = dbHelp.GetSQLiteDatabase();
if (sqlDatabase != null)
{
if (sqlDatabase.IsOpen)
{
if (IsNew)
{
Log.Info(TAG, "Save: New Reminder to Save for Spread with ID - " + medicationSpreadID.ToString());
ContentValues values = new ContentValues();
values.Put("MedicationSpreadID", medicationSpreadID);
values.Put("MedicationDay", (int)MedicationDay);
values.Put("MedicationTime", string.Format("{0:HH:mm:ss}", MedicationTime));
Log.Info(TAG, "Save: Saved Medication Day - " + StringHelper.DayStringForConstant(MedicationDay) + ", Medication Time - " + MedicationTime.ToShortTimeString());
ID = (int)sqlDatabase.Insert("MedicationReminder", null, values);
Log.Info(TAG, "Save: Reminder saved with new ID - " + ID.ToString());
IsNew = false;
IsDirty = false;
IsSet = true;
Log.Info(TAG, "Save: IsNew - FALSE, IsDirty - FALSE");
}
if (IsDirty)
{
Log.Info(TAG, "Save: Updating existing Reminder, ID - " + ID.ToString());
ContentValues values = new ContentValues();
values.Put("MedicationSpreadID", medicationSpreadID);
values.Put("MedicationDay", (int)MedicationDay);
values.Put("MedicationTime", string.Format("{0:HH:mm:ss}", MedicationTime));
Log.Info(TAG, "Save: Stored Medication Day - " + StringHelper.DayStringForConstant(MedicationDay) + ", Medication Time - " + MedicationTime.ToShortTimeString());
string whereClause = "ID = ?";
sqlDatabase.Update("MedicationReminder", values, whereClause, new string[] { ID.ToString() });
IsDirty = false;
Log.Info(TAG, "Save: Updated, IsDirty - FALSE");
}
sqlDatabase.Close();
return(true);
}
}
return(false);
}
catch (Exception e)
{
Log.Error(TAG, "Save: Exception - " + e.Message);
return(false);
}
}