private bool IsFormAlreadyExist(gFormSavedModel model)
{
var db = new LTCDataModel.PetaPoco.Database(DbConfiguration.LtcForm);
var id = db.Fetch <int>($"SELECT SavedFormID FROM _form_saved where office_sequence={model.Office_Sequence} and FormID={model.FormID} and PatientNumber={model.PatientNumber}").FirstOrDefault();
if (id == 0)
{
return(false);
}
return(true);
}
public string SaveFormAnswer(gFormSavedModel model)
{
if (!IsFormAlreadyExist(model))
{
var db = new LTCDataModel.PetaPoco.Database(DbConfiguration.LtcForm);
model.SystemDate = DateTime.Now;
db.Save(model);
return("Form Saved Succefully");
}
return("Form Already Exists");
}
