private void FillControls(SqlInt32 HospitalID)
{
HospitalENT entHospital = new HospitalENT();
HospitalBAL balHospital = new HospitalBAL();
entHospital = balHospital.SelectByPK(HospitalID);
if (!entHospital.HospitalName.IsNull)
{
txtHospitalName.Text = entHospital.HospitalName.Value.ToString();
}
if (!entHospital.Overview.IsNull)
{
txtOverview.Text = entHospital.Overview.Value.ToString();
}
if (!entHospital.Address.IsNull)
{
txtAddress.Text = entHospital.Address.Value.ToString();
}
if (!entHospital.Mobile.IsNull)
{
txtMobile.Text = entHospital.Mobile.Value.ToString();
}
if (!entHospital.Email.IsNull)
{
txtEmail.Text = entHospital.Email.Value.ToString();
}
if (!entHospital.CityID.IsNull)
{
ddlCity.SelectedValue = entHospital.CityID.Value.ToString();
}
if (!entHospital.SpecialityID.IsNull)
{
ddlSpeciality.SelectedValue = entHospital.SpecialityID.Value.ToString();
}
HospitalWiseReportBAL balHospitalWiseReportBAL = new HospitalWiseReportBAL();
DataTable dtReport = new DataTable();
dtReport = balHospitalWiseReportBAL.SelectByHospitalID(HospitalID);
foreach (DataRow row in dtReport.Rows)
{
foreach (ListItem item in chlReport.Items)
{
if (item.Value == row["ReportID"].ToString().Trim())
{
item.Selected = true;
}
}
}
}
public Boolean Insert(HospitalENT entHospital)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Hospital_Insert";
objCmd.Parameters.Add("@HospitalID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
objCmd.Parameters.Add("@HospitalName", SqlDbType.VarChar).Value = entHospital.HospitalName;
objCmd.Parameters.Add("@Overview", SqlDbType.VarChar).Value = entHospital.Overview;
objCmd.Parameters.Add("@SpecialityID", SqlDbType.Int).Value = entHospital.SpecialityID;
objCmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = entHospital.Address;
objCmd.Parameters.Add("@CityID", SqlDbType.Int).Value = entHospital.CityID;
objCmd.Parameters.Add("@Mobile", SqlDbType.VarChar).Value = entHospital.Mobile;
objCmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = entHospital.Email;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@HospitalID"] != null)
{
entHospital.HospitalID = Convert.ToInt32(objCmd.Parameters["@HospitalID"].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();
}
}
}
}
}
public Boolean Update(HospitalENT entHospital)
{
HospitalDAL dalHospital = new HospitalDAL();
if (dalHospital.Update(entHospital))
{
return(true);
}
else
{
Message = dalHospital.Message;
return(false);
}
}
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;
}
}
}
public void fillHospitalDetails(SqlInt32 HospitalID)
{
HospitalBAL balHospital = new HospitalBAL();
HospitalENT entHospital = new HospitalENT();
entHospital = balHospital.SelectByPK(HospitalID);
if (!entHospital.HospitalName.IsNull)
{
lblHospitalName.Text = entHospital.HospitalName.Value;
}
if (!entHospital.SpecialityID.IsNull)
{
SpecialityBAL balSpeciality = new SpecialityBAL();
SpecialityENT entSpeciality = new SpecialityENT();
entSpeciality = balSpeciality.SelectByPK(Convert.ToInt32(entHospital.SpecialityID.Value));
lblSpeciality.Text = entSpeciality.SpecialityName.Value;
}
if (!entHospital.Overview.IsNull)
{
lblOverview.Text = entHospital.Overview.Value;
}
if (!entHospital.Address.IsNull)
{
hlAddress.Text = entHospital.Address.Value;
}
if (!entHospital.Email.IsNull)
{
hlEmail.NavigateUrl = "mailto:" + entHospital.Email.Value;
hlEmail.Text = entHospital.Email.Value;
}
if (!entHospital.Mobile.IsNull)
{
hlMobile.NavigateUrl = "tel:" + entHospital.Mobile.Value;
hlMobile.Text = entHospital.Mobile.Value;
}
HospitalWiseReportBAL balHospitalWiseReport = new HospitalWiseReportBAL();
DataTable dtReport = new DataTable();
dtReport = balHospitalWiseReport.SelectByHospitalID(HospitalID);
rptReport.DataSource = dtReport;
rptReport.DataBind();
DoctorBAL balDoctorBAL = new DoctorBAL();
DataTable dtDoctor = new DataTable();
dtDoctor = balDoctorBAL.SelectByHospitalID(HospitalID);
if (dtDoctor != null && dtDoctor.Rows.Count > 0)
{
rptDoctors.DataSource = dtDoctor;
rptDoctors.DataBind();
pnlNoDoctorFound.Visible = false;
}
else
{
pnlNoDoctorFound.Visible = true;
}
if (Convert.ToBoolean(Application["CheckAdmin"]) == true && Convert.ToBoolean(Application["CheckDoctor"]) == false)
{
lbEditHospital.Visible = true;
lbDoctorAdd.Visible = true;
}
else if (Convert.ToBoolean(Application["CheckAdmin"]) == false && Convert.ToBoolean(Application["CheckDoctor"]) == true)
{
lbEditHospital.Visible = false;
lbDoctorAdd.Visible = false;
Boolean checkDoctor = dtDoctor.Select().ToList().Exists(row => row["DoctorID"].ToString().ToUpper() == Session["UserID"].ToString());
if (checkDoctor == true)
{
lbEditHospital.Visible = true;
}
}
}
public HospitalENT SelectByPK(SqlInt32 HospitalID)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Hospital_SelectByPK";
objCmd.Parameters.Add("@HospitalID", SqlDbType.Int).Value = HospitalID;
#endregion Prepare Command
#region ReadData and Set Controls
HospitalENT entHospital = new HospitalENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["HospitalID"].Equals(DBNull.Value))
{
entHospital.HospitalID = Convert.ToInt32(objSDR["HospitalID"]);
}
if (!objSDR["HospitalName"].Equals(DBNull.Value))
{
entHospital.HospitalName = Convert.ToString(objSDR["HospitalName"]);
}
if (!objSDR["Overview"].Equals(DBNull.Value))
{
entHospital.Overview = Convert.ToString(objSDR["Overview"]);
}
if (!objSDR["SpecialityID"].Equals(DBNull.Value))
{
entHospital.SpecialityID = Convert.ToInt32(objSDR["SpecialityID"]);
}
if (!objSDR["Address"].Equals(DBNull.Value))
{
entHospital.Address = Convert.ToString(objSDR["Address"]);
}
if (!objSDR["CityID"].Equals(DBNull.Value))
{
entHospital.CityID = Convert.ToInt32(objSDR["CityID"]);
}
if (!objSDR["Mobile"].Equals(DBNull.Value))
{
entHospital.Mobile = Convert.ToString(objSDR["Mobile"]);
}
if (!objSDR["Email"].Equals(DBNull.Value))
{
entHospital.Email = Convert.ToString(objSDR["Email"]);
}
}
}
return(entHospital);
#endregion ReadData and Set Controls
}
catch (SqlException sqlEx)
{
Message = sqlEx.InnerException.Message;
return(null);
}
catch (Exception ex)
{
Message = ex.InnerException.Message;
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public void fillHospitalDetails(SqlInt32 HospitalID)
{
HospitalBAL balHospital = new HospitalBAL();
HospitalENT entHospital = new HospitalENT();
entHospital = balHospital.SelectByPK(HospitalID);
if (!entHospital.HospitalName.IsNull)
{
lblHospitalName.Text = entHospital.HospitalName.Value;
}
if (!entHospital.SpecialityID.IsNull)
{
SpecialityBAL balSpeciality = new SpecialityBAL();
SpecialityENT entSpeciality = new SpecialityENT();
entSpeciality = balSpeciality.SelectByPK(Convert.ToInt32(entHospital.SpecialityID.Value));
lblSpeciality.Text = entSpeciality.SpecialityName.Value;
}
if (!entHospital.Overview.IsNull)
{
lblOverview.Text = entHospital.Overview.Value;
}
if (!entHospital.Address.IsNull)
{
hlAddress.Text = entHospital.Address.Value;
}
if (!entHospital.Email.IsNull)
{
hlEmail.NavigateUrl = "mailto:" + entHospital.Email.Value;
hlEmail.Text = entHospital.Email.Value;
}
if (!entHospital.Mobile.IsNull)
{
hlMobile.NavigateUrl = "tel:" + entHospital.Mobile.Value;
hlMobile.Text = entHospital.Mobile.Value;
}
HospitalWiseReportBAL balHospitalWiseReport = new HospitalWiseReportBAL();
DataTable dtReport = new DataTable();
dtReport = balHospitalWiseReport.SelectByHospitalID(HospitalID);
rptReport.DataSource = dtReport;
rptReport.DataBind();
DoctorBAL balDoctorBAL = new DoctorBAL();
DataTable dtDoctor = new DataTable();
dtDoctor = balDoctorBAL.SelectByHospitalID(HospitalID);
if (dtDoctor != null && dtDoctor.Rows.Count > 0)
{
rptDoctors.DataSource = dtDoctor;
rptDoctors.DataBind();
pnlNoDoctorFound.Visible = false;
}
else
{
pnlNoDoctorFound.Visible = true;
}
}
