コード例 #1
0
        public ActionResult TimeByWeek(string dummy)
        {
            string    project  = Request.Form["Projects"];
            string    fromDate = Request.Form["fromDate"];
            WeekTasks taskData = new WeekTasks();

            if (string.IsNullOrEmpty(fromDate))
            {
                fromDate = DateTime.Now.ToString("MM/dd/yyyy");
            }
            this.taskService.GetWeekTasks(fromDate, taskData, project);
            ViewBag.Message = "Result from " + fromDate + " to " + Convert.ToDateTime(taskData.EndDate).ToString("MM/dd/yyyy ");

            ViewBag.Projects = this.GetProjects();
            return(View(taskData));
        }
コード例 #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="fromDate"></param>
        /// <param name="wtData"></param>
        /// <returns></returns>
        public void GetWeekTasks(string fromDate, WeekTasks wtData, string project)
        {
            List <Task> tasks = null;

            if (!string.IsNullOrEmpty(fromDate))
            {
                DateTime fromdt = Convert.ToDateTime(fromDate);
                DateTime todt   = Convert.ToDateTime(fromDate).AddDays(6);

                tasks = this.db.Tasks.Include("Project").Include("Employee").Include("WorkCodesActivity").Where(x => x.ExecutionDate >= fromdt && x.ExecutionDate <= todt).OrderBy(x => x.ExecutionDate).ToList();

                if (tasks != null)
                {
                    if (!string.IsNullOrEmpty(project))
                    {
                        tasks = tasks.Where(x => x.Project.Name == project).ToList();
                    }
                }

                var wt = from f in tasks
                         group f by new { f.EmployeeId }

                into myGroup
                    select new
                {
                    myGroup.Key.EmployeeId,
                    EmployeeFirstName = myGroup.Select(h => h.Employee.FirstName).FirstOrDefault(),
                    EmployeeLastName  = myGroup.Select(h => h.Employee.LastName).FirstOrDefault(),
                    Date1             = myGroup.Where(f => f.ExecutionDate == fromdt).Sum(c => c.Hours),
                    Date2             = myGroup.Where(f => f.ExecutionDate == fromdt.AddDays(1)).Sum(c => c.Hours),
                    Date3             = myGroup.Where(f => f.ExecutionDate == fromdt.AddDays(2)).Sum(c => c.Hours),
                    Date4             = myGroup.Where(f => f.ExecutionDate == fromdt.AddDays(3)).Sum(c => c.Hours),
                    Date5             = myGroup.Where(f => f.ExecutionDate == fromdt.AddDays(4)).Sum(c => c.Hours),
                    Date6             = myGroup.Where(f => f.ExecutionDate == fromdt.AddDays(5)).Sum(c => c.Hours),
                    Date7             = myGroup.Where(f => f.ExecutionDate == fromdt.AddDays(6)).Sum(c => c.Hours),
                    TotalHours        = myGroup.Sum(c => c.Hours)
                };


                wtData.StartDate = fromdt;
                wtData.EndDate   = todt;
                if (wt != null)
                {
                    DataTable dt = new DataTable();
                    dt.Columns.Add("EmployeeId");
                    dt.Columns.Add("FirstName");
                    dt.Columns.Add("LastName");
                    dt.Columns.Add(fromdt.ToString("MM/dd/yyyy"), typeof(decimal));
                    dt.Columns.Add(fromdt.AddDays(1).ToString("MM/dd/yyyy"), typeof(decimal));
                    dt.Columns.Add(fromdt.AddDays(2).ToString("MM/dd/yyyy"), typeof(decimal));
                    dt.Columns.Add(fromdt.AddDays(3).ToString("MM/dd/yyyy"), typeof(decimal));
                    dt.Columns.Add(fromdt.AddDays(4).ToString("MM/dd/yyyy"), typeof(decimal));
                    dt.Columns.Add(fromdt.AddDays(5).ToString("MM/dd/yyyy"), typeof(decimal));
                    dt.Columns.Add(fromdt.AddDays(6).ToString("MM/dd/yyyy"), typeof(decimal));
                    dt.Columns.Add("Total Hours", typeof(decimal));
                    DataRow row = null;
                    foreach (var rowObj in wt)
                    {
                        row = dt.NewRow();
                        dt.Rows.Add(rowObj.EmployeeId
                                    , rowObj.EmployeeFirstName
                                    , rowObj.EmployeeLastName
                                    , rowObj.Date1
                                    , rowObj.Date2
                                    , rowObj.Date3
                                    , rowObj.Date4
                                    , rowObj.Date5
                                    , rowObj.Date6
                                    , rowObj.Date7
                                    , rowObj.TotalHours);
                    }
                    wtData.ReportData = dt;
                }
            }
        }