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