public void UpdateStudent(int idSt, string nameSt, string lastNameSt, string surnameSt, int ageSt,
string addressSt, string groupSt, int numbRecBook, DateTime dateOfBirthSt,
float progressSt, List <Phone> phonesSt)
{
using (StudentsDbContext db = new StudentsDbContext())
{
try
{
StudentInfo ChangeStud = db.StudentInfos.Where(c => c.Id == idSt).FirstOrDefault();
ChangeStud.FirstName = nameSt;
ChangeStud.LastName = lastNameSt;
ChangeStud.Surname = surnameSt;
ChangeStud.Age = ageSt;
ChangeStud.Adress.Address = addressSt;
ChangeStud.Group.Speciality = groupSt;
ChangeStud.NumberRecordBook = numbRecBook;
ChangeStud.Birthdate = dateOfBirthSt;
ChangeStud.StudentProgress.Progress = progressSt;
ChangeStud.StudentPhones.Clear();
ChangeStud.StudentPhones = phonesSt;
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
public List <ParentsInfo> ParentsInfosInfoList()
{
using (StudentsDbContext context = new StudentsDbContext())
{
var y = context.ParentsInfos.ToList().Select(x => x.Copy()).ToList();
return(y);
}
}
public void AddNewStudent(StudentInfo student)
{
using (StudentsDbContext context = new StudentsDbContext())
{
context.StudentInfos.Add(student);
context.SaveChanges();
}
}
public StudentInfo FindStudentById(int id)
{
using (StudentsDbContext context = new StudentsDbContext())
{
StudentInfo student = context.StudentInfos.Where(c => c.Id == id).ToList().SingleOrDefault();
if (student == null)
{
throw new ArgumentNullException(nameof(student));
}
return(student);
}
}
public void UpdateStudent(StudentInfo student)
{
using (StudentsDbContext db = new StudentsDbContext())
{
try
{
db.StudentInfos.AddOrUpdate(student);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
public void UpdateAdditionalRelations(string relationInfo, int relationId)
{
using (StudentsDbContext db = new StudentsDbContext())
{
try
{
ParentsInfo ChangeRelationInfo = db.ParentsInfos?.Where(x => x.Relation.Id == relationId).FirstOrDefault();
ChangeRelationInfo.Relation.Name = relationInfo;
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
public void DeleteStudentById(int id)
{
try
{
using (StudentsDbContext context = new StudentsDbContext())
{
StudentInfo student = context.StudentInfos.Where(c => c.Id == id).ToList().FirstOrDefault();
List <ParentsInfo> parents = student.ParentsInfo.ToList();
foreach (var parentsInfo in parents)
{
context.ParentsInfos.Remove(parentsInfo);
}
context.StudentInfos.Remove(student);
context.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/*
* public void UpdateParents(List<ParentsInfo> parents)
* {
* }
*/
public void UpdateParents(string motherName, string motherLastName, string motherWorkPlace,
string fatherName, string fatherLastName, string fatherWorkPlace, int motherId, int fatherId)
{
using (StudentsDbContext db = new StudentsDbContext())
{
try
{
ParentsInfo ChangeMotherInfo = db.ParentsInfos.Where(x => x.Id == motherId).FirstOrDefault();
ParentsInfo ChangeFatherInfo = db.ParentsInfos.Where(x => x.Id == fatherId).FirstOrDefault();
ChangeMotherInfo.FirstName = motherName;
ChangeMotherInfo.LastName = motherLastName;
ChangeMotherInfo.WorkPlace = motherWorkPlace;
ChangeFatherInfo.FirstName = fatherName;
ChangeFatherInfo.LastName = fatherLastName;
ChangeFatherInfo.WorkPlace = fatherWorkPlace;
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}