protected void gridPageChanging(object sender, GridViewPageEventArgs e)
{
if (DropDownList2.SelectedItem.Text == "Gallery")
{
if (DropDownList1.SelectedItem.Text == "Historical Spots" && ddlColumn.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchDetailBySearch(ddlColumn.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
else if (DropDownList1.SelectedItem.Text == "LP" && ddlColumn1.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchLPDetailBySearch(ddlColumn1.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
else if (DropDownList1.SelectedItem.Text == "Festivals" && ddlColumn.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchFestivalBySearch(ddlColumn.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
}
}
protected void ddlColumn1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedItem.Text == "LP" && ddlColumn1.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchLPDetailBySearch(ddlColumn1.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.DataBind();
}
}
public void FetchGridDetails(string LPID)
{
DataSet details = new DataSet();
GeneralBAL spot = new GeneralBAL();
details = spot.FetchLPDetailBySearch(LPID);
if (details.Tables[0].Rows.Count != 0)
{
lblName.Text = details.Tables[0].Rows[0][1].ToString();
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][3].ToString()))
{
lblDescription.Visible = false;
tr1.Visible = false;
trs1.Visible = false;
}
else
{
lblDescription.Visible = true;
lblDescription.Text = details.Tables[0].Rows[0][3].ToString();
tr1.Visible = true;
trs1.Visible = true;
}
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][4].ToString()))
{
tr1.Visible = true;
lblReligion.Visible = false;
lblReligionVal.Visible = false;
tr12.Visible = false;
trs12.Visible = false;
}
else if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][4].ToString()) && details.Tables[0].Rows[0][4].ToString() != "==Select==")
{
lblReligion.Visible = true;
lblReligionVal.Visible = true;
lblReligionVal.Text = details.Tables[0].Rows[0][4].ToString();
tr12.Visible = true;
trs12.Visible = true;
}
else
{
lblReligion.Visible = false;
lblReligionVal.Visible = false;
tr12.Visible = false;
trs12.Visible = false;
}
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][2].ToString()))
{
lblLPCategroy.Visible = false;
lblLPCategroyVal.Visible = false;
tr2.Visible = false;
trs2.Visible = false;
}
else if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][2].ToString()) && details.Tables[0].Rows[0][2].ToString() != "==Select==")
{
lblLPCategroy.Visible = true;
lblLPCategroyVal.Visible = true;
lblLPCategroyVal.Text = details.Tables[0].Rows[0][2].ToString();
tr2.Visible = true;
trs2.Visible = true;
}
else
{
lblLPCategroy.Visible = false;
lblLPCategroyVal.Visible = false;
tr2.Visible = false;
trs2.Visible = false;
}
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][5].ToString()))
{
lblDynasty.Visible = false;
lblDynastyVal.Visible = false;
tr3.Visible = false;
trs3.Visible = false;
}
else if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][5].ToString()) && details.Tables[0].Rows[0][5].ToString() != "==Select==")
{
lblDynasty.Visible = true;
lblDynastyVal.Visible = true;
lblDynastyVal.Text = details.Tables[0].Rows[0][5].ToString();
tr3.Visible = true;
trs3.Visible = true;
}
else
{
lblDynasty.Visible = false;
lblDynastyVal.Visible = false;
tr3.Visible = false;
trs3.Visible = false;
}
if (details.Tables[1].Rows.Count != 0)
{
if (!string.IsNullOrEmpty(details.Tables[1].Rows[0][0].ToString()))
{
GridView1.DataSource = details.Tables[1];
GridView1.DataBind();
tr11.Visible = true;
}
else
tr11.Visible = false;
}
else
tr11.Visible = false;
#region Batch process...
DataTable bt = new DataTable();
GeneralBAL bto = new GeneralBAL();
bt = bto.FetchBatchProcess();
if (bt.Rows.Count != 0)
{
for (int i = 0; i < bt.Rows.Count; i++)
if (!bt.Rows[i]["destination"].ToString().Contains("LegendaryPersonalities.aspx"))
lblDescription.Text = lblDescription.Text.Replace(bt.Rows[i]["li"].ToString(), bt.Rows[i]["destination"].ToString());
}
#endregion
}
else
{
lblName.Text = "Details not available.";
lblDescription.Visible = false;
lblReligion.Visible = false;
lblReligionVal.Visible = false;
lblLPCategroy.Visible = false;
lblLPCategroyVal.Visible = false;
lblDynasty.Visible = false;
lblDynastyVal.Visible = false;
tr11.Visible = false;
GridView1.Visible = false;
}
}
protected void gridPageChanging(object sender, GridViewPageEventArgs e)
{
if (DropDownList2.SelectedItem.Text == "Gallery")
{
if (DropDownList1.SelectedItem.Text == "Historical Spots" && ddlColumn.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchDetailBySearch(ddlColumn.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
else if (DropDownList1.SelectedItem.Text == "LP" && ddlColumn1.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchLPDetailBySearch(ddlColumn1.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
else if (DropDownList1.SelectedItem.Text == "Festivals" && ddlColumn.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchFestivalBySearch(ddlColumn.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
}
}
protected void ddlColumn1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedItem.Text == "LP" && ddlColumn1.SelectedItem.Text != "Select")
{
DataSet details = new DataSet();
GeneralBAL fest = new GeneralBAL();
details = fest.FetchLPDetailBySearch(ddlColumn1.SelectedValue.ToString());
GridView1.DataSource = details.Tables[1];
GridView1.DataBind();
}
}
public void FetchGridDetails(string LPID)
{
DataSet details = new DataSet();
GeneralBAL spot = new GeneralBAL();
details = spot.FetchLPDetailBySearch(LPID);
if (details.Tables[0].Rows.Count != 0)
{
lblName.Text = details.Tables[0].Rows[0][1].ToString();
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][3].ToString()))
{
lblDescription.Visible = false;
tr1.Visible = false;
trs1.Visible = false;
}
else
{
lblDescription.Visible = true;
lblDescription.Text = details.Tables[0].Rows[0][3].ToString();
tr1.Visible = true;
trs1.Visible = true;
}
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][4].ToString()))
{
tr1.Visible = true;
lblReligion.Visible = false;
lblReligionVal.Visible = false;
tr12.Visible = false;
trs12.Visible = false;
}
else if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][4].ToString()) && details.Tables[0].Rows[0][4].ToString() != "==Select==")
{
lblReligion.Visible = true;
lblReligionVal.Visible = true;
lblReligionVal.Text = details.Tables[0].Rows[0][4].ToString();
tr12.Visible = true;
trs12.Visible = true;
}
else
{
lblReligion.Visible = false;
lblReligionVal.Visible = false;
tr12.Visible = false;
trs12.Visible = false;
}
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][2].ToString()))
{
lblLPCategroy.Visible = false;
lblLPCategroyVal.Visible = false;
tr2.Visible = false;
trs2.Visible = false;
}
else if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][2].ToString()) && details.Tables[0].Rows[0][2].ToString() != "==Select==")
{
lblLPCategroy.Visible = true;
lblLPCategroyVal.Visible = true;
lblLPCategroyVal.Text = details.Tables[0].Rows[0][2].ToString();
tr2.Visible = true;
trs2.Visible = true;
}
else
{
lblLPCategroy.Visible = false;
lblLPCategroyVal.Visible = false;
tr2.Visible = false;
trs2.Visible = false;
}
if (string.IsNullOrEmpty(details.Tables[0].Rows[0][5].ToString()))
{
lblDynasty.Visible = false;
lblDynastyVal.Visible = false;
tr3.Visible = false;
trs3.Visible = false;
}
else if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][5].ToString()) && details.Tables[0].Rows[0][5].ToString() != "==Select==")
{
lblDynasty.Visible = true;
lblDynastyVal.Visible = true;
lblDynastyVal.Text = details.Tables[0].Rows[0][5].ToString();
tr3.Visible = true;
trs3.Visible = true;
}
else
{
lblDynasty.Visible = false;
lblDynastyVal.Visible = false;
tr3.Visible = false;
trs3.Visible = false;
}
if (details.Tables[1].Rows.Count != 0)
{
if (!string.IsNullOrEmpty(details.Tables[1].Rows[0][0].ToString()))
{
GridView1.DataSource = details.Tables[1];
GridView1.DataBind();
tr11.Visible = true;
}
else
{
tr11.Visible = false;
}
}
else
{
tr11.Visible = false;
}
#region Batch process...
DataTable bt = new DataTable();
GeneralBAL bto = new GeneralBAL();
bt = bto.FetchBatchProcess();
if (bt.Rows.Count != 0)
{
for (int i = 0; i < bt.Rows.Count; i++)
{
if (!bt.Rows[i]["destination"].ToString().Contains("LegendaryPersonalities.aspx"))
{
lblDescription.Text = lblDescription.Text.Replace(bt.Rows[i]["li"].ToString(), bt.Rows[i]["destination"].ToString());
}
}
}
#endregion
}
else
{
lblName.Text = "Details not available.";
lblDescription.Visible = false;
lblReligion.Visible = false;
lblReligionVal.Visible = false;
lblLPCategroy.Visible = false;
lblLPCategroyVal.Visible = false;
lblDynasty.Visible = false;
lblDynastyVal.Visible = false;
tr11.Visible = false;
GridView1.Visible = false;
}
}
