public HttpResponseMessage UserSubcriptionToPlan(UserPlanSubscribe model, int PlanId) { string UserId = _userService.GetCurrentUserId(); bool Subscribed = true; _plansService.UserSubcriptionToPlan(model, UserId, Subscribed, PlanId); SuccessResponse response = new SuccessResponse(); return Request.CreateResponse(HttpStatusCode.OK, response); }
//Code for Subscription public void UserSubcriptionToPlan(UserPlanSubscribe model, string userId, bool Subscribed, int PlanId) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.UserPlans_Insert" , inputParamMapper: delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@UserId", userId); paramCollection.AddWithValue("@PlanId", PlanId); paramCollection.AddWithValue("@Subscribed", Subscribed); //SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int); //p.Direction = System.Data.ParameterDirection.Output; //paramCollection.Add(p); }, returnParameters: delegate(SqlParameterCollection param) { } ); }