public HttpResponseMessage Create(LMSDocResponseRequest req)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
int userId = User.Identity.GetId().Value;
req.UserId = userId;
int newId = lmsService.Create(req);
ItemResponse <int> response = new ItemResponse <int>();
response.Item = newId;
return(Request.CreateResponse(HttpStatusCode.Created, response));
}
public int Create(LMSDocResponseRequest req)
{
int id = 0;
dataProvider.ExecuteNonQuery(
"LmsDocumentResponses_insert",
delegate(SqlParameterCollection parameter)
{
parameter.AddWithValue("@doc_id", req.DocId);
parameter.AddWithValue("@user_id", req.UserId);
parameter.AddWithValue("@time_spent", req.TimeSpentInSec);
parameter.AddWithValue("@feedback", JsonConvert.SerializeObject(req.FeedBack));
parameter.AddWithValue("@date_submitted", req.DateSubmitted ?? (object)DBNull.Value);
parameter.AddWithValue("@content", JsonConvert.SerializeObject(req.Content));
SqlParameter newId = new SqlParameter("@id", SqlDbType.Int);
newId.Direction = ParameterDirection.Output;
parameter.Add(newId);
}, returnParameters : delegate(SqlParameterCollection param)
{
id = (int)param["@id"].Value;
}
);
return(id);
}
