public bool DeleteStudent(int id)
{
tb1Student student = _db.tb1Student.Find(id);
List <tblStudentSubject> studentSubjects = (from ss in _db.tblStudentSubjects where ss.StudentId == id select ss).ToList();
foreach (var studentSubject in studentSubjects)
{
_db.tblStudentSubjects.Attach(studentSubject);
_db.tblStudentSubjects.Remove(studentSubject);
}
if (student != null)
{
_db.tb1Student.Attach(student);
_db.tb1Student.Remove(student);
}
return(_db.SaveChanges() > 0);
}
public bool UpdateStudent(StudentViewModel student)
{
tb1Student oldStudent = _db.tb1Student.Find(student.Id);
tb1Student newStudent = new tb1Student
{
Id = student.Id,
Name = student.Name,
Address = student.Address,
PhoneNumber = student.PhoneNumber,
Gender = student.Gender,
FatherName = student.FatherName,
DateOfBirth = student.DateOfBirth,
FacultyId = student.FacultyId
};
_db.Entry(oldStudent).CurrentValues.SetValues(newStudent);
UpdateStudentSubjects(student.Subjects, student.Id);
return(_db.SaveChanges() > 0);
}
public bool InsertStudent(StudentViewModel studentVm)
{
tb1Student student = new tb1Student()
{
Name = studentVm.Name,
Address = studentVm.Address,
DateOfBirth = studentVm.DateOfBirth,
Gender = studentVm.Gender,
FacultyId = studentVm.FacultyId,
FatherName = studentVm.FatherName,
PhoneNumber = studentVm.PhoneNumber
};
_db.tb1Student.Add(student);
int id = _db.SaveChanges();
if (id > 0)
{
List <int> subjectIds = studentVm.Subjects.Where(x => x.IsSelected == true).Select(x => x.Id).ToList();
InsertStudentSubjects(subjectIds, student.Id);
}
return(true);
}
