public JsonResult Update(int targetID, int officeID, string dueDate, int bookingTargets, float fundRaisingAmount, float gsbAmount, int arrivalTargets) { var targetManager = new DataAccess.TargetManager(); var dueDateDateTime = Convert.ToDateTime(dueDate); var status = targetManager.Update(targetID, officeID, dueDateDateTime, bookingTargets, fundRaisingAmount, gsbAmount, arrivalTargets); return Json(status); }
public PartialViewResult Edit(int id) { var officeManager = new DataAccess.OfficeMananer(); ViewData["Offices"] = officeManager.GetOffices(IsAdmin ? 0 : UserDetail.UserId); var targetManager = new DataAccess.TargetManager(); var target = targetManager.GetTarget(id); return PartialView(target); }
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 GetTasks() { var targetManager = new DataAccess.TargetManager(); var targetList = targetManager.GetTargets(); var targets = targetList.Select(model => new { ID = model.TargetId, OfficeName = model.Office.Name, DueDate = model.DueDate.ToString("MMM dd,yyyy"), Booking = model.Booking, FundRaising = model.FundRaising, GSB = model.GSB, Arrivals = model.Arrivals }).ToList(); return Json(new { data = targets }); }
public JsonResult GetGSBTargets(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.GetGSBTargets(offices, startDateTime, endDateTime); var achievedTargets = audienceManager.GetGSBTargetsAchived(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); }
// Fund Raising Target For CurrentYear public object GetFundRaisingTargetsChart(int id, DateTime startDate, DateTime endDate) { var dataSeries = new List<DataModel.Modal.ChartSeries>(); var targetManager = new DataAccess.TargetManager(); var audienceManager = new DataAccess.AudienceManager(); var targets = targetManager.GetFundingTargets(new List<int> { id }, startDate, endDate); var achievedTargets = audienceManager.GetFundingTargetsAchived(new List<int> { id }, startDate, endDate); dataSeries.Add(targets); dataSeries.Add(achievedTargets); var totalTargets = targets.data.Sum(model => model.y); var totalAchievedTargets = achievedTargets.data.Sum(model => model.y); return new { TotalTarget = totalTargets, TotalTargetAchieved = totalAchievedTargets, AchivedTarget = 0, ChartData = dataSeries }; }
public JsonResult Delete(int id) { var targetManager = new DataAccess.TargetManager(); var status = targetManager.Delete(id); return Json(status); }