コード例 #1
0
        public ActionResult TmwTask()
        {
            DutyTEntities1 db = new DutyTEntities1();

            DateTime tom = DateTime.Today.AddDays(1);

            var tmwT = from t in db.Duties
                       where t.DutyDueDate == tom
                       select new TmwTask
            {
                Task = t,
            };

            return(View(tmwT));
        }
コード例 #2
0
        public ActionResult Due()
        {
            DutyTEntities1 db = new DutyTEntities1();

            var dueToday = from e in db.Users
                           join t in db.Duties
                           on e.DutyId equals t.DutyId
                           where t.DutyDueDate == DateTime.Today
                           select new TodayModel
            {
                Task     = t,
                Employee = e
            };

            return(View(dueToday));
        }
コード例 #3
0
        public ActionResult TodCompl()
        {
            DutyTEntities1 db = new DutyTEntities1();

            var compT = from e in db.Users
                        join t in db.Duties
                        on e.DutyId equals t.DutyId
                        where t.DutyCompletion == DateTime.Today
                        select new CompToday
            {
                Task     = t,
                Employee = e
            };

            return(View(compT));
        }