private static Collection <Person> Read(OracleDataReader reader) { Collection <Person> People = new Collection <Person>(); while (reader.Read()) { int i = -1; Person m = new Person(); m.Id = reader.GetInt32(++i); m.First_Name = reader.GetString(++i); m.Last_Name = reader.GetString(++i); if (!reader.IsDBNull(++i)) { m.Birth_Date = reader.GetInt32(i); } if (!reader.IsDBNull(++i)) { m.Role = reader.GetString(i); } Game g = new Game(); g.Id = reader.GetInt32(++i); g = GameTable.SelectOne(g.Id); m.Game_Id = g; Team t = new Team(); t.Id = reader.GetInt32(++i); t = TeamTable.SelectOne(t.Id); m.Team_Id = t; People.Add(m); } return(People); }
public static int ZmenitHru(Team t, int gID, DatabaseT pDb = null) { DatabaseT db; if (pDb == null) { db = new DatabaseT(); db.Connect(); } else { db = (DatabaseT)pDb; } db.BeginTransaction(); if (SelectOne(t.Id) == null) { db.Rollback(); return(-1); } if (GameTable.SelectOne(gID) == null) { db.Rollback(); return(-1); } try { PersonTable.UpdateGame(t.Id, gID); } catch (Exception e) { Console.WriteLine(e.Message); db.Rollback(); return(-1); } try { t.Game_Id = GameTable.SelectOne(gID); Update(t); } catch (Exception e) { Console.WriteLine(e.Message); db.Rollback(); return(-1); } OracleCommand command = db.CreateCommand(SQL_SELECT_COUNT); command.Parameters.AddWithValue(":gID", gID); OracleDataReader reader = db.Select(command); int res = ReadCount(reader); reader.Close(); db.EndTransaction(); if (pDb == null) { db.Close(); } return(res); }