public IActionResult GetStudents() { var db = new _2019SBDContext(); var res = db.Student.ToList(); return(Ok(res)); }
[Route("api/students/modifyStudent")] //zmień na student public IActionResult ModifyStudent(ModifyStudentRequest request) { var db = new _2019SBDContext(); var s = new Student { IndexNumber = request.IndexNumber, FirstName = request.FirstName, LastName = request.LastName, BirthDate = request.BirthDate }; db.Attach(s); if (request.FirstName != null) { db.Entry(s).Property("FirstName").IsModified = true; } if (request.LastName != null) { db.Entry(s).Property("LastName").IsModified = true; } if (request.BirthDate != null) { db.Entry(s).Property("BirthDate").IsModified = true; } db.SaveChanges(); var db2 = new _2019SBDContext(); var res = db2.Student .Where(d => d.IndexNumber == request.IndexNumber) .FirstOrDefault(); var response = new ModifyStudentResponse(); response.IndexNumber = res.IndexNumber; response.FirstName = res.FirstName; response.LastName = res.LastName; response.BirthDate = res.BirthDate; return(Ok(response)); }
[Route("api/students/deleteStudent")] //zmień na student public IActionResult DeleteStudent(ModifyStudentRequest request) { var db = new _2019SBDContext(); var student = new Student { IndexNumber = request.IndexNumber }; db.Attach(student); db.Remove(student); db.SaveChanges(); return(Ok(request.IndexNumber + " zostal usunięty")); }
public PizzasController(_2019SBDContext context) { _context = context; }
public SqlStudentDbService(_2019SBDContext context) { _context = context; }
public ClientsController(_2019SBDContext context) { _context = context; }
public IngredientsController(_2019SBDContext context) { _context = context; }
public Customer_AlergenController(_2019SBDContext context) { _context = context; }
public IActionResult EnrollStudent(EnrollStudentRequest request) { var db = new _2019SBDContext(); var res = db.Studies .Where((d) => d.Name == request.Studies).FirstOrDefault(); if (res == null) { return(BadRequest()); } var db2 = new _2019SBDContext(); var res2 = db2.Enrollment .Where(d => d.Semester == 1 && d.IdStudy == res.IdStudy) .OrderByDescending(d => d.StartDate) //rosnąco czy malejąco? .FirstOrDefault(); EnrollStudentResponse esr = new EnrollStudentResponse(); if (res2 == null) { //wyszukaj największ idEnrollment var res3 = db.Enrollment .OrderByDescending(d => d.IdEnrollment) //rosnąco czy malejąco? .FirstOrDefault(); int maxIdEnrollment = res3.IdEnrollment; //ZMIEŃ UWAGA NA DATE teraz esr.StartDate = DateTime.Today; //stworz nowy var e = new Enrollment() { IdEnrollment = maxIdEnrollment + 1, StartDate = esr.StartDate, Semester = 1, IdStudy = res.IdStudy }; db.Enrollment.Add(e); esr.IdEnrollment = maxIdEnrollment + 1; // db.SaveChanges();//póżniej zlikwidować !!!!!1111 } else { esr.IdEnrollment = res2.IdEnrollment; } // var db4 = new _2019SBDContext(); var res4 = db2.Student .Where(d => d.IndexNumber == request.IndexNumber).FirstOrDefault(); if (res4 != null) { return(BadRequest()); } //DODAJ STUDENTA //sprawdzić jak się savuje bez tamtego var s = new Student() { IndexNumber = request.IndexNumber, FirstName = request.FirstName, LastName = request.LastName, BirthDate = request.BirthDate, IdEnrollment = esr.IdEnrollment }; db.Student.Add(s); db.SaveChanges();//póżniej zlikwidować !!!!!1111 esr.IndexNumber = s.IndexNumber; esr.Studies = request.Studies; esr.Semester = 1; var res5 = db2.Enrollment .Where(d => d.IdEnrollment == esr.IdEnrollment).FirstOrDefault(); esr.StartDate = res5.StartDate; return(Ok(esr)); }
public MenuController(_2019SBDContext context) { _context = context; }
public CustomersController(_2019SBDContext context) { _context = context; }
public AdditiveController(_2019SBDContext context) { _context = context; }
public Pizza_CompositionController(_2019SBDContext context) { _context = context; }
public OrdersController(_2019SBDContext context) { _context = context; }
[Route("api/enrollments/promotions")] //zmień na student public IActionResult PromoteStudents(PromoteStudentsRequest request) { var db = new _2019SBDContext(); // var res = db.Student.ToList(); var res = db.Studies .Where((d) => d.Name == request.Studies).FirstOrDefault(); if (res == null) { return(BadRequest()); } var res2 = db.Enrollment .Where((d) => d.IdStudy == res.IdStudy && d.Semester == request.Semester).FirstOrDefault(); if (res == null) { return(BadRequest()); } var res3 = db.Enrollment .Where((d) => d.IdStudy == res.IdStudy && d.Semester == request.Semester + 1).FirstOrDefault(); PromoteStudentsResponse response = new PromoteStudentsResponse(); if (res3 == null) { //dodaj enrollment var res4 = db.Enrollment .OrderByDescending(d => d.IdEnrollment) //rosnąco czy malejąco? .FirstOrDefault(); int maxIdEnrollment = res4.IdEnrollment; response.StartDate = DateTime.Today; var e = new Enrollment() { IdEnrollment = maxIdEnrollment + 1, StartDate = response.StartDate, Semester = request.Semester + 1, IdStudy = res.IdStudy }; db.Enrollment.Add(e); response.IdEnrollment = maxIdEnrollment + 1; } else { response.IdEnrollment = res3.IdEnrollment; } // db.SaveChanges(); //teraz trzeba wszystkich studentów zrolować var res5 = db.Student .Where((d) => d.IdEnrollment == res2.IdEnrollment).ToList(); foreach (Student s in res5) { s.IdEnrollment = response.IdEnrollment; } db.SaveChanges(); return(Ok(response)); }
public ServicesController(_2019SBDContext context) { _context = context; }
public Order_AdditivesController(_2019SBDContext context) { _context = context; }