public IEnumerable <Ruta> FindAll() { List <Ruta> list = new List <Ruta>(); using (IDbConnection connection = database.CreateOpenConnection()) { IDbTransaction tran = connection.BeginTransaction(); using (IDbCommand command = database.CreateStoredProcCommand("SelectAllRoutes", connection)) { try { command.Connection = connection; command.Transaction = tran; using (IDataReader reader = command.ExecuteReader()) { while (reader.Read()) { IPutniNalogRepository putnirepo = new PutniNalogRepository(); PutniNalog putninalog = putnirepo.FindById(reader.GetInt32(1)); Ruta temp = new Ruta { IDRuta = reader.GetInt32(0), PutniNalog = putninalog, Vrijeme = reader.GetDateTime(2), ACoordX = reader.GetInt32(3), ACoordY = reader.GetInt32(4), BCoordX = reader.GetInt32(5), BCoordY = reader.GetInt32(6), PrijedeniKM = reader.GetDouble(7), ProsjecniKMH = reader.GetDouble(8), PotrosenoGorivoLitre = reader.GetDouble(9) }; list.Add(temp); } } tran.Commit(); } catch (Exception ex) { try { tran.Rollback(); } catch (Exception ex2) { throw; } } } } return(list.AsEnumerable()); }
public Ruta FindById(int id) { Ruta temp = null; using (IDbConnection connection = database.CreateOpenConnection()) { IDbTransaction tran = connection.BeginTransaction(); using (IDbCommand command = database.CreateStoredProcCommand("FindRoute", connection)) { try { command.Connection = connection; command.Transaction = tran; command.Parameters.Add(database.CreateParameter("pID", id)); using (IDataReader reader = command.ExecuteReader()) { while (reader.Read()) { IPutniNalogRepository putnirepo = new PutniNalogRepository(); PutniNalog putninalog = putnirepo.FindById(reader.GetInt32(1)); temp = new Ruta { IDRuta = reader.GetInt32(0), PutniNalog = putninalog, Vrijeme = reader.GetDateTime(2), ACoordX = reader.GetInt32(3), ACoordY = reader.GetInt32(4), BCoordX = reader.GetInt32(5), BCoordY = reader.GetInt32(6), PrijedeniKM = reader.GetDouble(7), ProsjecniKMH = reader.GetDouble(8), PotrosenoGorivoLitre = reader.GetDouble(9) }; } } tran.Commit(); } catch (Exception ex) { try { tran.Rollback(); } catch (Exception ex2) { throw; } } } } return(temp); }
public IEnumerable <KupnjaGoriva> FindAll() { List <KupnjaGoriva> list = new List <KupnjaGoriva>(); using (IDbConnection connection = database.CreateOpenConnection()) { IDbTransaction tran = connection.BeginTransaction(); using (IDbCommand command = database.CreateStoredProcCommand("SelectAllFuelBuying", connection)) { try { command.Connection = connection; command.Transaction = tran; using (IDataReader reader = command.ExecuteReader()) { while (reader.Read()) { IPutniNalogRepository putrepo = new PutniNalogRepository(); PutniNalog putniNalog = putrepo.FindById(reader.GetInt32(1)); KupnjaGoriva temp = new KupnjaGoriva { IDKupnjaGoriva = reader.GetInt32(0), Lokacija = reader.GetString(2), GorivoPoLitri = reader.GetFloat(3), CijenaPoLitri = reader.GetFloat(4), PutniNalog = putniNalog }; list.Add(temp); } } tran.Commit(); } catch (Exception ex) { try { tran.Rollback(); } catch (Exception ex2) { throw; } } } } return(list.AsEnumerable()); }
public KupnjaGoriva FindById(int id) { KupnjaGoriva temp = null; using (IDbConnection connection = database.CreateOpenConnection()) { IDbTransaction tran = connection.BeginTransaction(); using (IDbCommand command = database.CreateStoredProcCommand("FindFuelBuyingByID", connection)) { try { command.Connection = connection; command.Transaction = tran; command.Parameters.Add(database.CreateParameter("pID", id)); using (IDataReader reader = command.ExecuteReader()) { while (reader.Read()) { IPutniNalogRepository putrepo = new PutniNalogRepository(); PutniNalog putniNalog = putrepo.FindById(reader.GetInt32(1)); temp = new KupnjaGoriva { IDKupnjaGoriva = reader.GetInt32(0), Lokacija = reader.GetString(2), GorivoPoLitri = reader.GetFloat(3), CijenaPoLitri = reader.GetFloat(4), PutniNalog = putniNalog }; } } tran.Commit(); } catch (Exception ex) { try { tran.Rollback(); } catch (Exception ex2) { throw; } } } } return(temp); }