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 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 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 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 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 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 void updateStudent(int id, string ind, string first, string last, int groupId, byte[] timestamp)
{
try
{
using (var db = new DataContext())
{
var original = db.Students.Include("Group").Where(orig => orig.StudentID == id).FirstOrDefault();
if (original != null)
{
if (!string.IsNullOrEmpty(first))
original.FirstName = first;
if (!string.IsNullOrEmpty(ind))
original.IndexNo = ind;
if (!string.IsNullOrEmpty(last))
original.LastName = last;
if (groupId!=original.Group.GroupID )
{
var group = db.Groups.Find(groupId);
original.Group = group;
}
original.TimeStamp = timestamp;
db.Students.Attach(original);
db.Entry(original).State = EntityState.Modified;
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Operacja sie nie powiodla. Sprobuj jeszcze raz za chwile", "Modyfikacja studenta");
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Nie mozna modyfikowac studenta. Blad polaczenia z baza danych.", "Modyfikacja studenta");
}
}
