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 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 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; } }