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