public bool Save(KeystoneProject.Models.Master.SMSSetting objSMSSetting)
{
try
{
HospitalLocationID();
Connect();
con.Open();
SqlCommand cmd = new SqlCommand("IUMobileSMS", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@MobileSMSID", objSMSSetting.MobileSMSID);
cmd.Parameters.AddWithValue("@IPDAddimisionDrSMS", objSMSSetting.IPDAddimisionDrSMS);
cmd.Parameters.AddWithValue("@IPDDischargeDrSMS", objSMSSetting.IPDDischargeDrSMS);
cmd.Parameters.AddWithValue("@IPDAddimisionPSMS", objSMSSetting.IPDAddimisionPSMS);
cmd.Parameters.AddWithValue("@OPDRegDrSMS", objSMSSetting.OPDRegDrSMS);
cmd.Parameters.AddWithValue("@IPDDischargePSMS", objSMSSetting.IPDDischargePSMS);
cmd.Parameters.AddWithValue("@IPDAddimisionCDrSMS", objSMSSetting.IPDAddimisionCDrSMS);
cmd.Parameters.AddWithValue("@IPDDischargeCDrSMS", objSMSSetting.IPDDischargeCDrSMS);
cmd.Parameters.AddWithValue("@AppointmentPSMS", objSMSSetting.AppointmentPSMS);
cmd.Parameters.AddWithValue("@AppointmentCDrSMS", objSMSSetting.AppointmentCDrSMS);
cmd.Parameters.AddWithValue("@IPDAddimisionDr", "");
cmd.Parameters.AddWithValue("@OPDBillDr", "");
cmd.Parameters.AddWithValue("@IPDBillDr", "");
cmd.Parameters.AddWithValue("@IPDFinalBillDr", "");
cmd.Parameters.AddWithValue("@IPDDischargeDr", "");
cmd.Parameters.AddWithValue("@IPDAddimisionP", "");
cmd.Parameters.AddWithValue("@OPDRegDr", "");
cmd.Parameters.AddWithValue("@IPDBillP", "");
cmd.Parameters.AddWithValue("@IPDFinalBillP", "");
cmd.Parameters.AddWithValue("@IPDDischargeP", "");
cmd.Parameters.AddWithValue("@IPDAddimisionCDr", "");
cmd.Parameters.AddWithValue("@IPDDischargeCDr", "");
cmd.Parameters.AddWithValue("@AppointmentP", "");
cmd.Parameters.AddWithValue("@AppointmentCDr", "");
cmd.Parameters.AddWithValue("@OPDBillDrSMS", "");
cmd.Parameters.AddWithValue("@IPDBillDrSMS", "");
cmd.Parameters.AddWithValue("@IPDFinalBillDrSMS", "");
cmd.Parameters.AddWithValue("@IPDBillPSMS", "");
cmd.Parameters.AddWithValue("@IPDFinalBillPSMS", "");
cmd.Parameters.AddWithValue("@Mode", objSMSSetting.Mode);
int i = cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
return(false);
ExceptionManager.Publish(ex);
throw ex;
}
return(true);
}
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));
}