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