public bool Save(TreatmentModel model)
{
if (CheckExisting(model.Id))
{
return(Update(model));
}
else
{
return(Add(model));
}
}
bool Update(TreatmentModel model)
{
try
{
var sql = string.Format("UPDATE [dbo].[uSomeTreatment] SET [TreatmentTypeId] = '{0}', [HospitalId] = '{1}', [TreatmentDate] = '{2}' WHERE id={3}",
model.TreatmentTypeId, model.HospitalId, model.TreatmentDate, model.Id);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on updating treatment ::" + ex.Message);
return(false);
}
}
bool Add(TreatmentModel model)
{
try
{
var sql = string.Format(@"INSERT INTO [dbo].[uSomeTreatment]
([UserId],[TreatmentTypeId],[HospitalId],[TreatmentDate])
VALUES ('{0}','{1}','{2}','{3}')",
model.UserId, model.TreatmentTypeId, model.HospitalId, model.TreatmentDate);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on adding treatment ::" + ex.Message);
return(false);
}
}
public ActionResult UpdateMemberTreatment(TreatmentModel model)
{
try
{
var member = Member.GetCurrentMember();
member.getProperty("treatmentPhase").Value = model.TreatmentPhase;
member.getProperty("isInterested").Value = model.IsInterested;
member.Save();
TempData["SuccessMessage"] = "Treatment Methodology details Saved";
return(RedirectToCurrentUmbracoPage());
}
catch (Exception ex)
{
Log.ErrorLog("Error in Treatment :: " + ex.Message);
TempData["ErrorMessage"] = "Treatment not saved";
return(CurrentUmbracoPage());
}
}
public JsonResult AddTreatment(int treatmentTypeId, int hospitalId, DateTime treatmentDate, int userId, int id)
{
try
{
var model = new TreatmentModel
{
TreatmentTypeId = treatmentTypeId,
HospitalId = hospitalId,
TreatmentDate = treatmentDate,
UserId = userId,
Id = id
};
t.Save(model);
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Log.ErrorLog("Error in Treatment :: " + ex.Message);
return(Json(new { result = "fail" }, JsonRequestBehavior.AllowGet));
}
}
private IList <TreatmentModel> GetTreatment(string sqlText)
{
var treatmentList = new List <TreatmentModel>();
var dr = _dataHelper.ExecuteReader(sqlText);
if (dr.HasRecords)
{
while (dr.Read())
{
var treatment = new TreatmentModel();
treatment.Id = dr.GetInt("Id");
treatment.UserId = dr.GetInt("userId");
treatment.TreatmentTypeId = dr.GetInt("treatmentTypeId");
treatment.HospitalId = dr.GetInt("hospitalId");
treatment.TreatmentDate = dr.GetDateTime("treatmentDate");
treatment.CreatedOn = dr.GetDateTime("createdOn");
treatmentList.Add(treatment);
}
}
return(treatmentList);
}
