internal UserDTO LogIn(string username, string password)
{
using (var context = new BackendContext())
{
var result = context.Users
.Include(s => s.Child).Include(s => s.Teacher)
.Where(s => s.UserName == username && s.Password == password)
.ToList();
//return result.Count != 0; //si es distinto de 0 true, al contrario false.
if (result.Count == 0)
{
return(null);
}
else
{
return(result[0].Teacher == null ?
new UserDTO()
{
IsTeacher = false,
UserName = result[0].UserName,
Password = result[0].Password,
Id = result[0].Id
}
: new UserDTO()
{
IsTeacher = true,
UserName = result[0].UserName,
Password = result[0].Password,
Id = result[0].Id
});
}
}
}
internal List <Report> RetriveByTeacher(int id)
{
List <Report> reports;
try
{
using (BackendContext context = new BackendContext())
{
reports = context.Teachers
.Where(t => t.Id == id)
.Include(t => t.TeachersClasrooms)
.ThenInclude(tc => tc.Classroom.ChildrenClassrooms)
.ThenInclude(cc => cc.Child.Reports)
.Select(t => t.TeachersClasrooms.Select(tc => tc.Classroom.ChildrenClassrooms.Select(cc => cc.Child.Reports)))
.SingleOrDefault()
.Aggregate((acc, ele) => acc.Concat(ele))
.Aggregate((acc, ele) => { acc.AddRange(ele); return(acc); })
.Distinct().ToList();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
return(reports);
}
internal void SaveChild(ChildDTO c)
{
using (BackendContext context = new BackendContext())
{
User user = new User()
{
UserName = c.UserName,
Password = c.Password,
};
context.Users.Add(user);
context.SaveChanges();
var id = context.Users.Where(e => e.UserName == c.UserName).First().Id;
Child child = new Child()
{
Id = id,
Surname = c.Surname,
Name = c.Name,
};
context.Children.Add(child);
context.SaveChanges();
}
}
internal bool AddClassroomToTeacher(int idteacher, int idclass)
{
try
{
using (BackendContext context = new BackendContext())
{
TeacherClassroom teacherClassroom;
teacherClassroom = new TeacherClassroom()
{
ClassroomId = idclass,
TeacherId = idteacher,
};
context.TeacherClassrooms.Add(teacherClassroom);
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
internal void Save(Report r)
{
BackendContext context = new BackendContext();
context.Reports.Add(r);
context.SaveChanges();
}
public List <ClassroomDTO> RetrieveClassrooms()
{
List <ClassroomDTO> classrooms;
try
{
using (var context = new BackendContext())
{
classrooms = context.Classrooms
.Select(c => new ClassroomDTO()
{
Id = c.Id,
Name = c.Name
})
.ToList();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
return(classrooms);
}
internal List <Child> getChildrenByClass(int id)
{
List <Child> children;
try
{
using (var context = new BackendContext())
{
children = context.Classrooms
.Where(t => t.Id == id)
.Include(t => t.ChildrenClassrooms)
.ThenInclude(tc => tc.Child)
.Select(t => t.ChildrenClassrooms.Select(cc => cc.Child))
.FirstOrDefault()
.ToList();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
return(children);
}
public List <ClassroomDTO> RetrieveByTeacher(int idTeacher)
{
var context = new BackendContext();
List <ClassroomDTO> classrooms;
try
{
classrooms = context.Teachers
.Where(t => t.Id == idTeacher)
.Include(t => t.TeachersClasrooms)
.ThenInclude(tc => tc.Classroom)
.Select(t => t.TeachersClasrooms.Select(tc => tc.Classroom))
.FirstOrDefault()
.Select(c => new ClassroomDTO()
{
Id = c.Id,
Name = c.Name
})
.ToList();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
return(classrooms);
}
internal void SaveClassroom(Classroom classroom)
{
using (BackendContext context = new BackendContext())
{
context.Classrooms.Add(classroom);
context.SaveChanges();
}
}
internal void Eliminar(ChildClassroom childClassroom)
{
using (BackendContext context = new BackendContext())
{
var child = context.ChildClassrooms
.Where(e => e.ChildId == childClassroom.ChildId && e.ClassroomId == childClassroom.ClassroomId)
.FirstOrDefault();
context.ChildClassrooms.Remove(child);
context.SaveChanges();
}
}
internal void AddClassroomToChild(int idchild, int idclass)
{
BackendContext context = new BackendContext();
ChildClassroom childClassroom = new ChildClassroom()
{
ClassroomId = idclass,
ChildId = idchild
};
context.ChildClassrooms.Add(childClassroom);
context.SaveChanges();
}
internal List <Report> RetrieveByChild(int id)
{
List <Report> reports = new List <Report>();
using (BackendContext context = new BackendContext())
{
reports = context.Children
.Where(s => s.Id == id)
.Include(s => s.Reports)
.Select(s => s.Reports)
.FirstOrDefault();
}
return(reports);
}
internal void deleteChild(int childid)
{
using (BackendContext context = new BackendContext())
{
var child = context.Children
.Where(e => e.Id == childid)
.FirstOrDefault();
var user = context.Users
.Where(e => e.Id == childid)
.FirstOrDefault();
context.Children.Remove(child);
context.Users.Remove(user);
context.SaveChanges();
}
}
internal bool modifyChild(ChildDTO child)
{
try
{
using (BackendContext context = new BackendContext())
{
context.Users.Single(u => u.Id == child.Id).Password = child.Password;
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
internal bool modifyTeacher(TeacherDTO teacher)
{
try
{
using (BackendContext context = new BackendContext())
{
context.Users.Single(u => u.Id == teacher.Id).Password = teacher.Password;
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
internal List <TeacherDTO> RetrieveAllTeachers()
{
List <TeacherDTO> teachers = new List <TeacherDTO>();
using (BackendContext context = new BackendContext()) {
teachers = context.Users
.Include(s => s.Teacher)
.Where(s => s.Teacher != null)
.Select(s => new TeacherDTO()
{
Id = s.Id,
Name = s.Teacher.Name,
Surname = s.Teacher.Surname,
UserName = s.UserName,
Password = s.Password
}).ToList();
}
return(teachers);
}
internal List <ChildDTO> RetrieveAllChildren()
{
List <ChildDTO> children = new List <ChildDTO>();
using (BackendContext context = new BackendContext())
{
children = context.Users
.Include(s => s.Child)
.Where(s => s.Child != null)
.Select(s => new ChildDTO()
{
Id = s.Id,
Name = s.Child.Name,
Surname = s.Child.Surname,
UserName = s.UserName,
Password = s.Password
}).ToList();
}
return(children);
}
//funciones que devuelvan un teacher y un child según su id.
internal TeacherDTO RetrieveTeacher(int id)
{
TeacherDTO teacher;
using (var context = new BackendContext()) {
teacher = context.Users
.Include(s => s.Teacher)
.Where(s => s.Id == id)
.Select(s => new TeacherDTO()
{
Id = s.Id,
Name = s.Teacher.Name,
Surname = s.Teacher.Surname,
UserName = s.UserName,
Password = s.Password
})
.FirstOrDefault();
}
return(teacher);
}
internal ChildDTO RetrieveChild(int id)
{
ChildDTO child;
using (var context = new BackendContext())
{
child = context.Users
.Include(s => s.Child)
.Where(s => s.Id == id)
.Select(s => new ChildDTO()
{
Id = s.Id,
Name = s.Child.Name,
Surname = s.Child.Surname,
UserName = s.UserName,
Password = s.Password
})
.FirstOrDefault();
}
return(child);
}
internal void SaveTeacher(TeacherDTO t)
{
BackendContext context = new BackendContext();
User user = new User()
{
UserName = t.UserName,
Password = t.Password,
};
context.Users.Add(user);
context.SaveChanges();
var id = context.Users.Where(e => e.UserName == t.UserName).First().Id;
Teacher teacher = new Teacher()
{
Id = id,
Surname = t.Surname,
Name = t.Name,
};
context.Teachers.Add(teacher);
context.SaveChanges();
}
