private void write(IDataAccessor da) { bool exx = false; AbstractConnection connection = null; AbstractTransaction transaction = null; try { connection = DBFactory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); da.Update(connection, transaction, dataSet); transaction.Commit(); } catch (Exception e) { Console.WriteLine(e.Message); exx = true; transaction.Rollback(); } finally { connection.Close(); } Assert.IsFalse(exx, "Exceptions not throwed"); }
private void read(IDataAccessor da) { bool exx = false; AbstractConnection connection = null; AbstractTransaction transaction = null; dataSet = new UPrintDataSet(); try { connection = DBFactory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); da.Read(connection, transaction, dataSet); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); } finally { connection.Close(); } Assert.IsFalse(exx, "Exceptions not throwed"); }
public TouristDataSet WriteSight(TouristDataSet dataSet) { using (AbstractConnection abstractConnection = ConnectionFactory.CreateConnection()) { abstractConnection.Open(); AbstractTransaction abstractTransaction = abstractConnection.BeginTransaction(); try { tourDataAccessor.WriteData(abstractTransaction, abstractConnection, dataSet); sightDataAccessor.WriteData(abstractTransaction, abstractConnection, dataSet); abstractTransaction.Commit(); } catch (Exception e) { abstractTransaction.Rollback(); throw e; } } return(dataSet); }
/** * Методы для класса Schedule */ public TouristDataSet ReadSchedule() { TouristDataSet dataSet = new TouristDataSet(); using (AbstractConnection abstractConnection = ConnectionFactory.CreateConnection()) { abstractConnection.Open(); AbstractTransaction abstractTransaction = abstractConnection.BeginTransaction(); try { instructorDataAccessor.ReadData(abstractTransaction, abstractConnection, dataSet); tourDataAccessor.ReadData(abstractTransaction, abstractConnection, dataSet); scheduleDataAccessor.ReadData(abstractTransaction, abstractConnection, dataSet); abstractTransaction.Commit(); } catch (Exception e) { abstractTransaction.Rollback(); throw e; } } return(dataSet); }
private void read(IDataAccessor da) { AbstractConnection connection = null; AbstractTransaction transaction = null; dataSet = new UPrintDataSet(); try { connection = DBFactory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); da.Read(connection, transaction, dataSet); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); } finally { connection.Close(); } }