public string EnrollStudent(EnrollStudentReq req) { var student = _context.Student.Where(s => s.IndexNumber.Equals(req.IndexNumber)).ToList(); if (student.Count != 0) { return("Istnieje juz taki indeks"); } var studi = _context.Studies.Where(st => st.Name.Equals(req.Studies)).ToList(); var enrollment = _context.Enrollment.Where(e => e.IdStudy.Equals(studi.First().IdStudy) && e.Semester == 1).ToList(); if (enrollment.Count() == 0) { Enrollment enrol = new Enrollment { IdEnrollment = enrollment.First().IdEnrollment, IdStudy = studi.First().IdStudy, Semester = 1, StartDate = DateTime.Now }; _context.Enrollment.Add(enrol); _context.SaveChanges(); } return(null); }
public Student deleteStudent(string index) { var data = new s18793Context(); var deleteList = data.Student.Where(s => s.IndexNumber == index).ToList(); Student deletedStudent = null; foreach (var student in deleteList) { deletedStudent = student; data.Student.Remove(student); } data.SaveChanges(); return(deletedStudent); }
public Student modfiyStudent(Student student) { var data = new s18793Context(); var stud = data.Student.Where(s => s.IndexNumber == student.IndexNumber); var studlist = stud.ToList(); foreach (var modStud in studlist) { modStud.IndexNumber = student.IndexNumber; modStud.FirstName = student.FirstName; modStud.LastName = student.LastName; modStud.IdEnrollment = student.IdEnrollment; modStud.BirthDate = student.BirthDate; } data.SaveChanges(); return(null); }