public void testInit()
{
_storage = new Storage();
_student = new Student();
_group = new Group();
_semestr = new Semester();
_student.FirstName = "Testowy";
_student.LastName = "Test";
_student.IndexNo = "123456";
_group.Name = "TstwGrp$#^134";
_semestr.Name = "78Z";
}
public void deleteStudent(Student st)
{
try
{
using (var db = new DataContext())
{
var original = db.Students.Find(st.StudentID);
if (original != null)
{
db.Students.Remove(original);
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw;
}
catch (DbUpdateException)
{
throw;
}
catch (DbEntityValidationException)
{ throw; }
}
public void createStudent(string firstName, string lastName, string index, int groupId)
{
try
{
using (var db = new DataContext())
{
var group = db.Groups.Find(groupId);
var student = new Student { FirstName = firstName, LastName = lastName, IndexNo = index, Group = group };
db.Students.Add(student);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{ throw; }
}
public void deleteStudent(Student st)
{
try
{
using (var db = new DataContext())
{
var original = db.Students.Find(st.StudentID);
if (original != null)
{
db.Students.Remove(original);
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
throw new EresDataContextException("Tymczasowy problem z dostepem do bazy. Sprobuj ponownie za chwile.", "Usuniecie studenta");
}
catch (DbUpdateException)
{
throw new EresDataContextException("Nie mozna usunac studenta zarejestrowanego w realizacji!", "Usuniecie studenta") ;
}
catch (DbEntityValidationException)
{
throw new EresDataContextException("Nie mozna usunac studenta, problem z baza danych", "Usuniecie studenta");
}
}
public void createStudent(string firstName, string lastName, string index, int groupId)
{
try
{
using (var db = new DataContext())
{
var group = db.Groups.Find(groupId);
var student = new Student { FirstName = firstName, LastName = lastName, IndexNo = index, Group = group };
db.Students.Add(student);
db.SaveChanges();
}
}
catch (DbEntityValidationException)
{ throw new EresDataContextException("Nie mozna dodac studenta. Blad polaczenia z baza danych.", "Dodawanie studenta"); }
catch (DbUpdateException)
{
throw new EresDataContextException("Dany student jest juz w bazie", "Dodawanie studenta");
}
}
