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