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 ddlColumn_SelectedIndexChanged(object sender, EventArgs e) { tr1.Visible = false; if (ddlColumn.SelectedItem.Text != "Select" && DropDownList1.SelectedItem.Text == "LP") { tr1.Visible = true; lblColumn1.Text = "LP Name"; DataTable ds = new DataTable(); GeneralBAL lp = new GeneralBAL(); ds = lp.FetchLPGridDetails1(ddlColumn.SelectedItem.Text); ddlColumn1.DataSource = ds; ddlColumn1.DataTextField = "lpname"; ddlColumn1.DataValueField = "lpid"; ddlColumn1.DataBind(); ddlColumn1.Items.Insert(0, "Select"); RequiredFieldValidator2.ErrorMessage = "Choose LP Name"; } 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.DataBind(); } else 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.DataBind(); } }
public void FetchGridDetails(string FestivalID) { DataSet details = new DataSet(); GeneralBAL fest = new GeneralBAL(); details = fest.FetchFestivalBySearch(FestivalID); if (details.Tables[0].Rows.Count != 0) { lblName.Text = details.Tables[0].Rows[0][1].ToString(); //lnkSpotName.CommandArgument = 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][2].ToString())) { lblMonth.Visible = false; lblMonthVal.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") { lblMonth.Visible = true; lblMonthVal.Visible = true; lblMonthVal.Text = details.Tables[0].Rows[0][2].ToString(); tr2.Visible = true; trs2.Visible = true; } else { lblMonth.Visible = false; lblMonthVal.Visible = false; tr2.Visible = false; trs2.Visible = false; } if (string.IsNullOrEmpty(details.Tables[0].Rows[0][5].ToString())) { lblSpotName.Visible = false; lblSpotNameVal.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") { lblSpotName.Visible = true; lblSpotNameVal.Visible = true; lblSpotNameVal.Text = details.Tables[0].Rows[0][5].ToString(); tr3.Visible = true; trs3.Visible = true; } else { lblSpotName.Visible = false; lblSpotNameVal.Visible = false; tr3.Visible = false; trs3.Visible = false; } if (string.IsNullOrEmpty(details.Tables[0].Rows[0][4].ToString())) { lblDuration.Visible = false; lblDurationVal.Visible = false; tr4.Visible = false; trs4.Visible = false; } else { lblDuration.Visible = true; lblDurationVal.Visible = true; lblDurationVal.Text = details.Tables[0].Rows[0][4].ToString(); tr4.Visible = true; trs4.Visible = true; } if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][6].ToString())) lnkSpotName.CommandArgument = details.Tables[0].Rows[0][6].ToString(); 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("Festivals.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; lblMonth.Visible = false; lblMonthVal.Visible = false; lblSpotName.Visible = false; lblSpotNameVal.Visible = false; lblDuration.Visible = false; lblDurationVal.Visible = false; tr11.Visible = false; GridView1.Visible = false; } }
public void FetchGridDetails(string FestivalID) { DataSet details = new DataSet(); GeneralBAL fest = new GeneralBAL(); details = fest.FetchFestivalBySearch(FestivalID); if (details.Tables[0].Rows.Count != 0) { lblName.Text = details.Tables[0].Rows[0][1].ToString(); //lnkSpotName.CommandArgument = 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][2].ToString())) { lblMonth.Visible = false; lblMonthVal.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") { lblMonth.Visible = true; lblMonthVal.Visible = true; lblMonthVal.Text = details.Tables[0].Rows[0][2].ToString(); tr2.Visible = true; trs2.Visible = true; } else { lblMonth.Visible = false; lblMonthVal.Visible = false; tr2.Visible = false; trs2.Visible = false; } if (string.IsNullOrEmpty(details.Tables[0].Rows[0][5].ToString())) { lblSpotName.Visible = false; lblSpotNameVal.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") { lblSpotName.Visible = true; lblSpotNameVal.Visible = true; lblSpotNameVal.Text = details.Tables[0].Rows[0][5].ToString(); tr3.Visible = true; trs3.Visible = true; } else { lblSpotName.Visible = false; lblSpotNameVal.Visible = false; tr3.Visible = false; trs3.Visible = false; } if (string.IsNullOrEmpty(details.Tables[0].Rows[0][4].ToString())) { lblDuration.Visible = false; lblDurationVal.Visible = false; tr4.Visible = false; trs4.Visible = false; } else { lblDuration.Visible = true; lblDurationVal.Visible = true; lblDurationVal.Text = details.Tables[0].Rows[0][4].ToString(); tr4.Visible = true; trs4.Visible = true; } if (!string.IsNullOrEmpty(details.Tables[0].Rows[0][6].ToString())) { lnkSpotName.CommandArgument = details.Tables[0].Rows[0][6].ToString(); } 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("Festivals.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; lblMonth.Visible = false; lblMonthVal.Visible = false; lblSpotName.Visible = false; lblSpotNameVal.Visible = false; lblDuration.Visible = false; lblDurationVal.Visible = false; tr11.Visible = false; GridView1.Visible = false; } }