private Studies DoStudiesExist(string name)
{
using (var db = new s18734Context())
{
return(db.Studies.Where(x => x.Name == name).SingleOrDefault());
}
}
public IEnumerable <Models_Zadanie10.Student> GetStudents_zad10()
{
using (var db = new s18734Context())
{
return(db.Student.ToList());
}
}
private Models_Zadanie10.Enrollment GetEnrollment(int id)
{
using (var db = new s18734Context())
{
return(db.Enrollment.Where(e => e.IdStudy == id && e.Semester == 1)
.FirstOrDefault());
}
}
public void removeStudent(string id)
{
using (var db = new s18734Context())
{
var student = db.Student.Where(s => s.IndexNumber == id).SingleOrDefault();
db.Student.Remove(student);
db.SaveChanges();
}
}
public bool checkIfStudentExist(string id)
{
using (var db = new s18734Context())
{
var res = db.Student.Where(s => s.IndexNumber.Equals(id));
if (res.Count() > 0)
{
return(true);
}
return(false);
}
}
public bool CheckIfStudentsExists()
{
using (var db = new s18734Context())
{
var res = db.Student.ToList();
if (res.Count() > 0)
{
return(true);
}
return(false);
}
}
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 PromoteStudent(PromoteStudentReq req)
{
using (var db = new s18734Context())
{
var enroll = db.Enrollment.Where(x => x.Semester == req.Semester)
.Join(db.Studies.Where(s => s.Name == req.Studies),
e => e.IdStudy, stud => stud.IdStudy,
(e, _) => e)
.SingleOrDefault();
if (enroll == null)
{
throw new Exception();
}
db.Database.ExecuteSqlRaw($"exec procedura1 {req.Studies}, {req.Semester} ");
enroll.Semester++;
return(enroll);
}
}
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);
}
}
}
