public static SalarioMinimoModels CarregarSalarioMinimo(SqlConnection conn) { SqlCommand comandoCarregarSalarioMinimo = new SqlCommand("SELECT * FROM SalarioMinimo", conn); SqlDataReader rdr = comandoCarregarSalarioMinimo.ExecuteReader(); try { SalarioMinimoModels salarioMinimo = new SalarioMinimoModels(); if (rdr.Read()) { salarioMinimo.id = Convert.ToInt32(rdr[0].ToString()); salarioMinimo.valor = Convert.ToDecimal(rdr[1].ToString()); } else { salarioMinimo.id = 0; salarioMinimo.valor = 0; } rdr.Close(); return(salarioMinimo); } catch (Exception e) { return(new SalarioMinimoModels()); } }
public HttpResponseMessage CarregarSalarioMinimo() { List <SalarioMinimoModels> listaContribuinte = new List <SalarioMinimoModels>(); string connectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); try { SalarioMinimoModels salarioMinimo = CarregarSalarioMinimo(conn); return(Request.CreateResponse(HttpStatusCode.OK, salarioMinimo.valor)); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Houve um erro ao carregar seu Salário Mínimo")); } finally { conn.Close(); } } }
public static SalarioMinimoModels SalvarSalarioMinimo(decimal valor, SqlConnection conn) { try { SalarioMinimoModels retorno = new SalarioMinimoModels(); retorno.valor = valor; SqlCommand comandoDeletarSalarioMinimo = new SqlCommand("DELETE FROM SalarioMinimo", conn); var execDeletar = comandoDeletarSalarioMinimo.ExecuteNonQuery(); SqlCommand comandoSalvarSalarioMinimo = new SqlCommand("INSERT INTO SalarioMinimo (valor) VALUES (@VALOR)", conn); comandoSalvarSalarioMinimo.Parameters.AddWithValue("@VALOR", valor); var execInserir = comandoSalvarSalarioMinimo.ExecuteReader(); execInserir.Close(); return(retorno); } catch (Exception e) { return(new SalarioMinimoModels()); } }