public static RevUnitQuery ObtemRevisao(string guid) { RevUnitQuery rev = null; string qryUser = "******" + "lv_revisao.guid AS guid," + "lv_revisao.id_estado AS ID_ESTADO" + " FROM lv_revisao" + " WHERE " + "lv_revisao.guid = '" + guid + "'"; using (var conexaoBD = new ConexaoMySQL()) { rev = conexaoBD.MySqlConnection.Query <RevUnitQuery>(qryUser).FirstOrDefault(); } return(rev); }
public RevUnitQuery ObtemRevisao(string guid) { RevUnitQuery rev = null; //api/ApiRevisao/{guidRevisao} var hndlr = new HttpClientHandler(); hndlr.UseDefaultCredentials = true; using (var client = new HttpClient(hndlr)) { string api = "api/ApiRevisao/" + guid; client.BaseAddress = new Uri(_baseURL); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var responseTask = client.GetAsync(api); responseTask.Wait(); var result = responseTask.Result; if (result.IsSuccessStatusCode) { var readTask = result.Content.ReadAsStringAsync(); readTask.Wait(); var str = readTask.Result; rev = JsonConvert.DeserializeObject <RevUnitQuery>(str); } } return(rev); }