public int GetCursNumber(string materie, string mail) { int index = 0; using (var db = new EducatieIncluzivaDBContext()) { var rr = new EduIncluziva.Metrics.ResourcesRepository(); var teach = rr.GetProfesoriByMail(mail); var curs = from p in db.Courses where p.ProfesorId == teach.UserId select p; foreach (var c in curs) { if (c.Nume.Equals(materie)) { break; } else { index++; } } } return(index); }
public List <Lesson> GetAllLessons(string mail, string materie) { List <Lesson> myList = new List <Lesson>(); try { using (var db = new EducatieIncluzivaDBContext()) { var rr = new EduIncluziva.Metrics.ResourcesRepository(); var teach = rr.GetProfesoriByMail(mail); var curs = (from p in db.Courses where p.Nume.Equals(materie) && p.ProfesorId == teach.UserId select p).FirstOrDefault(); var lectii = from p in db.Lessons where p.ProfesorOwner == teach select p; var b = db.Lessons.ToList(); foreach (Lesson c in b) { if (c.ProfesorOwnerId == teach.UserId && c.CourseId == curs.CourseId) { myList.Add(c); } } return(myList); } } catch (Exception exc) { throw exc; } }