コード例 #1
0
        public List <tblSchedule> GetOneoffSchedule(DateTime StartDate)
        {
            using (var context = new CeoContext())
            {
                var schedule = context.tblSchedules.Include(c => c.tblCustomer)
                               .Where(c => c.StartDate == StartDate)
                               .OrderBy(o => new { o.ScheduleID }).ThenByDescending(d => d.ScheduleID)
                               .ToList();

                return(schedule);
            }
        }
コード例 #2
0
        public List <tblSchedule> GetCustomersScheduleList()
        {
            using (var context = new CeoContext())
            {
                var schedule = context.tblSchedules.Include(c => c.tblCustomer)
                               .Take(500)
                               .OrderBy(o => new { o.ScheduleID }).ThenByDescending(d => d.ScheduleID)
                               .ToList();

                return(schedule);
            }
        }
コード例 #3
0
 public ProyectosController(CeoContext context)
 {
     _context = context;
 }