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