public HttpResponseMessage UpdateLatLong(ShopUpdateLatLongRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, model)); } _service.UpdateLatLong(model); SuccessResponse resp = new SuccessResponse(); return(Request.CreateResponse(HttpStatusCode.OK, resp)); }
public void UpdateLatLong(ShopUpdateLatLongRequest model) { using (var conn = GetConnection()) { var cmd = conn.CreateCommand(); cmd.CommandText = "dbo.Shops_UpdateLatLong"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", model.Id); cmd.Parameters.AddWithValue("@Lat", model.Lat); cmd.Parameters.AddWithValue("@Long", model.Lng); cmd.ExecuteNonQuery(); } }