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"); } }