public ActionResult MedicalSchedule(MedicalSchedule obj, FormCollection fc) { try { BL_MedicalSchedule Bl_Dept = new BL_MedicalSchedule(); if (obj.generalLedgerPosting == "on") { obj.generalLedgerPosting = Convert.ToString(true); } else if (obj.generalLedgerPosting == "null") { obj.generalLedgerPosting = Convert.ToString(false); } else { obj.generalLedgerPosting = Convert.ToString(false); } if (obj.showDetailsInReports == "on") { obj.showDetailsInReports = Convert.ToString(true); } else if (obj.showDetailsInReports == null) { obj.showDetailsInReports = Convert.ToString(false); } else { obj.showDetailsInReports = Convert.ToString(false); } if (Bl_Dept.Save(obj)) { if (obj.ScheduleID > 0) { ModelState.Clear(); TempData["Msg"] = " Medical Schedule Updated Successfully"; return(RedirectToAction("MedicalSchedule", "MedicalSchedule")); } else { ModelState.Clear(); TempData["Msg"] = " Medical Schedule Saved Successfully"; return(RedirectToAction("MedicalSchedule", "MedicalSchedule")); } } return(RedirectToAction("MedicalSchedule", "MedicalSchedule")); } catch (Exception) { return(RedirectToAction("MedicalSchedule", "MedicalSchedule")); } }
public bool Save(MedicalSchedule obj) { try { Connect(); SqlCommand cmd = new SqlCommand("IUMedicalSchedule", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.ScheduleID == 0) { cmd.Parameters.AddWithValue("@ScheduleID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@ScheduleID", obj.ScheduleID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@MasterScheduleID", obj.MasterScheduleName); cmd.Parameters.AddWithValue("@ScheduleName", obj.scheduleName); cmd.Parameters.AddWithValue("@Nature", obj.Nature); if (obj.BPT == null) { cmd.Parameters.AddWithValue("@BPT", 0); } else { cmd.Parameters.AddWithValue("@BPT", obj.BPT); } if (obj.generalLedgerPosting == null) { cmd.Parameters.AddWithValue("@GeneralLedgerPosting", 0); } else { cmd.Parameters.AddWithValue("@GeneralLedgerPosting", obj.generalLedgerPosting); } if (obj.showDetailsInReports == null) { cmd.Parameters.AddWithValue("@ShowDetailsInReports", 0); } else { cmd.Parameters.AddWithValue("@ShowDetailsInReports", obj.showDetailsInReports); } cmd.Parameters.AddWithValue("@ReferenceCode", 0); cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(RedirectToAction("Error", new { message = ex.Message })); } }