public DataSet FetchBanner()
{
DataSet ds = new DataSet();
GeneralDAL lp = new GeneralDAL();
ds = lp.FetchBanner();
return ds;
}
public DataSet FetchBanner()
{
DataSet ds = new DataSet();
GeneralDAL lp = new GeneralDAL();
ds = lp.FetchBanner();
return(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region Fetch Grid Page Size Details...
DataTable pg = new DataTable();
GeneralBAL pz = new GeneralBAL();
pg = pz.FetchGridPageSize();
if (pg.Rows.Count != 0 && pg.Rows[0][0].ToString() != string.Empty)
{
grdLP.PageSize = Convert.ToInt32(pg.Rows[0][0].ToString());
}
#endregion
// Bind the banner of the image.
DataSet ds = new DataSet();
GeneralDAL lp = new GeneralDAL();
ds = lp.FetchBanner();
if (ds.Tables[2].Rows.Count != 0)
{
imgBanner.ImageUrl = ds.Tables[2].Rows[0][1].ToString();
}
//End Bind the banner of the image.
// fetch value of the grid details....
DataSet ds1 = new DataSet();
LPDetailsBAL lp1 = new LPDetailsBAL();
ds1 = lp1.FetchLP();
grdLP.DataSource = ds1.Tables[0];
grdLP.DataBind();
if (Request.QueryString["LPId"] != null)
{
int rowno = 0;
for (int i = 0; ds1.Tables[0].Rows.Count > i; i++)
{
if (ds1.Tables[0].Rows[i]["LPId"].ToString() == Request.QueryString["LPId"].ToString())
{
rowno = i;
}
}
FetchGridDetails(Request.QueryString["LPId"].ToString());
grdLP.PageIndex = rowno / grdLP.PageSize;
int SelectedRowIndex = rowno - (grdLP.PageSize * grdLP.PageIndex);
grdLP.DataBind();
grdLP.Rows[SelectedRowIndex].BackColor = System.Drawing.Color.LightGray;
}//other load festival here.....
else
{
if (ds1.Tables[0].Rows.Count != 0)
{
FetchGridDetails(ds1.Tables[0].Rows[0][0].ToString());
grdLP.Rows[0].BackColor = System.Drawing.Color.LightGray;
}
//End fetch value of the grid details....
}
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList2.SelectedItem.Text == "Banner")
{
trBanner.Visible = true;
trGallery.Visible = false;
trGrid.Visible = false;
tr2.Visible = false;
trgrid4.Visible = false;
DataSet ds1 = new DataSet();
GeneralDAL lp = new GeneralDAL();
ds1 = lp.FetchBanner();
if (DropDownList1.SelectedItem.Text == "Historical Spots")
{
GridView2.DataSource = ds1.Tables[1];
}
else if (DropDownList1.SelectedItem.Text == "LP")
{
GridView2.DataSource = ds1.Tables[2];
}
else if (DropDownList1.SelectedItem.Text == "Festivals")
{
GridView2.DataSource = ds1.Tables[3];
}
else if (DropDownList1.SelectedItem.Text == "Home")
{
GridView2.DataSource = ds1.Tables[0];
}
GridView2.DataBind();
}
else if (DropDownList2.SelectedItem.Text == "Gallery")
{
tr2.Visible = false;
trgrid4.Visible = false;
trBanner.Visible = false;
trGallery.Visible = true;
trGrid.Visible = true;
tr1.Visible = false;
GridView1.DataSource = null;
GridView1.DataBind();
if (DropDownList1.SelectedItem.Text == "Historical Spots")
{
lblColumn.Text = "Spot Name";
DataSet ds = new DataSet();
SpotDetailsBAL sp = new SpotDetailsBAL();
ds = sp.FetchSpotDetails1();
ddlColumn.DataSource = ds.Tables[4];
ddlColumn.DataTextField = "spotname";
ddlColumn.DataValueField = "spotid";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Spot Name";
}
else if (DropDownList1.SelectedItem.Text == "LP")
{
lblColumn.Text = "LP Category Name";
DataSet ds = new DataSet();
LPDetailsBAL lp = new LPDetailsBAL();
ds = lp.FetchLP1();
ddlColumn.DataSource = ds.Tables[2];
ddlColumn.DataTextField = "lpcategoryname";
ddlColumn.DataValueField = "lpcategoryid";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose LP Category Name";
}
else if (DropDownList1.SelectedItem.Text == "Festivals")
{
lblColumn.Text = "Festival Name";
DataSet ds = new DataSet();
FestivalBAL fs = new FestivalBAL();
ds = fs.FetchFestival1();
ddlColumn.DataSource = ds.Tables[0];
ddlColumn.DataTextField = "Name";
ddlColumn.DataValueField = "FestivalID";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Festival Name";
}
else
{
lblColumn.Text = string.Empty;
ddlColumn.Items.Clear();
ddlColumn.Items.Add("Select");
}
}
else if (DropDownList2.SelectedItem.Text == "Map")
{
tr2.Visible = true;
trgrid4.Visible = true;
trBanner.Visible = false;
trGallery.Visible = false;
trGrid.Visible = false;
tr1.Visible = false;
// GridView3.DataSource = null;
GridView3.DataBind();
if (DropDownList1.SelectedItem.Text == "Historical Spots")
{
Label8.Text = "Spot Name";
DataSet ds = new DataSet();
SpotDetailsBAL sp = new SpotDetailsBAL();
ds = sp.FetchSpotDetails1();
DropDownList3.DataSource = ds.Tables[4];
DropDownList3.DataTextField = "spotname";
DropDownList3.DataValueField = "spotid";
DropDownList3.DataBind();
DropDownList3.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Spot Name";
}
else if (DropDownList1.SelectedItem.Text == "LP")
{
lblColumn.Text = "LP Category Name";
DataSet ds = new DataSet();
LPDetailsBAL lp = new LPDetailsBAL();
ds = lp.FetchLP1();
ddlColumn.DataSource = ds.Tables[2];
ddlColumn.DataTextField = "lpcategoryname";
ddlColumn.DataValueField = "lpcategoryid";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose LP Category Name";
}
else if (DropDownList1.SelectedItem.Text == "Festivals")
{
lblColumn.Text = "Festival Name";
DataSet ds = new DataSet();
FestivalBAL fs = new FestivalBAL();
ds = fs.FetchFestival1();
ddlColumn.DataSource = ds.Tables[0];
ddlColumn.DataTextField = "Name";
ddlColumn.DataValueField = "FestivalID";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Festival Name";
}
else
{
lblColumn.Text = string.Empty;
ddlColumn.Items.Clear();
ddlColumn.Items.Add("Select");
}
}
else
{
trBanner.Visible = false;
trGallery.Visible = false;
trGrid.Visible = false;
tr2.Visible = false;
trgrid4.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region Fetch Grid Page Size Details...
DataTable pg = new DataTable();
GeneralBAL pz = new GeneralBAL();
pg = pz.FetchGridPageSize();
if (pg.Rows.Count != 0 && pg.Rows[0][0].ToString() != string.Empty)
{
grdSpotName.PageSize = Convert.ToInt32(pg.Rows[0][0].ToString());
grdFestival.PageSize = Convert.ToInt32(pg.Rows[0][0].ToString());
}
#endregion
// Bind the search category value in first ddl
DataTable ds = new DataTable();
GeneralBAL lp = new GeneralBAL();
ds = lp.FetchSearchCategory();
ddlSearchCategory.DataSource = ds;
ddlSearchCategory.DataTextField = "SearchCategoryName";
ddlSearchCategory.DataValueField = "SearchCategoryID";
ddlSearchCategory.DataBind();
ddlSearchCategory.Items.Insert(0, "Select");
//End Bind the search category value in first ddl
// Bind the banner of the image.
DataSet dsphoto = new DataSet();
GeneralDAL lpphoto = new GeneralDAL();
dsphoto = lpphoto.FetchBanner();
if (dsphoto.Tables[1].Rows.Count != 0)
// imgBanner.ImageUrl = dsphoto.Tables[1].Rows[0][1].ToString();
//End Bind the banner of the image.
//// Bind the map of the image.
//DataSet dsmapphoto = new DataSet();
//GeneralDAL lpmapphoto = new GeneralDAL();
//dsmapphoto = lpmapphoto.FetchMap();
//if (dsmapphoto.Tables[1].Rows.Count != 0)
// Image1.ImageUrl = dsmapphoto.Tables[1].Rows[0][1].ToString();
//// End Bind the map of the image.
// fetch value of the grid details....
{
DataSet fetchspotdetails = new DataSet();
SpotDetailsBAL det = new SpotDetailsBAL();
fetchspotdetails = det.FetchSpotDetails();
grdSpotName.DataSource = fetchspotdetails.Tables[4];
grdSpotName.DataBind();
//End value of the grid details....
if (Session["SpotId"] != null)
{
int rowno = 0;
for (int i = 0; fetchspotdetails.Tables[4].Rows.Count > i; i++)
{
if (fetchspotdetails.Tables[4].Rows[i]["spotid"].ToString() == Session["SpotId"].ToString())
{
rowno = i;
}
}
FetchGridDetails(Session["SpotId"].ToString());
grdSpotName.PageIndex = rowno / grdSpotName.PageSize;
int SelectedRowIndex = rowno - (grdSpotName.PageSize * grdSpotName.PageIndex);
grdSpotName.DataBind();
grdSpotName.Rows[SelectedRowIndex].BackColor = System.Drawing.Color.LightGray;
Session["SpotId"] = null;
}
else if (Request.QueryString["SpotId"] != null)
{
int rowno = 0;
for (int i = 0; fetchspotdetails.Tables[4].Rows.Count > i; i++)
{
if (fetchspotdetails.Tables[4].Rows[i]["spotid"].ToString() == Request.QueryString["SpotId"].ToString())
{
rowno = i;
}
}
FetchGridDetails(Request.QueryString["SpotId"].ToString());
grdSpotName.PageIndex = rowno / grdSpotName.PageSize;
int SelectedRowIndex = rowno - (grdSpotName.PageSize * grdSpotName.PageIndex);
grdSpotName.DataBind();
grdSpotName.Rows[SelectedRowIndex].BackColor = System.Drawing.Color.LightGray;
}
else
{
if (fetchspotdetails.Tables[4].Rows.Count != 0)
{
grdSpotName.Rows[0].BackColor = System.Drawing.Color.LightGray;
FetchGridDetails(fetchspotdetails.Tables[4].Rows[0][0].ToString());
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region Fetch Grid Page Size Details...
DataTable pg = new DataTable();
GeneralBAL pz = new GeneralBAL();
pg = pz.FetchGridPageSize();
if (pg.Rows.Count != 0 && pg.Rows[0][0].ToString() != string.Empty)
{
grdSpotName.PageSize = Convert.ToInt32(pg.Rows[0][0].ToString());
grdFestival.PageSize = Convert.ToInt32(pg.Rows[0][0].ToString());
}
#endregion
// Bind the search category value in first ddl
DataTable ds = new DataTable();
GeneralBAL lp = new GeneralBAL();
ds = lp.FetchSearchCategory();
ddlSearchCategory.DataSource = ds;
ddlSearchCategory.DataTextField = "SearchCategoryName";
ddlSearchCategory.DataValueField = "SearchCategoryID";
ddlSearchCategory.DataBind();
ddlSearchCategory.Items.Insert(0, "Select");
//End Bind the search category value in first ddl
// Bind the banner of the image.
DataSet dsphoto = new DataSet();
GeneralDAL lpphoto = new GeneralDAL();
dsphoto = lpphoto.FetchBanner();
if (dsphoto.Tables[1].Rows.Count != 0)
// imgBanner.ImageUrl = dsphoto.Tables[1].Rows[0][1].ToString();
//End Bind the banner of the image.
//// Bind the map of the image.
//DataSet dsmapphoto = new DataSet();
//GeneralDAL lpmapphoto = new GeneralDAL();
//dsmapphoto = lpmapphoto.FetchMap();
//if (dsmapphoto.Tables[1].Rows.Count != 0)
// Image1.ImageUrl = dsmapphoto.Tables[1].Rows[0][1].ToString();
//// End Bind the map of the image.
// fetch value of the grid details....
{
DataSet fetchspotdetails = new DataSet();
SpotDetailsBAL det = new SpotDetailsBAL();
fetchspotdetails = det.FetchSpotDetails();
grdSpotName.DataSource = fetchspotdetails.Tables[4];
grdSpotName.DataBind();
//End value of the grid details....
if (Session["SpotId"] != null)
{
int rowno = 0;
for (int i = 0; fetchspotdetails.Tables[4].Rows.Count > i; i++)
{
if (fetchspotdetails.Tables[4].Rows[i]["spotid"].ToString() == Session["SpotId"].ToString())
rowno = i;
}
FetchGridDetails(Session["SpotId"].ToString());
grdSpotName.PageIndex = rowno / grdSpotName.PageSize;
int SelectedRowIndex = rowno - (grdSpotName.PageSize * grdSpotName.PageIndex);
grdSpotName.DataBind();
grdSpotName.Rows[SelectedRowIndex].BackColor = System.Drawing.Color.LightGray;
Session["SpotId"] = null;
}
else if (Request.QueryString["SpotId"] != null)
{
int rowno = 0;
for (int i = 0; fetchspotdetails.Tables[4].Rows.Count > i; i++)
{
if (fetchspotdetails.Tables[4].Rows[i]["spotid"].ToString() == Request.QueryString["SpotId"].ToString())
rowno = i;
}
FetchGridDetails(Request.QueryString["SpotId"].ToString());
grdSpotName.PageIndex = rowno / grdSpotName.PageSize;
int SelectedRowIndex = rowno - (grdSpotName.PageSize * grdSpotName.PageIndex);
grdSpotName.DataBind();
grdSpotName.Rows[SelectedRowIndex].BackColor = System.Drawing.Color.LightGray;
}
else
{
if (fetchspotdetails.Tables[4].Rows.Count != 0)
{
grdSpotName.Rows[0].BackColor = System.Drawing.Color.LightGray;
FetchGridDetails(fetchspotdetails.Tables[4].Rows[0][0].ToString());
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region Fetch Grid Page Size Details...
DataTable pg = new DataTable();
GeneralBAL pz = new GeneralBAL();
pg = pz.FetchGridPageSize();
if (pg.Rows.Count != 0 && pg.Rows[0][0].ToString() != string.Empty)
grdFestival.PageSize = Convert.ToInt32(pg.Rows[0][0].ToString());
#endregion
// Bind the banner of the image.
DataSet ds = new DataSet();
GeneralDAL lp = new GeneralDAL();
ds = lp.FetchBanner();
if (ds.Tables[3].Rows.Count != 0)
imgBanner.ImageUrl = ds.Tables[3].Rows[0][1].ToString();
//End Bind the banner of the image.
// fetch value of the grid details....
DataSet ds1 = new DataSet();
FestivalBAL fs = new FestivalBAL();
ds1 = fs.FetchFestival();
grdFestival.DataSource = ds1.Tables[0];
grdFestival.DataBind();
//End fetch value of the grid details....
//if comes from index page
if (Session["festivalId"] != null)
{
int rowno=0;
for (int i = 0; ds1.Tables[0].Rows.Count > i; i++)
{
if (ds1.Tables[0].Rows[i]["festivalid"].ToString() == Session["festivalId"].ToString())
rowno = i;
}
FetchGridDetails(Session["festivalId"].ToString());
grdFestival.PageIndex = rowno / grdFestival.PageSize;
int SelectedRowIndex = rowno - (grdFestival.PageSize * grdFestival.PageIndex);
grdFestival.DataBind();
grdFestival.Rows[SelectedRowIndex].BackColor = System.Drawing.Color.LightGray;
Session["festivalId"] = null;
}//other load festival here.....
else if (Request.QueryString["festivalId"] != null)
{
int rowno = 0;
for (int i = 0; ds1.Tables[0].Rows.Count > i; i++)
{
if (ds1.Tables[0].Rows[i]["festivalid"].ToString() == Request.QueryString["festivalId"].ToString())
rowno = i;
}
FetchGridDetails(Request.QueryString["festivalId"].ToString());
grdFestival.PageIndex = rowno / grdFestival.PageSize;
int SelectedRowIndex = rowno - (grdFestival.PageSize * grdFestival.PageIndex);
grdFestival.DataBind();
grdFestival.Rows[SelectedRowIndex].BackColor = System.Drawing.Color.LightGray;
}
else
{
if (ds1.Tables[0].Rows.Count != 0)
{
FetchGridDetails(ds1.Tables[0].Rows[0][0].ToString());
grdFestival.Rows[0].BackColor = System.Drawing.Color.LightGray;
}
}
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList2.SelectedItem.Text == "Banner")
{
trBanner.Visible = true;
trGallery.Visible = false;
trGrid.Visible = false;
tr2.Visible = false;
trgrid4.Visible = false;
DataSet ds1 = new DataSet();
GeneralDAL lp = new GeneralDAL();
ds1 = lp.FetchBanner();
if (DropDownList1.SelectedItem.Text == "Historical Spots")
GridView2.DataSource = ds1.Tables[1];
else if (DropDownList1.SelectedItem.Text == "LP")
GridView2.DataSource = ds1.Tables[2];
else if (DropDownList1.SelectedItem.Text == "Festivals")
GridView2.DataSource = ds1.Tables[3];
else if (DropDownList1.SelectedItem.Text == "Home")
GridView2.DataSource = ds1.Tables[0];
GridView2.DataBind();
}
else if (DropDownList2.SelectedItem.Text == "Gallery")
{
tr2.Visible = false;
trgrid4.Visible = false;
trBanner.Visible = false;
trGallery.Visible = true;
trGrid.Visible = true;
tr1.Visible = false;
GridView1.DataSource = null;
GridView1.DataBind();
if (DropDownList1.SelectedItem.Text == "Historical Spots")
{
lblColumn.Text = "Spot Name";
DataSet ds = new DataSet();
SpotDetailsBAL sp = new SpotDetailsBAL();
ds = sp.FetchSpotDetails1();
ddlColumn.DataSource = ds.Tables[4];
ddlColumn.DataTextField = "spotname";
ddlColumn.DataValueField = "spotid";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Spot Name";
}
else if (DropDownList1.SelectedItem.Text == "LP")
{
lblColumn.Text = "LP Category Name";
DataSet ds = new DataSet();
LPDetailsBAL lp = new LPDetailsBAL();
ds = lp.FetchLP1();
ddlColumn.DataSource = ds.Tables[2];
ddlColumn.DataTextField = "lpcategoryname";
ddlColumn.DataValueField = "lpcategoryid";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose LP Category Name";
}
else if (DropDownList1.SelectedItem.Text == "Festivals")
{
lblColumn.Text = "Festival Name";
DataSet ds = new DataSet();
FestivalBAL fs = new FestivalBAL();
ds = fs.FetchFestival1();
ddlColumn.DataSource = ds.Tables[0];
ddlColumn.DataTextField = "Name";
ddlColumn.DataValueField = "FestivalID";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Festival Name";
}
else
{
lblColumn.Text = string.Empty;
ddlColumn.Items.Clear();
ddlColumn.Items.Add("Select");
}
}
else if (DropDownList2.SelectedItem.Text == "Map")
{
tr2.Visible = true;
trgrid4.Visible = true;
trBanner.Visible = false;
trGallery.Visible = false ;
trGrid.Visible = false;
tr1.Visible = false;
// GridView3.DataSource = null;
GridView3.DataBind();
if (DropDownList1.SelectedItem.Text == "Historical Spots")
{
Label8.Text = "Spot Name";
DataSet ds = new DataSet();
SpotDetailsBAL sp = new SpotDetailsBAL();
ds = sp.FetchSpotDetails1();
DropDownList3.DataSource = ds.Tables[4];
DropDownList3.DataTextField = "spotname";
DropDownList3.DataValueField = "spotid";
DropDownList3.DataBind();
DropDownList3.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Spot Name";
}
else if (DropDownList1.SelectedItem.Text == "LP")
{
lblColumn.Text = "LP Category Name";
DataSet ds = new DataSet();
LPDetailsBAL lp = new LPDetailsBAL();
ds = lp.FetchLP1();
ddlColumn.DataSource = ds.Tables[2];
ddlColumn.DataTextField = "lpcategoryname";
ddlColumn.DataValueField = "lpcategoryid";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose LP Category Name";
}
else if (DropDownList1.SelectedItem.Text == "Festivals")
{
lblColumn.Text = "Festival Name";
DataSet ds = new DataSet();
FestivalBAL fs = new FestivalBAL();
ds = fs.FetchFestival1();
ddlColumn.DataSource = ds.Tables[0];
ddlColumn.DataTextField = "Name";
ddlColumn.DataValueField = "FestivalID";
ddlColumn.DataBind();
ddlColumn.Items.Insert(0, "Select");
RequiredFieldValidator1.ErrorMessage = "Choose Festival Name";
}
else
{
lblColumn.Text = string.Empty;
ddlColumn.Items.Clear();
ddlColumn.Items.Add("Select");
}
}
else
{
trBanner.Visible = false;
trGallery.Visible = false;
trGrid.Visible = false;
tr2.Visible = false;
trgrid4.Visible = false;
}
}