public static void AddEventToDb(int eventTypeId, int teamId, int matchId, int value, sakilaEntities4 db)
{
var newEv = new matchevent();
newEv.EventTypeID = eventTypeId;
newEv.TeamID = teamId;
newEv.eventvalue = value;
newEv.MatchID = matchId;
db.matchevent.Add(newEv);
db.SaveChanges();
}
public static void AddOffsidesDetailsToDb(DataObjects.MatchDetails match, sakilaEntities4 db, int homeTeamID, int awayTeamID)
{
//2
var homeEv = new matchevent();
homeEv.EventTypeID = 2;
homeEv.TeamID = homeTeamID;
homeEv.eventvalue = match.HomeTeam.Offsides;
homeEv.MatchID = match.MatchID;
var awayEv = new matchevent();
awayEv.EventTypeID = 2;
awayEv.TeamID = awayTeamID;
awayEv.eventvalue = match.AwayTeam.Offsides;
awayEv.MatchID = match.MatchID;
db.matchevent.Add(homeEv);
db.matchevent.Add(awayEv);
db.SaveChanges();
}
public static void AddShotsDetailsToDb(DataObjects.MatchDetails match, sakilaEntities4 db, int homeTeamID, int awayTeamID)
{
var homeEv = new matchevent();
homeEv.EventTypeID = 5;
homeEv.TeamID = homeTeamID;
homeEv.eventvalue = match.HomeTeam.OnTarget;
homeEv.MatchID = match.MatchID;
var awayEv = new matchevent();
awayEv.EventTypeID = 5;
awayEv.TeamID = awayTeamID;
awayEv.eventvalue = match.AwayTeam.OnTarget;
awayEv.MatchID = match.MatchID;
var homeEv2 = new matchevent();
homeEv2.EventTypeID = 6;
homeEv2.TeamID = homeTeamID;
homeEv2.eventvalue = match.HomeTeam.OffTarget;
homeEv2.MatchID = match.MatchID;
var awayEv2 = new matchevent();
awayEv2.EventTypeID = 6;
awayEv2.TeamID = awayTeamID;
awayEv2.eventvalue = match.AwayTeam.OffTarget;
awayEv2.MatchID = match.MatchID;
db.matchevent.Add(homeEv);
db.matchevent.Add(homeEv2);
db.matchevent.Add(homeEv);
db.matchevent.Add(awayEv2);
db.SaveChanges();
}