public static PaisModel RecuperarPeloId(int id) { PaisModel ret = null; using (var conexao = new SqlConnection()) { conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString; conexao.Open(); using (var comando = new SqlCommand()) { comando.Connection = conexao; comando.CommandText = "select * from pais where (id = @id)"; comando.Parameters.Add("@id", SqlDbType.Int).Value = id; var reader = comando.ExecuteReader(); if (reader.Read()) { ret = new PaisModel { Id = (int)reader["id"], Nome = (string)reader["nome"], Codigo = (string)reader["codigo"], Ativo = (bool)reader["ativo"] }; } } } return(ret); }
public static PaisModel RecuperarPeloId(int id) { PaisModel ret = null; using (var db = new ContextoBD()) { ret = db.Paises.Find(id); } return(ret); }
public static PaisModel RecuperarPeloId(int id) { PaisModel ret = null; using (var conexao = new SqlConnection()) { conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString; conexao.Open(); var sql = "select * from pais where (id = @id)"; var parametros = new { id }; ret = conexao.Query <PaisModel>(sql, parametros).SingleOrDefault(); } return(ret); }
public static bool ExcluirPeloId(int id) { var ret = false; if (RecuperarPeloId(id) != null) { using (var db = new ContextoBD()) { var pais = new PaisModel { Id = id }; db.Paises.Attach(pais); db.Entry(pais).State = EntityState.Deleted; } } return(ret); }
public static PaisModel RecuperarPeloId(int id) { PaisModel ret = null; using (var conexao = new SqlConnection()) { conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString; conexao.Open(); var sql = "select * from pais where (id = @id)"; var parametros = new { id }; ret = conexao.Query <PaisModel>(sql, parametros).SingleOrDefault(); /* using (var comando = new SqlCommand()) * { * comando.Connection = conexao; * comando.CommandText = "select * from pais where (id = @id)"; * * comando.Parameters.Add("@id", SqlDbType.Int).Value = id; * * var reader = comando.ExecuteReader(); * if (reader.Read()) * { * ret = new PaisModel * { * Id = (int)reader["id"], * Nome = (string)reader["nome"], * Codigo = (string)reader["codigo"], * Ativo = (bool)reader["ativo"] * }; * } * }*/ } return(ret); }