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);
}
