public async Task <IActionResult> Search([FromQuery] PaginationParams param, FilterQrCodeParam filterParam) { var lists = await _service.Search(param, filterParam); Response.AddPagination(lists.CurrentPage, lists.PageSize, lists.TotalCount, lists.TotalPages); return(Ok(lists)); }
public async Task<List<QRCodeMainViewModel>> SearchNotPagination(FilterQrCodeParam filterParam) { var listPackingList = _repoPacking.GetAll(); if (filterParam.From_Date != null && filterParam.To_Date != null) { listPackingList = listPackingList .Where( x => x.Receive_Date >= Convert.ToDateTime(filterParam.From_Date + " 00:00:00.000") && x.Receive_Date <= Convert.ToDateTime(filterParam.To_Date + " 23:59:59.997")); } var listQrCodeMain = _repoQrcode.GetAll().Where(x => x.Is_Scanned.Trim() == "N"); if (filterParam.MO_No != null && filterParam.MO_No != string.Empty) { listPackingList = listPackingList.Where(x => x.MO_No.Trim() == filterParam.MO_No.Trim()); } var listQrCodeModel = (from x in listQrCodeMain join y in listPackingList on x.Receive_No.Trim() equals y.Receive_No.Trim() select new QRCodeMainViewModel() { QRCode_ID = x.QRCode_ID, MO_No = y.MO_No, QRCode_Version = x.QRCode_Version, Receive_No = x.Receive_No, Receive_Date = y.Receive_Date, Supplier_ID = y.Supplier_ID, Supplier_Name = y.Supplier_Name, T3_Supplier = y.T3_Supplier, T3_Supplier_Name = y.T3_Supplier_Name, Subcon_ID = y.Subcon_ID, Subcon_Name = y.Subcon_Name, Model_Name = y.Model_Name, Model_No = y.Model_No, Article = y.Article, MO_Seq = y.MO_Seq, Material_ID = y.Material_ID, Material_Name = y.Material_Name }).Distinct().OrderByDescending(x => x.Receive_Date); return await listQrCodeModel.ToListAsync(); }
public async Task <PagedList <QRCodeMainViewModel> > Search(PaginationParams param, FilterQrCodeParam filterParam) { var pred_Packing_List = PredicateBuilder.New <WMSB_Packing_List>(true); if (filterParam.From_Date != null && filterParam.To_Date != null) { pred_Packing_List.And(x => x.Receive_Date >= Convert.ToDateTime(filterParam.From_Date) && x.Receive_Date <= Convert.ToDateTime(filterParam.To_Date + " 23:59:59.997")); } if (!String.IsNullOrEmpty(filterParam.MO_No)) { pred_Packing_List.And(x => x.MO_No.Trim() == filterParam.MO_No.Trim()); } var listPackingList = _repoPacking.FindAll(pred_Packing_List); var listQrCodeMain = _repoQrcode.FindAll(x => x.Is_Scanned.Trim() == "N"); var listQrCodeModel = (from x in listQrCodeMain join y in listPackingList on x.Receive_No.Trim() equals y.Receive_No.Trim() select new QRCodeMainViewModel() { QRCode_ID = x.QRCode_ID, MO_No = y.MO_No, QRCode_Version = x.QRCode_Version, Receive_No = x.Receive_No, Receive_Date = y.Receive_Date, Supplier_ID = y.Supplier_ID, Supplier_Name = y.Supplier_Name, T3_Supplier = y.T3_Supplier, T3_Supplier_Name = y.T3_Supplier_Name, Subcon_ID = y.Subcon_ID, Subcon_Name = y.Subcon_Name, Model_Name = y.Model_Name, Model_No = y.Model_No, Article = y.Article, MO_Seq = y.MO_Seq, Material_ID = y.Material_ID, Material_Name = y.Material_Name }).Distinct().OrderByDescending(x => x.Receive_Date); return(await PagedList <QRCodeMainViewModel> .CreateAsync(listQrCodeModel, param.PageNumber, param.PageSize, false)); }
public async Task <IActionResult> SearchNotPagination(FilterQrCodeParam filterParam) { var lists = await _service.SearchNotPagination(filterParam); return(Ok(lists)); }