public IEnumerable <Student> Get() { var db = new s7973Context(); var res = db.Student.ToList(); return(res); }
public IActionResult PromoteStudent(EFPromoteStudents request) { var db = new s7973Context(); var stud = new EFPromoteStudents() { Studies = request.Studies, Semester = request.Semester }; var studies = (from Studies in db.Studies join enrollment in db.Enrollment on Studies.IdStudy equals enrollment.IdStudy where Studies.Name == request.Studies && enrollment.Semester == request.Semester select new { Studies.Name, enrollment.Semester }); var c = (studies.SingleOrDefault(x => x.Semester == request.Semester)); if (c == null) { return(StatusCode(404, "Not found")); } var test = "Informatyka"; var test2 = 6; var proc = db.Database.ExecuteSqlCommand("PromoteStudents @p0, @p1", stud.Studies, stud.Semester); db.SaveChanges(); var enr = db.Enrollment.SingleOrDefault(x => x.StartDate == DateTime.Now.Date); return(StatusCode(201, enr)); }
public IActionResult Delete([FromRoute] String index) { var db = new s7973Context(); var stud = db.Student.SingleOrDefault(x => x.IndexNumber == index); db.Student.Remove(stud); db.SaveChangesAsync(); return(Ok("Student został usuniety")); }
public IActionResult Update([FromRoute] String index) { var db = new s7973Context(); var stud = db.Student.SingleOrDefault(x => x.IndexNumber == index); stud.FirstName = "Rafał"; stud.LastName = "Smoczyński"; db.SaveChangesAsync(); return(Ok(stud)); }
public IActionResult EnrollStudent(EFEnrollSudentRequest request) { var db = new s7973Context(); var studies = db.Studies.SingleOrDefault(x => x.Name == request.Studies); if (studies == null) { return(BadRequest(400)); } var semester = (from Studies in db.Studies join enrollment in db.Enrollment on Studies.IdStudy equals enrollment.IdStudy where Studies.Name == request.Studies && enrollment.Semester == 1 select new { Studies.Name, enrollment.Semester }); var c = (semester.SingleOrDefault(x => x.Semester == 1)); if (c == null) { var stud = db.Studies.SingleOrDefault(x => x.Name == request.Studies); var enroll = new Enrollment() { IdEnrollment = 40, Semester = 1, StartDate = DateTime.Now, IdStudy = stud.IdStudy }; db.Enrollment.Add(enroll); db.SaveChanges(); } var idx = db.Student.SingleOrDefault(x => x.IndexNumber == request.IndexNumber); if (idx == null) { var enroll = db.Enrollment.SingleOrDefault(x => x.StartDate == DateTime.Now.Date); var stud = new Student() { IndexNumber = request.IndexNumber, FirstName = request.FirstName, LastName = request.LastName, BirthDate = request.BirthDate, IdEnrollment = enroll.IdEnrollment }; db.Student.Add(stud); db.SaveChanges(); } else { return(StatusCode(400, "Student znajduje się już bazie")); } var enr = db.Enrollment.SingleOrDefault(x => x.StartDate == DateTime.Now.Date); return(StatusCode(201, enr)); }