public int Add(FaqAddRequest request, int userId)
{
string procName = "[dbo].[Faqs_Insert]";
int id = 0;
_data.ExecuteNonQuery(
procName,
delegate(SqlParameterCollection inputCollection)
{
FaqAddInputs(request, inputCollection, userId);
inputCollection.AddWithValue("@CreatedBy", userId);
SqlParameter outputId = new SqlParameter("@Id", SqlDbType.Int);
outputId.Direction = ParameterDirection.Output;
inputCollection.Add(outputId);
},
delegate(SqlParameterCollection returnCollection)
{
object outputOfId = returnCollection["@Id"].Value;
int.TryParse(outputOfId.ToString(), out id);
}
);
return(id);
}
public int Add(FaqAddRequest data, int userId)
{
if (data == null)
{
throw new ArgumentNullException("Parameter data is required");
}
int id = 0;
string storeProc = "[dbo].[Faq_Insert]";
_dataProvider.ExecuteNonQuery(storeProc,
delegate(SqlParameterCollection sqlParams)
{
sqlParams.AddWithValue("@UserId", userId);
sqlParams.AddWithValue("@CategoryId", data.CategoryId);
sqlParams.AddWithValue("@Question", data.Question);
sqlParams.AddWithValue("@Answer", data.Answer);
sqlParams.AddWithValue("@SortOrder", data.SortOrder);
SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
sqlParams.Add(idParameter);
}, returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@Id"].Value.ToString(), out id);
});
return(id);
}
private static void FaqAddInputs(FaqAddRequest request, SqlParameterCollection inputCollection, int userId)
{
inputCollection.AddWithValue("@Question", request.Question);
inputCollection.AddWithValue("@Answer", request.Answer);
inputCollection.AddWithValue("@CategoryId", request.CategoryId);
inputCollection.AddWithValue("@SortOrder", request.SortOrder);
inputCollection.AddWithValue("@ModifiedBy", userId);
}
private void MapCommonParameters(FaqAddRequest model, SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@DateCreated", model.DateCreated);
paramCollection.AddWithValue("@DateModified", model.DateModified);
paramCollection.AddWithValue("@UserIdCreated", UserService.GetCurrentUserId());
paramCollection.AddWithValue("@Question", model.Question);
paramCollection.AddWithValue("@Answer", model.Answer);
paramCollection.AddWithValue("@FaqCategoryId", model.FaqCategoryId);
}
public HttpResponseMessage AddFaq(FaqAddRequest model)
{
if (!ModelState.IsValid && model != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _faqService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, model));
}
public HttpResponseMessage Insert(FaqAddRequest model)
{
try
{
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _faqService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
catch (Exception ex)
{
_errorService.LogError(ex);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult <ItemResponse <int> > Add(FaqAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Add(model, userId);
ItemResponse <int> response = new ItemResponse <int> {
Item = id
};
result = Created201(response);
}
catch (Exception exception)
{
base.Logger.LogError(exception.ToString());
ErrorResponse response = new ErrorResponse(exception.Message);
result = StatusCode(500, response);
}
return(result);
}
public int Insert(FaqAddRequest model)
{
int Id = 0;
DataProvider.ExecuteNonQuery("dbo.Faq_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Title", model.Title);
paramCollection.AddWithValue("@Description", model.Description);
paramCollection.AddWithValue("@DisplayOrder", model.DisplayOrder);
paramCollection.AddWithValue("@CategoryId", model.CategoryId);
paramCollection.AddWithValue("@ModifiedBy", model.ModifiedBy);
SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(idParameter);
}, returnParameters : delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@Id"].Value.ToString(), out Id);
});
return(Id);
}
public int Insert(FaqAddRequest model)
{
int id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Faq_Insert",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@UserIdCreated", UserService.GetCurrentUserId());
paramCollection.AddWithValue("@Question", model.Question);
paramCollection.AddWithValue("@Answer", model.Answer);
paramCollection.AddWithValue("@FaqCategoryId", model.FaqCategoryId);
SqlParameter p = new SqlParameter("@Id", SqlDbType.Int);
p.Direction = ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@Id"].Value.ToString(), out id);
}
);
return(id);
}
