public async Task <IActionResult> GetCostComination(PendingOrderItemsDto items)
{
var combin = await _context.TransCostHeader
.Where(x => x.CustomerId == items.CustomerId && x.ArticleId == items.ArticleId &&
x.ColorId == items.ColorId && x.SizeId == items.SizeId)
.Join(_context.MstrCombination, h => h.CombinId, c => c.AutoId
, (h, c) =>
new
{
CombinId = c.AutoId,
Combination = c.Combination
}).ToListAsync();
return(Ok(combin));
}
public async Task <IEnumerable <PendingDelivOrderDto> > GetPendDelivOrderAsync(PendingOrderItemsDto items)
{
IEnumerable <PendingDelivOrderDto> PendDelivList;
DynamicParameters para = new DynamicParameters();
para.Add("CombinId", items.CombinId);
para.Add("CustomerId", items.CustomerId);
para.Add("ArticleId", items.ArticleId);
para.Add("ColorId", items.ColorId);
para.Add("SizeId", items.SizeId);
PendDelivList = await DbConnection.QueryAsync <PendingDelivOrderDto>("spTransJobCardGetPendingOrders", para
, commandType : CommandType.StoredProcedure);
return(PendDelivList);
}
public async Task <IActionResult> GetPendDelivOrder(PendingOrderItemsDto items)
{
var pendOrders = await _salesRepository.GetPendDelivOrderAsync(items);
return(Ok(pendOrders));
}