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);
}
