public void EnrollStudent(Student student)
{
s19677Context db = new s19677Context();
// Sprawdź, czy przekazane wszystkie dane. Czy istnieją studia zgodne z wartością.
if (!(student.FirstName == null) && !(student.LastName == null) && !(student.IndexNumber == null) && !(student.BirthDate == null) && !(student.Studies == null))
{
var studies = db.Studies.Select(s => s.Name == student.Studies);
if (studies != null)
{
var study = db.Studies.FirstOrDefault(s => s.Name == student.Studies);
var enrol = db.Enrollment.FirstOrDefault(e => e.Semester == 1 && e.IdStudy == study.IdStudy);
if (!db.Enrollment.Contains(enrol))
{
db.Enrollment.Add(new EntityModels.Enrollment {
IdEnrollment = 99, Semester = 1, IdStudy = study.IdStudy, StartDate = DateTime.Now
});
db.SaveChanges();
}
EntityModels.Student res = new EntityModels.Student
{
IndexNumber = student.IndexNumber,
FirstName = student.FirstName,
LastName = student.LastName,
BirthDate = student.BirthDate,
IdEnrollment = enrol.IdEnrollment
};
db.Add(res);
db.SaveChanges();
}
}
}
private void BtnSave_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
Controller.ControllerStudent ctrl = new Controller.ControllerStudent();
var student = new EntityModels.Student()
{
NameFamily = txtStudentName.Text,
Mobile = txtMobile.txtMobile.Text,
CodeMeli = txtNationCode.txtCode.Text,
StudentCode = txtStudentCode.txtStudentCode.Text,
DadName = txtFatherName.Text,
UserName = txtUserName.Text,
Password = txtPassword.Text,
Class = comboLevel.Text,
Email = txtEmail.Text,
IsDisabled = false,
IsGraguated = false,
RegisterDate = DateTime.Now.Date
};
int result = ctrl.Save(student);
if (result >= 1)
{
MessageBox.Show("به درستی ذخیره شد");
}
}
public void DeleteStudent(string ska)
{
s19677Context db = new s19677Context();
EntityModels.Student student = db.Student.SingleOrDefault(s => s.IndexNumber == ska);
db.Student.Remove(student);
db.SaveChanges();
}
public void UpdateStudent(EntityModels.Student student)
{
s19677Context db = new s19677Context();
var res = new EntityModels.Student
{
IndexNumber = student.IndexNumber,
FirstName = student.FirstName,
LastName = student.LastName,
BirthDate = student.BirthDate
};
db.Attach(res); // res w systemie śledzenia zmian.
db.Entry(res).Property("FirstName").IsModified = true;
db.Entry(res).Property("LastName").IsModified = true;
db.Entry(res).Property("BirthDate").IsModified = true;
db.SaveChanges();
}
