public static List <Nhl_Draftbook> UpdateDraftbook(string fileName, [Optional] bool saveToDb)
{
if (!File.Exists(fileName))
{
Console.WriteLine("File does not exist: {0}", fileName);
return(null);
}
List <Nhl_Draftbook> results = new List <Nhl_Draftbook>();
string[] lines = File.ReadAllLines(fileName);
for (int i = 1; i < lines.Length; i++) // start at 1 and skip the first line of headers
{
Nhl_Draftbook result = NhlDraftbook.ParseLine(lines[i]);
if (null != result)
{
results.Add(result);
}
}
if (saveToDb == true)
{
NhlDraftbook.AddOrUpdateDb(results);
}
return(results);
}
/// <summary>
/// Parse a csv line and return it as a NhlDraftBookModel
/// </summary>
private static Nhl_Draftbook ParseLine(string line)
{
string[] fields = line.Split(',');
int expectedNumFields = 12;
if (fields.Length != expectedNumFields)
{
Console.WriteLine("Expected {0} columns in line {1}", expectedNumFields, line);
return(null);
}
Nhl_Draftbook model = new Nhl_Draftbook();
model.Year = NhlBaseClass.ConvertStringToInt(fields[0]);
model.Round = NhlBaseClass.ConvertStringToInt(fields[1]);
model.Pick = NhlBaseClass.ConvertStringToInt(fields[2]);
model.Overall = NhlBaseClass.ConvertStringToInt(fields[3]);
model.Team = fields[4];
model.Name = fields[5];
model.Position = fields[6];
model.POB = fields[7];
string height = fields[8];
height = height.Replace(@"""", String.Empty).Replace(" ", String.Empty);
string[] heightParts = height.Split('\'');
if (heightParts.Length != 2)
{
model.HeightInches = 0;
}
else
{
model.HeightInches = NhlBaseClass.ConvertStringToInt(heightParts[0]) * 12 + NhlBaseClass.ConvertStringToInt(heightParts[1]);
}
model.WeightLbs = NhlBaseClass.ConvertStringToInt(fields[9]);
model.AmateurLeague = fields[10];
model.AmateurTeam = fields[11];
return(model);
}