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