private void SetDataSourceFromCategoryProvider()
{
ods.TypeName = typeof(CustomerDAC).FullName;
ods.EnablePaging = true;
ods.SelectParameters.Clear();
ods.SelectParameters.Add("categoryID", CategoryID.ToString());
ods.SelectParameters.Add("providerID", ProviderID.ToString());
ods.SelectParameters.Add("stFrom", dtFrom.ToString());
ods.SelectParameters.Add("stTo", dtTo.ToString());
ods.SelectParameters.Add("ageFrom", AgeFrom.ToString());
ods.SelectParameters.Add("ageTo", AgeTo.ToString());
ods.SelectParameters.Add("suburbID", SuburbID.ToString());
ods.SelectParameters.Add("MonFilter", MonFilter.ToString());
ods.SelectParameters.Add("TueFilter", TueFilter.ToString());
ods.SelectParameters.Add("WedFilter", WedFilter.ToString());
ods.SelectParameters.Add("ThursFilter", ThursFilter.ToString());
ods.SelectParameters.Add("FriFilter", FriFilter.ToString());
ods.SelectParameters.Add("SatFilter", SatFilter.ToString());
ods.SelectParameters.Add("SunFilter", SunFilter.ToString());
ods.SelectMethod = "RetrieveProviderActivities";
ods.SelectCountMethod = "RetrieveProviderActivitiesCount";
ods.MaximumRowsParameterName = "amount";
ods.StartRowIndexParameterName = "startIndex";
ods.SortParameterName = "sortExpression";
GridViewActivities.PageSize = PageSize;
GridViewActivities.DataSourceID = "ods";
SortProducts();
//DataPager1.SetPageProperties(StartRow, DataPager1.MaximumRows, false);
//ListViewProducts.DataBind();
}
private void SetDataSourcebySearchKey(String SearchPhrase)
{
ods.TypeName = typeof(CustomerDAC).FullName;
ods.EnablePaging = true;
ods.SelectParameters.Clear();
ods.SelectParameters.Add("searchKey", SearchPhrase);
ods.SelectParameters.Add("providerID", ProviderID.ToString());
ods.SelectParameters.Add("ageFrom", AgeFrom.ToString());
ods.SelectParameters.Add("ageTo", AgeTo.ToString());
ods.SelectParameters.Add("stFrom", dtFrom.ToString());
ods.SelectParameters.Add("stTo", dtTo.ToString());
ods.SelectParameters.Add("tmFrom", tmFrom.ToString());
ods.SelectParameters.Add("tmTo", tmTo.ToString());
ods.SelectParameters.Add("suburbID", SuburbID.ToString());
ods.SelectParameters.Add("categoryID", CategoryID.ToString());
ods.SelectParameters.Add("MonFilter", MonFilter.ToString());
ods.SelectParameters.Add("TueFilter", TueFilter.ToString());
ods.SelectParameters.Add("WedFilter", WedFilter.ToString());
ods.SelectParameters.Add("ThursFilter", ThursFilter.ToString());
ods.SelectParameters.Add("FriFilter", FriFilter.ToString());
ods.SelectParameters.Add("SatFilter", SatFilter.ToString());
ods.SelectParameters.Add("SunFilter", SunFilter.ToString());
ods.SelectMethod = "RetrieveProviderActivitiesbySearchPhrase";
ods.SelectCountMethod = "RetrieveProviderActivitiesbySearchPhraseCount";
ods.MaximumRowsParameterName = "amount";
ods.StartRowIndexParameterName = "startIndex";
ods.SortParameterName = "sortExpression";
ListViewActivities.DataSourceID = "ods";
SortProducts();
}
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 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();
}
}