// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ public int InsertQuoteRequest(QuoteRequestInsertRequest model) { int id = 0; try { DataProvider.ExecuteNonQuery(GetConnection, "dbo.QuoteRequests_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@UserId", model.UserId); paramCollection.AddWithValue("@CompanyId", model.CompanyId); paramCollection.AddWithValue("@Name", model.Name); paramCollection.AddWithValue("@QRType", model.QRType); 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 id); }); } catch (Exception ex) { throw ex; } return(id); }
public HttpResponseMessage QuoteRequestInsert(QuoteRequestInsertRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } //QuoteRequestInsertRequest newQuoteRequest = new QuoteRequestInsertRequest(); model.UserId = UserService.GetCurrentUserId(); var userProfile = _AdminService.ProfileGetByUserId(model.UserId); model.CompanyId = userProfile.CompanyId; int quoteId = _QuoteRequestService.InsertQuoteRequest(model); ActivityService activityService = new ActivityService(); ActivityRequest activity = new ActivityRequest(); activity.UserId = model.UserId; activity.CompanyId = model.CompanyId; activity.PrimaryId = quoteId.ToString(); activity.ActivityType = ActivityType.QuoteRequest; activity.ActionType = ActionType.Created; activity.Name = model.Name; activityService.ActivityInsert(activity); ItemResponse <int> response = new ItemResponse <int> { Item = quoteId }; return(Request.CreateResponse(HttpStatusCode.OK, response)); }