public int getQty_sumByYearAndShortItemNo(int year, int shortItemNo)
{
int result = 0;
salesHist = new F42071Repository();
var resultEntity = (from s in salesHist.GetAll(x => x.PeriodYear.Equals(year) && x.ShortItemNo.Equals(shortItemNo))
group s by s.ShortItemNo into groupsales
select new {
shortItemNo=groupsales.Key,
Qty_sum01=groupsales.Sum(x=>x.TotQty01),
Qty_sum02 = groupsales.Sum(x => x.TotQty02),
Qty_sum03 = groupsales.Sum(x => x.TotQty03),
Qty_sum04 = groupsales.Sum(x => x.TotQty04),
Qty_sum05 = groupsales.Sum(x => x.TotQty05),
Qty_sum06 = groupsales.Sum(x => x.TotQty06),
Qty_sum07 = groupsales.Sum(x => x.TotQty07),
Qty_sum08 = groupsales.Sum(x => x.TotQty08),
Qty_sum09 = groupsales.Sum(x => x.TotQty09),
Qty_sum10 = groupsales.Sum(x => x.TotQty10),
Qty_sum11 = groupsales.Sum(x => x.TotQty11),
Qty_sum12 = groupsales.Sum(x => x.TotQty12),
}).FirstOrDefault();
if (resultEntity != null)
result = resultEntity.Qty_sum01 + resultEntity.Qty_sum02 + resultEntity.Qty_sum03 + resultEntity.Qty_sum04 + resultEntity.Qty_sum05
+ resultEntity.Qty_sum06 + resultEntity.Qty_sum07 + resultEntity.Qty_sum08 + resultEntity.Qty_sum09 + resultEntity.Qty_sum10
+ resultEntity.Qty_sum11 + resultEntity.Qty_sum12;
return result;
}
public IList<IncreaseCreditLimitModel> getInfoIncreaseCrLimit(int month, int year,List<string> CustomerIDList)
{
IList<IncreaseCreditLimitModel> result = new List<IncreaseCreditLimitModel>();
objF42071 = new F42071Repository();
objF03021 = new F03021Repository();
objF03020 = new F03020Repository();
decimal TotSales = 0;
decimal TotRec = 0;
foreach (string custID in CustomerIDList)
{
ARTrackingListModel ARData = new ARTrackingListModel();
ARData = getARTrackingByCustomerID(month, year, custID);
IQueryable<F03020> objARRec_H = objF03020.GetQuery();
var Totdata = from sh in objF42071.GetAll().Where(x => x.CustomerID.Equals(custID) && x.PeriodYear == DateTime.Today.Year)
group sh by new { sh.CustomerID } into g
select new
{
customerID = g.Key.CustomerID,
TotSales = g.Sum(x => x.TotCost01 + x.TotCost02 + x.TotCost03 + x.TotCost04 + x.TotCost05 + x.TotCost06
+ x.TotCost07 + x.TotCost08 + x.TotCost09 + x.TotCost10 + x.TotCost11 + x.TotCost12)
};
//objARRec_H = objARRec_H.Where(x => x.AdvReceipt.Equals("N"));
objARRec_H = objARRec_H.Where(x => x.CustomerID.Equals(custID));
var ARReceipt = from h in objARRec_H.AsEnumerable()
where h.CustomerID.Equals(custID) && h.ReceiptDate.Year == DateTime.Today.Year
group h by new { h.CustomerID } into g
select new
{
CustomerID = g.Key.CustomerID,
TotReceiptAmtC = g.Sum(x => x.ReceiptAmt) + g.Sum(x => x.WriteOffAmt),
TotReceiptAmtLocal = g.Sum(x => x.ReceiptAmtLocal) + g.Sum(x => x.WriteOffAmtLocal)
};
if (Totdata.Count() > 0)
TotSales = Totdata.FirstOrDefault().TotSales;
else
TotSales = 0;
if (ARReceipt.Count() > 0)
TotRec = ARReceipt.FirstOrDefault().TotReceiptAmtLocal;
else
TotRec = 0;
IncreaseCreditLimitModel ICL = new IncreaseCreditLimitModel();
ICL.CustomerID = ARData.CustomerID;
ICL.CustomerName = ARData.CustomerName;
ICL.CreditLimit = ARData.CreditLimit;
ICL.CreditTerm = ARData.PaymentABC;
ICL.TotalOutstanding = ARData.TotOutstanding;
ICL.Over90 = ARData.Over90;
ICL.Over120 = ARData.Over120;
ICL.PTerm = ARData.PTerm;
ICL.TotalSales = TotSales;
ICL.TotalReceipt = TotRec;
ICL.LastReceiptDate = ARData.LastReceiptDate;
result.Add(ICL);
}
return result;
}
