private void Populate_Helpline(string dist_code)
{
try
{
dbname = GetDatabaseNameUsingXML("Ranchi");
DataSet ds = new DataSet();
ds = DaObj.Execute_SP("Get_Helpline_Data '" + dist_code + "'", dbname);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
GvHospital.DataSource = ds.Tables[0];
GvHospital.DataBind();
}
else
{
GvHospital.DataSource = null;
GvHospital.DataBind();
lblNoHospital.Text = "Sorry! No Data Available";
}
if (ds.Tables[1].Rows.Count > 0)
{
GvOxygen.DataSource = ds.Tables[1];
GvOxygen.DataBind();
}
else
{
GvOxygen.DataSource = null;
GvOxygen.DataBind();
lblNoOxy.Text = "Sorry! No Data Available";
}
if (ds.Tables[2].Rows.Count > 0)
{
GvPlazma.DataSource = ds.Tables[2];
GvPlazma.DataBind();
}
else
{
GvPlazma.DataSource = null;
GvPlazma.DataBind();
lblNoPlazma.Text = "Sorry! No Data Available";
}
if (ds.Tables[3].Rows.Count > 0)
{
GvDoctor.DataSource = ds.Tables[3];
GvDoctor.DataBind();
}
else
{
GvDoctor.DataSource = null;
GvDoctor.DataBind();
lblNoDoctor.Text = "Sorry! No Data Available";
}
if (ds.Tables[4].Rows.Count > 0)
{
GvAmbulance.DataSource = ds.Tables[4];
GvAmbulance.DataBind();
}
else
{
GvAmbulance.DataSource = null;
GvAmbulance.DataBind();
lblAmbulance.Text = "Sorry! No Data Available";
}
if (ds.Tables[5].Rows.Count > 0)
{
GvFood.DataSource = ds.Tables[5];
GvFood.DataBind();
}
else
{
GvFood.DataSource = null;
GvFood.DataBind();
lblNoFood.Text = "Sorry! No Data Available";
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "alertMessage", "swal('Error!', 'No Table Available', 'error')", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "alertMessage", "swal('Error!', '" + ex.Message.ToString() + "', 'error')", true);
}
}
private void Populate_Helpline(string dist_code)
{
try
{
dbname = GetDatabaseNameUsingXML("Ranchi");
DataSet ds = new DataSet();
ds = DaObj.Execute_SP("Get_Helpline_Data '" + dist_code + "'", dbname);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
GvHospital.DataSource = ds.Tables[0];
GvHospital.DataBind();
}
else
{
GvHospital.DataSource = null;
GvHospital.DataBind();
lblNoHospital.Text = "Sorry! No Data Available";
}
if (ds.Tables[1].Rows.Count > 0)
{
GvOxygen.DataSource = ds.Tables[1];
GvOxygen.DataBind();
}
else
{
GvOxygen.DataSource = null;
GvOxygen.DataBind();
lblNoOxy.Text = "Sorry! No Data Available";
}
if (ds.Tables[2].Rows.Count > 0)
{
GvPlazma.DataSource = ds.Tables[2];
GvPlazma.DataBind();
}
else
{
GvPlazma.DataSource = null;
GvPlazma.DataBind();
lblNoPlazma.Text = "Sorry! No Data Available";
}
if (ds.Tables[3].Rows.Count > 0)
{
GvDoctor.DataSource = ds.Tables[3];
GvDoctor.DataBind();
}
else
{
GvDoctor.DataSource = null;
GvDoctor.DataBind();
lblNoDoctor.Text = "Sorry! No Data Available";
}
if (ds.Tables[4].Rows.Count > 0)
{
GvAmbulance.DataSource = ds.Tables[4];
GvAmbulance.DataBind();
}
else
{
GvAmbulance.DataSource = null;
GvAmbulance.DataBind();
lblAmbulance.Text = "Sorry! No Data Available";
}
if (ds.Tables[5].Rows.Count > 0)
{
GvFood.DataSource = ds.Tables[5];
GvFood.DataBind();
}
else
{
GvFood.DataSource = null;
GvFood.DataBind();
lblNoFood.Text = "Sorry! No Data Available";
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), System.Guid.NewGuid().ToString(), "ShowMessage('No Table Available','" + MessageType.Error + "');", true);
}
}
catch (Exception ex)
{
ShowMessage(ex.Message.Replace("'", ""), MessageType.Error);
}
}