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