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