///end-add student-class
//begin add studentinfo&&student-class
public int Addstudentandclass(List <class_student> c_studl, List <StudInfo1> studentl)
{
Exercise_ERContainer cn = new Exercise_ERContainer();
System.Data.Entity.DbContextTransaction tr = cn.Database.BeginTransaction();
try
{
foreach (StudInfo1 student in studentl)
{
if (cn.StudInfo1Set.Find(student.studentid) == null)
{
cn.StudInfo1Set.Add(student);
}
}
foreach (class_student c_stud in c_studl)
{
cn.class_student.Add(c_stud);
}
cn.SaveChanges();
tr.Commit();
return(1);
}
//catch (DbEntityValidationException ex)
catch (Exception ex)
{
Console.WriteLine(ex.Message);
tr.Rollback();
return(0);
}
}
///////////////////endstuinfo
//////////////begin add student-class
public int Addstudenttoclass(class_student c_stud)
{
try
{
Exercise_ERContainer cn = new Exercise_ERContainer();
cn.class_student.Add(c_stud);
cn.SaveChanges();
return(1);
}
//catch (DbEntityValidationException ex)
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
public int Addstudent(StudInfo1 student)
{
try
{
Exercise_ERContainer cn = new Exercise_ERContainer();
if (cn.StudInfo1Set.Find(student.studentid) == null)
{
cn.StudInfo1Set.Add(student);
}
cn.SaveChanges();
return(1);
}
//catch (DbEntityValidationException ex)
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}