public ActionResult MasterSetting(KeystoneProject.Models.Master.MasterSetting MasterSetting)
{
Buisness_Logic.Master.BL_MasterSetting setting = new Buisness_Logic.Master.BL_MasterSetting();
MasterSetting.ShowAllMasterSetting = setting.GetMasterSetting();
MasterSetting.dsFinancial = setting.GetAllFinancialYear();
if (MasterSetting.ShowAllMasterSetting.Tables[0].Rows.Count != 0)
{
MasterSetting.OPDBillsOutSidePatient = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["OPDBillsOutSidePatient"].ToString());
MasterSetting.ForAuthorization = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["ForAuthorization"].ToString());
MasterSetting.OPDLabBillsOutSidePatient = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["OPDLabBillsOutSidePatient"].ToString());
MasterSetting.MasterSettingID = Convert.ToInt32(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["MasterSettingID"].ToString());
MasterSetting.DoctorNameInLabReport = MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["DoctorNameInLabReport"].ToString();
MasterSetting.DoctorNameInLabReport1 = MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["DoctorNameInLabReport1"].ToString();
MasterSetting.LogoSize = MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["LogoSize"].ToString();
MasterSetting.LabReportFooter = MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["LabReportFooter"].ToString();
MasterSetting.OPDRegistration = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["OPDRegistration"].ToString());
MasterSetting.OpdBill = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["OpdBill"].ToString());
MasterSetting.IPDAdmission = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["IPDAdmission"].ToString());
MasterSetting.IpdBill = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["IpdBill"].ToString());
MasterSetting.ProvisionalBill = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["ProvisionalBill"].ToString());
MasterSetting.IpdFinalBill = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["IpdFinalBill"].ToString());
MasterSetting.IPDDischargeSummary = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["IPDDischargeSummary"].ToString());
MasterSetting.PatientPaymentAndDeposite = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["PatientPaymentAndDeposite"].ToString());
MasterSetting.PatientPrescription = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["PatientPrescription"].ToString());
MasterSetting.PatientPrescreptionNew = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["PatientPrescreptionNew"].ToString());
MasterSetting.LabBills = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["LabBills"].ToString());
MasterSetting.LabReport = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["LabReport"].ToString());
MasterSetting.Authorized = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["Authorized"].ToString());
MasterSetting.DateTimeSetting = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["DateTimeSetting"].ToString());
MasterSetting.FinancialYearID = Convert.ToInt32(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["FinancialYearID"].ToString());
MasterSetting.FinalBillWithHeader = Convert.ToBoolean(MasterSetting.ShowAllMasterSetting.Tables[0].Rows[0]["FinalBillWithHeader"].ToString());
}
return(View(MasterSetting));
}
public bool Save(KeystoneProject.Models.Master.MasterSetting objMasterSetting)
{
try
{
HospitlLocationID();
Connect();
con.Open();
SqlCommand cmd = new SqlCommand("IUMasterSetting", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@MasterSettingID", objMasterSetting.MasterSettingID);
cmd.Parameters.AddWithValue("@OPDBillsOutSidePatient", false);
cmd.Parameters.AddWithValue("@OPDLabBillsOutSidePatient", false);
cmd.Parameters.AddWithValue("@IPDBillsBadCharges", false);
cmd.Parameters.AddWithValue("@ForAuthorization", objMasterSetting.ForAuthorization);
if (objMasterSetting.DoctorNameInLabReport == null || objMasterSetting.DoctorNameInLabReport == "")
{
cmd.Parameters.AddWithValue("@DoctorNameInLabReport", 0);
}
else
{
cmd.Parameters.AddWithValue("@DoctorNameInLabReport", objMasterSetting.DoctorNameInLabReport);
}
if (objMasterSetting.DoctorNameInLabReport1 == null || objMasterSetting.DoctorNameInLabReport1 == "")
{
cmd.Parameters.AddWithValue("@DoctorNameInLabReport1", 0);
}
else
{
cmd.Parameters.AddWithValue("@DoctorNameInLabReport1", objMasterSetting.DoctorNameInLabReport1);
}
cmd.Parameters.AddWithValue("@LogoSize", objMasterSetting.LogoSize);
cmd.Parameters.AddWithValue("@OPDRegistration", objMasterSetting.OPDRegistration);
cmd.Parameters.AddWithValue("@OPDPrescription", false);
cmd.Parameters.AddWithValue("@OpdBill", objMasterSetting.OpdBill);
cmd.Parameters.AddWithValue("@IPDAdmission", objMasterSetting.IPDAdmission);
cmd.Parameters.AddWithValue("@IpdBill", objMasterSetting.IpdBill);
cmd.Parameters.AddWithValue("@ProvisionalBill", objMasterSetting.ProvisionalBill);
cmd.Parameters.AddWithValue("@IpdFinalBill", objMasterSetting.IpdFinalBill);
cmd.Parameters.AddWithValue("@IPDDischargeSummary", objMasterSetting.IPDDischargeSummary);
cmd.Parameters.AddWithValue("@PatientPaymentAndDeposite", objMasterSetting.PatientPaymentAndDeposite);
cmd.Parameters.AddWithValue("@PatientPrescription", false);
cmd.Parameters.AddWithValue("@LabBills", objMasterSetting.LabBills);
cmd.Parameters.AddWithValue("@LabReport", objMasterSetting.LabReport);
cmd.Parameters.AddWithValue("@BirthCertificate", false);
cmd.Parameters.AddWithValue("@DeathCertificate", false);
cmd.Parameters.AddWithValue("@PatientPrescreptionNew", objMasterSetting.PatientPrescreptionNew);
cmd.Parameters.AddWithValue("@PatientPrescriptionMarathi", false);
cmd.Parameters.AddWithValue("@ReNewDate", System.DateTime.Now);
cmd.Parameters.AddWithValue("@MedicalName", 0);
cmd.Parameters.AddWithValue("@MedicalNameBill", 0);
cmd.Parameters.AddWithValue("@Password", "Delete");
cmd.Parameters.AddWithValue("@FinancialYearID", objMasterSetting.FinancialYearID);
cmd.Parameters.AddWithValue("@SMSUrl", 0);
cmd.Parameters.AddWithValue("@Authorized", objMasterSetting.Authorized);
cmd.Parameters.AddWithValue("@LabReportFooter", objMasterSetting.LabReportFooter);
cmd.Parameters.AddWithValue("@IPDAddimisionDrSMS", false);
cmd.Parameters.AddWithValue("@OPDBillDrSMS", false);
cmd.Parameters.AddWithValue("@IPDBillDrSMS", false);
cmd.Parameters.AddWithValue("@IPDFinalBillDrSMS", false);
cmd.Parameters.AddWithValue("@IPDDischargeDrSMS", false);
cmd.Parameters.AddWithValue("@IPDAddimisionPSMS", false);
cmd.Parameters.AddWithValue("@OPDRegDrSMS", false);
cmd.Parameters.AddWithValue("@IPDBillPSMS", false);
cmd.Parameters.AddWithValue("@IPDFinalBillPSMS", false);
cmd.Parameters.AddWithValue("@IPDDischargePSMS", false);
cmd.Parameters.AddWithValue("@IPDAddimisionCDrSMS", false);
cmd.Parameters.AddWithValue("@IPDDischargeCDrSMS", false);
cmd.Parameters.AddWithValue("@AppointmentPSMS", false);
cmd.Parameters.AddWithValue("@AppointmentCDrSMS", false);
cmd.Parameters.AddWithValue("@FinalBillWithHeader", objMasterSetting.FinalBillWithHeader);
cmd.Parameters.AddWithValue("@DateTimeSetting", objMasterSetting.DateTimeSetting);
cmd.Parameters.AddWithValue("@OtherBillsLogo", false);
cmd.Parameters.AddWithValue("@OtherPrebalanceLogo", false);
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", objMasterSetting.Mode);
int i = cmd.ExecuteNonQuery();
string[] Seq = objMasterSetting.Sequence.Split(',');
string[] Prints = objMasterSetting.PrintAs.Split(',');
string[] name = objMasterSetting.Name.Split(',');
string[] id = objMasterSetting.PatientDischargeSettingID.Split(',');
for (int j = 0; j < Seq.Length; j++)
{
SqlCommand cmd1 = new SqlCommand("IUPatientIPDDischargeSummarySettingNew", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@PatientDischargeSettingID", id[j]);
cmd1.Parameters.AddWithValue("@PrintAs", Prints[j]);
cmd1.Parameters.AddWithValue("@Name", name[j]);
cmd1.Parameters.AddWithValue("@Sequence", Seq[j]);
int ij = cmd1.ExecuteNonQuery();
}
con.Close();
}
catch (Exception ex)
{
return(false);
ExceptionManager.Publish(ex);
throw ex;
}
return(true);
}
