public void AddOrUpdateStudent(StudentModel student)
{
if (student.Id != 0)
{
var studentEntity = _db.Students.Include("Notes").Include("ParentInfo").Include("StudentsMedia").FirstOrDefault(it => it.Id == student.Id);
if (studentEntity != null)
{
studentEntity.FirstName = student.FirstName;
studentEntity.LastName = student.LastName;
studentEntity.Code = student.Code;
studentEntity.Age = student.Age;
studentEntity.Gender = student.Gender;
studentEntity.Phone = student.Phone;
studentEntity.Email = student.Email;
studentEntity.Adress = student.Adress;
studentEntity.Star = student.Star;
studentEntity.ClassModelId = student.ClassModelId;
_db.Entry(studentEntity.ParentInfo).State = EntityState.Deleted;
_db.ParentInfo.Update(student.ParentInfo);
DeleteData(studentEntity.StudentsMedia);
studentEntity.StudentsMedia.AddRange(student.StudentsMedia);
DeleteData(studentEntity.Notes);
studentEntity.Notes.AddRange(student.Notes);
_db.Students.Update(studentEntity);
}
}
else
{
_db.Students.Add(student);
}
_db.SaveChanges();
}
//public void AddStudentToClass(ClassModel classModel)
//{
// if (classModel.Id == 0) return;
// var classEntity = _db.Classes.Include("Students").FirstOrDefault(it => it.Id == classModel.Id);
// if (classEntity == null) return;
// DeleteData(classEntity.Students);
// classEntity.Students.AddRange(classModel.Students);
// _db.Classes.Update(classEntity);
// var student = classModel.Students.FirstOrDefault(x => x.Id == classEntity.Students.FirstOrDefault(y => y.Id == x.Id).Id);
// var studentEntity = _db.Students.Include("ClassModel").Include("Notes").Include("ParentInfo").Include("StudentsMedia").FirstOrDefault(it => it.Id == student.Id);
// //studentEntity.ClassModel = classModel;
// student.ClassModel = classModel;
// _db.Entry(studentEntity).State = EntityState.Deleted;
// _db.Students.Update(student);
// _db.Students.Update(student ?? throw new InvalidOperationException());
// _db.SaveChanges();
//}
public void AddOrUpdateClass(ClassModel classModel)
{
if (classModel.Id != 0)
{
var classEntity = _db.Classes.Include("ClassMediaIcon").Include("ClassesMediaFiles").Include("Students").Include("Groups").Include("Notes").FirstOrDefault(it => it.Id == classModel.Id);
if (classEntity != null)
{
classEntity.Title = classModel.Title;
classEntity.Code = classModel.Code;
classEntity.CourseStartDate = classModel.CourseStartDate;
classEntity.CourseEndDate = classModel.CourseEndDate;
classEntity.Stars = classModel.Stars;
_db.Entry(classEntity.ClassMediaIcon).State = EntityState.Deleted;
_db.ClassMediaIcon.Update(classModel.ClassMediaIcon);
DeleteData(classEntity.Groups);
classEntity.Groups.AddRange(classModel.Groups);
DeleteData(classEntity.Notes);
classEntity.Notes.AddRange(classModel.Notes);
DeleteData(classEntity.ClassesMediaFiles);
classEntity.ClassesMediaFiles.AddRange(classModel.ClassesMediaFiles);
_db.Classes.Update(classEntity);
}
}
else
{
_db.Classes.Add(classModel);
}
_db.SaveChanges();
}
public void Update(UserModel userModel)
{
_db.Entry(userModel).State = EntityState.Modified;
_db.SaveChanges();
}