public DataSet1 getUnits()
{
UnitsDataAccessor DA = new UnitsDataAccessor();
PositionDataAccessor DApos = new PositionDataAccessor();
DataSet1 dataSet1 = new DataSet1();
AbstractConnection absConnection = null;
AbstractTransaction absTransaction = null;
try
{
absConnection = DBFactory.createConnection();
absConnection.open();
absTransaction = absConnection.beginTransaction();
DA.Read(absConnection, absTransaction, dataSet1);
DApos.Read(absConnection, absTransaction, dataSet1);
absTransaction.commit();
}
catch (Exception e)
{
absTransaction.rollback();
}
finally
{
absConnection.close();
}
return(dataSet1);
}
public void updateMaterials(DataSet1 dataSet1)
{
MaterialDataAccessor DA = new MaterialDataAccessor();
PositionDataAccessor DApos = new PositionDataAccessor();
AbstractConnection absConnection = null;
AbstractTransaction absTransaction = null;
try
{
absConnection = DBFactory.createConnection();
absConnection.open();
absTransaction = absConnection.beginTransaction();
DA.Update(absConnection, absTransaction, dataSet1);
DApos.Update(absConnection, absTransaction, dataSet1);
absTransaction.commit();
}
catch (Exception e)
{
absTransaction.rollback();
}
finally
{
absConnection.close();
}
}
public void GetAll()
{
//Setup();
PositionDataAccessor daInvoice = new PositionDataAccessor();
DataSet1 dataSet1 = new DataSet1();
AbstractConnection connection = null;
AbstractTransaction transaction = null;
try
{
connection = DBFactory.createConnection();
connection.open();
transaction = connection.beginTransaction();
daInvoice.Read(connection, transaction, dataSet1);
transaction.commit();
}
catch (Exception e)
{
transaction.rollback();
}
finally
{
connection.close();
}
List <DataRow> list = dataSet1.position_in_mat_delivery_note.Select().OfType <DataRow>().ToList();
list.Sort((x, y) => ((int)x["id_"]).CompareTo((int)y["id_"])); //сортируем по ид
Assert.That(1, Is.EqualTo(1));
Assert.That(list.Count, Is.EqualTo(5));
Assert.That((int)(list[0]["id_"]), Is.EqualTo(1));
Assert.That((double)(list[0]["amount"]), Is.EqualTo(10));
Assert.That((int)(list[0]["invoice_id"]), Is.EqualTo(1));
}
public FullyQualifiedCarViewModel(CarbonFootprintPosition cfp, PositionDataAccessor positionDataAccessor, Func <string, TagColor> getColorForTag,
IEnumerable <ResponsibleSubjectViewModel> responsibleSubjects)
: base(cfp, getColorForTag, responsibleSubjects)
{
FullyQualifiedCarModel = (FullyQualifiedCar)cfp;
m_PositionDataAccessor = positionDataAccessor;
m_PositionDataAccessor.Loaded += CarDataLoaded;
if (m_PositionDataAccessor.CarData != null)
{
SetEntryData();
}
}
public AirportBasedFlightViewModel(CarbonFootprintPosition cfp, PositionDataAccessor positionDataAccessor, Func <string, TagColor> getColorForTag,
IEnumerable <ResponsibleSubjectViewModel> responsibleSubjects)
: base(cfp, getColorForTag, responsibleSubjects)
{
m_Model = (AirportBasedFlight)cfp;
m_PositionDataAccessor = positionDataAccessor;
m_PositionDataAccessor.Loaded += AirportDataLoaded;
if (m_PositionDataAccessor.AirportData != null)
{
GlobalAirports = m_PositionDataAccessor.AirportData;
}
}
public GeoLocatedPublicTransportViewModel(GeoLocatedPublicTransport cfp, PositionDataAccessor positionDataAccessor, Func <string, TagColor> getColorForTag,
IEnumerable <ResponsibleSubjectViewModel> responsibleSubjects)
: base(cfp, getColorForTag, responsibleSubjects)
{
GeoLocatedPublicTransportModel = cfp;
}
public GeoLocatedPublicTransportFactory(PositionDataAccessor positionDataAccessor, [Import] Func <string, TagColor> getColorForTag)
{
m_PositionDataAccessor = positionDataAccessor;
m_GetColorForTag = getColorForTag;
}
public FullyQualifiedCarFactory(PositionDataAccessor positionDataAccessor, [Import] Func <string, TagColor> getColorForTag)
{
m_PositionDataAccessor = positionDataAccessor;
m_GetColorForTag = getColorForTag;
}
public AirportBasedFlightFactory(PositionDataAccessor positionDataAccessor, [Import] Func <string, TagColor> getColorForTag)
{
m_PositionDataAccessor = positionDataAccessor;
m_GetColorForTag = getColorForTag;
}
