public void BindData() { try { // Dataset will countain 4 table 0 - all cat services, // Table 1 - all dog services, // Table 2 - Dog main service which is displayed on homepage // Table 3 - cat main service which is displayed on homepage #region Dog StoreFront ObjService = new StoreFront(); DataSet ds = new DataSet(); ds = ObjService.GetAllCatDogService(); if (ds.Tables[1].Rows.Count > 0) { int currpage; PageDs.DataSource = ds.Tables[1].DefaultView; PageDs.AllowPaging = true; PageDs.PageSize = 50; if (ViewState["CurrentPage"] != null) { currpage = Convert.ToInt32(ViewState["CurrentPage"]); } else { currpage = 1; } ViewState["CurrentPage"] = currpage; PageDs.CurrentPageIndex = currpage - 1; bool check = false; if (PageDs.IsFirstPage) { check = true; } else if (PageDs.IsLastPage) { check = true; } if (PageDs.PageCount == 1) { } else if (PageDs.PageCount > 1 && check == false) { } if (ds.Tables[1].Rows.Count == 0) { dlDog.Visible = false; } else { Session["PDSAllNewestProviders"] = PageDs; dlDog.DataSource = PageDs; dlDog.DataBind(); } } else { dlDog.Visible = false; } #endregion Dg #region Cat if (ds.Tables[0].Rows.Count > 0) { int currpage; PageDsCat.DataSource = ds.Tables[0].DefaultView; PageDsCat.AllowPaging = true; PageDsCat.PageSize = 50; if (ViewState["CurrentPage_Cat"] != null) { currpage = Convert.ToInt32(ViewState["CurrentPage_Cat"]); } else { currpage = 1; } ViewState["CurrentPage_Cat"] = currpage; PageDsCat.CurrentPageIndex = currpage - 1; bool check = false; if (PageDsCat.IsFirstPage) { check = true; } else if (PageDsCat.IsLastPage) { check = true; } if (PageDsCat.PageCount == 1) { } else if (PageDsCat.PageCount > 1 && check == false) { } if (ds.Tables[0].Rows.Count == 0) { dlCat.Visible = false; } else { Session["PDSAllNewestProviders_Cat"] = PageDsCat; dlCat.DataSource = PageDsCat; dlCat.DataBind(); } } else { dlCat.Visible = false; } #endregion #region Header Services StoreFront ObjStoreFront = new StoreFront(); DataSet ds_Service = new DataSet(); ds_Service = ObjStoreFront.GetAllServicePageServices(Convert.ToInt32(Session["UserType"].ToString())); if (ds_Service.Tables[1].Rows.Count > 0) { ImgDog.ImageUrl = Session["HomePath"] + "StoreData/ServicePageServices/" + ds_Service.Tables[1].Rows[0]["ImageName"].ToString(); ImgDog.ToolTip = ds_Service.Tables[1].Rows[0]["Description"].ToString(); divDogService.InnerText = ds_Service.Tables[1].Rows[0]["Description"].ToString(); } if (ds_Service.Tables[0].Rows.Count > 0) { imgCatservice.ImageUrl = Session["HomePath"] + "StoreData/ServicePageServices/" + ds_Service.Tables[0].Rows[0]["ImageName"].ToString(); imgCatservice.ToolTip = ds_Service.Tables[0].Rows[0]["Description"].ToString(); divCatService.InnerText = ds_Service.Tables[0].Rows[0]["Description"].ToString(); } } catch (Exception ex) { throw ex; } #endregion }