public Boolean Insert(HospitalWiseReportENT entHospitalWiseReport)
{
HospitalWiseReportDAL dalHospitalWiseReport = new HospitalWiseReportDAL();
if (dalHospitalWiseReport.Insert(entHospitalWiseReport))
{
return(true);
}
else
{
Message = dalHospitalWiseReport.Message;
return(false);
}
}
public Boolean Insert(HospitalWiseReportENT entHospitalWiseReport)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_HospitalWiseReportr_Insert";
objCmd.Parameters.Add("@HospitalWiseReportID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
objCmd.Parameters.Add("@HospitalID", SqlDbType.Int).Value = entHospitalWiseReport.HospitalID;
objCmd.Parameters.Add("@ReportID", SqlDbType.Int).Value = entHospitalWiseReport.ReportID;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@HospitalWiseReportID"] != null)
{
entHospitalWiseReport.HospitalWiseReportID = Convert.ToInt32(objCmd.Parameters["@HospitalWiseReportID"].Value);
}
return(true);
}
catch (SqlException sqlEx)
{
Message = sqlEx.InnerException.Message;
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message;
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region server side validation
String strErrorMessage = "";
Int32 Count = 0;
if (txtHospitalName.Text.Trim() == "")
{
strErrorMessage += "- Enter Hospital Name <br/>";
}
if (txtOverview.Text.Trim() == "")
{
strErrorMessage += "- Enter Overview <br/>";
}
if (txtAddress.Text.Trim() == "")
{
strErrorMessage += "- Enter Address <br/>";
}
if (txtEmail.Text.Trim() == "")
{
strErrorMessage += "- Enter Email <br/>";
}
if (txtMobile.Text.Trim() == "")
{
strErrorMessage += "- Enter Mobile <br/>";
}
if (ddlCity.SelectedIndex <= 0)
{
strErrorMessage += "- Select City <br/>";
}
if (ddlSpeciality.SelectedIndex <= 0)
{
strErrorMessage += "- Select Speciality <br/>";
}
foreach (ListItem item in chlReport.Items)
{
if (item.Selected == true)
{
Count++;
}
}
if (Count == 0)
{
strErrorMessage = strErrorMessage + "- Please select at least one Report. <br/>";
}
if (strErrorMessage.Trim() != "")
{
lblErrorMessage.Text = strErrorMessage;
return;
}
else
{
lblErrorMessage.Text = "";
}
#endregion server side validation
#region Collect Form Data
HospitalENT entHospital = new HospitalENT();
if (txtHospitalName.Text.Trim() != "")
{
entHospital.HospitalName = txtHospitalName.Text.Trim();
}
if (txtOverview.Text.Trim() != "")
{
entHospital.Overview = txtOverview.Text.Trim();
}
if (txtAddress.Text.Trim() != "")
{
entHospital.Address = txtAddress.Text.Trim();
}
if (txtEmail.Text.Trim() != "")
{
entHospital.Email = txtEmail.Text.Trim();
}
if (txtMobile.Text.Trim() != "")
{
entHospital.Mobile = txtMobile.Text.Trim();
}
if (ddlCity.SelectedIndex > 0)
{
entHospital.CityID = Convert.ToInt32(ddlCity.SelectedValue.ToString().Trim());
}
if (ddlSpeciality.SelectedIndex > 0)
{
entHospital.SpecialityID = Convert.ToInt32(ddlSpeciality.SelectedValue.ToString().Trim());
}
#endregion Collect Form Data
HospitalBAL balHospital = new HospitalBAL();
HospitalWiseReportBAL balHospitalWiseReport = new HospitalWiseReportBAL();
HospitalWiseReportENT entHospitalWiseReport = new HospitalWiseReportENT();
if (Request.QueryString["HospitalID"] == null)
{
if (balHospital.Insert(entHospital))
{
entHospitalWiseReport.HospitalID = Convert.ToInt32(entHospital.HospitalID.Value);
foreach (ListItem item in chlReport.Items)
{
if (item.Selected == true)
{
entHospitalWiseReport.ReportID = Convert.ToInt32(item.Value.ToString().Trim());
if (!balHospitalWiseReport.Insert(entHospitalWiseReport))
{
lblErrorMessage.Text = balHospitalWiseReport.Message;
}
}
}
foreach (ListItem item in chlReport.Items) // uncheck Image category list
{
if (item.Selected == true)
{
item.Selected = false;
}
}
ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Hospital Information inserted Successfully', showConfirmButton: false, timer: 2000});", true);
}
else
{
lblErrorMessage.Text = balHospital.Message;
}
}
else
{
entHospital.HospitalID = Convert.ToInt32(Request.QueryString["HospitalID"]);
if (balHospital.Update(entHospital))
{
if (balHospitalWiseReport.DeleteByHospitalID(Convert.ToInt32(Request.QueryString["HospitalID"])))
{
entHospitalWiseReport.HospitalID = Convert.ToInt32(entHospital.HospitalID.Value);
foreach (ListItem item in chlReport.Items)
{
if (item.Selected == true)
{
entHospitalWiseReport.ReportID = Convert.ToInt32(item.Value.ToString().Trim());
if (!balHospitalWiseReport.Insert(entHospitalWiseReport))
{
lblErrorMessage.Text = balHospitalWiseReport.Message;
}
}
}
foreach (ListItem item in chlReport.Items) // uncheck Image category list
{
if (item.Selected == true)
{
item.Selected = false;
}
}
Response.Redirect("~/AdminPanel/Hospital/HospitalList.aspx");
}
else
{
lblErrorMessage.Text = balHospitalWiseReport.Message;
}
}
else
{
lblErrorMessage.Text = balHospital.Message;
}
}
}
