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);
});
}
}
