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();
}
}
