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 void Save(Report r)
{
BackendContext context = new BackendContext();
context.Reports.Add(r);
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 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 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();
}
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 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);
}