public async Task <IActionResult> Search([FromQuery] PaginationParams param, FilterPackingListParam 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 <WMSB_Packing_List> > SearchNotPagination(FilterPackingListParam filterParam)
{
var packingSearch = _repoPackingList.GetAll();
if (filterParam.From_Date != null && filterParam.To_Date != null)
{
packingSearch = packingSearch.
Where(x => x.Receive_Date >= DateTime.Parse(filterParam.From_Date + " 00:00:00.000") &&
x.Generated_QRCode.Trim() == "N" &&
x.Receive_Date <= DateTime.Parse(filterParam.To_Date + " 23:59:59.000")
);
}
if (filterParam.MO_No != null && filterParam.MO_No != string.Empty)
{
packingSearch = packingSearch.Where(x => x.MO_No.Trim() == filterParam.MO_No.Trim());
}
return(await packingSearch.ToListAsync());
}
public async Task<PagedList<IntegrationInputModel>> SearchIntegrationInput(PaginationParams param, FilterPackingListParam filterparam)
{
var pred_Packing_Lists = PredicateBuilder.New<WMSB_Packing_List>(true);
pred_Packing_Lists.And(x => x.Generated_QRCode.Trim() == "Y");
if (!String.IsNullOrEmpty(filterparam.MO_No)) {
pred_Packing_Lists.And(x => x.MO_No.Trim() == filterparam.MO_No.Trim());
}
if (filterparam.Supplier_ID != null && filterparam.Supplier_ID != "All") {
pred_Packing_Lists.And(x => x.Supplier_ID.Trim() == filterparam.Supplier_ID.Trim());
}
if (filterparam.From_Date != null && filterparam.To_Date != null) {
pred_Packing_Lists.And(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 packingLists = await _repoPackingList.FindAll(pred_Packing_Lists).ToListAsync();
var conn = await _database.CreateConnectionAsync();
var qrCodeMains = conn.Query<WMSB_QRCode_Main>("Select * from WMSB_QRCode_Main where Is_Scanned = 'N'").ToList();
var qrCodeMainDetail = conn.Query<WMSB_QRCode_Detail>("Select * from WMSB_QRCode_Detail").ToList();
var data = (from a in packingLists
join b in qrCodeMains
on a.Receive_No.Trim() equals b.Receive_No.Trim()
join c in qrCodeMainDetail on b.QRCode_ID.Trim() equals c.QRCode_ID.Trim()
select new IntegrationInputModel()
{
Receive_No = a.Receive_No,
QRCode_Version = b.QRCode_Version,
QRCode_ID = b.QRCode_ID,
MO_No = a.MO_No,
Purchase_No = a.Purchase_No,
MO_Seq = a.MO_Seq,
Material_ID = a.Material_ID,
Material_Name = a.Material_Name,
Supplier_ID = a.Supplier_ID,
Supplier_Name = a.Supplier_Name,
Receive_Qty = c.Qty
}).GroupBy(x => x.QRCode_ID).Select(z => new IntegrationInputModel()
{
Receive_No = z.FirstOrDefault().Receive_No,
QRCode_Version = z.FirstOrDefault().QRCode_Version,
Purchase_No = z.FirstOrDefault().Purchase_No,
QRCode_ID = z.FirstOrDefault().QRCode_ID,
MO_No = z.FirstOrDefault().MO_No,
MO_Seq = z.FirstOrDefault().MO_Seq,
Material_ID = z.FirstOrDefault().Material_ID,
Material_Name = z.FirstOrDefault().Material_Name,
Supplier_ID = z.FirstOrDefault().Supplier_ID,
Supplier_Name = z.FirstOrDefault().Supplier_Name,
Receive_Qty = z.Sum(k => k.Receive_Qty)
}).ToList();
var receiveNos = data.Select(x => x.Receive_No.Trim()).ToList();
var packingListDetails = conn
.Query<WMSB_PackingList_Detail>("Select * from WMSB_PackingList_Detail where Receive_No IN @receiveNos", new {receiveNos = receiveNos})
.ToList();
foreach (var item in data)
{
item.PackingListDetailItem = packingListDetails.Where(x => x.Receive_No.Trim() == item.Receive_No.Trim()).ToList();
}
return PagedList<IntegrationInputModel>.Create(data, param.PageNumber, param.PageSize,false);
}
public async Task <PagedList <WMSB_Packing_List> > Search(PaginationParams param, FilterPackingListParam filterParam)
{
var pred_Packing_List = PredicateBuilder.New <WMSB_Packing_List>(true);
pred_Packing_List.And(x => x.Generated_QRCode.Trim() == "N");
if (filterParam.From_Date != null && filterParam.To_Date != null)
{
pred_Packing_List.And(x => x.Receive_Date >= DateTime.Parse(filterParam.From_Date + " 00:00:00.000") &&
x.Receive_Date <= DateTime.Parse(filterParam.To_Date + " 23:59:59.000"));
}
if (!String.IsNullOrEmpty(filterParam.MO_No))
{
pred_Packing_List.And(x => x.MO_No.Trim() == filterParam.MO_No.Trim());
}
if (filterParam.Supplier_ID != "All" && !String.IsNullOrEmpty(filterParam.Supplier_ID))
{
pred_Packing_List.And(x => x.Supplier_ID.Trim() == filterParam.Supplier_ID.Trim());
}
var data = _repoPackingList.FindAll(pred_Packing_List);
return(await PagedList <WMSB_Packing_List> .CreateAsync(data, param.PageNumber, param.PageSize, false));
}
public async Task <IActionResult> SearchIntegrationInput([FromQuery] PaginationParams param, FilterPackingListParam filterparam)
{
var result = await _service.SearchIntegrationInput(param, filterparam);
Response.AddPagination(result.CurrentPage, result.PageSize, result.TotalCount, result.TotalPages);
return(Ok(result));
}
public async Task <IActionResult> SearchNotPagination(FilterPackingListParam filterParam)
{
var lists = await _service.SearchNotPagination(filterParam);
return(Ok(lists));
}
public async Task <PagedList <WMSB_Packing_List> > SearchViewModel(PaginationParams param, FilterPackingListParam filterParam)
{
var packingSearch = _repoPackingList.GetAll();
if (filterParam.From_Date != null && filterParam.To_Date != null)
{
packingSearch = packingSearch.
Where(x => x.Receive_Date >= DateTime.Parse(filterParam.From_Date + " 00:00:00.000") &&
x.Generated_QRCode.Trim() == "N" &&
x.Receive_Date <= DateTime.Parse(filterParam.To_Date + " 23:59:59.000")
);
}
if (filterParam.MO_No != null && filterParam.MO_No != string.Empty)
{
packingSearch = packingSearch.Where(x => x.MO_No.Trim() == filterParam.MO_No.Trim());
}
return(await PagedList <WMSB_Packing_List> .CreateAsync(packingSearch, param.PageNumber, param.PageSize));
}
