public void Insert(AnalyticsAddRequest model, string userId)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Analytics_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@UserId", userId);
paramCollection.AddWithValue("@URL", model.URL);
paramCollection.AddWithValue("@TypeId", model.TypeId);
paramCollection.AddWithValue("@CategoryId", model.CategoryId);
paramCollection.AddWithValue("@Data", model.Data);
});
}
public HttpResponseMessage StoreAnalyticsV2([FromUri] AnalyticsAddRequest model)
{
string userId = _userService.GetCurrentUserId();
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
_analyticService.InsertV2(model, userId);
SuccessResponse response = new SuccessResponse();
return(Request.CreateResponse(response));
}
public void InsertV2(AnalyticsAddRequest model, string userId)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Analytics_InsertV2"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
SqlParameter ids = new SqlParameter("@Data", SqlDbType.Structured);
if (model.DataArr != null && model.DataArr.Any())
{
ids.Value = new RapidRents.Data.NVarcharTable(model.DataArr);
}
paramCollection.Add(ids);
paramCollection.AddWithValue("@UserId", userId);
paramCollection.AddWithValue("@URL", model.URL);
paramCollection.AddWithValue("@TypeId", model.TypeId);
paramCollection.AddWithValue("@CategoryId", model.CategoryId);
}
);
}
