public Player GetPlayerByPlayerId(int playerId)
{
var results = new Player();
using (var context = new LO30Context())
{
results = context.Players
.Where(x => x.PlayerId == playerId)
.IncludeAll()
.SingleOrDefault();
}
return results;
}
public ImportStat ImportPlayers()
{
string table = "Players";
var iStat = new ImportStat(_logger, table);
if (_seed && _context.Players.Count() == 0)
{
_logger.Write("Importing " + table);
var player = new Player()
{
PlayerId = 0,
FirstName = "Unknown",
LastName = "Player",
Suffix = null,
PreferredPosition = "X",
Shoots = "X",
BirthDate = DateTime.Parse("1/1/1970"),
Profession = null,
WifesName = null
};
_lo30ContextService.SaveOrUpdatePlayer(player);
dynamic parsedJson = _jsonFileService.ParseObjectFromJsonFile(_folderPath + "Players.json");
int count = parsedJson.Count;
int countSaveOrUpdated = 0;
_logger.Write("SaveOrUpdatePlayers: Access records to process:" + count);
for (var d = 0; d < parsedJson.Count; d++)
{
if (d % 100 == 0) { _logger.Write("SaveOrUpdatePlayers: Access records processed:" + d + ". Records saved or updated:" + countSaveOrUpdated); }
var json = parsedJson[d];
int playerId = json["PLAYER_ID"];
string firstName = json["PLAYER_FIRST_NAME"];
if (string.IsNullOrWhiteSpace(firstName))
{
firstName = "_";
};
string lastName = json["PLAYER_LAST_NAME"];
if (string.IsNullOrWhiteSpace(lastName))
{
lastName = "_";
};
string position, positionMapped;
position = json["PLAYER_POSITION"];
if (string.IsNullOrWhiteSpace(position))
{
position = "X";
}
switch (position.ToLower())
{
case "f":
case "forward":
positionMapped = "F";
break;
case "d":
case "defense":
positionMapped = "D";
break;
case "g":
case "goal":
case "goalie":
positionMapped = "G";
break;
default:
positionMapped = "X";
break;
}
string shoots, shootsMapped;
shoots = json["SHOOTS"];
if (string.IsNullOrWhiteSpace(shoots))
{
shoots = "X";
}
switch (shoots.ToLower())
{
case "l":
shootsMapped = "L";
break;
case "r":
shootsMapped = "R";
break;
default:
shootsMapped = "X";
break;
}
DateTime? birthDate = null;
if (json["BIRTHDATE"] != null)
{
birthDate = json["BIRTHDATE"];
}
player = new Player()
{
PlayerId = playerId,
FirstName = firstName,
LastName = lastName,
Suffix = json["PLAYER_SUFFIX"],
PreferredPosition = positionMapped,
Shoots = shootsMapped,
BirthDate = birthDate,
Profession = json["PROFESSION"],
WifesName = json["WIFES_NAME"]
};
countSaveOrUpdated = countSaveOrUpdated + _lo30ContextService.SaveOrUpdatePlayer(player);
}
iStat.Imported();
ContextSaveChanges();
iStat.Saved(_context.Players.Count());
}
else
{
_logger.Write(table + " records exist in context; not importing");
iStat.Imported();
iStat.Saved(0);
}
iStat.Log();
return iStat;
}
