public void UpdateStudent(StudentDetails studentDetails) { StudentContext studentContext = this.studentContext; Student student = studentContext.Students.Where(stu => stu.Id == studentDetails.Id).Single(); student.FirstName = studentDetails.FirstName; student.LastName = studentDetails.LastName; studentContext.SaveChanges(); List <StudentEmail> studentEmailList = studentContext.StudentEmails.Where(stuEmail => stuEmail.StudentId == studentDetails.Id).ToList(); foreach (string strStudentEmail in studentDetails.studentEmails) { if (!(string.IsNullOrEmpty(strStudentEmail))) { int stuEmailId = studentEmailList.First().Id; StudentEmail studentEmail = studentContext.StudentEmails.Where(stuEmail => stuEmail.Id == stuEmailId).Single(); studentEmail.Email = strStudentEmail; studentEmailList.Remove(studentEmailList.First()); } } if (studentEmailList.Count != 0) { foreach (StudentEmail studentEmail in studentEmailList) { studentContext.StudentEmails.Remove(studentEmail); } } studentContext.SaveChanges(); }
public void AddStudentEmail(StudentDetails studentDetails) { StudentContext studentContext = this.studentContext; StudentEmail studentEmail = studentContext.StudentEmails.Create(); studentEmail.StudentId = studentDetails.Id; studentEmail.Email = studentDetails.studentEmails.Last(); studentContext.StudentEmails.Add(studentEmail); studentContext.SaveChanges(); }