public ShipperViewStore GetShipperByPage(string search, string order, int pageIndex, int pageSize)
{
ShipperViewStore shipper = new ShipperViewStore();
shipper.PageIndex = pageIndex;
shipper.PageSize = pageSize;
shipper.Search = search;
shipper.Order = order;
SqlParameter paramPageSearch = new SqlParameter("@PageSearch", search);
SqlParameter paramOrderColumn = new SqlParameter("@SortOrder", order);
SqlParameter paramPageIndex = new SqlParameter("@PageIndex", pageIndex);
SqlParameter paramPageSize = new SqlParameter("@PageSize", pageSize);
SqlParameter paramRecordCount = new SqlParameter("@RecordCount", shipper.RecordCount);
paramRecordCount.Direction = ParameterDirection.Output;
var listResult = db.Database.SqlQuery <Shipper>("EXEC [dbo].[usp_MaintainShipperPage] @PageSearch, @SortOrder, @PageIndex, @PageSize, @RecordCount = @RecordCount OUTPUT", paramPageSearch, paramOrderColumn, paramPageIndex, paramPageSize, paramRecordCount).ToList();
shipper.RecordCount = (int)paramRecordCount.Value;
shipper.Shippers = listResult.Select(e => new ShipperDTO()
{
ShipperID = e.ShipperID,
CompanyName = e.CompanyName,
Phone = e.Phone
}).ToList();
return(shipper);
}
public JsonResult GetShipper(DTParameters param)
{
ShipperViewStore shipper = new ShipperViewStore();
shipper.PageIndex = param.Start / param.Length + 1;
shipper.PageSize = param.Length;
if (param.Search.Value == null)
{
shipper.Search = "%%";
}
else
{
shipper.Search = "%" + param.Search.Value + "%";
}
shipper.Order = param.SortOrder;
ShipperViewStore categories = new ShipperModels().GetShipperByPage(shipper.Search, shipper.Order, shipper.PageIndex, shipper.PageSize);
DTResult <ShipperDTO> final = new DTResult <ShipperDTO>()
{
draw = param.Draw,
data = categories.Shippers.ToList(),
recordsFiltered = categories.RecordCount,
recordsTotal = categories.Shippers.Count
};
return(Json(final));
}
