Exemple #1
0
        public ActionResult TaskSchedule(int page = 1, string action = "", FormCollection collection = null, int id = 0)
        {
            conn.OpenConnection();
            string    sql_1 = "SELECT * FROM [Task] WHERE ID =" + id;
            DataTable dt    = conn.Detail(sql_1);

            ViewBag.Data = dt;

            //string sql_id = "SELECT [User].UserName FROM [User] INNER JOIN [TaskSchedule] ON [User].ID = [TaskSchedule].PublisherID";
            //DataTable dts = conn.Detail(sql_id);
            //string PublisherUserName = dts.Rows[0][0].ToString();

            List <TaskSchedule> taskschedules = new List <TaskSchedule>();
            string  sql = "SELECT [TaskSchedule].*,[User].UserName FROM [TaskSchedule] INNER JOIN [Task] ON [Task].ID = [TaskSchedule].TaskID INNER JOIN [User] ON [TaskSchedule].PublisherID = [User].ID WHERE [TaskSchedule].TaskID = " + id + " ORDER BY [TaskSchedule].ID DESC ";
            DataSet ds  = conn.Ds_List(sql);

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                taskschedules.Add(new TaskSchedule
                {
                    ID                = int.Parse(item["ID"].ToString()),
                    Content           = item["Content"].ToString(),
                    TaskID            = int.Parse(item["TaskID"].ToString()),
                    PublisherID       = int.Parse(item["PublisherID"].ToString()),
                    PublisherUserName = item["UserName"].ToString(),
                    CreateTime        = item["CreateTime"].ToString(),
                    LastEditTime      = item["LastEditTime"].ToString(),
                    IsValid           = bool.Parse(item["IsValid"].ToString()),
                });
            }
            conn.CloseConnection();
            TaskScheduleViewModel TaskScheduleViewModel = new TaskScheduleViewModel()
            {
                TaskSchedules = taskschedules.Skip((page - 1) * PageSize).Take(PageSize).ToList(),
                PagingInfo    = new PagingInfo {
                    CurrentPage = page, TotalItmes = taskschedules.Count, ItemsPerPage = PageSize
                }
            };

            return(View(TaskScheduleViewModel));
        }
Exemple #2
0
        public ICollection <TaskScheduleViewModel> GetTaskSchedule()
        {
            var models = new List <TaskScheduleViewModel>();
            var list   = _appDbContext.Tasks.Where(x => x.DueDate > DateTime.Now && x.Active)
                         .Include(x => x.TaskRotation)
                         .OrderBy(x => x.DueDate)
                         .ToList();

            foreach (var item in list)
            {
                var model = new TaskScheduleViewModel
                {
                    Id            = item.TaskId,
                    DueDate       = item.DueDate,
                    TaskName      = item.TaskName,
                    TimeRemaining = GetTimeDifference(item.DueDate)
                };
                models.Add(model);
            }

            return(models);
        }