public void Clear() { Quarterback.Clear(); Receivers.Clear(); Runningbacks.Clear(); OffensiveLinemen.Clear(); TightEnds.Clear(); Cornerbacks.Clear(); Linebackers.Clear(); DefensiveLinemen.Clear(); Safeties.Clear(); }
public static int SortData(List <string> data) { int id = 0; switch (data[3]) { case "QB": Quarterback QB = new Quarterback(); QB.Rank = data[0]; QB.Name = data[1]; QB.Team = data[2]; QB.Position = data[3]; QB.Completions = data[4]; QB.Attempts = data[5]; QB.Percentage = data[6]; QB.AttemptsPerGame = data[7]; QB.TotalYards = data[8]; QB.Average = data[9]; QB.AveragePerGame = data[10]; QB.Touchdowns = data[11]; QB.Interceptions = data[12]; id = QBService.InsertQB(QB); break; case "RB": Runningback RB = new Runningback(); RB.Rank = data[0]; RB.Name = data[1]; RB.Team = data[2]; RB.Position = data[3]; RB.Attempts = data[4]; RB.AttemptsPerGame = data[5]; RB.Yards = data[6]; RB.Average = data[7]; RB.YardsPerGame = data[8]; RB.Touchdowns = data[9]; RB.LongestRun = data[10]; RB.FirstDowns = data[11]; RB.FirstDownPercentage = data[12]; RB.Fumbles = data[15]; id = RBService.InsertRB(RB); break; } return(id); }
public void Init() { Quarterback.Add(new Lineup("QB")); for (int i = 1; i <= Max; i++) { Receivers.Add(new Lineup("WR" + i.ToString())); } for (int i = 1; i <= Max; i++) { Runningbacks.Add(new Lineup("RB" + i.ToString())); } for (int i = 1; i <= Max; i++) { OffensiveLinemen.Add(new Lineup("OL" + i.ToString())); } for (int i = 1; i <= Max; i++) { TightEnds.Add(new Lineup("TE" + i.ToString())); } for (int i = 1; i <= Max; i++) { Cornerbacks.Add(new Lineup("CB" + i.ToString())); } for (int i = 1; i <= Max; i++) { Linebackers.Add(new Lineup("LB" + i.ToString())); } for (int i = 1; i <= Max; i++) { DefensiveLinemen.Add(new Lineup("DL" + i.ToString())); } for (int i = 1; i <= Max; i++) { Safeties.Add(new Lineup("S" + i.ToString())); } }
public Lineup(Quarterback qb, RunningBack[] RBs, WideReceiver[] WRs, TightEnd te1, IFlex flex, Defense defense) { this.Quarterback = qb; this.RunningBack1 = RBs[0]; this.RunningBack2 = RBs[1]; this.RunningBacks = RBs; this.WideReceivers = WRs; this.WideReceiver1 = WRs[0]; this.WideReceiver2 = WRs[1]; this.WideReceiver3 = WRs[2]; this.TightEnd = te1; this.Flex = flex; this.Defense = defense; this.Id = Guid.NewGuid(); // populate list of players this.Players = new List <IPlayer> { qb, RBs[0], RBs[1], WRs[0], WRs[1], WRs[2], te1, flex, defense }; this.PlayerIDs = this.Players.Select(p => p.Id).ToList(); // generate total projection this.Projection = this.Players.Sum(x => x.Projection); // generate total salary this.Salary = this.Players.Sum(p => p.Salary); }
public static List <Quarterback> GetQBs() { List <Quarterback> qblist = new List <Quarterback>(); string connString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; using (SqlConnection sqlConn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand("Get_QBs", sqlConn)) { sqlConn.Open(); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { int i = 0; Quarterback q = new Quarterback(); q.Id = reader.GetInt32(i++); q.Rank = reader.GetString(i++); q.Name = reader.GetString(i++); q.Team = reader.GetString(i++); q.Position = reader.GetString(i++); q.Completions = reader.GetString(i++); q.Attempts = reader.GetString(i++); q.Percentage = reader.GetString(i++); q.AttemptsPerGame = reader.GetString(i++); q.TotalYards = reader.GetString(i++); q.Average = reader.GetString(i++); q.AveragePerGame = reader.GetString(i++); q.Touchdowns = reader.GetString(i++); q.Interceptions = reader.GetString(i++); qblist.Add(q); } } } return(qblist); }
public Lineup(Quarterback qb, RunningBack rb1, RunningBack rb2, WideReceiver wr1, WideReceiver wr2, WideReceiver wr3, TightEnd te1, IFlex flex, Defense defense, List <Player> players) { this.Quarterback = qb; this.RunningBack1 = rb1; this.RunningBack1 = rb2; this.WideReceiver1 = wr1; this.WideReceiver2 = wr2; this.WideReceiver3 = wr3; this.TightEnd = te1; this.Flex = flex; this.Defense = defense; // build out lineup this.Players = players; // generate total projection this.Projection = this.Players.Sum(p => p.Projection); // generate total salary this.Salary = this.Players.Sum(p => p.Salary); }
public static int InsertQB(Quarterback payload) { int Id = 0; string connString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; using (SqlConnection sqlConn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand("Insert_Quarterback", sqlConn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Rank", payload.Rank); cmd.Parameters.AddWithValue("@Name", payload.Name); cmd.Parameters.AddWithValue("@Team", payload.Team); cmd.Parameters.AddWithValue("@Position", payload.Position); cmd.Parameters.AddWithValue("@Completions", payload.Completions); cmd.Parameters.AddWithValue("@Attempts", payload.Attempts); cmd.Parameters.AddWithValue("@Percentage", payload.Percentage); cmd.Parameters.AddWithValue("@AttemptsPerGame", payload.AttemptsPerGame); cmd.Parameters.AddWithValue("@TotalYards", payload.TotalYards); cmd.Parameters.AddWithValue("@Average", payload.Average); cmd.Parameters.AddWithValue("@AveragePerGame", payload.AveragePerGame); cmd.Parameters.AddWithValue("@Touchdowns", payload.Touchdowns); cmd.Parameters.AddWithValue("@Interceptions", payload.Interceptions); SqlParameter outPut = cmd.Parameters.Add("@ID", SqlDbType.Int); outPut.Direction = ParameterDirection.Output; sqlConn.Open(); cmd.ExecuteNonQuery(); Id = Convert.ToInt32(outPut.Value); } return(Id); } }
public QuarterbackService( Quarterback quarterback ) { _quarterback = quarterback; }
public void Load(string strFile) { this.Clear(); if (System.IO.File.Exists(strFile)) { XDocument doc = XDocument.Load(strFile); XElement elem = doc.Descendants("Position").First(f => f.Attribute("Name").Value == "QB"); Quarterback.Load(elem); allPositions.Add(Quarterback); offensivePositions.Add(Quarterback); IEnumerable <XElement> elems = doc.Descendants("Positions"); IEnumerable <XElement> posElems = elems.First(f => f.Attribute("Name").Value == "Receivers").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); Receivers.Add(pos); } allPositions.AddRange(Receivers); offensivePositions.AddRange(receivers); posElems = elems.First(f => f.Attribute("Name").Value == "Runningbacks").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); Runningbacks.Add(pos); } allPositions.AddRange(Runningbacks); offensivePositions.AddRange(Runningbacks); posElems = elems.First(f => f.Attribute("Name").Value == "OffensiveLinemen").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); OffensiveLinemen.Add(pos); } allPositions.AddRange(OffensiveLinemen); offensivePositions.AddRange(OffensiveLinemen); posElems = elems.First(f => f.Attribute("Name").Value == "TightEnds").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); TightEnds.Add(pos); } allPositions.AddRange(TightEnds); offensivePositions.AddRange(TightEnds); posElems = elems.First(f => f.Attribute("Name").Value == "Cornerbacks").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); Cornerbacks.Add(pos); } allPositions.AddRange(Cornerbacks); defensivePositions.AddRange(Cornerbacks); posElems = elems.First(f => f.Attribute("Name").Value == "Linebackers").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); Linebackers.Add(pos); } allPositions.AddRange(Linebackers); defensivePositions.AddRange(Linebackers); posElems = elems.First(f => f.Attribute("Name").Value == "DefensiveLinemen").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); DefensiveLinemen.Add(pos); } allPositions.AddRange(DefensiveLinemen); defensivePositions.AddRange(DefensiveLinemen); posElems = elems.First(f => f.Attribute("Name").Value == "Safeties").Elements(); foreach (XElement e in posElems) { Position pos = new Position(); pos.Load(e); Safeties.Add(pos); } allPositions.AddRange(Safeties); defensivePositions.AddRange(Safeties); } else { this.Init(); } }
public void Save(string strFile) { XDocument doc = new XDocument(); XDeclaration declare = new XDeclaration("1.0", "utf-8", "true"); doc.Declaration = declare; XElement rootElem = new XElement("PersonnelSetting"); Quarterback.Save(rootElem); XElement elem = new XElement("Positions"); XAttribute atrri = new XAttribute("Name", "Receivers"); elem.Add(atrri); foreach (Position pos in Receivers) { pos.Save(elem); } rootElem.Add(elem); elem = new XElement("Positions"); atrri = new XAttribute("Name", "Runningbacks"); elem.Add(atrri); foreach (Position pos in Runningbacks) { pos.Save(elem); } rootElem.Add(elem); elem = new XElement("Positions"); atrri = new XAttribute("Name", "OffensiveLinemen"); elem.Add(atrri); foreach (Position pos in OffensiveLinemen) { pos.Save(elem); } rootElem.Add(elem); elem = new XElement("Positions"); atrri = new XAttribute("Name", "TightEnds"); elem.Add(atrri); foreach (Position pos in TightEnds) { pos.Save(elem); } rootElem.Add(elem); elem = new XElement("Positions"); atrri = new XAttribute("Name", "Cornerbacks"); elem.Add(atrri); foreach (Position pos in Cornerbacks) { pos.Save(elem); } rootElem.Add(elem); elem = new XElement("Positions"); atrri = new XAttribute("Name", "Linebackers"); elem.Add(atrri); foreach (Position pos in Linebackers) { pos.Save(elem); } rootElem.Add(elem); elem = new XElement("Positions"); atrri = new XAttribute("Name", "DefensiveLinemen"); elem.Add(atrri); foreach (Position pos in DefensiveLinemen) { pos.Save(elem); } rootElem.Add(elem); elem = new XElement("Positions"); atrri = new XAttribute("Name", "Safeties"); elem.Add(atrri); foreach (Position pos in Safeties) { pos.Save(elem); } rootElem.Add(elem); doc.Add(rootElem); doc.Save(strFile); }
public void LoadLineup(string strFile) { this.Clear(); if (System.IO.File.Exists(strFile)) { XDocument doc = XDocument.Load(strFile); IEnumerable <XElement> elem = doc.Descendants("Position"); IEnumerable <XElement> posElems = elem.First(f => f.Attribute("Name").Value == "Quarterback").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.Load(e); pos.LoadLineup(e); Quarterback.Add(pos); } IEnumerable <XElement> elems = doc.Descendants("Positions"); posElems = elems.First(f => f.Attribute("Name").Value == "Receivers").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); Receivers.Add(pos); } posElems = elems.First(f => f.Attribute("Name").Value == "Runningbacks").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); Runningbacks.Add(pos); } posElems = elems.First(f => f.Attribute("Name").Value == "OffensiveLinemen").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); OffensiveLinemen.Add(pos); } posElems = elems.First(f => f.Attribute("Name").Value == "TightEnds").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); TightEnds.Add(pos); } posElems = elems.First(f => f.Attribute("Name").Value == "Cornerbacks").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); Cornerbacks.Add(pos); } posElems = elems.First(f => f.Attribute("Name").Value == "Linebackers").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); Linebackers.Add(pos); } posElems = elems.First(f => f.Attribute("Name").Value == "DefensiveLinemen").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); DefensiveLinemen.Add(pos); } posElems = elems.First(f => f.Attribute("Name").Value == "Safeties").Elements(); foreach (XElement e in posElems) { Lineup pos = new Lineup(); pos.LoadLineup(e); Safeties.Add(pos); } } else { this.Init(); } }