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(); }