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; }
}
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 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;
}
catch (DbUpdateException)
{
MessageBox.Show("You can not delete grade value with references.", "Grade Deletion Error");
return;
}
catch (DbEntityValidationException)
{ throw; }
}
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");
}
}
