public async Task <JsonResult> CreateModel1(Statistics1ViewModel stats) { if (stats == null) { return(Json(false, JsonRequestBehavior.AllowGet)); } var result = await _statistics1Orchestrator.SaveStatistics1(new Statistics1ViewModel { Team2Id = stats.Team2Id, Team2TotalScore = stats.Team2TotalScore, Team2TotalYards = stats.Team2TotalYards, Team2TotalRushingYards = stats.Team2TotalRushingYards, Team2TotalPassingYards = stats.Team2TotalPassingYards, Team2TotalSackYardsLost = stats.Team2TotalSackYardsLost, Team2TotalPenaltyYards = stats.Team2TotalPenaltyYards, Team2AverageYardsPerPunt = stats.Team2AverageYardsPerPunt, Team2TotalFirstDowns = stats.Team2TotalFirstDowns, Team2TotalRushes = stats.Team2TotalRushes, Team2TotalPassesAttempted = stats.Team2TotalPassesAttempted, Team2TotalPassesCompleted = stats.Team2TotalPassesCompleted, Team2TotalPassesIntercepted = stats.Team2TotalPassesIntercepted, Team2TotalSacks = stats.Team2TotalSacks, Team2TotalFumbles = stats.Team2TotalFumbles, Team2TotalFumblesLost = stats.Team2TotalFumblesLost, Team2TotalNumberOfPunts = stats.Team2TotalNumberOfPunts, Team2TotalNumberOfPenalties = stats.Team2TotalNumberOfPenalties }); return(Json(result, JsonRequestBehavior.AllowGet)); }
public async Task <bool> SaveStatistics1(Statistics1ViewModel stats) { try { System.Data.SqlClient.SqlConnection sqlConnection1 = new SqlConnection("Server=localhost\\SQLEXPRESS;Trusted_Connection=True;Initial Catalog=RealTimeSportsStatistics;Integrated Security = SSPI"); SqlCommand cmd = new System.Data.SqlClient.SqlCommand { CommandType = System.Data.CommandType.Text, CommandText = @" Insert into [Statistics1](Team2Id, Team2TotalScore, Team2TotalYards, Team2TotalRushingYards, Team2TotalPassingYards, Team2TotalSackYardsLost, Team2TotalPenaltyYards, Team2AverageYardsPerPunt, Team2TotalFirstDowns, Team2TotalRushes, Team2TotalPassesAttempted, Team2TotalPassesCompleted, Team2TotalPassesIntercepted, Team2TotalSacks, Team2TotalFumbles, Team2TotalFumblesLost, Team2TotalNumberOfPunts, Team2TotalNumberOfPenalties) " + "Values('" + stats.Team2Id + "', '" + stats.Team2TotalScore + "', '" + stats.Team2TotalYards + "', '" + stats.Team2TotalRushingYards + "', '" + stats.Team2TotalPassingYards + "', '" + stats.Team2TotalSackYardsLost + "', '" + stats.Team2TotalPenaltyYards + "', '" + stats.Team2AverageYardsPerPunt + "', '" + stats.Team2TotalFirstDowns + "', '" + stats.Team2TotalRushes + "', '" + stats.Team2TotalPassesAttempted + "', '" + stats.Team2TotalPassesCompleted + "', '" + stats.Team2TotalPassesIntercepted + "', '" + stats.Team2TotalSacks + "', '" + stats.Team2TotalFumbles + "', '" + stats.Team2TotalFumblesLost + "', '" + stats.Team2TotalNumberOfPunts + "', '" + stats.Team2TotalNumberOfPenalties + "')", Connection = sqlConnection1 }; sqlConnection1.Open(); cmd.ExecuteNonQuery(); sqlConnection1.Close(); } catch (Exception e) { File.WriteAllText(@"c:\Temp\Error.Txt", e.Message); } return(true); }