public dynamic GetList(string _search, long nd, int rows, int?page, string sidx, string sord, string filters = "")
{
// Construct where statement
string strWhere = GeneralFunction.ConstructWhere(filters);
// Get Data
var query = _deliveryOrderService.GetAll().Where(d => d.IsDeleted == false);
var list = query as IEnumerable <DeliveryOrder>;
var pageIndex = Convert.ToInt32(page) - 1;
var pageSize = rows;
var totalRecords = query.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
// default last page
if (totalPages > 0)
{
if (!page.HasValue)
{
pageIndex = totalPages - 1;
page = totalPages;
}
}
list = list.Skip(pageIndex * pageSize).Take(pageSize);
return(Json(new
{
total = totalPages,
page = page,
records = totalRecords,
rows = (
from model in list
select new
{
id = model.Id,
cell = new object[] {
model.Id,
model.Code,
model.SalesOrderId,
_salesOrderService.GetObjectById(model.SalesOrderId).Code,
model.DeliveryDate,
model.WarehouseId,
_warehouseService.GetObjectById(model.WarehouseId).Name,
model.IsConfirmed,
model.ConfirmationDate,
model.CreatedAt,
model.UpdatedAt,
}
}).ToArray()
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(DeliveryOrderViewModel model)
{
isAdminLogged();
ViewBag.Parent = "Quản lý giao hàng";
ViewBag.Child = "Tìm kiếm";
try
{
if (model.idDeliveryOrder > 0)
{
var t = _deliveryOrderService.SearchById(model.idDeliveryOrder);
if (t != null)
{
IList <DeliveryOrder> temp = new List <DeliveryOrder>();
temp.Add(t);
model.listDeliveryOrder = temp.ToList();
}
return(View("List", model));
}
else if (model.deliveryDate != null)
{
DateTime delivery_date = Convert.ToDateTime(model.deliveryDate);
model.listDeliveryOrder = _deliveryOrderService.SearchByDeliveryDate(delivery_date);
return(View("List", model));
}
else if (model.status != 0)
{
//byte status = Convert.ToByte(dOrder.status);
model.listDeliveryOrder = _deliveryOrderService.SearchByStatus(model.status);
View("List", model);
}
else
{
model.listDeliveryOrder = _deliveryOrderService.GetAll();
return(View("List", model));
}
}
catch (FormatException e)
{
throw;
}
return(View("List"));
}
