public void InsertPill(PillReporting pillDiary)
{
IDatabase db = new Database("PillDiaryConn");
var result = db.Fetch <PillReporting>(string.Format(" select r.*, i.* from PatientMedication m INNER JOIN Patient p ON m.PatientId=p.PatientId inner join MedicationInfo i on m.MedicationId=i.Id inner join[PillReporting] r on p.PatientId = r.patientid and m.MedicationId = r.medicationid where p.patientid='{0}' and m.medicationid='{1}' order by pilltimestamp desc", pillDiary.PatientId, pillDiary.MedicationId));
if (result?.Count > 0)
{
string str = "update PillReporting set pilltimestamp='" + pillDiary.PillTimeStamp + "',PillStatus=" + Convert.ToInt16(pillDiary.PillStatus.Value) + " where patientid=" + pillDiary.PatientId + " and medicationid=" + pillDiary.MedicationId;
db.Execute(str);
}
else
{
string str = "INSERT INTO PillReporting VALUES(" + pillDiary.MedicationId + "," + pillDiary.PatientId + "," + Convert.ToInt16(pillDiary.PillStatus.Value) + ", '" + pillDiary.PillTimeStamp + "')";
db.Execute(str);
}
}
public ActionResult Insert(PillReporting reporting)
{
IPillRepository repo = new PillRepository();
try
{
if (reporting.PillTimeStamp.HasValue)
{
reporting.PillTimeStamp = DateTime.Now.Date + reporting.PillTimeStamp.Value.TimeOfDay;
}
repo.InsertPill(reporting);
}
catch (Exception ex)
{
//Log errror
}
return(Json(new { status = "success" }));
}
public void UpdatePill(PillReporting pillDiary)
{
IDatabase db = new Database("PillDiaryConn");
db.Update(pillDiary);
}