public void DeleteTeacher(Guid id) { Models.DBObjects.Teacher teacherToDelete = dbContext.Teachers.FirstOrDefault(m => m.TeacherId == id); dbContext.Teachers.DeleteOnSubmit(teacherToDelete); dbContext.SubmitChanges(); }
public void UpdateTeacher(TeacherModel teacherModel) { Models.DBObjects.Teacher existingTeacher = dbContext.Teachers.FirstOrDefault(m => m.TeacherId == teacherModel.TeacherId); if (teacherModel != null) { existingTeacher.TeacherId = teacherModel.TeacherId; existingTeacher.Name = teacherModel.Name; existingTeacher.Phone = teacherModel.Phone; existingTeacher.CourseId = teacherModel.CourseId; dbContext.SubmitChanges(); } }
public TeacherModel GetTeacherById(Guid Id) { Models.DBObjects.Teacher dbTeacherModel = dbContext.Teachers.FirstOrDefault(m => m.TeacherId == Id); TeacherModel teacherModel = new TeacherModel(); if (dbTeacherModel != null) { teacherModel.TeacherId = dbTeacherModel.TeacherId; teacherModel.Name = dbTeacherModel.Name; teacherModel.Phone = dbTeacherModel.Phone; teacherModel.CourseId = dbTeacherModel.CourseId; } return(teacherModel); }
public void InsertTeacher(TeacherModel teacherModel) { teacherModel.TeacherId = Guid.NewGuid(); if (teacherModel != null) { Models.DBObjects.Teacher dbTeacherModel = new Models.DBObjects.Teacher(); dbTeacherModel.TeacherId = teacherModel.TeacherId; dbTeacherModel.Name = teacherModel.Name; dbTeacherModel.Phone = teacherModel.Phone; dbTeacherModel.CourseId = teacherModel.CourseId; dbContext.Teachers.InsertOnSubmit(dbTeacherModel); dbContext.SubmitChanges(); } }