public ActionResult FilterCreditRating(string creditRating)
{
cusList = new List <CustomerModel>();
using (var db = new hfShopEntities())
{
var query = from b in db.TEST_Customer
orderby b.ID
where b.CreditRating == creditRating //|| creditRt == null || creditRt == String.Empty
select b;
foreach (var item in query)
{
CustomerModel cm = new CustomerModel();
cm.Month = item.Month;
cm.EndUser = item.EndUser;
cm.AverageStock = Math.Round((double)item.AverageStock, 0);
cm.TurnoverRate = item.TurnoverRate;
cm.NumOfOverdue = item.NumOfOverdue;
cm.SlowSalesRate = item.SlowSalesRate;
cm.ReturnRate = item.ReturnRate;
cm.BreakageRate = item.BreakageRate;
cm.MonCumlShipQty = Math.Round((double)item.MonCumlShipQty, 0);
cm.UnitPrice = item.UnitPrice;
cm.MonCumlShipAmt = Math.Round((decimal)item.MonCumlShipAmt, 0);
cm.CreditRating = item.CreditRating;
cm.CanRaiseCapital = item.CanRaiseCapital;
cm.CreditScore = cm.CanRaiseCapital.Equals("Y") ? Math.Round((((double)(GetAvgStockScore((double)cm.AverageStock / 10000) + GetTurnoverRateScore((double)cm.TurnoverRate) +
GetNumOfOverdueScore((double)cm.NumOfOverdue) + GetSlowSalesRateScore((double)cm.SlowSalesRate) +
GetReturnRateScore((double)cm.ReturnRate) + GetBreakageRateScore((double)cm.BreakageRate))) + GetThirdPartyCreditScore(cm.CreditRating)) / 2, 2) : 0;
cm.CapitalAmt = cm.CanRaiseCapital.Equals("Y") ? Math.Round(((decimal)cm.MonCumlShipAmt * (decimal)cm.CreditScore) / 100, 0) : 0;
cm.CapExpRate = cm.CanRaiseCapital.Equals("Y") ? Math.Round((double)((baseRate + floatRate) / (cm.CreditScore / 100)), 4) : 0;
cm.ID = item.ID;
cusList.Add(cm);
}
ViewBag.CreditRating = (from c in db.TEST_Customer
orderby c.CreditRating
select c.CreditRating).Distinct().ToList();
}
return(View("Customer", cusList));
}
// GET: Test
public ActionResult Customer()
{
cusList = new List <CustomerModel>();
using (var db = new hfShopEntities())
{
var query = from b in db.TEST_Customer
orderby b.ID
select b;
foreach (var item in query)
{
CustomerModel cm = new CustomerModel();
cm.Month = item.Month;
cm.EndUser = item.EndUser;
cm.AverageStock = Math.Round((double)item.AverageStock, 0);
cm.TurnoverRate = item.TurnoverRate;
cm.NumOfOverdue = item.NumOfOverdue;
cm.SlowSalesRate = item.SlowSalesRate;
cm.ReturnRate = item.ReturnRate;
cm.BreakageRate = item.BreakageRate;
cm.MonCumlShipQty = Math.Round((double)item.MonCumlShipQty, 0);
cm.UnitPrice = item.UnitPrice;
cm.MonCumlShipAmt = Math.Round((decimal)item.MonCumlShipAmt, 0);
cm.CreditRating = item.CreditRating;
cm.CanRaiseCapital = item.CanRaiseCapital;
cm.ID = item.ID;
cusList.Add(cm);
}
ViewBag.CreditRating = (from c in db.TEST_Customer
orderby c.CreditRating
select c.CreditRating).Distinct().ToList();
}
return(View(cusList));
}
