public void Delete(Guid Id)
{
Models.DBObjects.Student dbStudentModel = dbContext.Students.FirstOrDefault(m => m.StudentId == Id);
dbContext.Students.DeleteOnSubmit(dbStudentModel);
dbContext.SubmitChanges();
}
public void Insert(StudentModel studentModel)
{
studentModel.StudentId = Guid.NewGuid();
if (studentModel != null)
{
Models.DBObjects.Student dbStudentModel = new Models.DBObjects.Student();
dbStudentModel.StudentId = studentModel.StudentId;
dbStudentModel.Name = studentModel.Name;
dbStudentModel.BirthDate = studentModel.BirthDate;
dbStudentModel.Age = studentModel.Age;
dbStudentModel.Address = studentModel.Address;
dbStudentModel.Email = studentModel.Email;
dbStudentModel.Phone = studentModel.Phone;
dbStudentModel.ProgramId = studentModel.ProgramId;
dbStudentModel.TeacherId = studentModel.TeacherId;
dbStudentModel.ParentId = studentModel.ParentId;
dbContext.Students.InsertOnSubmit(dbStudentModel);
dbContext.SubmitChanges();
}
}
public void Update(StudentModel studentModel)
{
Models.DBObjects.Student dbStudentModel = dbContext.Students.FirstOrDefault(m => m.StudentId == studentModel.StudentId);
if (studentModel != null)
{
dbStudentModel.StudentId = studentModel.StudentId;
dbStudentModel.Name = studentModel.Name;
dbStudentModel.BirthDate = studentModel.BirthDate;
dbStudentModel.Age = studentModel.Age;
dbStudentModel.Address = studentModel.Address;
dbStudentModel.Email = studentModel.Email;
dbStudentModel.Phone = studentModel.Phone;
dbStudentModel.ProgramId = studentModel.ProgramId;
dbStudentModel.TeacherId = studentModel.TeacherId;
dbStudentModel.ParentId = studentModel.ParentId;
dbContext.SubmitChanges();
}
}
public StudentModel GetStudentById(Guid Id)
{
Models.DBObjects.Student dbStudentModel = dbContext.Students.FirstOrDefault(m => m.StudentId == Id);
StudentModel studentModel = new StudentModel();
if (dbStudentModel != null)
{
studentModel.StudentId = dbStudentModel.StudentId;
studentModel.Name = dbStudentModel.Name;
studentModel.BirthDate = dbStudentModel.BirthDate;
studentModel.Age = dbStudentModel.Age;
studentModel.Address = dbStudentModel.Address;
studentModel.Email = dbStudentModel.Email;
studentModel.Phone = dbStudentModel.Phone;
studentModel.ProgramId = dbStudentModel.ProgramId;
studentModel.TeacherId = dbStudentModel.TeacherId;
studentModel.ParentId = dbStudentModel.ParentId;
}
return(studentModel);
}
