public RecommendationWhereString UpdateById(int id, RecommendationCreateRequest update)
{
var updatedReco = new RecommendationWhereString();
_dataProvider.ExecuteCmd("Recommendations_Update_ById",
send => {
send.AddWithValue("@Id", id);
send.AddWithValue("@CoachExpertiseTypeId", update.CoachExpertiseTypeId);
send.AddWithValue("@ResourceProviderId", update.ResourceProviderId);
send.AddWithValue("@WhereString", update.WhereString);
send.AddWithValue("@Description", update.Description);
},
(reader, vari) =>
{
updatedReco.Id = (int)reader["Id"];
updatedReco.WhereString = (string)reader["WhereString"];
object CoachExpertiseTypeId = reader["CoachExpertiseTypeId"];
if (CoachExpertiseTypeId != DBNull.Value)
{
updatedReco.CoachExpertiseTypeId = (int)CoachExpertiseTypeId;
}
object ResourceProviderId = reader["ResourceProviderId"];
if (ResourceProviderId != DBNull.Value)
{
updatedReco.ResourceProviderId = (int)ResourceProviderId;
}
});
return(updatedReco);
}
public HttpResponseMessage Update(int Id, RecommendationCreateRequest request)
{
if (request == null)
{
ModelState.AddModelError("empty object", "supply body");
}
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
var recommendation = _recommendationService.UpdateById(Id, request);
return(Request.CreateResponse(HttpStatusCode.OK, new ItemResponse <RecommendationWhereString> {
Item = recommendation
}));
}
public HttpResponseMessage Create(RecommendationCreateRequest request)
{
if (request == null)
{
ModelState.AddModelError("empty object", "supply body");
}
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
var id = _recommendationService.Create(request);
return(Request.CreateResponse(HttpStatusCode.OK, new ItemResponse <int> {
Item = id
}));
}
public int Create(RecommendationCreateRequest request)
{
int returnId = 0;
_dataProvider.ExecuteNonQuery("Recommendations_Insert",
send => {
send.AddWithValue("@CoachExpertiseTypeId", request.CoachExpertiseTypeId);
send.AddWithValue("@ResourceProviderId", request.ResourceProviderId);
send.AddWithValue("@WhereString", request.WhereString);
SqlParameter idParameter = new SqlParameter("@Id", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
send.Add(idParameter);
},
read =>
{
returnId = (int)read["@Id"].Value;
});
return(returnId);
}
