public StatDomainModel InsertStat(StatDomainModel stat)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cStat = new Stat
{
StatName = stat.StatName,
PositionTypeID = stat.PositionTypeID
};
context.Stats.Add(_cStat);
context.SaveChanges();
// pass TeamID back to BLL
stat.StatID = _cStat.StatID;
return(stat);
}
}
public StatDomainModel InsertStat(StatDomainModel stat)
{
return(dal.InsertStat(stat));
}
public static void HandlePitcher(List <clsPitcher> colPitchers)
{
PlayerBusinessLogic pBLL = new PlayerBusinessLogic();
PlayerDomainModel player = new PlayerDomainModel();
PlayerPostiionBusinessLogic ppBLL = new PlayerPostiionBusinessLogic();
PlayerPositionDomainModel playerposition = new PlayerPositionDomainModel();
StatBusinessLogic sBLL = new StatBusinessLogic();
StatDomainModel stat = new StatDomainModel();
SeasonPlayerPositionStatBusinessLogic sppsBLL = new SeasonPlayerPositionStatBusinessLogic();
SeasonPlayerPositionStatDomainModel statValue = new SeasonPlayerPositionStatDomainModel();
SeasonPlayerBusinessLogic spBLL = new SeasonPlayerBusinessLogic();
SeasonPlayerDomainModel spDM = new SeasonPlayerDomainModel();
statValue.SeasonID = C_SeasonID;
statValue.PlayerGUID = player.PlayerGUID;
sppsBLL.DeleteAllStatsForPlayer(statValue);
foreach (clsPitcher cPitcher in colPitchers)
{
player.PlayerName = cPitcher.FirstName.Trim() + " " + cPitcher.LastName.Trim();
pBLL.InsertPlayer(player);
playerposition.PlayerGUID = player.PlayerGUID;
playerposition.PrimaryPositionID = TransformPos(cPitcher.Pos);
playerposition.SecondaryPostiionID = null;
ppBLL.DeletePlayerPosition(playerposition);
ppBLL.InsertPlayerPosition(playerposition);
spDM.PlayerGUID = player.PlayerGUID;
spDM.SeasonID = C_SeasonID;
spBLL.InsertSeasonPlayer(spDM);
BindingFlags flags = BindingFlags.Instance |
BindingFlags.Public | BindingFlags.NonPublic;
foreach (FieldInfo f in cPitcher.GetType().GetFields(flags))
{
Console.WriteLine("{0} = {1}", f.Name, f.GetValue(cPitcher));
System.Diagnostics.Debug.WriteLine("{0} = {1}", f.Name, f.GetValue(cPitcher));
string fieldName = _getBackingFieldName(f.Name.ToUpper());
if (fieldName != "FIRSTNAME" &&
fieldName != "LASTNAME" &&
fieldName != "PT" &&
fieldName != "POS")
{
stat.StatName = fieldName;
stat.PositionTypeID = 2; // 1 = hitter
stat = sBLL.InsertStat(stat);
statValue.SeasonID = C_SeasonID;
statValue.PlayerGUID = player.PlayerGUID;
statValue.PositionID = TransformPos(cPitcher.Pos);
statValue.StatID = stat.StatID;
if (f.GetValue(cPitcher) == null)
{
statValue.StatValue = null;
}
else
{
statValue.StatValue = f.GetValue(cPitcher).ToString();
}
sppsBLL.InsertStatValue(statValue);
}
}
}
}
