protected void LnkOtherApp_Click(object sender, EventArgs e) { GrdHistory.DataSource = null; GrdHistory.DataBind(); LnkOtherApp.Visible = false; LblCount.Text = "Axtarış üzrə: 0 Səhifə üzrə: 0"; LnkOtherApp.CommandArgument = (int.Parse(LnkOtherApp.CommandArgument) + 20)._ToString(); Dictionary <string, object> DictHistory = new Dictionary <string, object>(); DictHistory.Add("AdoptionAdministratorsID", int.Parse(DListUsersName.SelectedValue)); DALC.DataTableResult AdoptionAdministratorHistory = DALC_Adoption.GetAdoptionAdministratorHistory(int.Parse(LnkOtherApp.CommandArgument), DictHistory, ""); if (AdoptionAdministratorHistory.Count == -1) { Config.MsgBoxAjax(Config._DefaultSystemErrorMessages, Page); return; } GrdHistory.DataSource = AdoptionAdministratorHistory.Dt; GrdHistory.DataBind(); LblCount.Text = "Axtarış üzrə: " + AdoptionAdministratorHistory.Count + " Səhifə üzrə: " + GrdHistory.Rows.Count._ToString(); if (AdoptionAdministratorHistory.Dt.Rows.Count > 0) { LnkOtherApp.Visible = (GrdHistory.Rows.Count < AdoptionAdministratorHistory.Count); } BtnSearch.CommandArgument = ""; }
protected void LnkOtherApp_Click(object sender, EventArgs e) { GrdHistory.DataSource = null; GrdHistory.DataBind(); LnkOtherApp.Visible = false; LnkOtherApp.CommandArgument = (int.Parse(LnkOtherApp.CommandArgument) + 20)._ToString(); bool Cache = true; // Əgər filter olunubsa Cache-de saxlamayaq if (BtnSearch.CommandArgument == "1") { Cache = false; } DALC.DataTableResult HistoryTypes = DALC.GetHistory(LnkOtherApp.CommandArgument, DListOrganization.SelectedValue, DListUsersName.SelectedValue, DListHistoryTypes.SelectedValue, DListPermissionsType.SelectedValue, PersonsID.IsEmptyReplaceNoul("-1"), Cache); if (HistoryTypes.Count == -1) { Config.MsgBoxAjax(Config._DefaultSystemErrorMessages, Page); return; } GrdHistory.DataSource = HistoryTypes.Dt; GrdHistory.DataBind(); if (HistoryTypes.Dt.Rows.Count > 0) { LnkOtherApp.Visible = (GrdHistory.Rows.Count < HistoryTypes.Count); } BtnSearch.CommandArgument = ""; }
protected void LnkOtherApp_Click(object sender, EventArgs e) { GrdList.DataSource = null; GrdList.DataBind(); LnkOtherApp.Visible = false; LblCount.Text = "Axtarış üzrə: 0 Səhifə üzrə: 0"; LnkOtherApp.CommandArgument = (int.Parse(LnkOtherApp.CommandArgument) + 20)._ToString(); Dictionary <string, object> Dictionary = new Dictionary <string, object>() { { "Username(LIKE)", TxtFilterUsername.Text }, { "Fullname(LIKE)", TxtFilterFullname.Text.Replace("i", "İ").Replace("ı", "I").ToUpper() }, { "IsActive", int.Parse(DListFilterStatus.SelectedValue) } }; DALC.DataTableResult AdoptionAdministrators = DALC_Adoption.GetAdoptionAdministrator(int.Parse(LnkOtherApp.CommandArgument), Dictionary, ""); if (AdoptionAdministrators.Count == -1) { Config.MsgBoxAjax(Config._DefaultSystemErrorMessages, Page); return; } GrdList.DataSource = AdoptionAdministrators.Dt; GrdList.DataBind(); LblCount.Text = "Axtarış üzrə: " + AdoptionAdministrators.Count + " Səhifə üzrə: " + GrdList.Rows.Count._ToString(); if (AdoptionAdministrators.Dt.Rows.Count > 0) { LnkOtherApp.Visible = (GrdList.Rows.Count < AdoptionAdministrators.Count); } }
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; }
void BindGrid() { GrdOrganizations.DataSource = null; GrdOrganizations.DataBind(); if (Session[_FilterSessionName] != null) { var DictionarySession = (Dictionary <string, object>)Session[_FilterSessionName]; if (DictionarySession.Count != 0) { DListTopOrganizationFilter.SelectedValue = DictionarySession["ParentID"]._ToString(); TxtNameFilter.Text = DictionarySession["Name(LIKE)"]._ToString(); } } var Dictionary = new Dictionary <string, object>() { { "ParentID", DListTopOrganizationFilter.SelectedValue }, { "Name(LIKE)", TxtNameFilter.Text }, }; int PageNum; int RowNumber = 20; if (!int.TryParse(Config._GetQueryString("p"), out PageNum)) { PageNum = 1; } // Axirinci sehifeni secmedikce Cache temizlemirik herdefe count almasin deye if (PageNum >= (Cache[_CountCacheName]._ToInt32() / RowNumber)) { Cache.Remove(_CountCacheName); } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult PersonsList = DALC.GetOrganizationsList(Dictionary, PageNum, RowNumber); if (PersonsList.Count == -1) { return; } if (PersonsList.Dt.Rows.Count < 1 && PageNum > 1) { Config.RedirectURL(string.Format("/tools/datalist/?p={0}", PageNum - 1)); } int Total_Count = PersonsList.Count % RowNumber > 0 ? (PersonsList.Count / RowNumber) + 1 : PersonsList.Count / RowNumber; HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = PersonsList.Count > RowNumber; GrdOrganizations.DataSource = PersonsList.Dt; GrdOrganizations.DataBind(); }
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 BindNeeders() { GrdAdoptionPersonsList.DataSource = null; GrdAdoptionPersonsList.DataBind(); PnlFilter.BindControls(FilterDictionary, _TableName); DListStatusType_SelectedIndexChanged(null, null); FilterDictionary = new Dictionary <string, object>() { { "Ap.ID", TxtID.Text }, { "CONCAT(Soyad,' ',Ad,' ',Ata)(LIKE)", TxtFullname.Text }, { "IsWebPreview", DListIsWebPreview.SelectedValue }, { "IsBrotherSister", DListIsBrotherSister.SelectedValue }, { "AdoptionPersonsStatusID", int.Parse(AdoptionPersonsStatusID) } }; if (DListStatusType.SelectedIndex == 0) { FilterDictionary.Add("AdoptionPersonsStatusID(NOTIN)", 90); } int PageNum; int RowNumber = 16; 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) { return; } if (AdoptionPersonsResult.Dt.Rows.Count < 1 && PageNum > 1) { Config.Redirect(string.Format("/adoptionadminn/tools/?p=adoptionpersons&pn={0}", PageNum - 1)); } LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", 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; GrdAdoptionPersonsList.DataSource = AdoptionPersonsResult.Dt; GrdAdoptionPersonsList.DataBind(); }
private void BindUsers() { rptUsers.DataSource = null; rptUsers.DataBind(); pnlFilter.ControlsBind(filterDictionary, tableName); int usersId; int.TryParse(txtUsersId.Text, out usersId); if (usersId == 0) { usersId = -1; } filterDictionary = new Dictionary <string, object>() { { "Id", usersId }, { "OrganizationsId", DALCL._Login.organizationsId }, { "UsersSocialStatusLangsId", (int)Tools.Langs.AZ }, { "UsersSocialStatusId", int.Parse(dListSocialStatus.SelectedValue) }, { "UsersGendersLangsId", (int)Tools.Langs.AZ }, }; int pageNumber; int rowNumber = 50; if (!int.TryParse(ConfigL._Route("pagenum", "1"), out pageNumber)) { pageNumber = 1; } hdnPageNumber.Value = pageNumber.ToString(); DALC.DataTableResult usersResult = DALC.GetFilterList(tableName, filterDictionary, pageNumber, rowNumber); if (usersResult.Count == -1) { return; } lblCount.Text = $"Axtarış üzrə nəticə: {usersResult.Count.ToString()}"; int totalCount = usersResult.Count % rowNumber > 0 ? (usersResult.Count / rowNumber) + 1 : usersResult.Count / rowNumber; hdnTotalCount.Value = totalCount.ToString(); pnlPager.Visible = usersResult.Count > rowNumber; rptUsers.DataSource = usersResult.Dt; rptUsers.DataBind(); }
private void BindNews() { RptNews.DataSource = null; RptNews.DataBind(); PnlFilter.ControlsBind(FilterDictionary, TableName); int NewsID; int.TryParse(TxtNewsID.Text, out NewsID); if (NewsID == 0) { NewsID = -1; } FilterDictionary = new Dictionary <string, object>() { { "Id", NewsID }, { "LangsId", Langs.Id }, { "OrganizationsId", DALCL._Login.organizationsId }, { "OrganizationsLangsId", Langs.Id }, { "NewsLangsStatusId", int.Parse(DListNewsStatus.SelectedValue) } }; int PageNum; int RowNumber = 50; if (!int.TryParse(ConfigL._Route("pagenum", "1"), out PageNum)) { PageNum = 1; } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult NewsResult = DALC.GetFilterList(Tools.Tables.V_News, FilterDictionary, PageNum, RowNumber); if (NewsResult.Count == -1) { return; } LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", NewsResult.Count.ToString()); int Total_Count = NewsResult.Count % RowNumber > 0 ? (NewsResult.Count / RowNumber) + 1 : NewsResult.Count / RowNumber; HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = NewsResult.Count > RowNumber; RptNews.DataSource = NewsResult.Dt; RptNews.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 BindAdministrators() { grdAdministrators.DataSource = null; grdAdministrators.DataBind(); pnlFilter.ControlsBind(filterDictionary, tableName); int administratorsId; int.TryParse(txtAdministratorsId.Text, out administratorsId); if (administratorsId == 0) { administratorsId = -1; } filterDictionary = new Dictionary <string, object>() { { "Id", administratorsId }, { "OrganizationsId", int.Parse(dListOrganizations.SelectedValue) }, { "OrganizationsLangsId", (int)Tools.Langs.AZ }, { "AdministratorsStatusId", int.Parse(dListAdministratorsStatus.SelectedValue) } }; int pageNumber; int rowNumber = 50; if (!int.TryParse(ConfigL._Route("pagenum", "1"), out pageNumber)) { pageNumber = 1; } HdnPageNumber.Value = pageNumber.ToString(); DALC.DataTableResult administratorsResult = DALC.GetFilterList(tableName, filterDictionary, pageNumber, rowNumber); if (administratorsResult.Count == -1) { return; } lblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", administratorsResult.Count.ToString()); int totalCount = administratorsResult.Count % rowNumber > 0 ? (administratorsResult.Count / rowNumber) + 1 : administratorsResult.Count / rowNumber; hdnTotalCount.Value = totalCount.ToString(); pnlPager.Visible = administratorsResult.Count > rowNumber; grdAdministrators.DataSource = administratorsResult.Dt; grdAdministrators.DataBind(); }
private void BindSurveys() { grdSurveys.DataSource = null; grdSurveys.DataBind(); pnlFilter.ControlsBind(filterDictionary, tableName); int surveysId; int.TryParse(txtSurveysId.Text, out surveysId); if (surveysId == 0) { surveysId = -1; } filterDictionary = new Dictionary <string, object>() { { "Id", surveysId }, { "LangsId", Langs.Id }, { "SurveysStatusId", int.Parse(dListSurveysStatus.SelectedValue) } }; int pageNumber; int rowNumber = 50; if (!int.TryParse(ConfigL._Route("pagenum", "1"), out pageNumber)) { pageNumber = 1; } HdnPageNumber.Value = pageNumber.ToString(); DALC.DataTableResult surveysResult = DALC.GetFilterList(tableName, filterDictionary, pageNumber, rowNumber); if (surveysResult.Count == -1) { return; } lblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", surveysResult.Count.ToString()); int totalCount = surveysResult.Count % rowNumber > 0 ? (surveysResult.Count / rowNumber) + 1 : surveysResult.Count / rowNumber; hdnTotalCount.Value = totalCount.ToString(); pnlPager.Visible = surveysResult.Count > rowNumber; grdSurveys.DataSource = surveysResult.Dt; grdSurveys.DataBind(); }
private void BindGrdApplicationsPersons() { GrdApplicationsDetails.DataSource = null; GrdApplicationsDetails.DataBind(); var Dictionary = new Dictionary <string, object>() { { "ApplicationsID", _ApplicationsID } }; DALC.DataTableResult PersonsList = DALC.GetFilterList(Tools.Table.V_ApplicationsPersons, Dictionary, 1, 20); GrdApplicationsDetails.DataSource = PersonsList.Dt; GrdApplicationsDetails.DataBind(); }
private void BindData() { GrdUserLogs.DataSource = null; GrdUserLogs.DataBind(); FilterDictionary = new Dictionary <string, object>() { { "PIN", TxtPin.Text }, { "AdoptionOrganizationsID", DListOrganizations.SelectedValue }, { "RegisterNo", TxtRegisterNo.Text }, { "SearchParams(LIKE)", TxtContent.Text } }; int PageNum; int RowNumber = 20; if (!int.TryParse(Config._GetQueryString("pn"), out PageNum)) { PageNum = 1; } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult AdoptionSearchResult = DALC_Adoption.GetAdoptionSearchHistory(FilterDictionary, PageNum, RowNumber); if (AdoptionSearchResult.Count == -1) { return; } if (AdoptionSearchResult.Dt.Rows.Count < 1 && PageNum > 1) { Config.Redirect(string.Format("/adoptionadminn/tools/?p=servicesuserslogs&pn={0}", PageNum - 1)); } LblCount.Text = string.Format("Tapılıb: {0}", AdoptionSearchResult.Count.ToString()); int Total_Count = AdoptionSearchResult.Count % RowNumber > 0 ? (AdoptionSearchResult.Count / RowNumber) + 1 : AdoptionSearchResult.Count / RowNumber; HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = AdoptionSearchResult.Count > RowNumber; GrdUserLogs.DataSource = AdoptionSearchResult.Dt; GrdUserLogs.DataBind(); }
private void BindSurveysAnswers() { pnlAnswers.Visible = true; DALC.DataTableResult result = new DALC.DataTableResult(); var dictionary = new Dictionary <string, object>() { { "SurveysId", _surveysId }, { "LangsId", Langs.Id }, { "IsActive", true } }; result = DALC.GetFilterList(Tools.Tables.V_SurveysAnswers, dictionary, 1, 500, "T.*", "", "Order By Id asc"); if (result.Count == -1) { return; } grdSurveysAnswers.DataSource = result.Dt; grdSurveysAnswers.DataBind(); }
private void BindServices() { DALC.DataTableResult result = new DALC.DataTableResult(); var dictionary = new Dictionary <string, object>() { { "Id", txtServicesId.Text }, { "ServicesTypesId", int.Parse(ConfigL._Route("servicestypesid", "10")) }, { "LangsId", Langs.Id }, { "IsActive", int.Parse(dListServicesStatus.SelectedValue) }, }; result = DALC.GetFilterList(Tools.Tables.V_Services, dictionary, 1, 500); if (result.Count == -1) { return; } grdSrvices.DataSource = result.Dt; grdSrvices.DataBind(); }
private void BindServicesOrganizations() { DALC.DataTableResult result = new DALC.DataTableResult(); var dictionary = new Dictionary <string, object>() { { "OrganizationsLangsId", Langs.Id }, { "ServicesTypesId", (int)Tools.ServicesTypes.Xidmətlər }, { "ServicesLangsId", Langs.Id }, { "IsActive", true }, }; result = DALC.GetFilterList(Tools.Tables.V_ServicesOrganizations, dictionary, 1, 500); if (result.Count == -1) { return; } grdSrvices.DataSource = result.Dt; grdSrvices.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { //Login control if (DALC._GetUsersLogin == null) { Config.Redirect("/?return=" + Request.Url.ToString()); return; } if (!IsPostBack) { LblCount1.Text = DALC.GetDbSingleValues("Count(*)", "Persons", ""); LblCount2.Text = DALC.GetDbSingleValues("Count(*)", "Users", "Where IsActive=1"); LblCount3.Text = DALC.GetDbSingleValues("Count(*)", "UsersHistory", "where YEAR(Add_Dt)=YEAR(GETDATE()) and MONTH(Add_Dt) = MONTH(GETDATE())"); LblCount4.Text = DALC.GetDbSingleValues("Count(*)", "UsersHistory", "where FORMAT(Add_Dt,'ddMMyyyy')=FORMAT(GETDATE(),'ddMMyyyy')"); DALC.DataTableResult HistoryTypes = DALC.GetHistory("10", DALC._GetUsersLogin.OrganizationsID._ToString(), "0", "0", "0"); GrdHistory.DataSource = HistoryTypes.Dt; GrdHistory.DataBind(); } }
protected void LnkOtherApp_Click(object sender, EventArgs e) { GrdList.DataSource = null; GrdList.DataBind(); LnkOtherApp.Visible = false; LblCount.Text = "Axtarış üzrə: 0 Səhifə üzrə: 0"; LnkOtherApp.CommandArgument = (int.Parse(LnkOtherApp.CommandArgument) + 20)._ToString(); string PassNumber = "0"; if (TxtFilterPassportNumber.Text.Trim().IsNumeric()) { PassNumber = TxtFilterPassportNumber.Text.Trim(); } DALC.DataTableResult UsersList = DALC.GetUsersList( LnkOtherApp.CommandArgument, DListFilterOrganizations.SelectedValue, TxtFilterUsername.Text, PassNumber, TxtFilterFullname.Text.Trim(), DListFilterStatus.SelectedValue); if (UsersList.Count == -1) { Config.MsgBoxAjax(Config._DefaultSystemErrorMessages, Page); return; } GrdList.DataSource = UsersList.Dt; GrdList.DataBind(); LblCount.Text = "Axtarış üzrə: " + UsersList.Count + " Səhifə üzrə: " + GrdList.Rows.Count._ToString(); if (UsersList.Dt.Rows.Count > 0) { LnkOtherApp.Visible = (GrdList.Rows.Count < UsersList.Count); } }
private void BindServices() { DALC.DataTableResult result = new DALC.DataTableResult(); var dictionary = new Dictionary <string, object>() { { "ServicesId", txtServicesId.Text }, { "ServicesLangsId", Langs.Id }, { "OrganizationsId", DALCL._Login.organizationsId }, { "OrganizationsLangsId", (int)Tools.Langs.AZ }, { "ServicesTypesId", (int)Tools.ServicesTypes.Tədbirlər }, { "IsActive", int.Parse(dListServicesStatus.SelectedValue) }, }; result = DALC.GetFilterList(Tools.Tables.V_ServicesOrganizations, dictionary, 1, 500); if (result.Count == -1) { return; } grdSrvices.DataSource = result.Dt; grdSrvices.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(); }
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(); }
void BindGrid() { if (Session[_FilterSessionName] != null) { var DictionarySession = (Dictionary <string, object>)Session[_FilterSessionName]; if (DictionarySession.Count != 0) { TxtRowIndexFilter.Text = DictionarySession["RowIndex"]._ToString(); DlistRegionalCenterFilter.SelectedValue = DictionarySession["RegionalCentersID"]._ToString(); DListParentOrganizationFilter.SelectedValue = DictionarySession["ParentOrganizationsID"]._ToString(); DListTopOrganizationFilter_SelectedIndexChanged(null, null); DListSubOrganizationFilter.SelectedValue = DictionarySession["OrganizationsID"]._ToString(); DlistVisitTypeFilter.SelectedValue = DictionarySession["VisitTypeID"]._ToString(); TxtVisitDtStartFilter.Text = DictionarySession["StartVisit_Dt"]._ToString(); TxtVisitDtEndFilter.Text = DictionarySession["EndVisit_Dt"]._ToString(); TxtDescriptionFilter.Text = DictionarySession["Descriptions"]._ToString(); DListDatePriority.SelectedValue = DictionarySession["DatePriority"]._ToString(); DListPageSize.SelectedValue = DictionarySession["PageSize"]._ToString(); } } #region BetweenDateFromat string Date = ""; string Dt1 = "19000101"; string Dt2 = DateTime.Now.ToString("yyyyMMdd"); object DateFilter1 = Config.DateTimeFormat(TxtVisitDtStartFilter.Text.Trim()); object DateFilter2 = Config.DateTimeFormat(TxtVisitDtEndFilter.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>() { { "RegionalCentersID", DlistRegionalCenterFilter.SelectedValue }, { "ParentOrganizationsID", DListParentOrganizationFilter.SelectedValue }, { "OrganizationsID", DListSubOrganizationFilter.SelectedValue }, { "VisitTypeID", DlistVisitTypeFilter.SelectedValue }, { "Visit_Dt(BETWEEN)", Date }, { "Descriptions(LIKE)", TxtDescriptionFilter.Text } }; string OrderByType = "desc"; if (DListDatePriority.SelectedValue == "20") { OrderByType = "asc"; } //Sira sayina gore filteri elave olaraq gonderirik int RowIndex = -1; if (!int.TryParse(TxtRowIndexFilter.Text, out RowIndex)) { RowIndex = -1; } int PageNum; int RowNumber = 30; if (DListPageSize.SelectedValue == "20") { RowNumber = 10000; } if (!int.TryParse(Config._GetQueryString("p"), out PageNum)) { PageNum = 1; } // Axirinci sehifeni secmedikce Cache temizlemirik herdefe count almasin deye if (PageNum >= (Cache[_CountCacheName]._ToInt32() / RowNumber)) { Cache.Remove(_CountCacheName); } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult ApplicationsList = DALC.GetAuditsOrganizations(Dictionary, PageNum, RowNumber, new object[] { RowIndex }, OrderByType); if (ApplicationsList.Count == -1) { return; } if (ApplicationsList.Dt.Rows.Count < 1 && PageNum > 1) { Config.RedirectURL(string.Format("/tools/AuditsOrganizations/?p={0}", PageNum - 1)); } int Total_Count = ApplicationsList.Count % RowNumber > 0 ? (ApplicationsList.Count / RowNumber) + 1 : ApplicationsList.Count / RowNumber; HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = ApplicationsList.Count > RowNumber; GrdAuditsOrganizations.DataSource = ApplicationsList.Dt; GrdAuditsOrganizations.DataBind(); LblCountInfo.Text = string.Format("Axtarış üzrə nəticə: {0}", ApplicationsList.Count); }
private void BindGridUsers() { GrdUsers.DataSource = null; GrdUsers.DataBind(); if (Session[_FilterSessionName] != null) { var DictionarySession = (Dictionary <string, object>)Session[_FilterSessionName]; if (DictionarySession.Count != 0) { DListFilterOrganizations.SelectedValue = DictionarySession["OrganizationsID"]._ToString(); TxtFilterFullname.Text = DictionarySession["Fullname"]._ToString(); TxtFilterDocNumber.Text = DictionarySession["DocumentNumber"]._ToString(); TxtFilterPin.Text = DictionarySession["PIN"]._ToString(); DListFilterDocType.SelectedValue = DictionarySession["DocumentsTypesID"]._ToString(); } } TxtFilterFullname.Text = TxtFilterFullname.Text.ToUpper(); TxtFilterPin.Text = TxtFilterPin.Text.ToUpper(); var Dictionary = new Dictionary <string, object>() { { "OrganizationsID", int.Parse(DListFilterOrganizations.SelectedValue) }, { "Fullname(LIKE)", TxtFilterFullname.Text }, { "DocumentNumber", TxtFilterDocNumber.Text }, { "PIN", TxtFilterPin.Text }, { "DocumentsTypesID", int.Parse(DListFilterDocType.SelectedValue) } }; int PageNum; int RowNumber = 20; if (!int.TryParse(Config._GetQueryString("p"), out PageNum)) { PageNum = 1; } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult UsersList = DALC.GetUsers(Dictionary, PageNum, RowNumber); if (UsersList.Count == -1) { return; } if (UsersList.Dt.Rows.Count < 1 && PageNum > 1) { Config.RedirectURL(string.Format("/tools/users/?p={0}", PageNum - 1)); } LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", UsersList.Count); int Total_Count = UsersList.Count % RowNumber > 0 ? (UsersList.Count / RowNumber) + 1 : UsersList.Count / RowNumber; HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = UsersList.Count > RowNumber; GrdUsers.DataSource = UsersList.Dt; GrdUsers.DataBind(); }
public static DALC.DataTableResult GetAdoptionPersons(Dictionary <string, object> Dictionary, int PageNumber, int RowNumber = 20) { DALC.DataTableResult AdoptionPersonsList = new DALC.DataTableResult(); SqlCommand com = new SqlCommand(); string Key = ""; object Value = ""; string[] Query = { "IS NULL", "IS NOT NULL" }; StringBuilder AddWhere = new StringBuilder("Where 1=1"); StringBuilder ORWhere = new StringBuilder(); if (Dictionary != null) { int i = 0; foreach (var Item in Dictionary) { Key = Item.Key.ToUpper().Replace("İ", "I"); Value = Item.Value; i++; if (!string.IsNullOrEmpty(Convert.ToString(Value)) && Convert.ToString(Value) != "-1") { // --Eger tarix araligi lazim olarsa-- if (Key.Contains("(BETWEEN)")) { AddWhere.AppendFormat(" and ({0} Between @PDt1{1} and @PDt2{1})", Key.Replace("(BETWEEN)", ""), i.ToString()); com.Parameters.Add("@PDt1" + i.ToString(), SqlDbType.NVarChar).Value = Value._ToString().Split('&')[0]; com.Parameters.Add("@PDt2" + i.ToString(), SqlDbType.NVarChar).Value = Value._ToString().Split('&')[1]; } else if (Key.Contains("(LIKE)")) { AddWhere.AppendFormat(" and {0} Like '%' + @P{1} + '%'", Key.Replace("(LIKE)", ""), i.ToString()); com.Parameters.AddWithValue("@P" + i.ToString(), Value.LikeFormat()); } else if (Key.ToUpper().Contains("(IN)")) { AddWhere.AppendFormat(" and {0} in(Select item from SplitString(@wIn{1},','))", Key.Replace("(IN)", ""), i.ToString()); com.Parameters.AddWithValue("@wIn" + i.ToString(), Value); } else if (Key.ToUpper().Contains("(NOTIN)")) { AddWhere.AppendFormat(" and {0} not in(Select item from SplitString(@wNotIn{1},','))", Key.Replace("(NOTIN)", ""), i.ToString()); com.Parameters.AddWithValue("@wNotIn" + i.ToString(), Value); } else if (Array.IndexOf(Query, Value._ToString().ToUpper()) > -1) { AddWhere.AppendFormat(" and {0} {1}", Key, Value); } else { AddWhere.AppendFormat(" and {0}=@P{1}", Key, i.ToString()); com.Parameters.AddWithValue("@P" + i.ToString(), Value); } } } if (ORWhere.Length > 0) { AddWhere.AppendFormat(" and ({0})", ORWhere.Remove(ORWhere.ToString().Length - 2, 2)); } } string QueryCommand = @"Select {0} From (Select Row_Number() Over (Order By Ap.ID desc) as RowIndex, CONCAT(Soyad,' ',Ad,' ',Ata) as Fullname , CONCAT(r.Name,' , ',c.Name) as Location , ec.Name as EyeColor, hc.Name as HairColor, AO.Name as AdoptionOrganizations, CONVERT(int,ROUND(DATEDIFF(hour,DogumTarixi,GETDATE())/8766.0,0)) as Yash, Ap.* From AdoptionPersons as Ap LEFT JOIN Colors as ec on ec.ID=Ap.GozColorsID LEFT JOIN Colors as hc on hc.ID=Ap.SachColorsID LEFT JOIN Countries as c on c.ID=Ap.CountriesID LEFT JOIN Regions as r on r.ID=Ap.RegionsID LEFT JOIN AdoptionOrganizations as AO on AO.ID=AP.AdoptionOrganizationsID {1} ) as Ap {2}"; com.Connection = DALC.SqlConn; com.CommandText = string.Format(QueryCommand, "COUNT(Ap.ID)", AddWhere, ""); try { com.Connection.Open(); AdoptionPersonsList.Count = com.ExecuteScalar()._ToInt32(); } catch (Exception er) { DALC.ErrorLogsInsert(string.Format("DALC_Adoption.GetAdoptionPersons TableName: {0} count xəta: {1}", "AdoptionPersons", er.Message)); AdoptionPersonsList.Count = -1; AdoptionPersonsList.Dt = null; return(AdoptionPersonsList); } finally { com.Connection.Close(); } string RowIndexWhere = " Where Ap.RowIndex BETWEEN @R1 AND @R2"; com.Parameters.Add("@R1", SqlDbType.Int).Value = ((PageNumber * RowNumber) - RowNumber) + 1; com.Parameters.Add("@R2", SqlDbType.Int).Value = PageNumber * RowNumber; com.CommandText = string.Format(QueryCommand, "Ap.* ", AddWhere, RowIndexWhere); try { new SqlDataAdapter(com).Fill(AdoptionPersonsList.Dt); return(AdoptionPersonsList); } catch (Exception er) { DALC.ErrorLogsInsert(string.Format("DALC_Adoption.GetAdoptionPersons TableName: {0} xəta: {1}", "AdoptionPersons", er.Message)); AdoptionPersonsList.Count = -1; AdoptionPersonsList.Dt = null; return(AdoptionPersonsList); } }
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(); }
public static DALC.DataTableResult GetAdoptionAdministratorHistory(int Top, Dictionary <string, object> Dictionary, string OrderBy = "") { DALC.DataTableResult AdoptionAdministratorHistory = new DALC.DataTableResult(); SqlCommand com = new SqlCommand(); string Key = ""; object Value = ""; string[] Query = { "IS NULL", "IS NOT NULL" }; StringBuilder AddWhere = new StringBuilder("Where 1=1"); StringBuilder ORWhere = new StringBuilder(); if (Dictionary != null) { int i = 0; foreach (var Item in Dictionary) { Key = Item.Key.ToUpper().Replace("İ", "I"); Value = Item.Value; i++; if (!string.IsNullOrEmpty(Convert.ToString(Value)) && Convert.ToString(Value) != "-1") { // --Eger tarix araligi lazim olarsa-- if (Key.Contains("(BETWEEN)")) { AddWhere.AppendFormat(" and ({0} Between @PDt1{1} and @PDt2{1})", Key.Replace("(BETWEEN)", ""), i.ToString()); com.Parameters.Add("@PDt1" + i.ToString(), SqlDbType.NVarChar).Value = Value._ToString().Split('&')[0]; com.Parameters.Add("@PDt2" + i.ToString(), SqlDbType.NVarChar).Value = Value._ToString().Split('&')[1] + " 23:59:59"; } else if (Key.Contains("(LIKE)")) { AddWhere.AppendFormat(" and {0} Like '%' + @P{1} + '%'", Key.Replace("(LIKE)", ""), i.ToString()); com.Parameters.AddWithValue("@P" + i.ToString(), Value); } else if (Key.ToUpper().Contains("(IN)")) { AddWhere.AppendFormat(" and {0} in(Select item from SplitString(@wIn{0},','))", Key.Replace("(IN)", "")); com.Parameters.AddWithValue("@wIn" + Key.Replace("(IN)", ""), Value); } else if (Array.IndexOf(Query, Value._ToString().ToUpper()) > -1) { AddWhere.AppendFormat(" and {0} {1}", Key, Value); } else { AddWhere.AppendFormat(" and {0}=@P{1}", Key, i.ToString()); com.Parameters.AddWithValue("@P" + i.ToString(), Value); } } } if (ORWhere.Length > 0) { AddWhere.AppendFormat(" and ({0})", ORWhere.Remove(ORWhere.ToString().Length - 2, 2)); } } string QueryCommand = @"Select {0} From AdoptionAdministratorsHistory as AAH LEFT JOIN AdoptionAdministrators as AA on AAH.AdoptionAdministratorsID=AA.ID {1} {2}"; com.Connection = DALC.SqlConn; com.CommandText = string.Format(QueryCommand, "COUNT(AAH.ID)", AddWhere, OrderBy); try { com.Connection.Open(); AdoptionAdministratorHistory.Count = com.ExecuteScalar()._ToInt32(); } catch (Exception er) { DALC.ErrorLogsInsert("AdoptionAdministratorHistory count xəta: " + er.Message); AdoptionAdministratorHistory.Count = -1; AdoptionAdministratorHistory.Dt = null; return(AdoptionAdministratorHistory); } finally { com.Connection.Close(); } com.CommandText = String.Format(QueryCommand, @"Top (@Top) AAH.ID, AAH.AdoptionAdministratorsID, AA.Username as UserName, AA.Fullname as FullName, AAH.LogText as Logtext, FORMAT(AAH.Add_Dt, 'dd.MM.yyyy hh:mm') as Date, AAH.Add_Ip as Ip", AddWhere, OrderBy); com.Parameters.Add("@Top", SqlDbType.Int).Value = Top; try { new SqlDataAdapter(com).Fill(AdoptionAdministratorHistory.Dt); return(AdoptionAdministratorHistory); } catch (Exception er) { DALC.ErrorLogsInsert("AdoptionAdministratorHistory xəta: " + er.Message); AdoptionAdministratorHistory.Count = -1; AdoptionAdministratorHistory.Dt = null; return(AdoptionAdministratorHistory); } }
void BindGrid() { if (Session[_FilterSessionName] != null) { var DictionarySession = (Dictionary<string, object>)Session[_FilterSessionName]; if (DictionarySession.Count != 0) { TxtRowIndexFilter.Text = DictionarySession["RowIndex"]._ToString(); TxtNumbersFilter.Text = DictionarySession["Numbers"]._ToString(); DListComplaintTypeFilter.SelectedValue = DictionarySession["ComplaintTypeID"]._ToString(); DlistExecutiveUsersFilter.SelectedValue = DictionarySession["ExecutiveUsersID"]._ToString(); TxtApplicantsFullnameFilter.Text = DictionarySession["ApplicantsFullname"]._ToString(); DListApplicantsGenderTypeFilter.SelectedValue = DictionarySession["GenderTypeID"]._ToString(); DListApplicantsSocialStatusFilter.SelectedValue = DictionarySession["SocialStatusID"]._ToString(); TxtVictimsFullnameFilter.Text = DictionarySession["VictimsFullname"]._ToString(); TxtComplaintInstitutionFilter.Text = DictionarySession["ComplaintInstitution"]._ToString(); DListComplaintResultTypeFilter.SelectedValue = DictionarySession["ComplaintResultTypeID"]._ToString(); TxtResultsFilter.Text = DictionarySession["Results"]._ToString(); TxtEnterOrganizationsStartDtFilter.Text = DictionarySession["StartEnterOrganizations_Dt"]._ToString(); TxtEnterOrganizationsEndDtFilter.Text = DictionarySession["EndEnterOrganizations_Dt"]._ToString(); TxtEnterSectorStartDtFilter.Text = DictionarySession["StartEnterSector_Dt"]._ToString(); TxtEnterSectorEndDtFilter.Text = DictionarySession["EndEnterSector_Dt"]._ToString(); DListDatePriority.SelectedValue = DictionarySession["DatePriority"]._ToString(); DListPageSize.SelectedValue = DictionarySession["PageSize"]._ToString(); } } #region BetweenDateFromat string OrganizationsDate = ""; string Dt1 = "19000101"; string Dt2 = DateTime.Now.ToString("yyyyMMdd"); object DateFilter1 = Config.DateTimeFormat(TxtEnterOrganizationsStartDtFilter.Text.Trim()); object DateFilter2 = Config.DateTimeFormat(TxtEnterOrganizationsEndDtFilter.Text.Trim()); if (DateFilter1 == null && DateFilter2 == null) { OrganizationsDate = ""; } else { if (DateFilter1 != null) { Dt1 = ((DateTime)DateFilter1).ToString("yyyyMMdd"); } if (DateFilter2 != null) { Dt2 = ((DateTime)DateFilter2).ToString("yyyyMMdd"); } OrganizationsDate = Dt1 + "&" + Dt2; } string SectorDate = ""; Dt1 = "19000101"; Dt2 = DateTime.Now.ToString("yyyyMMdd"); DateFilter1 = Config.DateTimeFormat(TxtEnterSectorStartDtFilter.Text.Trim()); DateFilter2 = Config.DateTimeFormat(TxtEnterSectorEndDtFilter.Text.Trim()); if (DateFilter1 == null && DateFilter2 == null) { SectorDate = ""; } else { if (DateFilter1 != null) { Dt1 = ((DateTime)DateFilter1).ToString("yyyyMMdd"); } if (DateFilter2 != null) { Dt2 = ((DateTime)DateFilter2).ToString("yyyyMMdd"); } SectorDate = Dt1 + "&" + Dt2; } #endregion var Dictionary = new Dictionary<string, object>() { {"Numbers",TxtNumbersFilter.Text}, {"ComplaintTypeID",int.Parse(DListComplaintTypeFilter.SelectedValue)}, {"ExecutiveUsersID",int.Parse(DlistExecutiveUsersFilter.SelectedValue) }, {"GenderTypeID",int.Parse(DListApplicantsGenderTypeFilter.SelectedValue) }, {"SocialStatusID",int.Parse(DListApplicantsSocialStatusFilter.SelectedValue) }, {"(LIKE)ApplicantsFullname",TxtApplicantsFullnameFilter.Text}, {"(LIKE)VictimsFullname",TxtVictimsFullnameFilter.Text}, {"ComplaintInstitution", TxtComplaintInstitutionFilter.Text}, {"ComplaintResultTypeID", DListComplaintResultTypeFilter.SelectedValue}, {"(LIKE)Results", TxtResultsFilter.Text}, {"EnterOrganizations_Dt(BETWEEN)", OrganizationsDate}, {"EnterSector_Dt(BETWEEN)", SectorDate} }; //Sira sayina gore filteri elave olaraq gonderirik int RowIndex = -1; if (!int.TryParse(TxtRowIndexFilter.Text, out RowIndex)) { RowIndex = -1; } int PageNum; int RowNumber = 30; if (DListPageSize.SelectedValue == "20") { RowNumber = 10000; } string OrderByType = "desc"; if (DListDatePriority.SelectedValue == "20") { OrderByType = "asc"; } if (!int.TryParse(Config._GetQueryString("p"), out PageNum)) { PageNum = 1; } // Axirinci sehifeni secmedikce Cache temizlemirik herdefe count almasin deye if (PageNum >= (Cache[_CountCacheName]._ToInt32() / RowNumber)) { Cache.Remove(_CountCacheName); } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult ApplicationsList = DALC.GetIndividualComplaints(Dictionary, PageNum, RowNumber, new object[] { RowIndex }, OrderByType); if (ApplicationsList.Count == -1) { return; } if (ApplicationsList.Dt.Rows.Count < 1 && PageNum > 1) { Config.RedirectURL(string.Format("/tools/IndividualComplaints/?p={0}", PageNum - 1)); } int Total_Count = ApplicationsList.Count % RowNumber > 0 ? (ApplicationsList.Count / RowNumber) + 1 : ApplicationsList.Count / RowNumber; HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = ApplicationsList.Count > RowNumber; GrdIndividualComplaints.DataSource = ApplicationsList.Dt; GrdIndividualComplaints.DataBind(); LblCountInfo.Text = string.Format("Axtarış üzrə nəticə: {0}", ApplicationsList.Count); }
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(); }
public static DALC.DataTableResult GetAdoptionSearchHistory(Dictionary <string, object> Dictionary, int PageNumber, int RowNumber = 20) { DALC.DataTableResult AdoptionSearchHistory = new DALC.DataTableResult(); SqlCommand com = new SqlCommand(); string Key = ""; object Value = ""; string[] Query = { "IS NULL", "IS NOT NULL" }; StringBuilder AddWhere = new StringBuilder("Where 1=1"); StringBuilder ORWhere = new StringBuilder(); if (Dictionary != null) { int i = 0; foreach (var Item in Dictionary) { Key = Item.Key.ToUpper().Replace("İ", "I"); Value = Item.Value; i++; if (!string.IsNullOrEmpty(Convert.ToString(Value)) && Convert.ToString(Value) != "-1") { // --Eger tarix araligi lazim olarsa-- if (Key.Contains("(BETWEEN)")) { AddWhere.AppendFormat(" and ({0} Between @PDt1{1} and @PDt2{1})", Key.Replace("(BETWEEN)", ""), i.ToString()); com.Parameters.Add("@PDt1" + i.ToString(), SqlDbType.NVarChar).Value = Value._ToString().Split('&')[0]; com.Parameters.Add("@PDt2" + i.ToString(), SqlDbType.NVarChar).Value = Value._ToString().Split('&')[1]; } else if (Key.Contains("(LIKE)")) { AddWhere.AppendFormat(" and {0} Like '%' + @P{1} + '%'", Key.Replace("(LIKE)", ""), i.ToString()); com.Parameters.AddWithValue("@P" + i.ToString(), Value.LikeFormat()); } else if (Key.ToUpper().Contains("(IN)")) { AddWhere.AppendFormat(" and {0} in(Select item from SplitString(@wIn{1},','))", Key.Replace("(IN)", ""), i.ToString()); com.Parameters.AddWithValue("@wIn" + i.ToString(), Value); } else if (Key.ToUpper().Contains("(NOTIN)")) { AddWhere.AppendFormat(" and {0} not in(Select item from SplitString(@wNotIn{1},','))", Key.Replace("(NOTIN)", ""), i.ToString()); com.Parameters.AddWithValue("@wNotIn" + i.ToString(), Value); } else if (Array.IndexOf(Query, Value._ToString().ToUpper()) > -1) { AddWhere.AppendFormat(" and {0} {1}", Key, Value); } else { AddWhere.AppendFormat(" and {0}=@P{1}", Key, i.ToString()); com.Parameters.AddWithValue("@P" + i.ToString(), Value); } } } if (ORWhere.Length > 0) { AddWhere.AppendFormat(" and ({0})", ORWhere.Remove(ORWhere.ToString().Length - 2, 2)); } } string QueryCommand = @"Select {0} From (Select Row_Number() Over (Order By ASH.ID desc) as RowIndex, ASH.*,AO.Name as AdoptionOrganizations From AdoptionSearchHistory as ASH LEFT JOIN AdoptionOrganizations as AO on AO.ID=ASH.AdoptionOrganizationsID {1} ) as ASH {2}"; com.Connection = DALC.SqlConn; com.CommandText = string.Format(QueryCommand, "COUNT(ASH.ID)", AddWhere, ""); try { com.Connection.Open(); AdoptionSearchHistory.Count = com.ExecuteScalar()._ToInt32(); } catch (Exception er) { DALC.ErrorLogsInsert(string.Format("DALC_Adoption.GetAdoptionSearchHistory TableName: {0} count xəta: {1}", "AdoptionSearchHistory", er.Message)); AdoptionSearchHistory.Count = -1; AdoptionSearchHistory.Dt = null; return(AdoptionSearchHistory); } finally { com.Connection.Close(); } string RowIndexWhere = " Where ASH.RowIndex BETWEEN @R1 AND @R2"; com.Parameters.Add("@R1", SqlDbType.Int).Value = ((PageNumber * RowNumber) - RowNumber) + 1; com.Parameters.Add("@R2", SqlDbType.Int).Value = PageNumber * RowNumber; com.CommandText = string.Format(QueryCommand, "ASH.* ", AddWhere, RowIndexWhere); try { new SqlDataAdapter(com).Fill(AdoptionSearchHistory.Dt); return(AdoptionSearchHistory); } catch (Exception er) { DALC.ErrorLogsInsert(string.Format("DALC_Adoption.GetAdoptionSearchHistory TableName: {0} xəta: {1}", "AdoptionSearchHistory", er.Message)); AdoptionSearchHistory.Count = -1; AdoptionSearchHistory.Dt = null; return(AdoptionSearchHistory); } }