public int InsertStudentMarks(CreateStudentMark student) { using (var conn = new SqlConnection(_connectionStringHolder.Value)) { //conn.Open(); //qq does this need to be opened? No. var affectedRows = conn.Execute("Insert into StudentMarks (Name, Subject, Marks) values (@Name, @subject, @Marks)", new { Name = student.Name, Subject = student.Subject, Marks = student.Marks }); //conn.Close(); return(affectedRows); } }
[HttpPost("api/FiddlerExAddStudentMarksPost")] // [HttpGet("FiddlerExAddStudentMarksPost")] doesn't work //[ActionName("Post")] //qq is this attribute req'd //[ValidateAntiForgeryToken] public ActionResult FiddlerExAddStudentMarksPost([Bind("Name, Subject, Marks")] CreateStudentMark sm) { var x = _fiddlerRepository.InsertStudentMarks(sm); if (x != 0) //(x != null) { //return Ok(x); //return Created(new Uri("/Home/Index/testPathOnly", UriKind.Relative), newItem); //the path is returned in the "Location" header for this item (its value can be nonsense). return(CreatedAtAction("FiddlerExAddStudentMarksPost", sm)); //the full path for this action is returned in the "Location" header for this item (must be valid action method name). } //return NotFound(new { Message = $"Something went wrong!!?." }); return(BadRequest(new { Message = $"Something went wrong!!?." })); }