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