public int DeleteBlogFile(int blogId, IdRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.BlogFiles_DeleteById", inputParamMapper: delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@BlogId", blogId); paramCollection.AddWithValue("@FileId", model.Id); }, returnParameters: delegate(SqlParameterCollection param) { int.TryParse(param["@FileId"].Value.ToString(), out id); } ); return id; }
public int InsertBlogFile(int blogId, IdRequest model, string userId) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.BlogFiles_Insert", inputParamMapper: delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@BlogId", blogId); paramCollection.AddWithValue("@FileId", model.Id); paramCollection.AddWithValue("@UserId", userId); SqlParameter b = new SqlParameter("@Id", System.Data.SqlDbType.Int); b.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(b); }, returnParameters: delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out id); } ); return id; }
public HttpResponseMessage DeselectCoverPhoto(int blogId, IdRequest model) { ItemResponse<int> response = new ItemResponse<int>(); response.Item = _blogService.DeleteBlogFile(blogId, model); return Request.CreateResponse(response); }
public HttpResponseMessage BlogFile(int blogId, IdRequest model) { string userId = _userService.GetCurrentUserId(); ItemResponse<int> response = new ItemResponse<int>(); response.Item = _blogService.InsertBlogFile(blogId, model, userId); return Request.CreateResponse(response); }