public HttpResponseMessage Create(GlobalEventAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _globalEventService.Insert(model); _notificationService.GlobalEvent(response.Item, Enums.EventActionType.Created); return(Request.CreateResponse(HttpStatusCode.Created, response)); }
private void MapCommonParameters(GlobalEventAddRequest model, SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@name", model.Name); paramCollection.AddWithValue("@address", model.Address); paramCollection.AddWithValue("@city", model.City); paramCollection.AddWithValue("@state", model.State); paramCollection.AddWithValue("@zipCode", model.ZipCode); paramCollection.AddWithValue("@country", model.Country); paramCollection.AddWithValue("@dateStart", model.DateStart); paramCollection.AddWithValue("@dateEnd", model.DateEnd); paramCollection.AddWithValue("@startTime", model.StartTime); paramCollection.AddWithValue("@endTime", model.EndTime); paramCollection.AddWithValue("@description", model.Description); paramCollection.AddWithValue("@latitude", model.Latitude); paramCollection.AddWithValue("@longitude", model.Longitude); paramCollection.AddWithValue("@userId", UserService.GetCurrentUserId()); }
public int Insert(GlobalEventAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.GlobalEvent_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { MapCommonParameters(model, paramCollection); 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); } ); return(id); }