public int Add(ShopAddRequest model) { using (var conn = GetConnection()) { var cmd = conn.CreateCommand(); cmd.CommandText = "dbo.Shops_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", model.Name); cmd.Parameters.AddWithValue("@AddressLineOne", model.AddressLineOne); cmd.Parameters.AddWithValue("@AddressLineTwo", model.AddressLineTwo); cmd.Parameters.AddWithValue("@City", model.City); cmd.Parameters.AddWithValue("@State", model.State); cmd.Parameters.AddWithValue("@PostalCode", model.PostalCode); cmd.Parameters.AddWithValue("@PhotoURL", model.PhotoURL); cmd.Parameters.AddWithValue("@Website", model.Website); cmd.Parameters.AddWithValue("@InstagramHandle", model.InstagramHandle); cmd.Parameters.AddWithValue("@Description", model.Description); cmd.Parameters.AddWithValue("@TimeOpen", model.TimeOpen); cmd.Parameters.AddWithValue("@TimeClose", model.TimeClose); cmd.Parameters.AddWithValue("@Lat", model.Lat); cmd.Parameters.AddWithValue("@Long", model.Lng); cmd.Parameters.AddWithValue("@UserId", model.UserId); cmd.Parameters.AddWithValue("@Id", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@Id"].Value); } }
public HttpResponseMessage Add(ShopAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } ItemResponse <int> response = new ItemResponse <int> { Item = _service.Add(model) }; return(Request.CreateResponse(HttpStatusCode.Created, response)); }