public void UptadeMatchup(MatchUpModel model) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(db))) { var p = new DynamicParameters(); p.Add("@Id", model.Id); p.Add("@WinnerId", model.Winner.Id); connection.Execute("dbo.spMatchups_Update", p, commandType: CommandType.StoredProcedure); foreach (MatchUpEntryModel me in model.Entries) { p = new DynamicParameters(); p.Add("@Id", me.Id); p.Add("@TeamCompetingId", me.TeamCompeting.Id); p.Add("@Score", me.Score); connection.Execute("dbo.spMatchups_Update", p, commandType: CommandType.StoredProcedure); } } }
public void UptadeMatchup(MatchUpModel model) { model.UpdateMatchUpToFile(); }