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);
        }
Exemple #2
0
        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);
        }