public ActionResult SMSSetting(KeystoneProject.Models.Master.SMSSetting SMSSetting) { ViewData["smssave"] = "0"; Buisness_Logic.Master.BL_SMSSetting setting = new Buisness_Logic.Master.BL_SMSSetting(); Buisness_Logic.Master.BL_SMSSetting setting1 = new Buisness_Logic.Master.BL_SMSSetting(); SMSSetting.dsparamiter = setting.GetMasterSmsDetails(); SMSSetting.dsparamiter1 = setting1.GetSMSSetting(); if (SMSSetting.dsparamiter.Tables[1].Rows.Count != 0) { SMSSetting.MobileSMSID = Convert.ToInt32(SMSSetting.dsparamiter.Tables[1].Rows[0]["MobileSMSID"].ToString()); SMSSetting.IPDAddimisionDrSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDAddimisionDrSMS"].ToString(); SMSSetting.IPDDischargeDrSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDDischargeDrSMS"].ToString(); SMSSetting.IPDAddimisionPSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDAddimisionPSMS"].ToString(); SMSSetting.OPDRegDrSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["OPDRegDrSMS"].ToString(); SMSSetting.IPDDischargePSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDDischargePSMS"].ToString(); SMSSetting.IPDAddimisionCDrSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDAddimisionCDrSMS"].ToString(); SMSSetting.IPDDischargeCDrSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDDischargeCDrSMS"].ToString(); SMSSetting.AppointmentPSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["AppointmentPSMS"].ToString(); SMSSetting.AppointmentCDrSMS = SMSSetting.dsparamiter.Tables[1].Rows[0]["AppointmentCDrSMS"].ToString(); // SMSSetting.IPDDischargeP = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDDischargeP"].ToString(); // SMSSetting.IPDAdmissionCDr = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDAddimisionCDr"].ToString(); // SMSSetting.IPDDischargeCDr = SMSSetting.dsparamiter.Tables[1].Rows[0]["IPDDischargeCDr"].ToString(); // SMSSetting.AppointmentP = SMSSetting.dsparamiter.Tables[1].Rows[0]["AppointmentP"].ToString(); // SMSSetting.AppointmentCDr = SMSSetting.dsparamiter.Tables[1].Rows[0]["AppointmentCDr"].ToString(); } if (SMSSetting.dsparamiter1.Tables[0].Rows.Count != 0) { SMSSetting.MasterSettingID = Convert.ToInt32(SMSSetting.dsparamiter1.Tables[0].Rows[0]["MasterSettingID"].ToString()); SMSSetting.chkIPDAddimisionDrSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["IPDAddimisionDrSMS"].ToString()); SMSSetting.chkIPDDischargeDrSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["IPDDischargeDrSMS"].ToString()); SMSSetting.chkIPDAddimisionPSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["IPDAddimisionPSMS"].ToString()); SMSSetting.chkOPDRegDrSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["OPDRegDrSMS"].ToString()); SMSSetting.chkIPDDischargePSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["IPDDischargePSMS"].ToString()); SMSSetting.chkIPDAddimisionCDrSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["IPDAddimisionCDrSMS"].ToString()); SMSSetting.chkIPDDischargeCDrSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["IPDDischargeCDrSMS"].ToString()); SMSSetting.chkAppointmentPSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["AppointmentPSMS"].ToString()); SMSSetting.chkAppointmentCDrSMS = Convert.ToBoolean(SMSSetting.dsparamiter1.Tables[0].Rows[0]["AppointmentCDrSMS"].ToString()); } return(View(SMSSetting)); }
public JsonResult GetMasterSmsDetails() { KeystoneProject.Buisness_Logic.Master.BL_SMSSetting Bl_obj = new Buisness_Logic.Master.BL_SMSSetting(); KeystoneProject.Models.Master.SMSSetting AddServiceMod = new Models.Master.SMSSetting(); AddServiceMod.dsparamiter = Bl_obj.GetMasterSmsDetails(); List <KeystoneProject.Models.Master.SMSSetting> search = new List <KeystoneProject.Models.Master.SMSSetting>(); foreach (DataRow dr in AddServiceMod.dsparamiter.Tables[0].Rows) { search.Add(new KeystoneProject.Models.Master.SMSSetting { PARAMETER = dr["PARAMETER"].ToString(), }); } return(new JsonResult { Data = search, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult SMSSetting(FormCollection fc) { KeystoneProject.Models.Master.SMSSetting obj = new Models.Master.SMSSetting(); if (fc["chkIPDAddimisionDrSMS"] == null) { obj.chkIPDAddimisionDrSMS = false; } else { obj.chkIPDAddimisionDrSMS = true; } if (fc["chkIPDDischargeDrSMS"] == null) { obj.chkIPDDischargeDrSMS = false; } else { obj.chkIPDDischargeDrSMS = true; } if (fc["chkIPDAddimisionPSMS"] == null) { obj.chkIPDAddimisionPSMS = false; } else { obj.chkIPDAddimisionPSMS = true; } if (fc["chkOPDRegDrSMS"] == null) { obj.chkOPDRegDrSMS = false; } else { obj.chkOPDRegDrSMS = true; } if (fc["chkIPDDischargePSMS"] == null) { obj.chkIPDDischargePSMS = false; } else { obj.chkIPDDischargePSMS = true; } if (fc["chkIPDDischargePSMS"] == null) { obj.chkIPDDischargePSMS = false; } else { obj.chkIPDDischargePSMS = true; } if (fc["chkIPDAddimisionCDrSMS"] == null) { obj.chkIPDAddimisionCDrSMS = false; } else { obj.chkIPDAddimisionCDrSMS = true; } if (fc["chkIPDDischargeCDrSMS"] == null) { obj.chkIPDDischargeCDrSMS = false; } else { obj.chkIPDDischargeCDrSMS = true; } if (fc["chkAppointmentPSMS"] == null) { obj.chkAppointmentPSMS = false; } else { obj.chkAppointmentPSMS = true; } if (fc["chkAppointmentCDrSMS"] == null) { obj.chkAppointmentCDrSMS = false; } else { obj.chkAppointmentCDrSMS = true; } obj.IPDAddimisionDrSMS = fc["IPDAddimisionDrSMS"]; obj.IPDDischargeDrSMS = fc["IPDDischargeDrSMS"]; obj.IPDAddimisionPSMS = fc["IPDAddimisionPSMS"]; obj.OPDRegDrSMS = fc["OPDRegDrSMS"]; obj.IPDDischargePSMS = fc["IPDDischargePSMS"]; obj.IPDAddimisionCDrSMS = fc["IPDAddimisionCDrSMS"]; obj.IPDDischargeCDrSMS = fc["IPDDischargeCDrSMS"]; obj.AppointmentPSMS = fc["AppointmentPSMS"]; obj.AppointmentCDrSMS = fc["AppointmentCDrSMS"]; HospitalLocationID(); Connect(); DataSet dsMasterSetting = new DataSet(); SqlCommand cmd1 = new SqlCommand("GetMasterSetting", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@HospitalID", HospitalID); cmd1.Parameters.AddWithValue("@LocationID", LocationID); con.Open(); SqlDataAdapter ad1 = new SqlDataAdapter(); ad1.SelectCommand = cmd1; ad1.Fill(dsMasterSetting); con.Close(); dsMasterSetting.Tables[0].Rows[0]["IPDAddimisionDrSMS"] = obj.chkIPDAddimisionDrSMS; dsMasterSetting.Tables[0].Rows[0]["MasterSettingID"] = obj.MasterSettingID; dsMasterSetting.Tables[0].Rows[0]["IPDDischargeDrSMS"] = obj.chkIPDDischargeDrSMS; dsMasterSetting.Tables[0].Rows[0]["IPDAddimisionPSMS"] = obj.chkIPDAddimisionPSMS; dsMasterSetting.Tables[0].Rows[0]["OPDRegDrSMS"] = obj.chkOPDRegDrSMS; dsMasterSetting.Tables[0].Rows[0]["IPDDischargePSMS"] = obj.chkIPDDischargePSMS; dsMasterSetting.Tables[0].Rows[0]["IPDAddimisionCDrSMS"] = obj.chkIPDAddimisionCDrSMS; dsMasterSetting.Tables[0].Rows[0]["IPDDischargeCDrSMS"] = obj.chkIPDDischargeCDrSMS; dsMasterSetting.Tables[0].Rows[0]["AppointmentPSMS"] = obj.chkAppointmentPSMS; dsMasterSetting.Tables[0].Rows[0]["AppointmentCDrSMS"] = obj.chkAppointmentCDrSMS; DataSet dschkmastersetting = new DataSet(); SqlCommand cmdchk = new SqlCommand("update MasterSetting set IPDAddimisionCDrSMS='" + obj.chkIPDAddimisionCDrSMS + "', OPDRegDrSMS='" + obj.chkOPDRegDrSMS + "' ,IPDAddimisionDrSMS='" + obj.chkIPDAddimisionDrSMS + "' ,IPDAddimisionPSMS='" + obj.chkIPDAddimisionPSMS + "' ,IPDDischargeDrSMS='" + obj.chkIPDDischargeDrSMS + "' ,IPDDischargePSMS='" + obj.chkIPDDischargePSMS + "',IPDDischargeCDrSMS='" + obj.chkIPDDischargeCDrSMS + "',AppointmentCDrSMS='" + obj.chkAppointmentCDrSMS + "' ,AppointmentPSMS='" + obj.chkAppointmentPSMS + "' where HospitalID='" + HospitalID + "' and LocationID='" + LocationID + "' and RowStatus=0", con); con.Open(); int a = cmdchk.ExecuteNonQuery(); con.Close(); KeystoneProject.Buisness_Logic.Master.BL_SMSSetting Bl_obj = new Buisness_Logic.Master.BL_SMSSetting(); int rows = Bl_obj.GetMasterSmsDetails().Tables[1].Rows.Count; if (rows == 0) { obj.Mode = "Add"; } else { obj.Mode = "Edit"; obj.MobileSMSID = Convert.ToInt32(fc["MobileSMSID"]); } bool chk = Bl_obj.Save(obj); if (chk == true) { ModelState.Clear(); TempData["msg"] = "SMSSetting Updated Successfully"; } else { TempData["msg"] = "SMSSetting Not Save"; } return(RedirectToAction("SMSSetting", "SMSSetting")); }