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