public static LegaGladio.Entities.Race getRaceByTeamId(int id) { LegaGladio.Entities.Race race = null; LegaGladioDS.raceDataTable rdt = null; LegaGladioDSTableAdapters.raceTableAdapter rta = null; LegaGladioDS.raceRow raceRow = null; try { rdt = new LegaGladioDS.raceDataTable(); rta = new LegaGladioDSTableAdapters.raceTableAdapter(); rta.FillByTeamId(rdt, id); if(rdt.Rows.Count > 0) { race = new LegaGladio.Entities.Race(); raceRow = (LegaGladioDS.raceRow)rdt.Rows[0]; race.Id = (int)raceRow.id; race.Name = raceRow.name; } } catch(Exception ex) { rdt.GetErrors(); throw ex; } finally { rta = null; rdt = null; } return race; }
public static List<LegaGladio.Entities.Race> listRace() { LegaGladioDS.raceDataTable rdt = new LegaGladioDS.raceDataTable(); LegaGladioDSTableAdapters.raceTableAdapter rta = new LegaGladioDSTableAdapters.raceTableAdapter(); rta.Fill(rdt); List<LegaGladio.Entities.Race> raceList = new List<LegaGladio.Entities.Race>(); foreach (LegaGladioDS.raceRow raceRow in rdt.Rows) { LegaGladio.Entities.Race race = new LegaGladio.Entities.Race(); race.Id = (int)raceRow.id; race.Name = raceRow.name; raceList.Add(race); } rta = null; rdt = null; return raceList; }
public static Boolean updateRace(LegaGladio.Entities.Race race, int oldID) { LegaGladioDSTableAdapters.raceTableAdapter rta = new LegaGladioDSTableAdapters.raceTableAdapter(); LegaGladioDS.raceDataTable rdt = new LegaGladioDS.raceDataTable(); LegaGladioDS.raceRow rr = (LegaGladioDS.raceRow)rdt.NewRow(); rr.id = oldID; rr.name = race.Name; int result = rta.Update(rr); return result > 0; }