public static List<LegaGladio.Entities.Team> listTeam(Boolean active) { LegaGladioDS.teamDataTable tdt = new LegaGladioDS.teamDataTable(); LegaGladioDSTableAdapters.teamTableAdapter tta = new LegaGladioDSTableAdapters.teamTableAdapter(); tta.FillByActive(tdt, active); List<LegaGladio.Entities.Team> teamList = new List<LegaGladio.Entities.Team>(); foreach (LegaGladioDS.teamRow tr in tdt.Rows) { try { LegaGladio.Entities.Team team = new LegaGladio.Entities.Team(); team.Id = tr.id; team.AssistantCoach = tr.assistantCoach; team.Cheerleader = tr.cheerleader; team.coachName = Coach.getCoachName(team.Id); //team.ListPlayer = Player.listPlayer(team.Id); team.Name = tr.name; team.Race = Race.getRaceByTeamId(team.Id); team.Reroll = tr.reroll; team.Value = tr.value; team.Active = tr.active; teamList.Add(team); } catch(Exception ex) { Console.WriteLine(ex.StackTrace); } } tta = null; tdt = null; return teamList; }
public static List<LegaGladio.Entities.Team> listTeam(int coachId) { LegaGladioDS.teamDataTable tdt = new LegaGladioDS.teamDataTable(); LegaGladioDSTableAdapters.teamTableAdapter tta = new LegaGladioDSTableAdapters.teamTableAdapter(); tta.FillByCoachId(tdt, coachId); List<LegaGladio.Entities.Team> teamList = new List<LegaGladio.Entities.Team>(); foreach (LegaGladioDS.teamRow tr in tdt.Rows) { LegaGladio.Entities.Team team = new LegaGladio.Entities.Team(); team.Id = tr.id; team.AssistantCoach = tr.assistantCoach; team.Cheerleader = tr.cheerleader; team.coachName = Coach.getCoachName(team.Id); //team.ListPlayer = Player.listPlayer(team.Id); team.Name = tr.name; team.Race = Race.getRaceByTeamId(team.Id); team.Reroll = tr.reroll; team.Value = tr.value; team.Active = tr.active; teamList.Add(team); } tta = null; tdt = null; return teamList; }
public static int countTeam() { LegaGladioDSTableAdapters.teamTableAdapter tta = new LegaGladioDSTableAdapters.teamTableAdapter(); int count = (int)tta.Count(); tta = null; return count; }
public static Boolean updateTeam(LegaGladio.Entities.Team team, int oldID) { LegaGladioDSTableAdapters.teamTableAdapter tta = new LegaGladioDSTableAdapters.teamTableAdapter(); LegaGladioDS.teamDataTable tdt = new LegaGladioDS.teamDataTable(); LegaGladioDS.teamRow tr = (LegaGladioDS.teamRow)tdt.NewRow(); tr.id = oldID; tr.name = team.Name; tr.value = team.Value; tr.funFactor = team.FunFactor; tr.reroll = team.Reroll; tr.hasMedic = team.HasMedic; tr.cheerleader = team.Cheerleader; tr.assistantCoach = team.AssistantCoach; tr.active = team.Active; int result = tta.Update(tr); return result > 0; }
public static Boolean newTeam(LegaGladio.Entities.Team team) { LegaGladioDSTableAdapters.teamTableAdapter tta = new LegaGladioDSTableAdapters.teamTableAdapter(); //value, name, funFactor, reroll, hasMedic, cheerleader, assistantCoach, active int result = tta.Insert(team.Value, team.Name, team.FunFactor, team.Reroll, (byte)(team.HasMedic ? 1 : 0), team.Cheerleader, team.AssistantCoach, (byte)(team.Active? 1 : 0)); tta = null; return result > 0; }
public static LegaGladio.Entities.Team getTeam(int id) { LegaGladio.Entities.Team team = null; LegaGladioDS.teamDataTable ttd = null; LegaGladioDSTableAdapters.teamTableAdapter tta = null; LegaGladioDS.teamRow teamRow = null; try { team = new LegaGladio.Entities.Team(); ttd = new LegaGladioDS.teamDataTable(); tta = new LegaGladioDSTableAdapters.teamTableAdapter(); tta.FillById(ttd, id); teamRow = (LegaGladioDS.teamRow)ttd.Rows[0]; team.Id = teamRow.id; team.AssistantCoach = teamRow.assistantCoach; team.Cheerleader = teamRow.cheerleader; team.coachName = Coach.getCoachName(team.Id); team.ListPlayer = Player.listPlayer(team.Id); team.Name = teamRow.name; team.Race = Race.getRace(team.Id); team.Reroll = teamRow.reroll; team.Active = teamRow.active; team.Value = teamRow.value; } catch (Exception ex) { throw ex; } tta = null; ttd = null; return team; }