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); } ); }