private void SetLinkTarget() { CustomerEDSC.v_MenuDTDataTable dt = new CustomerDAC().RetrieveMenuExplorers((int)SystemConstants.MenuType.MemberMenu); CustomerEDSC.PageDTDataTable dtPages = new CustomerDAC().RetrievePages(); int x = 0; foreach (CustomerEDSC.v_MenuDTRow drParent in dt) { if (drParent.LinkType == 1) { x++; if (drParent.ParentMenuID == 0 && drParent.LinkText != null) { MenuItem menu = new MenuItem(drParent.LinkText, x.ToString(), "", "~/Activity/Default.aspx?" + SystemConstants.CategoryID + "=" + drParent.LinkValue, ""); MenuNavigation.Items.Add(menu); foreach (CustomerEDSC.v_MenuDTRow drChild in dt) { if (drChild.ParentMenuID == drParent.ID && drChild.LinkText != null && drChild.LinkType != 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", "~/Activity/Default.aspx?" + SystemConstants.CategoryID + "=" + drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } else if (drChild.ParentMenuID == drParent.ID && drChild.LinkType == 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } } } } else if (drParent.LinkType == 2) { x++; if (drParent.ParentMenuID == 0 && drParent.LinkText != null) { MenuItem menu = new MenuItem(drParent.LinkText, x.ToString(), "", "~/Activity/Default.aspx?" + SystemConstants.ProviderID + "=" + drParent.LinkValue, ""); MenuNavigation.Items.Add(menu); foreach (CustomerEDSC.v_MenuDTRow drChild in dt) { if (drChild.ParentMenuID == drParent.ID && drChild.LinkText != null && drChild.LinkType != 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", "~/Activity/Default.aspx?" + SystemConstants.ProviderID + "=" + drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } else if (drChild.ParentMenuID == drParent.ID && drChild.LinkType == 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } } } } else if (drParent.LinkType == 3) { x++; if (drParent.ParentMenuID == 0) { MenuItem menu = new MenuItem(drParent.LinkText, x.ToString(), "", "~/Activity/Default.aspx??" + SystemConstants.ActivityID + "=" + drParent.LinkValue, ""); MenuNavigation.Items.Add(menu); foreach (CustomerEDSC.v_MenuDTRow drChild in dt) { if (drChild.ParentMenuID == drParent.ID && drChild.LinkType != 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", "~/Activity/Default.aspx?" + SystemConstants.ActivityID + "=" + drChild.LinkValue, " "); menu.ChildItems.Add(ChildMenu); } else if (drChild.ParentMenuID == drParent.ID && drChild.LinkType == 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } } } } else if (drParent.LinkType == 4) { var PageName = dtPages .Where(p => p.ID == Convert.ToInt32(drParent.LinkValue)).FirstOrDefault(); if (PageName == null) { PageName = new CustomerEDSC.PageDTDataTable().NewPageDTRow(); PageName.Name = "NotFound"; } x++; if (drParent.ParentMenuID == 0) { MenuItem menu = new MenuItem(drParent.LinkText, x.ToString(), "", "~/Pages/" + PageName.Name, ""); MenuNavigation.Items.Add(menu); foreach (CustomerEDSC.v_MenuDTRow drChild in dt) { if (drChild.ParentMenuID == drParent.ID && drChild.LinkType != 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", "~/Pages/" + PageName.Name, ""); menu.ChildItems.Add(ChildMenu); } else if (drChild.ParentMenuID == drParent.ID && drChild.LinkType == 6) { if (drChild.LinkType == 4) { var ChildPageName = dtPages .Where(p => p.ID == Convert.ToInt32(drChild.LinkValue)).FirstOrDefault(); if (ChildPageName == null) { ChildPageName = new CustomerEDSC.PageDTDataTable().NewPageDTRow(); ChildPageName.Name = "NotFound"; } MenuItem ChildMenuPage = new MenuItem(drChild.LinkText, "", "", ChildPageName.Name, ""); menu.ChildItems.Add(ChildMenuPage); } MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } } } } else if (drParent.LinkType == 5) { var PageName = dtPages .Where(p => p.ID == Convert.ToInt32(drParent.LinkValue)).FirstOrDefault(); if (PageName == null) { PageName = new CustomerEDSC.PageDTDataTable().NewPageDTRow(); PageName.Name = "NotFound"; } x++; if (drParent.ParentMenuID == 0) { MenuItem menu = new MenuItem(drParent.LinkText, x.ToString(), "", "~/Pages/" + PageName.Name, ""); MenuNavigation.Items.Add(menu); foreach (CustomerEDSC.v_MenuDTRow drChild in dt) { var ChildPageName = dtPages .Where(p => p.ID == Convert.ToInt32(drChild.LinkValue)).FirstOrDefault(); if (ChildPageName == null) { ChildPageName = new CustomerEDSC.PageDTDataTable().NewPageDTRow(); ChildPageName.Name = "NotFound"; } if (drChild.ParentMenuID == drParent.ID && drChild.LinkType != 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", "~/Pages/" + ChildPageName.Name, ""); menu.ChildItems.Add(ChildMenu); } else if (drChild.ParentMenuID == drParent.ID && drChild.LinkType == 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", ChildPageName.Name, ""); menu.ChildItems.Add(ChildMenu); } } } } else if (drParent.LinkType == 6) { x++; if (drParent.ParentMenuID == 0) { MenuItem menu = new MenuItem(drParent.LinkText, x.ToString(), "", drParent.LinkValue, ""); MenuNavigation.Items.Add(menu); foreach (CustomerEDSC.v_MenuDTRow drChild in dt) { if (drChild.ParentMenuID == drParent.ID && drChild.LinkType != 6) { var ChildPageName = dtPages .Where(p => p.ID == Convert.ToInt32(drChild.LinkValue)).FirstOrDefault(); if (ChildPageName == null) { ChildPageName = new CustomerEDSC.PageDTDataTable().NewPageDTRow(); ChildPageName.Name = "NotFound"; } if (drChild.ParentMenuID == drParent.ID && drChild.LinkType != 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", "~/Pages/" + ChildPageName.Name, ""); menu.ChildItems.Add(ChildMenu); } else if (drChild.ParentMenuID == drParent.ID && drChild.LinkType != 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", "~/Pages/" + drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } } else if (drChild.ParentMenuID == drParent.ID && drChild.LinkType == 6) { MenuItem ChildMenu = new MenuItem(drChild.LinkText, "", "", drChild.LinkValue, ""); menu.ChildItems.Add(ChildMenu); } } } } } MenuItem Rewards = new MenuItem("Rewards Program", x.ToString(), "", "~/Rewards/RewardsHome"); MenuNavigation.Items.Add(Rewards); x++; MenuItem ContactUs = new MenuItem("Contact Us", x.ToString(), "", "~/ContactUs"); MenuNavigation.Items.Add(ContactUs); }
internal void Refresh() { ddSort.SelectedValue = SortValue; lblKeyword.Visible = false; String query = ""; if (SearchKey != null) { List <String> parameters = new CustomerBFC().RefineSearchKey(SearchKey); foreach (var parameter in parameters) { if (!string.IsNullOrEmpty(parameter)) { if (parameter.StartsWith(SystemConstants.Query)) { query = parameter.Replace(SystemConstants.Query, string.Empty); } else if (parameter.StartsWith(SystemConstants.Location)) { String[] locs = parameter.Replace(SystemConstants.Location, string.Empty).ToUpper().Split(';'); var subDT = new CustomerDAC().RetrieveSuburbs(); var suburbs = subDT.Where(x => locs.Contains(x.Name.ToUpper())); foreach (var sub in suburbs) { if (String.IsNullOrEmpty(SuburbID)) { SuburbID = sub.ID.ToString(); } else { SuburbID += "|" + sub.ID.ToString(); } } } else if (parameter.StartsWith(SystemConstants.Day)) { MonFilter = TueFilter = WedFilter = ThursFilter = FriFilter = SatFilter = SunFilter = false; string[] days = parameter.Replace(SystemConstants.Day, string.Empty).Split(';'); foreach (var day in days) { if (day.ToUpper().Equals(DayOfWeek.Monday.ToString().ToUpper())) { MonFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Tuesday.ToString().ToUpper())) { TueFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Wednesday.ToString().ToUpper())) { WedFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Thursday.ToString().ToUpper())) { ThursFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Friday.ToString().ToUpper())) { FriFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Saturday.ToString().ToUpper())) { SatFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Sunday.ToString().ToUpper())) { SunFilter = true; } } } else if (parameter.StartsWith(SystemConstants.Time)) { string[] times = parameter.Replace(SystemConstants.Time, string.Empty).Split('-'); if (times.Length == 2) { dtFrom = Convert.ToDateTime(SystemConstants.nodate.ToShortDateString() + " " + Convert.ToDateTime(times[0]).ToShortTimeString()); dtTo = Convert.ToDateTime(SystemConstants.nodate.ToShortDateString() + " " + Convert.ToDateTime(times[1]).ToShortTimeString()); } else if (times.Length == 1) { dtFrom = Convert.ToDateTime(SystemConstants.nodate.ToShortDateString() + " " + Convert.ToDateTime(times[0]).ToShortTimeString()); } } } } } if (!string.IsNullOrEmpty(query)) { Stopwatch sw = Stopwatch.StartNew(); SetDataSourceFromSearchKey(query); lblAmount.Text = new CustomerDAC().RetrieveProviderActivitiesbySearchPhraseCount(ProviderID, dtFrom.ToString(), dtTo.ToString(), tmFrom.ToString(), tmTo.ToString(), AgeFrom, AgeTo, SuburbID, CategoryID, query, MonFilter.ToString(), TueFilter.ToString(), WedFilter.ToString(), ThursFilter.ToString(), FriFilter.ToString(), SatFilter.ToString(), SunFilter.ToString()).ToString(); if (Convert.ToInt32(lblAmount.Text) <= Convert.ToInt32(PageSize + StartRow)) { lblEndIndex.Text = lblAmount.Text; } else { lblEndIndex.Text = (StartRow + PageSize).ToString(); } lblStartIndex.Text = (StartRow + 1).ToString(); if (Convert.ToInt32(lblStartIndex.Text) >= Convert.ToInt32(lblEndIndex.Text)) { lblStartIndex.Text = lblEndIndex.Text; } lblEndIndex1.Text = lblEndIndex.Text; lblStartIndex1.Text = lblStartIndex.Text; lblAmount1.Text = lblAmount.Text; lblKeyword.Visible = true; if (lblAmount.Text != "0") { // lblKeyword.Text = "Search Found " + lblAmount.Text + " Record with keyword '" + SearchKey + "'"; // else //{ //lblKeyword.Text = "there are no records with keyword '" + SearchKey + "'"; } TimeSpan elapsed = sw.Elapsed; hdnTimespan.Value = elapsed.ToString(); } else { SetDataSourceFromCategoryProvider(); lblAmount.Text = new CustomerDAC().RetrieveProviderActivitiesCount(ProviderID, dtFrom.ToString(), dtTo.ToString(), tmFrom.ToString(), tmTo.ToString(), AgeFrom, AgeTo, SuburbID, CategoryID, MonFilter.ToString(), TueFilter.ToString(), WedFilter.ToString(), ThursFilter.ToString(), FriFilter.ToString(), SatFilter.ToString(), SunFilter.ToString()).ToString(); if (Convert.ToInt32(lblAmount.Text) <= Convert.ToInt32(PageSize + StartRow)) { lblEndIndex.Text = lblAmount.Text; } else { lblEndIndex.Text = (StartRow + PageSize).ToString(); } lblStartIndex.Text = (StartRow + 1).ToString(); if (Convert.ToInt32(lblStartIndex.Text) >= Convert.ToInt32(lblEndIndex.Text)) { lblStartIndex.Text = lblEndIndex.Text; } lblEndIndex1.Text = lblEndIndex.Text; lblStartIndex1.Text = lblStartIndex.Text; lblAmount1.Text = lblAmount.Text; } if (GridViewActivities.HeaderRow != null) { GridViewActivities.HeaderRow.TableSection = TableRowSection.TableHeader; } }
public List <string> RefineSearchKey(string InputQueries) { List <string> SearchParameters = new List <string>(); String SearchQuery = ""; String DaysQuery = ""; String LocationsQuery = ""; String TimeQuery = ""; List <TimeSpan> Timelist = new List <TimeSpan>(); List <string> keywords = InputQueries.ToUpper().Split(' ').OfType <string>().ToList(); if (isImplementAdvanceSearch()) { /*Delete Prepositions/Postposition from keyword * See SystemConstants.Prepositions for list of prepositions */ List <string> exclude = (SystemConstants.Prepositions + SystemConstants.Conjunctions).Split(';').Select(x => x.Trim()).OfType <string>().ToList(); HashSet <string> preposHash = new HashSet <string>(exclude.Select(x => x.ToUpper())); keywords.RemoveAll(x => preposHash.Contains(x.ToUpper())); /*Match and save locations from keyword * First we retrieve available locations from db */ var suburbs = new CustomerDAC().RetrieveSuburbs().ToList(); List <SuburbExplorer> SubsCont = new List <SuburbExplorer>(); foreach (var suburb in suburbs) { string[] subs = suburb.Name.Split(' '); foreach (var sub in subs) { SubsCont.Add(new SuburbExplorer() { ID = suburb.ID, Name = sub }); } } var matchedLocs = SubsCont.Where(x => keywords.Contains(x.Name.ToUpper())); HashSet <int> locsID = new HashSet <int>(matchedLocs.Select(x => x.ID)); IEnumerable <CustomerEDSC.v_SuburbExplorerDTRow> matchedSuburbs = suburbs.Where(x => locsID.Contains(x.ID)); StringBuilder lq = new StringBuilder(); foreach (var matchedSuburb in matchedSuburbs) { lq.Append(matchedSuburb.Name + ";"); } LocationsQuery = lq.ToString(); HashSet <string> locationsHash = new HashSet <string>(SubsCont.Select(x => x.Name.ToUpper())); keywords.RemoveAll(x => locationsHash.Contains(x.ToUpper())); /*Match and save Days from keyword */ List <string> dayofweek = new List <string> { DayOfWeek.Monday.ToString(), DayOfWeek.Tuesday.ToString(), DayOfWeek.Wednesday.ToString(), DayOfWeek.Thursday.ToString(), DayOfWeek.Friday.ToString(), DayOfWeek.Saturday.ToString(), DayOfWeek.Sunday.ToString(), }; HashSet <string> dayofweekHash = new HashSet <string>(dayofweek.Select(x => x.ToUpper())); var days = keywords.Where(x => dayofweekHash.Contains(x.ToUpper())); if (days.Count() != 0) { DaysQuery = String.Join(";", days); } keywords.RemoveAll(x => dayofweekHash.Contains(x.ToUpper())); foreach (var key in keywords) { DateTime dateTime = new DateTime(); //12hourformat h:mm tt 6:30 AM if (DateTime.TryParseExact(key, @"h:mm tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else if (DateTime.TryParseExact(key, @"h:mm tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } if (DateTime.TryParseExact(key, @"hmm tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else if (DateTime.TryParseExact(key, @"hmm tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } if (DateTime.TryParseExact(key, @"h:mmtt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else if (DateTime.TryParseExact(key, @"h:mmtt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } if (DateTime.TryParseExact(key, @"hmmtt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else if (DateTime.TryParseExact(key, @"hmmtt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } if (DateTime.TryParseExact(key, @"h tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } if (DateTime.TryParseExact(key, @"htt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } //24hourformat HH:mm 14:30 else if (DateTime.TryParseExact(key, @"HH:mm", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else if (DateTime.TryParseExact(key, @"H:mm", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else if (DateTime.TryParseExact(key, @"HHmm", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else if (DateTime.TryParseExact(key, @"Hmm", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { Timelist.Add(dateTime.TimeOfDay); } else { var keyCollections = new CustomerDAC().SearchKeywordCollection(key); if (keyCollections.Count == 0 || keyCollections == null) { foreach (var keycol in keyCollections) { SearchQuery = SearchQuery + keycol.Keywords + ";"; } } if (!string.IsNullOrEmpty(SearchQuery)) { SearchQuery = SearchQuery + ";" + key; } else { SearchQuery = key; } } } } else { SearchQuery = InputQueries.Replace(' ', ';'); } if (Timelist.Count != 0) { Timelist = Timelist.OrderBy(row => row.Hours).ToList(); if (Timelist.Count >= 2) { TimeQuery = Timelist[0].ToString() + "-" + Timelist[Timelist.Count - 1].ToString(); } else if (Timelist.Count == 1) { TimeQuery = Timelist[0].ToString(); } } SearchQuery = SearchQuery.Replace(" ", string.Empty); SearchQuery = SearchQuery.Replace(";;", ";"); if (SearchQuery.EndsWith(";")) { SearchQuery = SearchQuery.TrimEnd(';'); } SearchQuery = SearchQuery.Trim(); SearchParameters.Add(SystemConstants.Query + SearchQuery); if (!string.IsNullOrEmpty(LocationsQuery)) { SearchParameters.Add(SystemConstants.Location + LocationsQuery); } if (!string.IsNullOrEmpty(DaysQuery)) { SearchParameters.Add(SystemConstants.Day + DaysQuery); } if (!string.IsNullOrEmpty(TimeQuery)) { SearchParameters.Add(SystemConstants.Time + TimeQuery); } return(SearchParameters); }
public void Refresh() { if (WebSecurity.IsAuthenticated) { RetrieveSavedList(); } ddSort.SelectedValue = SortValue; lblKeyword.Visible = false; String query = ""; Stopwatch sw = new Stopwatch(); sw.Start(); if (!string.IsNullOrEmpty(SearchKey)) { List <String> parameters = new CustomerBFC().RefineSearchKey(SearchKey); foreach (var parameter in parameters) { if (!string.IsNullOrEmpty(parameter)) { if (parameter.StartsWith(SystemConstants.Query)) { query = parameter.Replace(SystemConstants.Query, string.Empty); } else if (parameter.StartsWith(SystemConstants.Location)) { String[] locs = parameter.Replace(SystemConstants.Location, string.Empty).ToUpper().Split(';'); var subDT = new CustomerDAC().RetrieveSuburbs(); var suburbs = subDT.Where(x => locs.Contains(x.Name.ToUpper())); foreach (var sub in suburbs) { if (String.IsNullOrEmpty(SuburbID)) { SuburbID = sub.ID.ToString(); } else { SuburbID += "|" + sub.ID.ToString(); } } } else if (parameter.StartsWith(SystemConstants.Day)) { MonFilter = TueFilter = WedFilter = ThursFilter = FriFilter = SatFilter = SunFilter = false; string[] days = parameter.Replace(SystemConstants.Day, string.Empty).Split(';'); foreach (var day in days) { if (day.ToUpper().Equals(DayOfWeek.Monday.ToString().ToUpper())) { MonFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Tuesday.ToString().ToUpper())) { TueFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Wednesday.ToString().ToUpper())) { WedFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Thursday.ToString().ToUpper())) { ThursFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Friday.ToString().ToUpper())) { FriFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Saturday.ToString().ToUpper())) { SatFilter = true; } if (day.ToUpper().Equals(DayOfWeek.Sunday.ToString().ToUpper())) { SunFilter = true; } } } else if (parameter.StartsWith(SystemConstants.Time)) { string[] times = parameter.Replace(SystemConstants.Time, string.Empty).Split('-'); if (times.Length == 2) { dtFrom = Convert.ToDateTime(SystemConstants.nodate.ToShortDateString() + " " + Convert.ToDateTime(times[0]).ToShortTimeString()); dtTo = Convert.ToDateTime(SystemConstants.nodate.ToShortDateString() + " " + Convert.ToDateTime(times[1]).ToShortTimeString()); } else if (times.Length == 1) { dtFrom = Convert.ToDateTime(SystemConstants.nodate.ToShortDateString() + " " + Convert.ToDateTime(times[0]).ToShortTimeString()); } } } } } TimeSpan time = sw.Elapsed; sw.Restart(); lbltimerefine.Text = time.ToString(); if (!string.IsNullOrEmpty(query)) { SetDataSourcebySearchKey(query); int amount = new CustomerDAC().RetrieveProviderActivitiesbySearchPhraseCount(ProviderID, dtFrom.ToString(), dtTo.ToString(), tmFrom.ToString(), tmTo.ToString(), AgeFrom, AgeTo, SuburbID, CategoryID, query, MonFilter.ToString(), TueFilter.ToString(), WedFilter.ToString(), ThursFilter.ToString(), FriFilter.ToString(), SatFilter.ToString(), SunFilter.ToString()); lblAmount.Text = amount.ToString(); if (Convert.ToInt32(lblAmount.Text) <= Convert.ToInt32(PageSize + StartRow)) { lblEndIndex.Text = lblAmount.Text; } else { lblEndIndex.Text = (StartRow + PageSize).ToString(); } lblStartIndex.Text = (StartRow + 1).ToString(); if (Convert.ToInt32(lblStartIndex.Text) >= Convert.ToInt32(lblEndIndex.Text)) { lblStartIndex.Text = lblEndIndex.Text; } lblEndIndex1.Text = lblEndIndex.Text; lblStartIndex1.Text = lblStartIndex.Text; lblAmount1.Text = lblAmount.Text; lblKeyword.Visible = true; if (amount == 0) { ItemCountBottom.Visible = false; } else { if (amount <= PageSize) { divPager.Visible = false; ItemCountBottom.Visible = true; } else { divPager.Visible = ItemCountBottom.Visible = true; } } TimeSpan time1 = sw.Elapsed; lblshowres.Text = hdnTimespan.Value = "Set list by searchprovcat: " + time1.ToString(); } else { SetDataSourcebyProviderCategory(); int amount = new CustomerDAC().RetrieveProviderActivitiesCount(ProviderID, dtFrom.ToString(), dtTo.ToString(), tmFrom.ToString(), tmTo.ToString(), AgeFrom, AgeTo, SuburbID, CategoryID, MonFilter.ToString(), TueFilter.ToString(), WedFilter.ToString(), ThursFilter.ToString(), FriFilter.ToString() , SatFilter.ToString(), SunFilter.ToString()); lblAmount.Text = amount.ToString(); if (Convert.ToInt32(lblAmount.Text) <= Convert.ToInt32(PageSize + StartRow)) { lblEndIndex.Text = lblAmount.Text; } else { lblEndIndex.Text = (StartRow + PageSize).ToString(); } lblStartIndex.Text = (StartRow + 1).ToString(); if (Convert.ToInt32(lblStartIndex.Text) >= Convert.ToInt32(lblEndIndex.Text)) { lblStartIndex.Text = lblEndIndex.Text; } lblEndIndex1.Text = lblEndIndex.Text; lblStartIndex1.Text = lblStartIndex.Text; lblAmount1.Text = lblAmount.Text; if (amount == 0) { ItemCountBottom.Visible = false; } else { if (amount <= PageSize) { divPager.Visible = false; ItemCountBottom.Visible = true; } else { divPager.Visible = ItemCountBottom.Visible = true; } } TimeSpan time1 = sw.Elapsed; lblshowres.Text = hdnTimespan.Value = "Set list byprovcat: " + time1.ToString(); } }