/// <summary>
/// This Method is for Get Regular Quantity Order.
/// </summary>
/// <returns>
/// List of Regular Quantity Order.
/// </returns>
public List <AmountOrderDTO> GetAmountCategoryOrdred()
{
List <AmountOrderDTO> lsorder = new List <AmountOrderDTO>();
try
{
var Reugular = _x3v6.ExecuteStoreQuery <AmountOrderDTO>(@"SELECT itm.TCLCOD_0 [Category],
cast(sum(sop.NETPRI_0 * soq.QTY_0) as float) [Amount]
FROM
PRODUCTION.SORDER so
INNER JOIN PRODUCTION.SORDERQ soq ON soq.SOHNUM_0 = so.SOHNUM_0
INNER JOIN PRODUCTION.SORDERP sop ON so.SOHNUM_0 = sop.SOHNUM_0 AND soq.SOPLIN_0 = sop.SOPLIN_0 AND sop.LINTYP_0 <> 7
INNER JOIN PRODUCTION.ITMMASTER itm ON itm.ITMREF_0 = soq.ITMREF_0
WHERE cast(soq.ORDDAT_0 as date)= cast(dateadd(d,0,getdate()) as date)
AND so.SOHTYP_0 IN ('SON','SOI','SOP')
GROUP BY itm.TCLCOD_0 ORDER BY [Amount];
").AsParallel().ToList();
if (Reugular.Count() > 0)
{
foreach (var item in Reugular)
{
AmountOrderDTO regularorder = (AmountOrderDTO)item;
lsorder.Add(regularorder);
}
}
}
catch (Exception)
{
}
return(lsorder);
}
public static List <AmountOrderDTO> RemoveLessThanZeroAmountOrder(this List <AmountOrderDTO> lsOrederamountDto)
{
List <AmountOrderDTO> _rerurn = new List <AmountOrderDTO>();
Double Total = lsOrederamountDto.ToTotalOrderAmount();
Int32 Limit = Convert.ToInt32(Total / 100);
foreach (var item in lsOrederamountDto)
{
if (item.Amount >= Limit)
{
AmountOrderDTO order = (AmountOrderDTO)item;
_rerurn.Add(order);
}
}
return(_rerurn);
}
