public static Teacher LoginUser(string username, string password) { var db = new DnevnikEntities(); var user = db.Teachers.Include("Class").Where(t => t.Email == username && t.Password == password).FirstOrDefault(); return(user); }
public static List <Subject> GetSubjects() { var db = new DnevnikEntities(); var subjects = db.Subjects.ToList(); db.Dispose(); return(subjects); }
public static Teacher GetUserByEmail(string email) { var db = new DnevnikEntities(); var t = db.Teachers.Where(a => a.Email == email).FirstOrDefault(); db.Dispose(); return(t); }
public static Teacher GetCurrentUser(int id) { var dbContext = new DnevnikEntities(); var teacher = dbContext.Teachers.Where(t => t.Id == id).FirstOrDefault(); dbContext.Dispose(); return(teacher); }
public static void DeleteAllGrades() { using (var db = new DnevnikEntities()) { db.Grades.RemoveRange(db.Grades.Where(x => 1 == 1)); db.SaveChanges(); } }
public static int GetClassId(int number, int letter) { using (var db = new DnevnikEntities()) { int id = db.Classes.Where(c => c.Number == number && c.Letter == letter).Select(c => c.Id).FirstOrDefault(); return(id); } }
public static void UpdateTeacherSettings(Teacher t) { using (var db = new DnevnikEntities()) { db.Teachers.Add(t); var entry = db.Entry(t); entry.State = EntityState.Modified; entry.Property(e => e.IsAdmin).IsModified = false; entry.Property(e => e.Class_id).IsModified = false; db.SaveChanges(); } }
public static List <SingleClass> GetClasses() { var db = new DnevnikEntities(); var classes = db.Classes.Where(c => c.Id > 1).OrderBy(c => c.Number).ThenBy(c => c.Letter); List <SingleClass> classesList = new List <SingleClass>(); foreach (var item in classes) { SingleClass c = new SingleClass() { Id = item.Id, Number = item.Number, Letter = ConvertClassLetter(item.Letter) }; classesList.Add(c); } db.Dispose(); return(classesList); }
public static List <SubjectVM> GetClassSubjects(int class_id) { var db = new DnevnikEntities(); var subjects = db.Schedules .Where(s => s.Class_id == class_id) .GroupBy(s => new { Id = s.Subject.Id, Title = s.Subject.Title, IsZip = s.Subject.IsZip, Semester = s.Semester }) .Select(o => new SubjectVM { Id = o.Key.Id, Title = o.Key.Title, IsZip = o.Key.IsZip, Semester = o.Key.Semester }) .ToList(); db.Dispose(); return(subjects); }