/// <summary> /// Funkcja dodająca nowego studenta do tabeli Students /// </summary> /// <param name="index"></param> /// <param name="fieldOfStudyName"></param> /// <param name="studyVintageYear"></param> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="birthDate"></param> /// <param name="pesel"></param> /// <param name="addressId"></param> /// <param name="deficit"></param> /// <param name="phoneNumber"></param> /// <param name="eMail"></param> /// <returns></returns> public bool AddStudent(int index, string fieldOfStudyName, int studyVintageYear, string firstName, string lastName, DateTime birthDate, string pesel, int addressId, short deficit, string phoneNumber, string eMail) { StudyVintage studyVintage = DbContext.StudyVintages.SingleOrDefault(s => s.Year == studyVintageYear); FieldOfStudy fieldOfStudy = DbContext.FieldsOfStudies.SingleOrDefault(f => f.Name == fieldOfStudyName); if (studyVintage == null || fieldOfStudy == null) { return(false); } Student student = new Student() { Sindex = index, FieldOfStudy = fieldOfStudy, StudyVintage = studyVintage, FirstName = firstName, LastName = lastName, BirthDate = birthDate, Pesel = pesel, AddressId = addressId, ECTSDeficit = deficit, PhoneNumber = phoneNumber, EMail = eMail }; DbContext.Students.Add(student); return(DbContext.SaveChanges() > 0); }
/// <summary> /// Funkcja aktualizująca studenta o zadanym Id /// </summary> /// <param name="index"></param> /// <param name="fieldOfStudyName"></param> /// <param name="studyVintageYear"></param> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="birthDate"></param> /// <param name="pesel"></param> /// <param name="addressId"></param> /// <param name="deficit"></param> /// <param name="phoneNumber"></param> /// <param name="eMail"></param> /// <returns></returns> public bool UpdateStudent(int index, string fieldOfStudyName, int studyVintageYear, string firstName, string lastName, DateTime birthDate, string pesel, int addressId, short deficit, string phoneNumber, string eMail) { Student student = DbContext.Students.SingleOrDefault(s => s.Sindex == index); StudyVintage studyVintage = DbContext.StudyVintages.SingleOrDefault(s => s.Year == studyVintageYear); FieldOfStudy fieldOfStudy = DbContext.FieldsOfStudies.SingleOrDefault(f => f.Name == fieldOfStudyName); if (studyVintage == null || fieldOfStudy == null) { return(false); } student.FieldOfStudy = fieldOfStudy; student.StudyVintage = studyVintage; student.FirstName = firstName; student.LastName = lastName; student.BirthDate = birthDate; student.Pesel = pesel; student.AddressId = addressId; student.ECTSDeficit = deficit; student.PhoneNumber = phoneNumber; student.EMail = eMail; return(DbContext.SaveChanges() > 0); }