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