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