public void Update(TrackUpdateRequest model) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.Tracks_Update", inputParamMapper : delegate(SqlParameterCollection updateCTrack) { updateCTrack.AddWithValue("@Id", model.Id); updateCTrack.AddWithValue("@Name", model.Name); updateCTrack.AddWithValue("@Format", model.Format); updateCTrack.AddWithValue("@ExpectedOutcome", model.ExpectedOutCome); updateCTrack.AddWithValue("@Cost", model.Cost); updateCTrack.AddWithValue("@Description", model.Description); }); DataProvider.ExecuteNonQuery(GetConnection, "dbo.TrackCourses_Delete", inputParamMapper : delegate(SqlParameterCollection parameterCollection) { parameterCollection.AddWithValue("@TracksId", model.Id); }); foreach (var courseId in model.CourseIds) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.TrackCourses_Insert", delegate(SqlParameterCollection para) { para.AddWithValue("@TracksId", model.Id); para.AddWithValue("@CourseId", courseId); }); } }
public HttpResponseMessage Edit(TrackUpdateRequest model, int id) { //the if statement is your SSV if (!ModelState.IsValid) { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } SucessResponse response = new SucessResponse(); _trackService.Update(model); return Request.CreateResponse(response); }
public HttpResponseMessage Edit(TrackUpdateRequest model, int id) { //the if statement is your SSV if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } SucessResponse response = new SucessResponse(); _trackService.Update(model); return(Request.CreateResponse(response)); }
public void Update(TrackUpdateRequest model) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.Tracks_Update", inputParamMapper: delegate(SqlParameterCollection updateCTrack) { updateCTrack.AddWithValue("@Id", model.Id); updateCTrack.AddWithValue("@Name", model.Name); updateCTrack.AddWithValue("@Format", model.Format); updateCTrack.AddWithValue("@ExpectedOutcome", model.ExpectedOutCome); updateCTrack.AddWithValue("@Cost", model.Cost); updateCTrack.AddWithValue("@Description", model.Description); }); DataProvider.ExecuteNonQuery(GetConnection, "dbo.TrackCourses_Delete", inputParamMapper: delegate(SqlParameterCollection parameterCollection) { parameterCollection.AddWithValue("@TracksId", model.Id); }); foreach (var courseId in model.CourseIds) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.TrackCourses_Insert", delegate(SqlParameterCollection para) { para.AddWithValue("@TracksId", model.Id); para.AddWithValue("@CourseId", courseId); }); } }