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 banner of the image. DataSet ds = new DataSet(); DataTable fest = new DataTable(); GeneralBAL lp = new GeneralBAL(); ds = lp.FetchBanner(); if (ds.Tables[0].Rows.Count != 0) // imgBanner.ImageUrl = ds.Tables[0].Rows[0][1].ToString(); //End Bind the banner of the image. fest = lp.FetchFestivalByMonth(); grdFestival.DataSource = fest; grdFestival.DataBind(); // Bind the search category value in first ddl DataTable ds1 = new DataTable(); GeneralBAL lp1 = new GeneralBAL(); ds1 = lp1.FetchSearchCategory(); ddlSearchCategory.DataSource = ds1; ddlSearchCategory.DataTextField = "SearchCategoryName"; ddlSearchCategory.DataValueField = "SearchCategoryID"; ddlSearchCategory.DataBind(); ddlSearchCategory.Items.Insert(0, "Select"); //End Bind the search category value in first ddl // 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 first value of the grid details.... DataTable dt = fetchspotdetails.Tables[4]; DataTable dt1 = new DataTable(); dt1.Columns.Add("id"); dt1.Columns.Add("pid"); dt1.Columns.Add("name"); dt1.Columns.Add("desc"); foreach (DataRow row in dt.Rows) { string[] s = row["spotname"].ToString().Split('-'); if (dt1.Select("name = '" + s[0] + "'").Length == 0) { dt1.Rows.Add(s[0], null, s[0]); } dt1.Rows.Add(row["spotid"].ToString(), s[0], s[1], row[2].ToString()); } Addmenu(dt1); Lbl_Festival.Text = "Festival(s) in " + GetMonthName(DateTime.Now); // Bind Active list details DataSet ds2 = new DataSet(); GeneralBAL act = new GeneralBAL(); ds2 = act.FetchNoOfActiveList(); if (ds2.Tables[0].Rows.Count != 0) { lblSpot.Visible = true; lblSpot.Text = ds2.Tables[0].Rows[0][0].ToString(); } else lblSpot.Visible = false; if (ds2.Tables[1].Rows.Count != 0) { lblLp.Visible = true; lblLp.Text = ds2.Tables[1].Rows[0][0].ToString(); } else lblLp.Visible = false; if (ds2.Tables[2].Rows.Count != 0) { lblFest.Visible = true; lblFest.Text = ds2.Tables[2].Rows[0][0].ToString(); } else lblFest.Visible = false; //end Bind Active list details }
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 banner of the image. DataSet ds = new DataSet(); DataTable fest = new DataTable(); GeneralBAL lp = new GeneralBAL(); ds = lp.FetchBanner(); if (ds.Tables[0].Rows.Count != 0) imgBanner.ImageUrl = ds.Tables[0].Rows[0][1].ToString(); //End Bind the banner of the image. fest = lp.FetchFestivalByMonth(); grdFestival.DataSource = fest; grdFestival.DataBind(); // Bind the search category value in first ddl DataTable ds1 = new DataTable(); GeneralBAL lp1 = new GeneralBAL(); ds1 = lp1.FetchSearchCategory(); ddlSearchCategory.DataSource = ds1; ddlSearchCategory.DataTextField = "SearchCategoryName"; ddlSearchCategory.DataValueField = "SearchCategoryID"; ddlSearchCategory.DataBind(); ddlSearchCategory.Items.Insert(0, "Select"); //End Bind the search category value in first ddl // 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 first value of the grid details.... Lbl_Festival.Text = "Festival(s) in " + GetMonthName(DateTime.Now); // Bind Active list details DataSet ds2 = new DataSet(); GeneralBAL act = new GeneralBAL(); ds2 = act.FetchNoOfActiveList(); if (ds2.Tables[0].Rows.Count != 0) { lblSpot.Visible = true; lblSpot.Text = ds2.Tables[0].Rows[0][0].ToString(); } else lblSpot.Visible = false; if (ds2.Tables[1].Rows.Count != 0) { lblLp.Visible = true; lblLp.Text = ds2.Tables[1].Rows[0][0].ToString(); } else lblLp.Visible = false; if (ds2.Tables[2].Rows.Count != 0) { lblFest.Visible = true; lblFest.Text = ds2.Tables[2].Rows[0][0].ToString(); } else lblFest.Visible = false; //end Bind Active list details } }
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 banner of the image. DataSet ds = new DataSet(); DataTable fest = new DataTable(); GeneralBAL lp = new GeneralBAL(); ds = lp.FetchBanner(); if (ds.Tables[0].Rows.Count != 0) { imgBanner.ImageUrl = ds.Tables[0].Rows[0][1].ToString(); } //End Bind the banner of the image. fest = lp.FetchFestivalByMonth(); grdFestival.DataSource = fest; grdFestival.DataBind(); // Bind the search category value in first ddl DataTable ds1 = new DataTable(); GeneralBAL lp1 = new GeneralBAL(); ds1 = lp1.FetchSearchCategory(); ddlSearchCategory.DataSource = ds1; ddlSearchCategory.DataTextField = "SearchCategoryName"; ddlSearchCategory.DataValueField = "SearchCategoryID"; ddlSearchCategory.DataBind(); ddlSearchCategory.Items.Insert(0, "Select"); //End Bind the search category value in first ddl // 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 first value of the grid details.... DataTable dt = fetchspotdetails.Tables[4]; DataTable dt1 = new DataTable(); dt1.Columns.Add("id"); dt1.Columns.Add("pid"); dt1.Columns.Add("name"); dt1.Columns.Add("desc"); foreach (DataRow row in dt.Rows) { string[] s = row["spotname"].ToString().Split('-'); if (dt1.Select("name = '" + s[0] + "'").Length == 0) { dt1.Rows.Add(s[0], null, s[0]); } dt1.Rows.Add(row["spotid"].ToString(), s[0], s[1], row[2].ToString()); } Addmenu(dt1); Lbl_Festival.Text = "Festival(s) in " + GetMonthName(DateTime.Now); // Bind Active list details DataSet ds2 = new DataSet(); GeneralBAL act = new GeneralBAL(); ds2 = act.FetchNoOfActiveList(); if (ds2.Tables[0].Rows.Count != 0) { lblSpot.Visible = true; lblSpot.Text = ds2.Tables[0].Rows[0][0].ToString(); } else { lblSpot.Visible = false; } if (ds2.Tables[1].Rows.Count != 0) { lblLp.Visible = true; lblLp.Text = ds2.Tables[1].Rows[0][0].ToString(); } else { lblLp.Visible = false; } if (ds2.Tables[2].Rows.Count != 0) { lblFest.Visible = true; lblFest.Text = ds2.Tables[2].Rows[0][0].ToString(); } else { lblFest.Visible = false; } //end Bind Active list details } }