public static void Insert(Student Student)
{
_command = new SqlCommand("insert into StudentList(StudentID, Name, Gender, [Group]) values(@StudentID, @Name, @Gender, @Group)");
_command.Parameters.AddWithValue("@StudentID", Student.StudentID);
_command.Parameters.AddWithValue("@Name", Student.Name);
_command.Parameters.AddWithValue("@Gender", Student.Gender);
_command.Parameters.AddWithValue("@Group", Student.Group);
try
{
_connection.Open();
_transaction = _connection.BeginTransaction();
_command.Connection = _connection;
_command.Transaction = _transaction;
_command.ExecuteNonQuery();
foreach (var course in Student.Courses)
{
course.StudentID = Student.StudentID;
DalCourse.Insert(true, course, _connection, _transaction);
}
_transaction.Commit();
_connection.Close();
}
catch (Exception ex)
{
_transaction.Rollback();
_connection.Close();
throw ex;
}
}
public static void Update(Student Student)
{
_command = new SqlCommand("update StudentList set StudentID = @StudentID, Name= @Name, Gender = @Gender, [Group] = @Group where SerialNo=@SerialNo");
_command.Parameters.AddWithValue("@StudentID", Student.StudentID);
_command.Parameters.AddWithValue("@Name", Student.Name);
_command.Parameters.AddWithValue("@Gender", Student.Gender);
_command.Parameters.AddWithValue("@Group", Student.Group);
_command.Parameters.AddWithValue("@SerialNo", Student.SerialNo);
try
{
_connection.Open();
_transaction = _connection.BeginTransaction();
_command.Connection = _connection;
_command.Transaction = _transaction;
_command.ExecuteNonQuery();
DalCourse.Delete(true, Student.StudentID, _connection, _transaction);
foreach (var course in Student.Courses)
{
DalCourse.Insert(true, course, _connection, _transaction);
}
_transaction.Commit();
_connection.Close();
}
catch (Exception ex)
{
_transaction.Rollback();
_connection.Close();
throw ex;
}
}
