Beispiel #1
0
        public ActionResult WorkLog(WorkLogViewModel model)
        {
            //string selectedDate = Request.QueryString["month"];
            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            if (!string.IsNullOrWhiteSpace(model.Month))
            {
                string[] arr = model.Month.Split("/".ToArray(), StringSplitOptions.RemoveEmptyEntries);
                int      yearTemp, monthTemp;
                if (int.TryParse(arr[0], out monthTemp) && int.TryParse(arr[1], out yearTemp) && monthTemp > 0 && yearTemp > 1900)
                {
                    year  = yearTemp;
                    month = monthTemp;
                }
            }

            if (CurrentUser.IsManager)
            {
                model = WorkLogService.GetAllUserWorkLogs(year, month, model.SortField, model.SortDirection, model.Filter);
            }
            else
            {
                model = WorkLogService.GetWorkLogs(CurrentUser.Id, year, month);
            }
            return(View(model));
        }
Beispiel #2
0
        public ActionResult WorkLog()
        {
            //DateTime startDate = DateTime.Now.Date;
            //DateTime endDate = DateTime.Now.Date;

            //if (Request.QueryString["startDate"] != null)
            //    startDate = DateTime.ParseExact(Request.QueryString["startDate"].ToString(), "dd/MM/yyyy",
            //                           System.Globalization.CultureInfo.InvariantCulture);

            //if (Request.QueryString["endDate"] != null)
            //    endDate = DateTime.ParseExact(Request.QueryString["endDate"].ToString(), "dd/MM/yyyy",
            //                           System.Globalization.CultureInfo.InvariantCulture);

            WorkLogViewModel vm = new WorkLogViewModel();

            return(View(vm));
        }
Beispiel #3
0
        public ActionResult GetWorkLog()
        {
            DateTime startDate = DateTime.Now.Date;
            DateTime endDate   = DateTime.Now.Date;

            if (Request.QueryString["startDate"] != null)
            {
                startDate = DateTime.ParseExact(Request.QueryString["startDate"].ToString(), "dd/MM/yyyy",
                                                System.Globalization.CultureInfo.InvariantCulture);
            }

            if (Request.QueryString["endDate"] != null)
            {
                endDate = DateTime.ParseExact(Request.QueryString["endDate"].ToString(), "dd/MM/yyyy",
                                              System.Globalization.CultureInfo.InvariantCulture);
            }


            WorkLogViewModel vm = new WorkLogViewModel();
            var worklog         = _context.tblWorkLogs.ToList();

            worklog.Where(x => x.StartTime <= startDate || x.StartTime >= endDate)
            .ToList().ForEach(c => vm.WorkLogs.Add(new WorkLogModel()
            {
                WorkLogId   = c.WorkLogId,
                StartTime   = c.StartTime.Value.ToString("dd/MM/yyyy HH:mm"),
                EndTime     = c.EndTime.Value.ToString("dd/MM/yyyy HH:mm"),
                Duration    = (c.Duration / 60),
                TaskId      = c.TaskId,
                Unit        = c.Unit,
                AverageTime = c.AverageTime,
                TaskName    = _context.tblTasks.FirstOrDefault(x => x.TaskId == c.TaskId).TaskName,
                ProjectId   = _context.tblTasks.FirstOrDefault(x => x.TaskId == c.TaskId).ProjectId,
                ProjectName = _context.tblProjects.FirstOrDefault(v => v.ProjectId == _context.tblTasks.FirstOrDefault(x => x.TaskId == c.TaskId).ProjectId).ProjectName
            }));

            var list = from s in vm.WorkLogs
                       select s;

            var json = Json(new
            {
                data = list.ToList()
            }, JsonRequestBehavior.AllowGet);

            return(json);
        }
        public ActionResult Index()
        {
            WorkLogViewModel vm = new WorkLogViewModel();

            _context.tblWorkLogs.ToList().ForEach(c => vm.WorkLogs.Add(new WorkLogModel()
            {
                WorkLogId   = c.WorkLogId,
                StartTime   = c.StartTime.Value.ToString("dd/MM/yyyy HH:mm"),
                EndTime     = c.EndTime.Value.ToString("dd/MM/yyyy HH:mm"),
                Duration    = (c.Duration / 60),
                TaskId      = c.TaskId,
                Unit        = c.Unit,
                AverageTime = c.AverageTime,
                TaskName    = _context.tblTasks.FirstOrDefault(x => x.TaskId == c.TaskId).TaskName,
                ProjectId   = _context.tblTasks.FirstOrDefault(x => x.TaskId == c.TaskId).ProjectId,
                ProjectName = _context.tblProjects.FirstOrDefault(v => v.ProjectId == _context.tblTasks.FirstOrDefault(x => x.TaskId == c.TaskId).ProjectId).ProjectName
            }));
            return(View(vm));
        }