///------------------------------------------------------------------------------- /// <summary> /// Kiadványok csatolt dokumentumai /// </summary> /// <param name="dataGrid">Grid</param> /// <param name="index">Lapszám</param> /// <param name="sort">Sorrendezõ oszlop</param> /// <param name="order">Sorrend</param> ///------------------------------------------------------------------------------- protected void ShowGridAttachments(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.EDocumentAttachment"); //kapott ID paraméter meghatározása string docID = Request["ID"]; Guid docGuidID = new Guid(docID); IEDocumentService srvEDoc = ServiceFactory.GetEDocumentService(); EDocumentAttachmentsContainer selected = srvEDoc.SelectChildrenByAttachmentOfEDocumentFileSize(docGuidID); gridAttachment.DataSource = selected.All.Items; gridAttachment.DataBind(); if (selected.All.Count == 0) { gridAttachment.Visible = false; lblNotFoundAttachment.Visible = true; } else { gridAttachment.Visible = true; lblNotFoundAttachment.Visible = false; } ArrayList sortableList; // Sort if necessary if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.Continuative"); // Get query result from database IContinuativeService srv = ServiceFactory.GetContinuativeService(); Continuative filter = new Continuative(Guid.NewGuid()); filter.FilterOnIsactive = 1; ContinuativeContainer selected = srv.ContinuativeSelectFiltered(filter); if (selected.AllCount > 0) { dataGrid.Visible = true; lblNotFound.Visible = false; } else { dataGrid.Visible = false; lblNotFound.Visible = true; return; } ArrayList sortableList; // Sort if necessary if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
/// <summary> /// /// </summary> /// <param name="dataGrid">Grid</param> /// <param name="index">Lapszám</param> /// <param name="sort">Sorrendezõ oszlop</param> /// <param name="order">Sorrend</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.Competition"); // Get query result from database IEDocumentTypeService srv = ServiceFactory.GetEDocumentTypeService(); EDocumentContainer selected; if (Context.User.Identity.IsAuthenticated) { selected = srv.SelectChildrenByTypeOfEDocumentVisibleForRegistered(EDocumentTypeEnum.COM); } else { selected = srv.SelectChildrenByTypeOfEDocumentVisibleForVisitor(EDocumentTypeEnum.COM); } if (selected.AllCount > 0) { dataGrid.Visible = true; lblNotFound.Visible = false; } else { dataGrid.Visible = false; lblNotFound.Visible = true; return; } ArrayList sortableList; // Sort if necessary if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
/// <summary> /// Shows the grid. /// </summary> /// <param name="dataGrid">The data grid.</param> /// <param name="index">The index.</param> /// <param name="sort">The sort.</param> /// <param name="order">The order.</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.JobFindList"); // Get query result from database JobFind filter = new JobFind(Guid.Empty); filter.Sender = Context.User.Identity.Name; filter.Status = JobStatusEnum.ACT; JobFindContainer jobSelectedAll = m_JobSrv.JobFindSelectFiltered(filter); JobFindContainer jobSelected = new JobFindContainer(); if (cmbAll.SelectedValue != "" && cmbAll.SelectedValue != "0") { foreach (JobFind job in jobSelectedAll.All) { int answerCount = 0; foreach (JobAnswer answer in m_answers.All) { if (answer.JobRef == job.ID) { answerCount++; } } if (cmbAll.SelectedValue == "1" && answerCount == 0) // nincs jelentkező { jobSelected.Add(job); } if (cmbAll.SelectedValue == "2" && answerCount > 0) //van { jobSelected.Add(job); } } } else { jobSelected = jobSelectedAll; } if (jobSelected.AllCount > 0) { gridJob.Visible = true; lblNotFound.Visible = false; } else { gridJob.Visible = false; lblNotFound.Visible = true; } ArrayList sortableList; // Sort if necessary if (sort == null) { sortableList = jobSelected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = jobSelected.All.SortBy(sort, true); } else sortableList = String.Compare(order, "Descending", true) == 0 ? jobSelected.All.SortBy(sort, false) : jobSelected.All.SortBy(sort); } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentPageIndex = jobSelected.AllCount <= dataGrid.PageSize*dataGrid.CurrentPageIndex ? 0 : index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
/// <summary> /// Shows the grid. /// </summary> /// <param name="dataGrid">The data grid.</param> /// <param name="index">The index.</param> /// <param name="sort">The sort.</param> /// <param name="order">The order.</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.OrganisationList"); // Get query result from database Organisation filter = new Organisation(Guid.NewGuid()); filter.Name = Helpers.CreateLikeSearchText(txtName.Text); filter.RegionRef = cmbRegion.SelectedValue; filter.OrganisationFormRef = cmbOrganisationForm.SelectedValue; if (cbxPrevention.Checked) filter.ActivityPrevention = true; if (cbxResearch.Checked) filter.ActivityResearch = true; if (cbxRehabilitation.Checked) filter.ActivityRehabilitation = true; if (cbxOther.Checked) filter.ActivityOther = true; filter.FilterOnIsactive = 1; IOrganisationService orgSrv = ServiceFactory.GetOrganisationService(); OrganisationDispsetContainer orgSelected = orgSrv.OrganisationSelectDispsetFiltered(filter); if (orgSelected.AllCount > 0) { gridOrganisation.Visible = true; lblNotFound.Visible = false; } else { gridOrganisation.Visible = false; lblNotFound.Visible = true; } ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = orgSelected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, false); } else { sortableList = orgSelected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (orgSelected.AllCount <= dataGrid.PageSize*dataGrid.CurrentPageIndex) { dataGrid.CurrentPageIndex = 0; } else { dataGrid.CurrentPageIndex = index; } //dataGrid.CurrentSortExpression = sort; //dataGrid.CurrentSortOrder = order; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
protected void ShowForumItemGrid(DataGrid dataGrid, int index, string sort, string order, Guid threadGuid) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.ForumItemList"); // Get query result from database IForumItemService srv = ServiceFactory.GetForumItemService(); ForumItemContainer selected = srv.ForumItemSelectForWeb(threadGuid); if (selected.AllCount > 0) { dataGrid.Visible = true; lblNotFound.Visible = false; } else { dataGrid.Visible = false; lblNotFound.Visible = true; return; } ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
/// <summary> /// Shows the own grid. /// </summary> /// <param name="dataGrid">The data grid.</param> /// <param name="selected">The selected.</param> /// <param name="notFound">The not found.</param> protected void ShowOwnGrid(DataGrid dataGrid, ProgramContainer selected, Panel notFound) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.ProgramList"); if (selected.AllCount > 0) { dataGrid.Visible = true; notFound.Visible = false; } else { dataGrid.Visible = false; notFound.Visible = true; } ArrayList sortableList = selected.All.SortBy("Name", true); // Bind list to datagrid control dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.ProgramList"); // Get query result from database Program filter = new Program(Guid.NewGuid()); filter.Name = Helpers.CreateLikeSearchText(txtProgramName.Text); filter.ProgramCategoryRef = cmbCategory.SelectedValue; filter.FilterOnIsActive = 1; if (cmbOrganisation.SelectedValue.Length > 0) { Guid g = new Guid(cmbOrganisation.SelectedValue); filter.OrganisationRef = g; } IProgramService srv = ServiceFactory.GetProgramService(); ProgramContainer selected = srv.ProgramSelectFiltered(filter); if (selected.AllCount > 0) { gridProgram.Visible = true; lblNotFound.Visible = false; } else { gridProgram.Visible = false; lblNotFound.Visible = true; } ArrayList sortableList = null; if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (selected.AllCount <= dataGrid.PageSize*dataGrid.CurrentPageIndex) { dataGrid.CurrentPageIndex = 0; } else { dataGrid.CurrentPageIndex = index; } //dataGrid.CurrentSortExpression = sort; //dataGrid.CurrentSortOrder = order; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
/// <summary> /// Shows the grid. /// </summary> /// <param name="dataGrid">The data grid.</param> /// <param name="index">The index.</param> /// <param name="sort">The sort.</param> /// <param name="order">The order.</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.JobFindList"); // Get query result from database JobFind filter = new JobFind(Guid.Empty); filter.Description = Helpers.CreateLikeSearchText(txtName.Text); if(txtRefId.Text.Length >0) filter.FilterOnRefId = Convert.ToInt32(txtRefId.Text); filter.RegionRef = cmbRegion.SelectedValue; if (cbxPrevention.Checked) filter.FilterOnActivityPrevention = 1; if (cbxResearch.Checked) filter.FilterOnActivityResearch = 1; if (cbxRehabilitation.Checked) filter.FilterOnActivityRehabilitation = 1; if (cbxOther.Checked) filter.FilterOnActivityOther = 1; filter.Status = JobStatusEnum.ACT; filter.City = Helpers.CreateLikeSearchText(txtCity.Text); filter.Qualification = cmbQualification.SelectedValue; //filter.FilterOnIsactive = 1; //JobFindContainer jobSelectedAll = m_JobSrv.JobFindSelectFiltered(filter); JobFindContainer jobSelected = m_JobSrv.JobFindSelectFiltered(filter); //foreach (JobFind job in jobSelectedAll.All) //{ // if(job.LoginNameRef!= Context.User.Identity.Name) // { // jobSelected.Add(job); // } //} if (jobSelected.AllCount > 0) { gridJob.Visible = true; lblNotFound.Visible = false; } else { gridJob.Visible = false; lblNotFound.Visible = true; } ArrayList sortableList; // Sort if necessary if (sort == null) { sortableList = jobSelected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = jobSelected.All.SortBy(sort, true); } else sortableList = String.Compare(order, "Descending", true) == 0 ? jobSelected.All.SortBy(sort, false) : jobSelected.All.SortBy(sort); } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentPageIndex = jobSelected.AllCount <= dataGrid.PageSize*dataGrid.CurrentPageIndex ? 0 : index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order, string selectedRegion) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.OrganisationList"); // Get query result from database Organisation filter = new Organisation(Guid.NewGuid()); filter.RegionRef = selectedRegion; filter.FilterOnIsactive = 1; IOrganisationService orgSrv = ServiceFactory.GetOrganisationService(); OrganisationDispsetContainer orgSelected = orgSrv.OrganisationSelectDispsetFiltered(filter); if (orgSelected.AllCount > 0) { dataGrid.Visible = true; lblNotFound.Visible = false; } else { dataGrid.Visible = false; lblNotFound.Visible = true; } ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = orgSelected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, false); } else { sortableList = orgSelected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (orgSelected.AllCount <= dataGrid.PageSize * dataGrid.CurrentPageIndex) { dataGrid.CurrentPageIndex = 0; } else { dataGrid.CurrentPageIndex = index; } //dataGrid.CurrentSortExpression = sort; //dataGrid.CurrentSortOrder = order; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { DataView dv = DataSource.Tables[0].DefaultView; if (dv.Count > 0) { dataGrid.Visible = true; } else { dataGrid.Visible = false; return; } if (((EDocument) Page).SelectedGridSort != null && ((EDocument) Page).SelectedGridSort != "") { if (order == "Ascending") { dv.Sort = ((EDocument) Page).SelectedGridSort + " ASC"; } else { dv.Sort = ((EDocument) Page).SelectedGridSort + " DESC"; } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; ((EDocument) Page).SelectedGridSort = sort; ((EDocument) Page).SelectedGridOrder = order; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = dv; dataGrid.DataBind(); }
/// <summary> /// Shows the grid. /// </summary> /// <param name="dataGrid">The data grid.</param> /// <param name="index">The index.</param> /// <param name="sort">The sort.</param> /// <param name="order">The order.</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.JobOfferList"); JobOfferContainer jobSelected = m_JobSrv.JobOfferSelectBySubscriber(Context.User.Identity.Name, JobAnswerTypeEnum.OFF); ArrayList sortableList; jobSelected.All.SortBy("RefId"); // Sort if necessary if (sort == null) { sortableList = jobSelected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = jobSelected.All.SortBy(sort, true); } else sortableList = String.Compare(order, "Descending", true) == 0 ? jobSelected.All.SortBy(sort, false) : jobSelected.All.SortBy(sort); } if (sortableList.Count > 0) { gridJob.Visible = true; lblNotFound.Visible = false; } else { gridJob.Visible = false; lblNotFound.Visible = true; } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentPageIndex = jobSelected.AllCount <= dataGrid.PageSize*dataGrid.CurrentPageIndex ? 0 : index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
/// <summary> /// /// </summary> /// <param name="dataGrid">Grid</param> /// <param name="index">Lapszám</param> /// <param name="sort">Sorrendezõ oszlop</param> /// <param name="order">Sorrend</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.EBookCommendation"); IEDocumentCommendationService srvEDocCom = ServiceFactory.GetEDocumentCommendationService(); DataSet ds; string title = Helpers.CreateLikeSearchText(txtTitle.Text); ; string author = Helpers.CreateLikeSearchText(txtAuthor.Text); string cauthor = Helpers.CreateLikeSearchText(txtCommendationAuthor.Text); string ctitle = Helpers.CreateLikeSearchText(txtCommendationTitle.Text); if (Context.User.Identity.IsAuthenticated) { ds = srvEDocCom.EDocumentCommendationSelectFiltered(title, author, ctitle, cauthor, cmbBookOrPeriodical.SelectedValue.ToString(), 1, DBInt.Null, 1); } else { ds = srvEDocCom.EDocumentCommendationSelectFiltered(title, author, ctitle, cauthor, cmbBookOrPeriodical.SelectedValue.ToString(), 1, 1, DBInt.Null); } gridEBookCommendation.Visible = false; if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { gridEBookCommendation.Visible = true; lblNotFound.Visible = false; } else { lblNotFound.Visible = true; } } else { lblNotFound.Visible = true; } DataView dv = ds.Tables[0].DefaultView; if (dataGrid.CurrentSortExpression != null && dataGrid.CurrentSortExpression != "") { if (order == "Ascending") { dv.Sort = dataGrid.CurrentSortExpression + " ASC"; } else { dv.Sort = dataGrid.CurrentSortExpression + " DESC"; } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = dv; dataGrid.DataBind(); }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = GetCurrentPageSize(); IDictionaryService srvDict = ServiceFactory.GetDictionaryService(); Ndi.HelpDesk.BusinessDocuments.Dictionary filter = new Ndi.HelpDesk.BusinessDocuments.Dictionary(Guid.Empty); string sortAbc; sortAbc = Request["__EVENTTARGET"]; #region : ABC szûrés : if (sortAbc != null) { sortAbc = sortAbc.Replace("ctl00$bodycontent$", ""); if (sortAbc.Length == 1) { txtWord.Text = sortAbc + "*"; index = 0; } } #endregion #region : Kiválasztott szó részletei : if (sortAbc != null) { if ((sortAbc.IndexOf("lnkRefWord") > -1) || (sortAbc.IndexOf("lnkDictionaryWordDetails") > -1)) { index = dataGrid.CurrentPageIndex; if (sortAbc.IndexOf('#') > 0) { string id = sortAbc.Split('#')[1]; Guid currentID = new Guid(id); ShowDetails(currentID); } } } #endregion bool isNormalFilter = sortAbc == null || (sortAbc != null && (sortAbc.Length == 0 || sortAbc.Length > 1) && sortAbc.IndexOf("lnkRefWord") < 0 && sortAbc.IndexOf("lnkDictionaryWordDetails") < 0); filter.Word = isNormalFilter ? Helpers.CreateLikeSearchText(txtWord.Text) : txtWord.Text; filter.English = isNormalFilter ? Helpers.CreateLikeSearchText(txtEnglish.Text) : txtEnglish.Text; if (cmbType.SelectedIndex > 0) { if (cmbType.SelectedIndex == 1) { filter.FilterOnProfessional = 1; } else { filter.FilterOnProfessional = 0; } } filter.FilterOnIsactive = 1; DictionaryContainer selected = srvDict.DictionarySelectFiltered(filter); if (selected.All.Count == 0) { dataGrid.Visible = false; lblNotFound.Visible = true; } else { dataGrid.Visible = true; lblNotFound.Visible = false; } ArrayList sortableList; // Sort if necessary if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
/// <summary> /// /// </summary> /// <param name="dataGrid">Grid</param> /// <param name="index">Lapszám</param> /// <param name="sort">Sorrendezõ oszlop</param> /// <param name="order">Sorrend</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { string publisher = ""; DBInt publishYear = DBInt.Null; dataGrid.PageSize = Helpers.GetPageSize("PageSize.EBookPeriodical"); IEDocumentService srvEDoc = ServiceFactory.GetEDocumentService(); Ndi.HelpDesk.BusinessDocuments.EDocument filter = new Ndi.HelpDesk.BusinessDocuments.EDocument(Guid.Empty); //filter felparaméterezése filter.Title = Helpers.CreateLikeSearchText(txtTitle.Text); ; filter.Author = Helpers.CreateLikeSearchText(txtAuthor.Text); filter.LanguageRef = cmbLanguage.SelectedValue; filter.SubTypeRef = cmbBookOrPeriodical.SelectedValue; filter.TypeRef = EDocumentTypeEnum.PUB; filter.FilterOnIsactive = 1; if (Context.User.Identity.IsAuthenticated) { filter.FilterOnVisibleForRegistered = 1; filter.FilterOnVisibleForVisitor = DBInt.Null; } else { filter.FilterOnVisibleForRegistered = DBInt.Null; filter.FilterOnVisibleForVisitor = 1; } DataSet ds; if (txtPublisherName.Text.Length > 0 || txtDate.Text.Length > 0) { if (txtPublisherName.Text.Length > 0) { publisher = Helpers.CreateLikeSearchText(txtPublisherName.Text); } if (txtDate.Text.Length > 0) { publishYear = Convert.ToInt16(txtDate.Text); } ds = srvEDoc.EDocumentSelectFiltered(filter, 0, "", "", publisher, publishYear); } else { ds = srvEDoc.EDocumentSelectFiltered(filter, 0); } gridEBookPeriodical.Visible = false; if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { gridEBookPeriodical.Visible = true; lblNotFound.Visible = false; } else { lblNotFound.Visible = true; } } else { lblNotFound.Visible = true; } DataView dv = ds.Tables[0].DefaultView; if (dataGrid.CurrentSortExpression != null && dataGrid.CurrentSortExpression != "") { if (order == "Ascending") { dv.Sort = dataGrid.CurrentSortExpression + " ASC"; } else { dv.Sort = dataGrid.CurrentSortExpression + " DESC"; } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (!Page.IsPostBack) { dv.Sort = "nPublishedYear desc, dModifiedDate desc, dCreatedDate desc"; dataGrid.CurrentSortExpression = "nPublishedYear"; dataGrid.CurrentSortOrder = "Descending"; } else { dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = dv; dataGrid.DataBind(); //dataGrid.Sort(new RowComparer(SortOrder.Descending)); }
protected void ShowAttachmentGrid(DataGrid dataGrid, int index, string sort, string order, Guid newsId) { // Get query result from database INewsService srv = ServiceFactory.GetNewsService(); NewsAttachmentContainer selected = srv.SelectChildrenByAttachmentOfNews(newsId); if (selected.AllCount > 0) { pnlAttachement.Visible = true; dataGrid.Visible = true; } else { dataGrid.Visible = false; pnlAttachement.Visible = false; return; } ArrayList sortableList; // Sort if necessary if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); }