private void UpdateActivePage()
{
int num = 0;
for (int i = 0; i < this.m_PlantsElements.Count; i++)
{
PageNum component = this.m_PlantsElements[i].GetComponent <PageNum>();
NotepadData component2 = this.m_PlantsElements[i].gameObject.GetComponent <NotepadData>();
if (component.m_PageNum == this.m_CurrentPage && (component2 == null || component2.ShouldShow()))
{
this.m_PlantsElements[i].SetActive(true);
if (component2 != null)
{
component2.m_WasActive = true;
}
this.UpdateSubElements(this.m_PlantsElements[i].transform);
num++;
}
else
{
this.m_PlantsElements[i].SetActive(false);
}
}
this.m_NumActiveElementsOnPage = num;
}
private void Awake()
{
for (int i = 0; i < base.gameObject.transform.childCount; i++)
{
GameObject gameObject = base.gameObject.transform.GetChild(i).gameObject;
this.m_ItemsElelements.Add(gameObject);
NotepadData component = gameObject.GetComponent <NotepadData>();
if (component)
{
component.Init();
}
}
int num = 0;
for (int j = 0; j < this.m_ItemsElelements.Count; j++)
{
List <Text> componentsDeepChild = General.GetComponentsDeepChild <Text>(this.m_ItemsElelements[j]);
for (int k = 0; k < componentsDeepChild.Count; k++)
{
componentsDeepChild[k].text = GreenHellGame.Instance.GetLocalization().Get(componentsDeepChild[k].name);
}
PageNum component2 = this.m_ItemsElelements[j].GetComponent <PageNum>();
if (component2.m_PageNum + 1 > num)
{
num = component2.m_PageNum + 1;
}
}
this.m_NumActivePages = num * 2;
}
public override void Init()
{
base.Init();
for (int i = 0; i < base.gameObject.transform.childCount; i++)
{
GameObject gameObject = base.gameObject.transform.GetChild(i).gameObject;
this.m_PlantsElements.Add(gameObject);
}
int num = 0;
for (int j = 0; j < this.m_PlantsElements.Count; j++)
{
Text[] componentsDeepChild = General.GetComponentsDeepChild <Text>(this.m_PlantsElements[j]);
for (int k = 0; k < componentsDeepChild.Length; k++)
{
componentsDeepChild[k].text = GreenHellGame.Instance.GetLocalization().Get(componentsDeepChild[k].name, true);
}
PageNum component = this.m_PlantsElements[j].GetComponent <PageNum>();
if (component.m_PageNum + 1 > num)
{
num = component.m_PageNum + 1;
}
}
this.m_NumActivePages = num * 2;
}
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();
}
public override void AddAdditionalParams(Dictionary <string, string> parameters)
{
this.NameValues["action"] = this.MethodName;
this.NameValues["word"] = this.Word;
this.NameValues["apilevel"] = "4";
this.NameValues["rn"] = "50";
this.NameValues["pn"] = PageNum.ToString();
base.AddAdditionalParams(parameters);
}
private void Navigation(long totalRecords)
{
//------------
txtPageTotalRowsNum.Text = totalRecords.ToString();
if (totalRecords != 0)
{
Double totalPages = Math.Ceiling(((double)totalRecords / PageSize));
if ((totalRecords == 1) || (totalPages == 0))
{
totalPages = 1;
}
//if (PageSizeMAE > totalRecords)
//{
// PageSizeMAE = (int)totalPages;
//}
//else
// PageSizeMAE = long.Parse(ConfigurationSettings.AppSettings["RowsPorPagina"].ToString());
txtGoToPage.Text = PageNum.ToString();
lblCurrentPage.Text = PageNum.ToString();
lblTotalPages.Text = totalPages.ToString();
}
else
{
txtPageTotalRowsNum.Text = "0";
txtGoToPage.Text = "0";
lblCurrentPage.Text = "0";
lblTotalPages.Text = "0";
}
//control de teclas
if (lblCurrentPage.Text.Trim().Equals(lblTotalPages.Text.Trim()))
{
NextPage.Enabled = false;
LastPage.Enabled = false;
}
else
{
NextPage.Enabled = true;
LastPage.Enabled = true;
}
if (lblCurrentPage.Text.Trim().Equals("1"))
{
FirstPage.Enabled = false;
PreviousPage.Enabled = false;
}
else
{
FirstPage.Enabled = true;
PreviousPage.Enabled = true;
}
}
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 ShowPageForLastUnlockedItem()
{
for (int i = 0; i < this.m_ItemsElelements.Count; i++)
{
PageNum component = this.m_ItemsElelements[i].GetComponent <PageNum>();
NotepadItemData component2 = this.m_ItemsElelements[i].gameObject.GetComponent <NotepadItemData>();
if (!(component == null) && !(component2 == null) && component2.m_ItemID == this.m_LastUnlockedItem.ToString())
{
this.m_CurrentPage = component.m_PageNum;
}
}
}
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();
}
/// <summary>
/// Returns the hash code for this instance
/// </summary>
/// <returns>The hash code for this instance</returns>
public override int GetHashCode()
{
var hashCode = -2110119757;
hashCode = hashCode * -1521134295 + ISBN.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Author);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Name);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(PublishingHouse);
hashCode = hashCode * -1521134295 + Year.GetHashCode();
hashCode = hashCode * -1521134295 + PageNum.GetHashCode();
return(hashCode);
}
public virtual string Render(IPagingConfig config)
{
StringBuilder sb = new StringBuilder();
var qString = PageNum != 0 ? "?" + _State.BuildPaginationQueryString(config.PageKey, PageNum) : "#";
sb.Append(PageNum == 0 ? config.DisabledLinkWrapperStart : config.LinkWrapperStart);
sb.Append($"<a id='page_link_{PageNum}'");
sb.Append($" name='page_link_{PageNum}' ");
sb.Append($" class='{config.LinkClass}' ");
sb.Append($" href='{ qString}' ");
sb.Append(">");
sb.Append(Text ?? PageNum.ToString());
sb.Append("</a>");
sb.Append(config.LinkWrapperEnd);
return(sb.ToString());
}
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 Awake()
{
for (int i = 0; i < base.gameObject.transform.childCount; i++)
{
GameObject gameObject = base.gameObject.transform.GetChild(i).gameObject;
this.m_SkillsElement.Add(gameObject);
}
int num = 0;
for (int j = 0; j < this.m_SkillsElement.Count; j++)
{
PageNum component = this.m_SkillsElement[j].GetComponent <PageNum>();
if (component.m_PageNum + 1 > num)
{
num = component.m_PageNum + 1;
}
}
this.m_NumActivePages = num * 2;
}
private void UpdateActivePage()
{
int num = 0;
for (int i = 0; i < this.m_SkillsElement.Count; i++)
{
PageNum component = this.m_SkillsElement[i].GetComponent <PageNum>();
if (component.m_PageNum == this.m_CurrentPage)
{
this.m_SkillsElement[i].SetActive(true);
num++;
}
else
{
this.m_SkillsElement[i].SetActive(false);
}
}
this.m_NumActiveElementsOnPage = num;
this.UpdateTexts();
}
protected void btnToExcell_Click(object sender, ImageClickEventArgs e)
{
DataTable dt = ToDatatable.toDataTable(sesNotificacionesVencidas);
dt.TableName = "ListadoDevolucionesFueraDePlazo-Pagina-" + PageNum.ToString() + "-" + System.DateTime.Now.ToShortDateString();
try
{
string strBody = "";
strBody = Exportar.DataTable2ExcelString(dt);
Response.AppendHeader("Content-Type", "application/vnd.ms-excel");
Response.AppendHeader("Content-disposition", "attachment; filename=DevolucionesFueraDePlazo_Consulta_Pagina_" + PageNum.ToString() + "_" + System.DateTime.Now.ToShortDateString() + "_Pag_" + lblCurrentPage.Text + ".xls");
Response.Write(strBody);
}
catch (Exception er)
{
log.Error("Ocurrio un error al generar el listado de exportacion." + er.Message);
MError.MensajeError = "Ocurrio un error al generar el listado de exportacion.";
}
}
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();
}
public static PageNum <THelper> SetDisabled <THelper>(this PageNum <THelper> pageNum, bool disabled = true)
where THelper : BootstrapHelper <THelper>
{
pageNum.Disabled = disabled;
return(pageNum);
}
public static PageNum <THelper> SetActive <THelper>(this PageNum <THelper> pageNum, bool active = true)
where THelper : BootstrapHelper <THelper>
{
pageNum.Active = active;
return(pageNum);
}
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 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();
}
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();
}
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();
}
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);
}
protected void Page_PreRender(object sender, EventArgs e)
{
string Url = ViewState["Url"].ToString();
if (String.IsNullOrEmpty(Request.QueryString["page"]))
{
curpage = 1;
}
else
{
curpage = Convert.ToInt32(Request.QueryString["page"]);
}
//每页显示条数
if (String.IsNullOrEmpty(Request.QueryString["pageSize"]))
{
curpageSize = pagesize;
}
else
{
curpageSize = Convert.ToInt32(Request.QueryString["pageSize"]);
}
if (!IsPostBack)
{
if (String.IsNullOrEmpty(Request.QueryString["pageSize"]))
{
txtPage.Text = pagesize.ToString();
}
else
{
txtPage.Text = Request.QueryString["pageSize"];
}
}
if (ViewState["query"] == null || ViewState["query"].ToString() == string.Empty)
{
this.Visible = false;
return;
}
GetData(curpage, curpageSize);
if (total == 0)
{
this.Visible = false;
return;
}
else
{
this.Visible = true;
}
if (text.Visible == true)
{
if (curpage == 1 && totalpage > 1)
{
ChangeState(false, true);
}
else if (curpage == totalpage && totalpage > 1)
{
ChangeState(true, false);
}
else if (totalpage == 1)
{
ChangeState(false, false);
}
else
{
ChangeState(true, true);
}
}
else
{
int startpage;
int endpage;
startpage = Convert.ToInt16(curpage);
endpage = startpage + 9;
if (endpage > totalpage)
{
endpage = totalpage;
}
for (int i = 0; i <= 9; i++)//初使化分页链接
{
HyperLink lnkbtn = (this.FindControl("lnkbtn" + i) as HyperLink);
if (i + startpage <= endpage)
{
lnkbtn.NavigateUrl = Url + "&page=" + (i + startpage).ToString() + "&pageSize=" + txtPage.Text;
lnkbtn.Text = (i + startpage).ToString();
if (curpage == i + startpage)
{
lnkbtn.Enabled = false;
}
else
{
lnkbtn.Enabled = true;
}
lnkbtn.Visible = true;
}
else
{
lnkbtn.Visible = false;
}
}
if (lnkbtn0.Text == "1")
{
pre.Visible = false;
}
else
{
pre.Visible = true;
}
if (lnkbtn9.Visible == false || Convert.ToInt16(lnkbtn9.Text) == totalpage)
{
next.Visible = false;
}
else
{
next.Visible = true;
}
}
lblCurpage.Text = curpage.ToString(); //页次
lblTotal.Text = total.ToString(); //记录总数
lblPages.Text = totalpage.ToString(); //总页数
//Num 分页 下十页,最后一页,上十页,最前一页
int PageNum;
if (Convert.ToInt16(lblCurpage.Text) - 10 < 1)
{
PageNum = 1;
}
else
{
PageNum = Convert.ToInt16(lblCurpage.Text) - 10;
}
lnkbtnFTen.NavigateUrl = Url + "&page=" + PageNum.ToString() + "&pageSize=" + txtPage.Text;
if (Convert.ToInt16(lblCurpage.Text) - 1 < 1)
{
PageNum = 1;
}
else
{
PageNum = Convert.ToInt16(lblCurpage.Text) - 1;
}
lnkbtnPTen.NavigateUrl = Url + "&page=" + PageNum.ToString() + "&pageSize=" + txtPage.Text;
if (Convert.ToInt16(lblCurpage.Text) + 1 > total)
{
PageNum = total;
}
else
{
PageNum = Convert.ToInt16(lblCurpage.Text) + 1;
}
lnkbtnNTen.NavigateUrl = Url + "&page=" + PageNum.ToString() + "&pageSize=" + txtPage.Text;
if (Convert.ToInt16(lblCurpage.Text) + 10 > total)
{
PageNum = total;
}
else
{
PageNum = Convert.ToInt16(lblCurpage.Text) + 10;
}
lnkbtnLTen.NavigateUrl = Url + "&page=" + PageNum.ToString() + "&pageSize=" + txtPage.Text;
//Text 分页 首页 上一页 下一页 末页
lnkbtnFirst.NavigateUrl = Url + "&page=1" + "&pageSize=" + txtPage.Text;
lnkbtnPrevious.NavigateUrl = Url + "&page=" + (curpage - 1).ToString() + "&pageSize=" + txtPage.Text;
lnkbtnNext.NavigateUrl = Url + "&page=" + (curpage + 1).ToString() + "&pageSize=" + txtPage.Text;
lnkbtnLast.NavigateUrl = Url + "&page=" + totalpage.ToString() + "&pageSize=" + txtPage.Text;
}
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 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();
}
