public Boolean isGroupName(string n)
{
try
{
using (var db = new DataContext())
{
if (db.Groups.Where(orig => orig.Name == n).FirstOrDefault() == null)
return false;
else
return true;
}
}
catch (Exception e)
{ Console.WriteLine("isGroupName" + e.Message); return false; }
}
public void createSubject(string newName, string newConspect, string newUrl)
{
try
{
using (var db = new DataContext())
{
var subject = new Subject { Name = newName, Conspect = newConspect, url = newUrl };
db.Subjects.Add(subject);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczenia z baza danych" ,"Dodawanie przedmiotu");
}
}
public void createGV(int regId, int gradeId, string value, string date)
{
try
{
using (var db = new DataContext())
{
var reg = db.Registrations.Find(regId);
var grade = db.Grades.Find(gradeId);
var gv = new GradeValue { Registration = reg, Grade = grade, Value = value, Date = date };
db.GradeValues.Add(gv);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Dodawanie wartosci oceny");
}
}
public GradeValue getGradeValueById(int id)
{
using (var db = new DataContext())
{
return db.GradeValues.Where(o => o.GradeValueID == id).ToList().First();
}
}
public void updateGrade(int id, string gradeName, string maxValue, int realId, byte[] timestamp)
{
try
{
using (var db = new DataContext())
{
var original = db.Grades.Include("Realisation").Where(orig => orig.GradeID == id).FirstOrDefault();
if (original != null)
{
if (realId != original.Realisation.RealisationID)
{
var real = db.Realisations.Find(realId);
original.Realisation = real;
}
if (!string.IsNullOrEmpty(maxValue))
{
string Stud = string.Empty;
List<GradeValue> gv = db.GradeValues.Include("Grade").Include("Registration").Include("Registration.Student").Where(o => o.Grade.GradeID == id).ToList();
if (gv != null)
{
foreach(GradeValue v in gv)
{
if (!Validation(maxValue, v.Value))
{
Stud = string.Concat(Stud, "\n", v.Registration.Student.LastName);
Console.WriteLine(v.Registration.Student.LastName);
}
}
if (!string.IsNullOrEmpty(Stud))
{
throw new EresDataContextException("Musisz podac ocene", "Modyfikacja oceny");
}
}
original.MaxValue = maxValue.ToUpper();
}
if (!string.IsNullOrEmpty(gradeName))
{
if (db.Grades.Include("Realisation").Where(o => o.Realisation.RealisationID == realId).Where(o => o.Name == gradeName).FirstOrDefault() != null)
{
throw new EresDataContextException("Nazwa oceny musi byc unikalna", "Modyfikacja oceny");
}
original.Name = gradeName;
}
original.TimeStamp = timestamp;
db.Grades.Attach(original);
db.Entry(original).State = EntityState.Modified;
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Modyfikacja oceny");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Modyfikacja oceny");
}
catch (EresDataContextException e)
{
throw e;
}
}
public IList<Grade> getRealGrades(int realId)
{
using (var db = new DataContext())
{
return db.Grades.Include("Realisation").Include("Realisation.Subject").Include("Realisation.Semester").Where(o => o.Realisation.RealisationID == realId).ToList();
}
}
public void deleteRegistration(Registration r)
{
try
{
using (var db = new DataContext())
{
var orig = db.Registrations.Find(r.RegistrationID);
if (orig != null)
{
db.Registrations.Remove(orig);
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Usuwanie rejestracji");
}
catch (DbUpdateException)
{
throw new EresDataContextException("Nie mozna usunac trwajacej rejestracji!", "Usuwanie rejestracji");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Usuwanie rejestracji");
}
}
public IList<GradeValue> getRegGradeValues(int regId)
{
using (var db = new DataContext())
return db.GradeValues.Include("Grade").Include("Registration").Include("Registration.Student").Where(o => o.Registration.RegistrationID == regId).ToList();
}
public List<Realisation> getSemRealisations(int semId)
{
using (var db = new DataContext())
{
return db.Realisations.Include("Semester").Include("Subject").Where(o => o.Semester.SemesterID == semId).ToList();
}
}
public List<Registration> getRegistrations()
{
using (var db = new DataContext())
return db.Registrations.Include("Student").Include("Realisation").Include("Realisation.Subject").Include("Realisation.Semester").ToList();
}
public void deleteSemester(Semester sem)
{
try
{
using (var db = new DataContext())
{
var original = db.Semesters.Find(sem.SemesterID);
if (original != null)
{
db.Semesters.Remove(original);
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Usuwanie semestru");
}
catch (DbUpdateException)
{
throw new EresDataContextException("Nie mozna usunac semestru z realizacja!", "Usuwanie semestru");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Usuwanie semestru");
}
}
public void updateSemester(int id, string n, byte[] timestamp)
{
try
{
using (var db = new DataContext())
{
var original = db.Semesters.Where(orig => orig.SemesterID == id).FirstOrDefault();
if (original != null)
{
if (!original.Name.Equals(n))
{
original.Name = n;
original.TimeStamp = timestamp;
db.Semesters.Attach(original);
db.Entry(original).State = EntityState.Modified;
db.SaveChanges();
}
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Modyfikacja semestru");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Modyfikacja semestru");
}
}
public void createSemester(string NewSemName)
{
try
{
using (var db = new DataContext())
{
var sem = new Semester { Name = NewSemName };
db.Semesters.Add(sem);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Dodawanie semestru");
}
}
public List<Subject> getSubjects()
{
using (var db = new DataContext())
return db.Subjects.ToList();
}
public void updateSubject(int id, string NewSubName, string NewConspect, string NewUrl, byte[] timestamp)
{
try
{
using (var db = new DataContext())
{
var original = db.Subjects.Where(orig => orig.SubjectID == id).FirstOrDefault();
if (original != null)
{
if (!string.IsNullOrEmpty(NewSubName))
original.Name = NewSubName;
if (!string.IsNullOrEmpty(NewConspect))
original.Conspect = NewConspect;
if (!string.IsNullOrEmpty(NewUrl))
original.url = NewUrl;
original.TimeStamp = timestamp;
db.Subjects.Attach(original);
db.Entry(original).State = EntityState.Modified;
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Modyfikacja przedmiotu");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Modyfikacja przedmiotu");
}
}
public bool canRegister(int realId, int studId)
{
using (var db = new DataContext())
{
if (db.Registrations.Where(o => o.Realisation.RealisationID == realId).Where(o => o.Student.StudentID == studId).FirstOrDefault() == null)
return true;
else
return false;
}
}
public void createRegistration(int realId, int studId)
{
try
{
using (var db = new DataContext())
{
var real = db.Realisations.Find(realId);
var stud = db.Students.Find(studId);
var reg = new Registration { Realisation = real, Student = stud };
db.Registrations.Add(reg);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Dodawanie rejestracji");
}
}
public Boolean isSubInSem(int semId, int subId)
{
try
{
using (var db = new DataContext())
{
var real = db.Realisations.Where(o=>o.Subject.SubjectID==subId).Where(o=>o.Semester.SemesterID==semId).FirstOrDefault();
if (real == null)
return false;
else
return true;
}
}
catch (Exception e)
{ Console.WriteLine("isSubInSem1" + e.Message); return false; }
}
public void updateRegistration(int id, int realId, int studId, byte[] timestamp)
{
try
{
using (var db = new DataContext())
{
var orig = db.Registrations.Include("Realisation").Include("Student").Where(o => o.RegistrationID == id).FirstOrDefault();
if (orig != null)
{
if (orig.Realisation.RealisationID != realId || orig.Student.StudentID != studId)
{
if (db.Registrations.Where(o => o.Realisation.RealisationID == realId).Where(o => o.Student.StudentID == studId).FirstOrDefault() != null)
{
throw new EresDataContextException("Student juz jest dodany do realizacji", "Modyfikacja rejestracji");
}
else
{
var real = db.Realisations.Find(realId);
orig.Realisation = real;
var stud = db.Students.Find(studId);
orig.Student = stud;
orig.TimeStamp = timestamp;
db.Registrations.Attach(orig);
db.Entry(orig).State = EntityState.Modified;
db.SaveChanges();
}
}
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Modyfikacja rejestracji");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Modyfikacja rejestracji");
}
catch (EresDataContextException e)
{
throw e;
}
}
public Boolean isSubInSem(Realisation r)
{
try
{
using (var db = new DataContext())
{
int id = r.RealisationID;
int subId = r.Subject.SubjectID;
int semId = r.Semester.SemesterID;
var orig = db.Realisations.Include("Subject").Include("Semester").Where(o => o.RealisationID == id).FirstOrDefault();
if (orig.Semester.SemesterID != semId || orig.Subject.SubjectID != subId) //jeśli coś się zmieniło
{
var real = db.Realisations.Where(o => o.Subject.SubjectID == subId).Where(o => o.Semester.SemesterID == semId).FirstOrDefault();
if (real == null)
return false;
else
return true;
}
else
return false;
}
}
catch (Exception e)
{ Console.WriteLine("isSubInSem2" + e.Message); return false; }
}
public void createRealisation(int semId, int subId)
{
try
{
using (var db = new DataContext())
{
var semester = db.Semesters.Find(semId);
var subject = db.Subjects.Find(subId);
var real = new Realisation { Subject = subject, Semester = semester };
db.Realisations.Add(real);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Dodawanie realizacji");
}
}
public List<Grade> getGrades()
{
using (var db = new DataContext())
return db.Grades.Include("Realisation").Include("Realisation.Subject").Include("Realisation.Semester").ToList();
}
public void createGrade(int realId, string gradeName, string maxValue)
{
try
{
using (var db = new DataContext())
{
var real = db.Realisations.Find(realId);
var grade = new Grade { Realisation = real, Name = gradeName, MaxValue = maxValue };
db.Grades.Add(grade);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Dodawanie oceny");
}
}
public void updateRealisation(int id, int semId, int subId, byte[] timestamp)
{
try
{
using (var db = new DataContext())
{
var orig = db.Realisations.Include("Subject").Include("Semester").Where(o => o.RealisationID == id).FirstOrDefault();
if (orig != null)
{
if (orig.Semester.SemesterID != semId || orig.Subject.SubjectID != subId) //jeśli coś się zmieniło
{
if (db.Realisations.Where(o => o.Subject.SubjectID == subId).Where(o => o.Semester.SemesterID == semId).FirstOrDefault() != null)
{
throw new EresDataContextException("Jest juz semestr z tym przedmiotem.", "Modyfikacja realizacji");
}
else
{
var sem = db.Semesters.Find(semId);
orig.Semester = sem;
var sub = db.Subjects.Find(subId);
orig.Subject = sub;
orig.TimeStamp = timestamp;
db.Realisations.Attach(orig);
db.Entry(orig).State = EntityState.Modified;
db.SaveChanges();
}
}
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Modyfikacja realizacji");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Modyfikacja realizacji");
}
catch (EresDataContextException)
{
throw;
}
}
public bool isGrade(int gradeId, int regId)
{
using (var db = new DataContext())
{
if (db.GradeValues.Include("Grade").Include("Registration").Where(o => o.Registration.RegistrationID == regId).Where(o => o.Grade.GradeID == gradeId).FirstOrDefault() == null)
{
return false;
}
else
{
return true;
}
}
}
public List<GradeValue> getGradeValues()
{
using (var db = new DataContext())
return db.GradeValues.Include("Grade").Include("Registration").ToList();
}
public void deleteGV(GradeValue gv)
{
try
{
using (var db = new DataContext())
{
var orig = db.GradeValues.Find(gv.GradeValueID);
if (orig != null)
{
db.GradeValues.Remove(orig);
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Usuwanie wartosci oceny");
}
catch (DbUpdateException)
{
throw new EresDataContextException("Nie usunac tej wartosci oceny!", "Usuwanie wartosci oceny");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Usuwanie wartosci oceny");
}
}
public IList<Registration> getRealRegistrations(int realId)
{
using (var db = new DataContext())
{
return db.Registrations.Include("Student").Include("Realisation").Include("Realisation.Subject").Include("Realisation.Semester").Where(o => o.Realisation.RealisationID == realId).ToList();
}
}
public void updateGV(int id, string value, string date, int regId, int gradeId, byte[] timestamp)
{
try
{
using (var db = new DataContext())
{
var original = db.GradeValues.Include("Registration").Include("Grade").Where(orig => orig.GradeValueID == id).FirstOrDefault();
if (original != null)
{
if (regId != original.Registration.RegistrationID || gradeId != original.Grade.GradeID)
{
if (isGrade(gradeId, regId))
{
throw new EresDataContextException("Student ma juz ta ocene", "Modyfikacja wartosci oceny");
}
var reg = db.Registrations.Find(regId);
original.Registration = reg;
var g = db.Grades.Find(gradeId);
original.Grade = g;
}
if (!string.IsNullOrEmpty(value))
{
original.Value = value.ToUpper();
}
if (!string.IsNullOrEmpty(date))
{
original.Date = date;
}
original.TimeStamp = timestamp;
db.GradeValues.Attach(original);
db.Entry(original).State = EntityState.Modified;
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Blad polaczania z baza danych. Sprobuj jeszcze raz.", "Modyfikacja wartosci oceny");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Blad polaczania z baza danych.", "Modyfikacja wartosci oceny");
}
catch (EresDataContextException e)
{
throw e;
}
}
public List<Semester> getSemesters()
{
using (var db = new DataContext())
return db.Semesters.ToList();
}