public IActionResult GetStudent(Models_Zadanie10.Student student)
{
if (!_dbService.CheckIfStudentsExists())
{
return(Forbid());
}
return(Ok(_dbService.GetStudents_zad10()));
}
public IActionResult ChangeStudent(Models_Zadanie10.Student student, string id)
{
if (!_dbService.checkIfStudentExist(id))
{
return(Forbid());
}
_dbService.modifyStudent(student, id);
return(Ok("Aktualizacja dokonana"));
}
public void modifyStudent(Models_Zadanie10.Student student, String id)
{
using (var db = new s18734Context())
{
var s = db.Student.Where(s => s.IndexNumber == id).SingleOrDefault();
s.IndexNumber = student.IndexNumber;
s.FirstName = student.FirstName;
s.BirthDate = student.BirthDate;
s.IdEnrollment = student.IdEnrollment;
s.Salt = student.Salt;
s.Password = student.Password;
db.SaveChanges();
}
}
public Models_Zadanie10.Enrollment EnrollStudent(EnrollStudentReq req)
{
using (var db = new s18734Context())
{
using (var transaction = db.Database.BeginTransaction())
{
var study = DoStudiesExist(req.Studies);
if (study == null)
{
transaction.Rollback();
throw new Exception("Studia nie istnieja");
}
Models_Zadanie10.Enrollment enrollment = GetEnrollment(study.IdStudy);
if (enrollment == null)
{
enrollment = new Models_Zadanie10.Enrollment()
{
Semester = 1,
IdStudy = study.IdStudy,
StartDate = DateType.FromString(DateTime.Now.ToString("MM.dd.yyyy"))
};
db.Enrollment.Add(enrollment);
db.SaveChanges();
}
if (checkIfStudentExist(req.IndexNumber))
{
transaction.Rollback();
throw new Exception();
}
var stud = new Models_Zadanie10.Student
{
IndexNumber = req.IndexNumber,
FirstName = req.FirstName,
LastName = req.LastName,
BirthDate = DateType.FromString(req.BirthDate),
IdEnrollment = IntegerType.FromObject(enrollment.IdEnrollment)
};
db.Student.Add(stud);
db.SaveChanges();
transaction.Commit();
return(enrollment);
}
}
}
