/// <summary>
/// Fetch xml data using both xsd dataset & LINQ techniques
/// </summary>
protected void LinqFetchXmlData()
{
category.ReadXml(xmlFile);
var cates = (from c in category select c).ToList();
var _pagedDataSource = new PagedDataSource
{
AllowCustomPaging = true,
AllowPaging = true,
PageSize = this.PageSize,
DataSource = category.Skip((this.CurrentPageIndex - 1) * this.PageSize)
};
// Get the total pages
decimal decimalPages = Decimal.Divide((decimal)category.Count, (decimal)_pagedDataSource.PageSize);
this.PageCount = (int)(Math.Ceiling(decimalPages));
// Get the pager info
BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.CategoryCount, category.Count);
//lbPaginationInfo.Text = string.Format("{0} {1} {2} {3}", Properties.Resources.Page, this.CurrentPageIndex, Properties.Resources.Of, this.PageCount);
this.StylePageNagiation(category.Count);
// Fill Repeater Data from PagedDataSource
repeaterData.DataSource = _pagedDataSource;
repeaterData.DataBind();
this.NavigationFor = "LoadingData";
}
/// <summary>
/// Search for data in xml file using both xsd dataset & LINQ techniques
/// </summary>
protected void LinqSearchXmlData()
{
category.ReadXml(xmlFile);
// Note: using [select new] below is most important for showing them in repeater, otherwise we cannot.
// !Important: c.Element("id") -> <name>1</name> - c.Element("id").Value -> 1 - same for active
var cates = (from c in category
where c.Name.Contains(this.Keywrod) || c.Description.Contains(this.Keywrod)
select c).ToList();
//select new { Id = c.Element("id").Value, Name = c.Element("name"), Description = c.Element("description"), Active = c.Element("active").Value }).ToList();
var _pagedDataSource = new PagedDataSource
{
AllowCustomPaging = true,
AllowPaging = true,
PageSize = this.PageSize,
DataSource = category.Skip((this.CurrentPageIndex - 1) * this.PageSize)
};
decimal decimalPages = Decimal.Divide((decimal)category.Count, (decimal)_pagedDataSource.PageSize);
this.PageCount = (int)(Math.Ceiling(decimalPages));
// Get the pager info
BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.Search, category.Count);
this.StylePageNagiation(category.Count);
// Fill Repeater Data from PagedDataSource
repeaterData.DataSource = _pagedDataSource;
repeaterData.DataBind();
// navibation pager will work for the following
this.NavigationFor = "Search";
}
/// <summary>
/// Fetch data using LINQ techniques
/// </summary>
public void LinqFetchData()
{
var contact = (from c in smartDb.ContactUs select new { c.Id, c.Name, c.Email, c.Message, c.SentDate}).ToList();
var _pagedDataSource = new PagedDataSource
{
AllowCustomPaging = true,
AllowPaging = true,
PageSize = this.PageSize,
DataSource = contact.Skip((this.CurrentPageIndex - 1) * this.PageSize)
};
// Get the total pages
this.PageCount = BaseSys.CalculateTotalPages(contact.Count, this.PageSize);
// Get the pager info
BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.NewsCount, contact.Count);
this.StylePageNagiation(contact.Count);
// Fill Repeater Data from PagedDataSource
repeaterData.DataSource = _pagedDataSource;
repeaterData.DataBind();
this.NavigationFor = "LoadingData";
}
/// <summary>
/// Fetch data using LINQ techniques
/// </summary>
public void LinqFetchData()
{
var user = smartDb.SelectUser().ToList();
var _pagedDataSource = new PagedDataSource
{
AllowCustomPaging = true,
AllowPaging = true,
PageSize = this.PageSize,
DataSource = user.Skip((this.CurrentPageIndex - 1) * this.PageSize)
};
// Get the total pages
this.PageCount = BaseSys.CalculateTotalPages(user.Count, this.PageSize);
// Get the pager info
BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.NewsCount, user.Count);
this.StylePageNagiation(user.Count);
// Fill Repeater Data from PagedDataSource
repeaterData.DataSource = _pagedDataSource;
repeaterData.DataBind();
this.NavigationFor = "LoadingData";
}
/// <summary>
/// Search for data in xml file using both xsd dataset & LINQ techniques
/// </summary>
protected void LinqSearchData()
{
var contact = smartDb.SearchContacts(this.Keywrod).ToList();
var _pagedDataSource = new PagedDataSource
{
AllowCustomPaging = true,
AllowPaging = true,
PageSize = this.PageSize,
DataSource = contact.Skip((this.CurrentPageIndex - 1) * this.PageSize)
};
this.PageCount = BaseSys.CalculateTotalPages(contact.Count, this.PageSize);
BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.Search, contact.Count);
this.StylePageNagiation(contact.Count);
// Fill Repeater Data from PagedDataSource
repeaterData.DataSource = _pagedDataSource;
repeaterData.DataBind();
// navibation pager will work for the following
this.NavigationFor = "Search";
}