public IActionResult GetStudnet()
{
var db = new s19191Context();
var students = db.Student.ToList();
return(Ok(students));
}
public IActionResult UpdateStudnet(Student request)
{
var db = new s19191Context();
db.Attach(request);
db.Entry(request).State = EntityState.Modified;
db.SaveChanges();
return(Ok("Student zmodyfikowany"));
}
public IActionResult EnrollStudent(EnrollStudentRequest request)
{
var db = new s19191Context();
var studies = db.Studies
.FirstOrDefault(s => s.Name.Equals(request.Studies));
if (studies != null)
{
var maxStartDate = db.Enrollment
.Max(e => e.StartDate);
var enrollment = db.Enrollment
.Where(e => e.StartDate.Equals(maxStartDate))
.FirstOrDefault(e => e.IdStudy.Equals(studies.IdStudy));
int maxIdEnrollment;
if (enrollment == null)
{
maxIdEnrollment = db.Enrollment.Max(e => e.IdEnrollment);
maxIdEnrollment++;
db.Enrollment.Add(new Enrollment
{
IdEnrollment = maxIdEnrollment,
Semester = 1,
IdStudy = studies.IdStudy,
StartDate = DateTime.Now
});
}
else
{
maxIdEnrollment = enrollment.IdEnrollment;
}
var idStudnet = db.Student
.FirstOrDefault(s => s.IndexNumber.Equals(request.IndexNumber));
if (idStudnet == null)
{
var student = new Student
{
IndexNumber = request.IndexNumber,
FirstName = request.FirstName,
LastName = request.LastName,
BirthDate = request.BirthDate,
IdEnrollment = maxIdEnrollment,
Salt = request.Salt,
RefreshToken = request.RefreshToken,
Password = request.Password
};
db.Student.Add(student);
db.SaveChanges();
var allStudents = db.Student.ToList();
EnrollStudentResponse response = new EnrollStudentResponse(allStudents, student, request.Studies);
return(Ok(response.ToString()));
}
return(BadRequest(400 + ", student o podanym indexie już istnieje"));
}
return(BadRequest(400 + ", podane Studia nie istnieją"));
}
public IActionResult DeleteStudnet(string Index)
{
var db = new s19191Context();
var s = new Student
{
IndexNumber = Index
};
db.Attach(s);
db.Student.Remove(s);
db.SaveChanges();
return(Ok("Studnet usunięty z bazy"));
}
public IActionResult PromoteStudents(PromoteStudentsRequest request)
{
var db = new s19191Context();
var IdStudy = db.Studies
.FirstOrDefault(s => s.Name.Equals(request.Studies));
if (IdStudy != null)
{
var IdEnrollment = db.Enrollment
.FirstOrDefault(e => e.IdStudy.Equals(IdStudy.IdStudy) && e.Semester.Equals(request.Semester));
if (IdEnrollment != null)
{
var EnrollmentInserting = db.Enrollment
.FirstOrDefault(e => e.IdStudy.Equals(IdStudy.IdStudy) && e.Semester.Equals(request.Semester + 1));
if (EnrollmentInserting == null)
{
int maxIdEnrollment = db.Enrollment.Max(e => e.IdEnrollment);
EnrollmentInserting = new Enrollment
{
IdEnrollment = maxIdEnrollment + 1,
Semester = request.Semester + 1,
IdStudy = IdStudy.IdStudy,
StartDate = DateTime.Today
};
db.Enrollment.Add(EnrollmentInserting);
}
int IdEnrollmentInserting = EnrollmentInserting.IdEnrollment;
var update = db.Student
.Where(s => s.IdEnrollment.Equals(IdEnrollment.IdEnrollment));
foreach (var student in update)
{
student.IdEnrollment = IdEnrollmentInserting;
}
db.SaveChanges();
PromoteStudentResponse response = new PromoteStudentResponse(request.Studies, request.Semester);
return(Ok(response.ToString()));
}
return(BadRequest(HttpStatusCode.NotFound));
}
return(BadRequest(HttpStatusCode.NotFound + ", podane Studia nie istnieją"));
}
public EfAdvertDbService(s19191Context context)
{
_context = context;
}
