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();
}