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