public void Update(ShopUpdateRequest model) { using (var conn = GetConnection()) { var cmd = conn.CreateCommand(); cmd.CommandText = "dbo.Shops_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", model.Id); 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.ExecuteNonQuery(); } }
public HttpResponseMessage Update(ShopUpdateRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, model)); } _service.Update(model); SuccessResponse resp = new SuccessResponse(); return(Request.CreateResponse(HttpStatusCode.OK, resp)); }