protected void BtnSearch_Click(object sender, EventArgs e)
{
PnlSearch.BindControls(FilterDictionary, TableName, true);
Session["IsSearch"] = null;
Cache.Remove(TableName._ToString());
Config.Redirect("/e-services/adoption/?pn=1");
}
private void BindGrid()
{
GrdDownloads.DataSource = null;
GrdDownloads.DataBind();
PnlSearch.BindControls(FilterDictionary, TableName);
FilterDictionary = new Dictionary <string, object>()
{
{ "DownloadsTypesID", DListFilterDownloadsTypes.SelectedValue },
{ "DisplayName(LIKE)", TxtFilterFileName.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, FilterDictionary, PageNum, RowNumber);
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/downloads/?p={0}", PageNum - 1));
}
LblCount.Text = string.Format(LblCount.Text, 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;
GrdDownloads.DataSource = FilterList.Dt;
GrdDownloads.DataBind();
GrdDownloads.Columns[GrdDownloads.Columns.Count - 1].Visible = DALC._GetUsersLogin.OrganizationsParentID == 0;
}
private void BindGridApplications()
{
GrdApplicationsFamily.DataSource = null;
GrdApplicationsFamily.DataBind();
PnlSearch.BindControls(FilterDictionary, TableName);
FilterDictionary = new Dictionary <string, object>()
{
{ "OrganizationsID", int.Parse(DListFltOrganizations.SelectedValue) },
{ "ID", TxtApplicationsFamilyID.Text },
{ "ApplicationsFamilyTypesID", int.Parse(DListFltApplicationsFamilyTypes.SelectedValue) },
{ "ApplicationsFamilyStatusID", int.Parse(DListFltApplicationsFamilyStatus.SelectedValue) },
{ "Tour_Dt(BETWEEN)", Config.DateTimeFilter(TxtFilterTourDt1.Text, TxtFilterTourDt2.Text) },
{ "Add_Dt(Between)", Config.DateTimeFilter(TxtFilterDate1.Text, TxtFilterDate2.Text) },
};
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, FilterDictionary, PageNum, RowNumber);
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/applicationsfamily/?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;
GrdApplicationsFamily.DataSource = FilterList.Dt;
GrdApplicationsFamily.DataBind();
}
private void BindGrdServices()
{
GrdServices.DataSource = null;
GrdServices.DataBind();
PnlSearch.BindControls(FilterDictionary, TableName);
var Dictionary = new Dictionary <string, object>()
{
{ "OrganizationsID", int.Parse(DListFilterOrganizations.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, "Order By ID asc, Name asc");
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/electronicregistry/servicesplans?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;
GrdServices.DataSource = FilterList.Dt;
GrdServices.DataBind();
}
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();
}
protected void BtnClear_Click(object sender, EventArgs e)
{
PnlSearch.ClearControls();
Session["FilterSession"] = null;
BtnFilter_Click(null, null);
}
protected void BtnFilter_Click(object sender, EventArgs e)
{
PnlSearch.BindControls(FilterDictionary, TableName, true);
Cache.Remove(TableName._ToString());
Config.RedirectURL("/tools/electronicregistry/?p=1");
}
private void BindGrdApplicationsPersons()
{
GrdApplicationsPersons.DataSource = null;
GrdApplicationsPersons.DataBind();
PnlSearch.BindControls(FilterDictionary, _TableName);
FilterDictionary = new Dictionary <string, object>()
{
{ "OrganizationsID", int.Parse(DListFltOrganizations.SelectedValue) },
{ "ID", TxtFltPersonID.Text },
{ "ApplicationsID", TxtFltApplicationsID.Text },
{ "ApplicationsTypesID", int.Parse(DListFltApplicationsTypes.SelectedValue) },
{ "ApplicationsPersonsTypesID", int.Parse(DListFltApplicationsPersonsType.SelectedValue) },
{ "DocumentTypesID", int.Parse(DListFltDocumentTypes.SelectedValue) },
{ "DocumentNumber", TxtFltDocumentNumber.Text },
{ "Surname(LIKE)", TxtFltSurname.Text },
{ "Name(LIKE)", TxtFltName.Text },
{ "Patronymic(LIKE)", TxtFltPatronymic.Text },
{ "SocialStatusID", int.Parse(DListFltSocialStatusID.SelectedValue) },
{ "RegisteredAddress(LIKE)", TxtFilterRegisteredAddress.Text },
{ "CurrentAddress(LIKE)", TxtFilterCurrentAddress.Text },
{ "Add_Dt(Between)", Config.DateTimeFilter(TxtFilterDate1.Text, TxtFilterDate2.Text) },
};
if (PnlOperations.Visible == true)
{
//Əməliyyatlar multi secim oldugu ucun onun axtarish algoritmasini elave olaraq burda yazdim
for (int i = 0; i < DListFltListOperationTypes.Items.Count; i++)
{
ListItem Item = DListFltListOperationTypes.Items[i];
if (Item.Selected == true)
{
FilterDictionary.Add(((Tools.ListOperationTypes) int.Parse(Item.Value)).ToDescriptionString() + "(OR)", "IS NOT NULL");
}
}
}
else
{
switch (Config._GetQueryString("type"))
{
case "sibr-evaluations":
FilterDictionary.Add("SIBRID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "SIB-R Qiymətləndirilənlər";
break;
case "evaluations":
FilterDictionary.Add("EvaluationsID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "Qiymətləndirilənlər";
break;
case "evaluationsskill":
FilterDictionary.Add("EvaluationsSkillID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "Qiymətləndirilənlər";
break;
case "services":
FilterDictionary.Add("ApplicationsPersonsServicesID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "Xidmətlərdən istifadə edənlər";
break;
case "case":
FilterDictionary.Add("ApplicationsCaseID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "CASE açılanlar";
break;
default:
break;
}
}
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, FilterDictionary, PageNum, RowNumber);
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/applicationspersons/?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;
GrdApplicationsPersons.DataSource = FilterList.Dt;
GrdApplicationsPersons.DataBind();
}
protected void BtnFilter_Click(object sender, EventArgs e)
{
PnlSearch.BindControls(FilterDictionary, _TableName, true);
Cache.Remove(_TableName._ToString());
Config.RedirectURL("/tools/applicationspersons/?p=1");
}
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();
}
private void BindGallery()
{
RptFotoGallery.DataSource = null;
RptFotoGallery.DataBind();
PnlSearch.BindControls(FilterDictionary, TableName);
FilterDictionary = new Dictionary <string, object>()
{
{ "OrganizationsID", int.Parse(DListFilterOrganizations.SelectedValue) },
{ "DataID(!=)", 0 },
{ "DownloadsQualityTypesID", int.Parse(DListFilterDownloadsQualityTypes.SelectedValue) },
{ "DisplayName(LIKE)", TxtFilterFileName.Text },
{ "IsActive", int.Parse(DListFilterStatus.SelectedValue) },
};
if (PnlFilterDate.Visible == true)
{
FilterDictionary.Add("DownloadsTypesID", int.Parse(DListFilterDownloadsTypes.SelectedValue));
FilterDictionary.Add("Years", int.Parse(DListFilterYears.SelectedValue));
FilterDictionary.Add("Months", int.Parse(DListFilterMonths.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, FilterDictionary, PageNum, RowNumber);
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/downloads/?p={0}", PageNum - 1));
}
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;
RptFotoGallery.DataSource = FilterList.Dt;
RptFotoGallery.DataBind();
}
private void BindGridApplications()
{
GrdApplications.DataSource = null;
GrdApplications.DataBind();
PnlSearch.BindControls(FilterDictionary, TableName);
FilterDictionary = new Dictionary <string, object>()
{
{ "OrganizationsID", int.Parse(DListFilterOrganizations.SelectedValue) },
{ "ID", TxtFilterAppID.Text },
{ "ApplicationsTypesID", int.Parse(DListFilterApplicationsTypes.SelectedValue) },
{ "ApplicationsCaseStatusID", int.Parse(DListFilterApplicationsCaseStatus.SelectedValue) },
{ "RegisteredAddress(LIKE)", TxtFilterRegisteredAddress.Text },
{ "CurrentAddress(LIKE)", TxtFilterCurrentAddress.Text },
{ "SocialStatusID", int.Parse(DListFilterSocialStatusID.SelectedValue) },
{ "ApplicationsPersonsTypesID", int.Parse(DListFilterApplicationsPersonsTypes.SelectedValue) },
{ "DocumentTypesID", int.Parse(DListFilterDocumentTypes.SelectedValue) },
{ "DocumentNumber", TxtFilterDocumentNumber.Text },
{ "Name(LIKE)", TxtFilterName.Text },
{ "Surname(LIKE)", TxtFilterSurname.Text },
{ "Patronymic(LIKE)", TxtFilterPatronymic.Text },
{ "Create_Dt(Between)", Config.DateTimeFilter(TxtFilterDate1.Text, TxtFilterDate2.Text) },
{ "IsRepeat", CheckFilterIsRepeat.Checked ? 1 : -1 },
};
//Əməliyyatlar multi secim oldugu ucun onun axtarish algoritmasini elave olaraq burda yazdim
for (int i = 0; i < DListFilterListOperationTypes.Items.Count; i++)
{
ListItem Item = DListFilterListOperationTypes.Items[i];
if (Item.Selected == true)
{
FilterDictionary.Add(((Tools.ListOperationTypes) int.Parse(Item.Value)).ToDescriptionString() + "(OR)", "IS NOT NULL");
}
}
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, FilterDictionary, PageNum, RowNumber);
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/applications/?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;
GrdApplications.DataSource = FilterList.Dt;
GrdApplications.DataBind();
}
private void BindData()
{
RptChilds.DataSource = null;
RptChilds.DataBind();
PnlSearch.BindControls(FilterDictionary, TableName);
FilterDictionary = new Dictionary <string, object>()
{
{ "Gender", DListGender.SelectedValue },
{ "GozColorsID", int.Parse(DListEyeColor.SelectedValue) },
{ "SachColorsID", int.Parse(DListHairColor.SelectedValue) },
{ "FLOOR(DATEDIFF(DAY , DogumTarixi ,GETDATE()) / 365.25)(BETWEEN)", DListAgeRange.SelectedValue }
};
if (DListBrotherSister.SelectedIndex != 0)
{
FilterDictionary.Add("IsBrotherSister", Convert.ToByte(DListBrotherSister.SelectedValue));
}
if (TxtFullname.Text.Length > 0)
{
FilterDictionary.Add("CONCAT(Soyad,' ',Ad,' ',Ata)(LIKE)", TxtFullname.Text);
}
int PageNum;
int RowNumber = 3;
if (!int.TryParse(Config._GetQueryString("pn"), out PageNum))
{
PageNum = 1;
}
HdnPageNumber.Value = PageNum.ToString();
DALC.DataTableResult AdoptionPersonsResult = DALC_Adoption.GetAdoptionPersons(FilterDictionary, PageNum, RowNumber);
if (AdoptionPersonsResult.Count == -1 || AdoptionPersonsResult.Dt == null)
{
Config.RedirectError();
return;
}
if (AdoptionPersonsResult.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.Redirect(string.Format("/e-services/adoption/?p=adoptionsite&pn={0}", PageNum - 1));
}
LblCount.Text = string.Format("Tapılıb: {0} anket", AdoptionPersonsResult.Count.ToString());
int Total_Count = AdoptionPersonsResult.Count % RowNumber > 0 ? (AdoptionPersonsResult.Count / RowNumber) + 1 : AdoptionPersonsResult.Count / RowNumber;
HdnTotalCount.Value = Total_Count.ToString();
PnlPager.Visible = AdoptionPersonsResult.Count > RowNumber;
RptChilds.DataSource = AdoptionPersonsResult.Dt;
RptChilds.DataBind();
CheckControls();
}
