protected void GridItemList_SortCommand(object source, DataGridSortCommandEventArgs e)
{
string sortingDirection = string.Empty;
if (sortProperty == SortDirection.Ascending)
{
sortProperty = SortDirection.Descending;
sortingDirection = "Desc";
}
else
{
sortProperty = SortDirection.Ascending;
sortingDirection = "Asc";
}
DataTable dataTable = Session["UnitsList"] as DataTable;
DataView sortedView = new DataView(dataTable);
sortedView.Sort = e.SortExpression + " " + sortingDirection;
GridItemList.DataSource = sortedView;
GridItemList.DataBind();
}
private void SearchResult()
{
try
{
int tinhtranghoso = Utils.CIntDef(ddlTinhtranghoso.SelectedValue, 0);
string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value);
var AllList = (from g in DB.ESHOP_NEWs
where ("" == keyword || DB.fClearUnicode(g.NEWS_TITLE).Contains(keyword) || g.NEWS_DESC.Contains(keyword))
//&& g.NEWS_LANGUAGE == lang
&& (g.NEWS_TYPE == 2) &&
(g.TINHTRANGHOSO == tinhtranghoso || tinhtranghoso == 0)
orderby g.NEWS_ID descending
select g);
if (AllList.ToList().Count > 0)
{
Session["NewsList"] = DataUtil.LINQToDataTable(AllList);
}
GridItemList.DataSource = AllList;
if (AllList.ToList().Count > GridItemList.PageSize)
{
GridItemList.AllowPaging = true;
}
else
{
GridItemList.AllowPaging = false;
}
GridItemList.DataBind();
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
private void SearchResult()
{
try
{
string keyword = txtKeyword.Value;
var AllList = (from g in DB.ESHOP_CONTACTs
where ("" == keyword || (g.CONTACT_NAME).Contains(keyword) || (g.CONTACT_EMAIL).Contains(keyword) ||
(g.CONTACT_TITLE).Contains(keyword) || (g.CONTACT_CONTENT).Contains(keyword) ||
g.CONTACT_NAME.Contains(keyword) || g.CONTACT_EMAIL.Contains(keyword) ||
g.CONTACT_TITLE.Contains(keyword) || g.CONTACT_CONTENT.Contains(keyword))
//&&g.CONTACT_TYPE!=1
orderby g.CONTACT_PUBLISHDATE descending
select g);
if (AllList.ToList().Count > 0)
{
Session["ContactList"] = DataUtil.LINQToDataTable(AllList);
}
GridItemList.DataSource = AllList;
if (AllList.ToList().Count > GridItemList.PageSize)
{
GridItemList.AllowPaging = true;
}
else
{
GridItemList.AllowPaging = false;
}
GridItemList.DataBind();
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
private void SearchResult()
{
try
{
string keyword = txtKeyword.Value;
//int Cat_Id=Utils.CIntDef(ddlCategory.SelectedValue);
DateTime fromDate = ucFromDate.returnDate;
DateTime toDate = new DateTime(ucToDate.returnDate.Year, ucToDate.returnDate.Month, ucToDate.returnDate.Day, 23, 59, 59);
int _status = Utils.CIntDef(ddlStatus.SelectedValue);
if (_status != 99)
{
var AllList = (from o in DB.ESHOP_ORDERs
//join o_i in DB.ESHOP_ORDER_ITEMs on o.ORDER_ID equals o_i.ORDER_ID
where ("" == keyword || (o.ORDER_CODE).Contains(keyword) || (o.ORDER_FIELD1).Contains(keyword)) &&
o.ORDER_PUBLISHDATE <= toDate && o.ORDER_PUBLISHDATE >= fromDate &&
o.ORDER_STATUS == _status
select o).Distinct().OrderByDescending(n => n.ORDER_ID);
if (AllList.ToList().Count > 0)
{
Session["OrderList"] = DataUtil.LINQToDataTable(AllList);
}
GridItemList.DataSource = AllList;
if (AllList.ToList().Count > GridItemList.PageSize)
{
GridItemList.AllowPaging = true;
}
else
{
GridItemList.AllowPaging = false;
}
GridItemList.DataBind();
}
else
{
var AllList = (from o in DB.ESHOP_ORDERs
//join o_i in DB.ESHOP_ORDER_ITEMs on o.ORDER_ID equals o_i.ORDER_ID
where ("" == keyword || (o.ORDER_CODE).Contains(keyword) || (o.ORDER_FIELD1).Contains(keyword)) &&
o.ORDER_PUBLISHDATE <= toDate && o.ORDER_PUBLISHDATE >= fromDate
select o).Distinct().OrderByDescending(n => n.ORDER_ID);
if (AllList.ToList().Count > 0)
{
Session["OrderList"] = DataUtil.LINQToDataTable(AllList);
}
GridItemList.DataSource = AllList;
if (AllList.ToList().Count > GridItemList.PageSize)
{
GridItemList.AllowPaging = true;
}
else
{
GridItemList.AllowPaging = false;
}
GridItemList.DataBind();
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}