/// <summary> /// Saves a record to the BusinessAreas table. /// </summary> public void Save(BowlingEntity bowlingEntity) { if (bowlingEntity == null) { throw new Exception(bowlingEntity + " not be null"); } SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Name", bowlingEntity.Name), new SqlParameter("@Score", bowlingEntity.Score), new SqlParameter("@ScoreDetails", bowlingEntity.ScoreDetails), }; using (var con = new SqlConnection(this.connectionString)) { con.Open(); var cmd = new SqlCommand(" insert into [Score] ( " + "[Name],[Score], [ScoreDetails])" + " values ( @Name, @Score, @ScoreDetails)" + "select scope_identity()", con); cmd.Parameters.AddRange(parameters); cmd.ExecuteNonQuery(); con.Close(); } }
// POST api/bowling public void Post([FromBody] BowlingEntity bowlingEntity) { bowlingModel.Save(bowlingEntity); }