public object GetArrivalTargets(int id, DateTime startDate, DateTime endDate)
 {
     var targetManager = new DataAccess.TargetManager();
     var audienceManager = new DataAccess.AudienceManager();
     var targets = targetManager.GetArrivalTargets(new List<int> { id }, startDate, endDate);
     var achievedTargets = audienceManager.GetArrivalTargetsAchived(new List<int> { id }, startDate, endDate);
     var totalTargets = targets.data.Sum(model => model.y);
     var totalAchievedTargets = achievedTargets.data.Sum(model => model.y);
     return new { Total = totalTargets, ActTotal = totalAchievedTargets };
 }
 public JsonResult GetArrivalTargets(string startDate, string endDate)
 {
     var dataSeries = new List<object>();
     var targetManager = new DataAccess.TargetManager();
     var audienceManager = new DataAccess.AudienceManager();
     var offices = new DataAccess.OfficeMananer().GetOfficeIDs(IsAdmin ? 0 : UserDetail.UserId);
     var startDateTime = Convert.ToDateTime(startDate);
     var endDateTime = Convert.ToDateTime(endDate);
     var targets = targetManager.GetArrivalTargets(offices, startDateTime, endDateTime);
     var achievedTargets = audienceManager.GetArrivalTargetsAchived(offices, startDateTime, endDateTime);
     dataSeries.Add(targets);
     dataSeries.Add(achievedTargets);
     var totalTargets = targets.data.Sum(model => model.y);
     var totalAchievedTargets = achievedTargets.data.Sum(model => model.y);
     var chartWidgetData = new { TotalTarget = totalTargets, TotalTargetAchieved = totalAchievedTargets, AchivedTarget = 0, ChartData = dataSeries };
     return Json(chartWidgetData);
 }