private void BindGrdServicesCourses() { GrdServicesCourses.DataSource = null; GrdServicesCourses.DataBind(); PnlSearch.BindControls(FilterDictionary, TableName); #region BetweenDateFromat string Start_Dt = ""; string End_Dt = ""; object DateFilterStart_Dt = Config.DateTimeFormat(TxtFilterStart_Dt.Text.Trim()); object DateFilterEnd_Dt = Config.DateTimeFormat(TxtFilterEnd_Dt.Text.Trim()); if (DateFilterStart_Dt != null) { Start_Dt = ((DateTime)DateFilterStart_Dt).ToString("yyyyMMdd"); } if (DateFilterEnd_Dt != null) { End_Dt = ((DateTime)DateFilterEnd_Dt).ToString("yyyyMMdd"); } #endregion var Dictionary = new Dictionary <string, object>() { { "OrganizationsID", int.Parse(DListFilterOrganizations.SelectedValue) }, { "Start_Dt(>=)", Start_Dt }, { "End_Dt(<=)", End_Dt } }; int PageNum; int RowNumber = 20; if (!int.TryParse(Config._GetQueryString("p"), out PageNum)) { PageNum = 1; } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult FilterList = DALC.GetFilterList(TableName, Dictionary, PageNum, RowNumber); if (FilterList.Count == -1) { return; } if (FilterList.Dt.Rows.Count < 1 && PageNum > 1) { Config.RedirectURL(string.Format("/tools/electronicregistry/?p={0}", PageNum - 1)); } LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", FilterList.Count); int Total_Count = 0; if (FilterList.Count % RowNumber > 0) { Total_Count = (FilterList.Count / RowNumber) + 1; } else { Total_Count = FilterList.Count / RowNumber; } HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = FilterList.Count > RowNumber; GrdServicesCourses.DataSource = FilterList.Dt; GrdServicesCourses.DataBind(); }
private void BindGrdCourses() { GrdServicesCourses.DataSource = null; GrdServicesCourses.DataBind(); PnlSearch.BindControls(FilterDictionary, TableName); #region BetweenDateFromat string Date = ""; string Dt1 = "20170101"; string Dt2 = DateTime.Now.ToString("yyyyMMdd"); object DateFilter1 = Config.DateTimeFormat(TxtFilterStart_Dt.Text.Trim()); object DateFilter2 = Config.DateTimeFormat(TxtFilterEnd_Dt.Text.Trim()); if (DateFilter1 == null && DateFilter2 == null) { Date = ""; } else { if (DateFilter1 != null) { Dt1 = ((DateTime)DateFilter1).ToString("yyyyMMdd"); } if (DateFilter2 != null) { Dt2 = ((DateTime)DateFilter2).ToString("yyyyMMdd"); } Date = Dt1 + "&" + Dt2; } #endregion var Dictionary = new Dictionary <string, object>() { { "OrganizationsID", int.Parse(DListFilterOrganizations.SelectedValue) }, { "ServicesID", int.Parse(DListFilterServices.SelectedValue) }, { "TeacherUsersID", int.Parse(DListFilterTeacherUsers.SelectedValue) }, { "Name(LIKE)", TxtCourseName.Text }, { "Start_Dt(BETWEEN)", Config.DateTimeFilter(TxtFilterStart_Dt.Text, TxtFilterEnd_Dt.Text) }, { "IsActive", int.Parse(DListFilterStatus.SelectedValue) }, }; int PageNum; int RowNumber = 20; if (!int.TryParse(Config._GetQueryString("p"), out PageNum)) { PageNum = 1; } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult FilterList = DALC.GetFilterList(TableName, Dictionary, PageNum, RowNumber); if (FilterList.Count == -1) { return; } if (FilterList.Dt.Rows.Count < 1 && PageNum > 1) { Config.RedirectURL(string.Format("/tools/electronicregistry/courses/?p={0}", PageNum - 1)); } LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", FilterList.Count); int Total_Count = 0; if (FilterList.Count % RowNumber > 0) { Total_Count = (FilterList.Count / RowNumber) + 1; } else { Total_Count = FilterList.Count / RowNumber; } HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = FilterList.Count > RowNumber; GrdServicesCourses.DataSource = FilterList.Dt; GrdServicesCourses.DataBind(); }