public int Insert(FAQAddRequest model) //comes from FAQApiController route. we instantiate new userId before running insertFAQ in FAQApiController.
{
int uid = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.FAQs_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Question", model.Question);
paramCollection.AddWithValue("@Category", model.Category);
paramCollection.AddWithValue("@Answer", model.Answer);
paramCollection.AddWithValue("@UserId", _userService.GetCurrentUserId());
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@Id"].Value.ToString(), out uid);
}
);
return(uid);
}
public Int32 Insert(FAQAddRequest model)
{
int id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.FAQ_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CategoryId", model.CategoryId);
paramCollection.AddWithValue("@LanguageId", model.LanguageId);
paramCollection.AddWithValue("@Question", model.Question);
paramCollection.AddWithValue("@Answer", model.Answer);
SqlParameter p = new SqlParameter("@id", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@id"].Value.ToString(), out id);
}
);
return(id);
}
public ActionResult <ItemResponse <int> > Add(FAQAddRequest model)
{
ObjectResult result = null;
int userId = _authService.GetCurrentUserId();
try
{
int id = _service.Add(model, userId);
ItemResponse <int> response = new ItemResponse <int>()
{
Item = id
};
result = Created201(response);
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
ErrorResponse response = new ErrorResponse(ex.Message);
result = StatusCode(500, response);
}
return(result);
}
public int Add(FAQAddRequest model, int userId)
{
string procName = "dbo.FAQs_Insert";
int id = 0;
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Question", model.Question);
paramCollection.AddWithValue("@Answer", model.Answer);
paramCollection.AddWithValue("@CategoryId", model.CategoryId);
paramCollection.AddWithValue("@SortOrder", model.SortOrder);
paramCollection.AddWithValue("@CreatedBy", userId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
paramCollection.Add(idOut);
},
returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@Id"].Value;
int.TryParse(oId.ToString(), out id);
Console.WriteLine("");
}
);
return(id);
}
public int Add(FAQAddRequest model, int userId)
{
int id = 0;
string procName = "dbo.FAQs_Insert";
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
AddCommonParams(model, col);
col.AddWithValue("@CreatedBy", userId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
col.Add(idOut);
},
returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@Id"].Value;
int.TryParse(oId.ToString(), out id);
});
return(id);
}
private static void AddCommonParams(FAQAddRequest model, SqlParameterCollection col)
{
col.AddWithValue("@Question", model.Question);
col.AddWithValue("@Answer", model.Answer);
col.AddWithValue("@CategoryId", model.CategoryId);
col.AddWithValue("@SortOrder", model.SortOrder);
}
public HttpResponseMessage Add(FAQAddRequest model)
{
// if the Model does not pass validation, there will be an Error response returned with errors
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _faqService.Insert(model);
return(Request.CreateResponse(response));
}
public HttpResponseMessage Insert(FAQAddRequest model)
{
string userId = _userService.GetCurrentUserId(); //this is where the userId is.
// if the Model does not pass validation, there will be an Error response returned with errors
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _service.Insert(model);
return(Request.CreateResponse(response));
}
