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();
}
