public BaseController() { db = new SkeamSystemDb(); if (ConfigurationManager.ConnectionStrings["skeamsysdb"] != null) { _educationModel = db.Educations.ToList(); ViewBag.EducationModel = _educationModel; } }
public bool IsValid(string _username, string _password) { var db = new SkeamSystemDb(); if (db.Teachers.Any(u => (u.Username == _username && u.Password == _password))) { return true; } return false; }
/* * Dictionary<int, List<TableCellViewModel>> dic = new Dictionary<int,List<TableCellViewModel>>(); dic.Add(0, new List<TableCellViewModel>() { new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { Teacher = db.Teachers.FirstOrDefault(), SubjectName = "SD", Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } } }); dic.Add(1, new List<TableCellViewModel>() { new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, null, null, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } } }); dic.Add(2, new List<TableCellViewModel>() { new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { Teacher = db.Teachers.FirstOrDefault(), SubjectName = "SD", Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } } }); dic.Add(3, new List<TableCellViewModel>() { null, new TableCellViewModel() { Teacher = db.Teachers.FirstOrDefault(), SubjectName = "SD", Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } }, new TableCellViewModel() { SubjectName = "SD", Teacher = db.Teachers.FirstOrDefault(), Room = new Room() { RoomName = "A1.1" } } }); */ public static Dictionary<int, List<TableCellViewModel>> buildScheme(DateTime startDate, Scheme scheme) { SkeamSystemDb db = new SkeamSystemDb(); Dictionary<int, List<TableCellViewModel>> dic = new Dictionary<int, List<TableCellViewModel>>(); startDate = CalculateStartDate(startDate); DateTime endDate = startDate.AddDays(4); IEnumerable<LessonBlock> blocks = scheme.LessonBlocks.Where(l => l.Date >= startDate && l.Date <= endDate); foreach (var block in blocks) { int key = block.BlockNumber; if (dic.ContainsKey(key)) { List<TableCellViewModel> cells = dic[key]; cells[((int)block.Date.Date.DayOfWeek) - 1] = new TableCellViewModel() { BlockNumber = block.BlockNumber, Room = block.Room, SubjectName = block.Subject.Name, Teacher = block.Teacher }; dic[key] = cells; } else { List<TableCellViewModel> cells = new List<TableCellViewModel>() { null, null, null, null, null }; cells[((int)block.Date.Date.DayOfWeek) - 1] = new TableCellViewModel() { BlockNumber = block.BlockNumber, Room = block.Room, SubjectName = block.Subject.Name, Teacher = block.Teacher }; dic.Add(key, cells); } } return dic; }
public HomeController() { _db = new SkeamSystemDb(); }