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