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