public ActionResult Detail(int Id) { var data = new TaskDepartmentViewModel(); var taskdata = itaskBusiness.GetTaskByDept(Id); if (taskdata != null) { data = (from task in db.Tasks join dept in db.Departments on task.departmentId equals dept.departmentId where dept.departmentId == Id /*&& task.Completed == 0*/ group task by task.Department.departmentname into g select new TaskDepartmentViewModel { departmentname = g.First().Department.departmentname, BudgetedHours = g.Sum(s => s.BudgetedHours), description = g.First().Department.description, created_on = g.First().Department.created_on, updated_on = g.First().Department.updated_on, departmentId = g.First().Department.departmentId }).FirstOrDefault(); } else { var Deptdata = idepartmentBusiness.GetById(Id); Mapper.Map(Deptdata, data); //data.departmentname = Deptdata.departmentname; } return(View(data)); }
public IActionResult bindSummary() { var taskdata = new List <TaskDepartmentViewModel>(); var departmensts = idepartmentBusiness.GetAll(); foreach (var department in departmensts) { var targetCompletion = db.Tasks.Where(w => w.departmentId == department.departmentId).FirstOrDefault(); var targetCreatedOn = db.Tasks.Where(w => w.departmentId == department.departmentId).FirstOrDefault(); if (targetCompletion != null && targetCreatedOn != null) { TimeSpan ts = targetCompletion.TargetCompletionDate - DateTime.Now; var weeks = Math.Round((ts).TotalDays / 7, 0); var days = Math.Round((ts).TotalDays % 7, 0); //var curruntDate = targetCompletion.TargetCompletionDate.AddDays(Math.Round((ts).TotalDays)).TimeOfDay; var hours = ts.Hours;// Math.Round((weeks)*24); var inCompleteHours = string.Format("{0} hours, {1} weeks, {2} days", hours, weeks, days); var taskdept = new TaskDepartmentViewModel { departmentname = department.departmentname, InCompleteHours = inCompleteHours, VisibleOnDashboard = department.VisibleOnDashboard ?? false, Color = department.Color }; taskdata.Add(taskdept); } else { var taskdept = new TaskDepartmentViewModel { departmentname = department.departmentname, VisibleOnDashboard = department.VisibleOnDashboard ?? false }; taskdata.Add(taskdept); } } //var data = (from task in db.Tasks // join dept in db.Departments on task.departmentId equals dept.departmentId // select new TaskDepartmentViewModel // { // departmentname = dept.departmentname // //BudgetedHours = g.Sum(s => s.BudgetedHours), // //description = g.First().Department.description, // //created_on = g.First().Department.created_on, // //updated_on = g.First().Department.updated_on // }).ToList(); ViewBag.data = taskdata; return(RedirectToAction("dashboard")); }