public virtual ActionResult GetAll([DataSourceRequest] DataSourceRequest request,
string barcode,
string sku)
{
LogI("GetAll, barcode=" + barcode + ", sku=" + sku);
var filter = new CustomBarcodeFilterViewModel()
{
Barcode = barcode,
SKU = sku
};
var items = CustomBarcodeViewModel.GetAll(Db, filter);
var dataSource = items.ToDataSourceResult(request);
return(new JsonResult {
Data = dataSource, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public static IQueryable <CustomBarcodeViewModel> GetAll(IUnitOfWork db,
CustomBarcodeFilterViewModel filter)
{
var query = db.CustomBarcodes.GetAllAsDto()
.Where(b => !String.IsNullOrEmpty(b.SKU))
.Select(b => new CustomBarcodeViewModel()
{
Id = b.Id,
Barcode = b.Barcode,
SKU = b.SKU,
AttachSKUDate = b.AttachSKUDate,
});
if (!String.IsNullOrEmpty(filter.Barcode))
{
query = query.Where(b => b.Barcode.StartsWith(filter.Barcode));
}
if (!String.IsNullOrEmpty(filter.SKU))
{
query = query.Where(b => b.SKU.StartsWith(filter.SKU));
}
return(query);
}
