protected void SearchForHospital() { try { string CS = ConfigurationManager.ConnectionStrings["ConnectToPatientPortal"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { string query = "Select * from Institutes"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); DataView dv = new DataView(dt); if (ddlcity.SelectedValue != "All") { dv.RowFilter = "City='" + ddlcity.SelectedValue + "'"; } dt = dv.ToTable(); GridViewDoctor.DataSource = null; GridViewDoctor.DataBind(); GridViewHospital.DataSource = dt; GridViewHospital.DataBind(); } } catch (Exception ex) { Session["Exception"] = ex; Response.Redirect("~/404.aspx"); } }
protected void SearchForHospital() { string CS = ConfigurationManager.ConnectionStrings["ConnectToPatientPortal"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { string query = "Select * from Institutes"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); DataView dv = new DataView(dt); if (ddlcity.SelectedValue != "All") { dv.RowFilter = "City='" + ddlcity.SelectedValue + "'"; } dt = dv.ToTable(); GridViewHospital.DataSource = dt; GridViewHospital.DataBind(); } }
protected void SearchForDoctor() { try { string CS = ConfigurationManager.ConnectionStrings["ConnectToPatientPortal"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { string query = "Select DoctorProfile.*,UserAccounts.Username from DoctorProfile inner join UserAccounts on DoctorProfile.UserId=UserAccounts.UserId"; if (ddlFilterBy.SelectedValue == "Services" && ddlspecialization.SelectedValue != "All") { query = "Select DoctorProfile.*,DoctorOfferServices.ServiceName,UserAccounts.Username from ((DoctorProfile inner join DoctorOfferServices on DoctorProfile.DoctorId=DoctorOfferServices.DoctorId) inner join UserAccounts on DoctorProfile.UserId=UserAccounts.UserId)"; } if (ddlFilterBy.SelectedValue == "Diseases" && ddlspecialization.SelectedValue != "All") { query = "Select DoctorProfile.*,Diseases.DiseaseName,UserAccounts.Username from DoctorProfile inner join DoctorCureDiseases on DoctorProfile.DoctorId=DoctorCureDiseases.DoctorId inner join UserAccounts on DoctorProfile.UserId=UserAccounts.UserId"; } SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); if (ddlcity.SelectedValue != "All") { DataView dv = new DataView(dt); dv.RowFilter = "City='" + ddlcity.SelectedValue + "'"; dt = dv.ToTable(); } if (ddlgender.SelectedValue != "Both") { DataView dv = new DataView(dt); dv.RowFilter = "Gender= '" + ddlgender.SelectedValue + "'"; dt = dv.ToTable(); } if (ddlFeeMin.SelectedValue != "--Minimum--" && ddlFeeMin.SelectedValue != "Don,t Filter" && ddlFeeMax.SelectedValue != "--Maximum--" && ddlFeeMax.SelectedValue != "Don,t Filter") { DataView dv = new DataView(dt); dv.RowFilter = "FeeMin >= '" + ddlFeeMin.SelectedValue + "' AND FeeMax <= '" + ddlFeeMax.SelectedValue + "'"; dt = dv.ToTable(); } if (ddlspecialization.SelectedValue != "All") { DataView dv = new DataView(dt); dv.RowFilter = "Specialization= '" + ddlspecialization.SelectedValue + "'"; dt = dv.ToTable(); } if (ddlFilterBy.SelectedValue == "Diseases" && ddlspecialization.SelectedValue != "All") { DataView dv = new DataView(dt); dv.RowFilter = "DiseaseName= '" + ddlDiseases.SelectedValue + "'"; dt = dv.ToTable(); } if (ddlFilterBy.SelectedValue == "Services" && ddlspecialization.SelectedValue != "All") { DataView dv = new DataView(dt); dv.RowFilter = "ServiceName= '" + ddlServices.SelectedValue + "'"; dt = dv.ToTable(); } DataView dv2 = new DataView(dt); dv2.Sort = "Recommendations DESC"; dt = dv2.ToTable(); GridViewHospital.DataSource = null; GridViewHospital.DataBind(); GridViewDoctor.DataSource = dt; GridViewDoctor.DataBind(); } } catch (Exception ex) { Session["Exception"] = ex; Response.Redirect("~/404.aspx"); } }