protected void addD2AToBD(D2A d2a)
{
using (var adapter = new SqlDataAdapter())
{
DataTable d2aTable = TableInit.D2AInit();
DataRow dr = TableInit.D2AAddRow(d2aTable, d2a);
d2aTable.Rows.Add(dr);
adapter.InsertCommand = QueryGenerator.D2AGenerateInsertQuery(ConfigurationManager.ConnectionStrings["tpDb"].ConnectionString);
adapter.Update(d2aTable);
}
}
public static List <D2A> GetD2As(string connectionString, SqlDataAdapter adapter, List <Car> carList, List <Driver> driverList)
{
List <D2A> d2al = new List <D2A>();
DataTable Table = TableInit.D2AInit();
adapter.SelectCommand = QueryGenerator.GenerateSelectQuery("Drivers2Auto", connectionString);
adapter.Fill(Table);
foreach (DataRow row in Table.Rows)
{
d2al.Add(TableInit.D2AGetRow(row, carList, driverList));
}
return(d2al);
}
