public JsonResult GetTargetData(string valueVolumne) { List <object> lstData = new List <object>(); List <decimal> dataList = new List <decimal>(); try { bool IsValue = false; if (valueVolumne == "1") { IsValue = true; } var UserSession = (CustomerDetail)Session["ChitaleUser"]; DashboardTarget objDashboardTarget = new DashboardTarget(); objDashboardTarget = CDR.GetTargetData(UserSession.CustomerId, IsValue); dataList.Add(objDashboardTarget.TargetValueWise); dataList.Add(objDashboardTarget.AchiveValueWise); dataList.Add(objDashboardTarget.TargetVolumeWise); dataList.Add(objDashboardTarget.AchiveVolumeWise); } catch (Exception ex) { newexception.AddException(ex); } return(new JsonResult() { Data = dataList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue }); }
public DashboardTarget GetTargetData(string CustomerId, bool IsValue) { DashboardTarget objDashboardTarget = new DashboardTarget(); List <TargetMaster> objTargetMaster = new List <TargetMaster>(); using (var context = new ChitaleDBContext()) { objTargetMaster = context.TargetMasters.Where(x => x.CustomerId == CustomerId && x.TargetFromDate.Value.Month == DateTime.Today.Month && x.TargetFromDate.Value.Year == DateTime.Today.Year).ToList(); if (objTargetMaster != null) { if (IsValue) { objDashboardTarget.TargetValueWise = (decimal)objTargetMaster.Sum(x => x.TargetProductAmt); objDashboardTarget.AchiveValueWise = 0; objDashboardTarget.TargetVolumeWise = 0; objDashboardTarget.AchiveVolumeWise = 0; } else { objDashboardTarget.TargetVolumeWise = (decimal)objTargetMaster.Sum(x => x.TargetProductVolume); objDashboardTarget.AchiveVolumeWise = 0; objDashboardTarget.TargetValueWise = 0; objDashboardTarget.AchiveValueWise = 0; } } } return(objDashboardTarget); }