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