public JsonResult GetDashboardLostOppData(string profileFlag)
{
List <decimal> dataList = new List <decimal>();
try
{
bool IsBTD = false;
if (profileFlag == "1")
{
IsBTD = true;
}
var UserSession = (CustomerDetail)Session["ChitaleUser"];
DashboardLostOpp objDashboardLostOpp = new DashboardLostOpp();
objDashboardLostOpp = CDR.GetDashboardLostOppData(UserSession.CustomerId, IsBTD);
dataList.Add(objDashboardLostOpp.LateOrder);
dataList.Add(objDashboardLostOpp.CancelOrder);
dataList.Add(objDashboardLostOpp.TgtVsAch);
//dataList.Add(objDashboardLostOpp.SCMOrder);
var lstData = string.Join(" ", dataList);
}
catch (Exception ex)
{
newexception.AddException(ex);
}
return(new JsonResult()
{
Data = dataList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public DashboardLostOpp GetDashboardLostOppData(string CustomerId, bool IsBTD)
{
DashboardLostOpp objDashboardLostOpp = new DashboardLostOpp();
List <TransactionMaster> objtransactionmaster = new List <TransactionMaster>();
using (var context = new ChitaleDBContext())
{
if (IsBTD)
{
objtransactionmaster = context.TransactionMasters.Where(x => x.CustomerId == CustomerId).ToList();
}
else
{
objtransactionmaster = context.TransactionMasters.Where(x => x.CustomerId == CustomerId && x.OrderDatetime.Value.Month == DateTime.Today.Month &&
x.OrderDatetime.Value.Year == DateTime.Today.Year).ToList();
}
if (objtransactionmaster != null)
{
objDashboardLostOpp.LateOrder = (decimal)objtransactionmaster.Where(x => x.TxnType == "Purchase").Sum(x => x.PenaltyPoints);
objDashboardLostOpp.CancelOrder = (decimal)objtransactionmaster.Where(x => x.TxnType == "Cancel Order").Sum(x => x.PenaltyPoints);
objDashboardLostOpp.TgtVsAch = (decimal)objtransactionmaster.Where(x => x.TxnType == "tgt vs ach").Sum(x => x.PenaltyPoints);
objDashboardLostOpp.SCMOrder = (decimal)objtransactionmaster.Where(x => x.TxnType == "SCM").Sum(x => x.PenaltyPoints);
}
}
return(objDashboardLostOpp);
}
