public List <AnimalEnt> Buscar(AnimalEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM Animal WHERE nome like @nome";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome + "%";
cn.Connection = con;
SqlDataReader dr;
List <AnimalEnt> lista = new List <AnimalEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
AnimalEnt dado = new AnimalEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Especie = Convert.ToString(dr["especie"]);
dado.Raca = Convert.ToString(dr["raca"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Proprietario = Convert.ToString(dr["proprietario"]);
dado.Email = Convert.ToString(dr["email"]);
dado.Cuidados_esp = Convert.ToString(dr["cuidados_esp"]);
dado.Alergico = Convert.ToString(dr["alergico"]);
lista.Add(dado);
}
}
return(lista);
}
}
public int Inserir(AnimalEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
try
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "INSERT INTO Animal ([especie], [raca], [nome], [proprietario], [telefone], [email], [cuidados_esp], [alergico]) VALUES (@especie, @raca, @nome, @proprietario, @telefone, @email, @cuidados_esp, @alergico)";
cn.Parameters.Add("especie", SqlDbType.VarChar).Value = objTabela.Especie;
cn.Parameters.Add("raca", SqlDbType.VarChar).Value = objTabela.Raca;
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("proprietario", SqlDbType.VarChar).Value = objTabela.Proprietario;
cn.Parameters.Add("telefone", SqlDbType.VarChar).Value = objTabela.Telefone;
cn.Parameters.Add("email", SqlDbType.VarChar).Value = objTabela.Email;
cn.Parameters.Add("cuidados_esp", SqlDbType.VarChar).Value = objTabela.Cuidados_esp;
cn.Parameters.Add("alergico", SqlDbType.VarChar).Value = objTabela.Alergico;
//cn.Parameters.Add("foto", SqlDbType.Binary).Value = objTabela.Foto;
cn.Connection = con;
qtd = cn.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine("Error DAO - INSERT: " + ex.Message);
}
return(qtd);
}
}
public int Excluir(AnimalEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "DELETE FROM Animal WHERE id = @id";
cn.Parameters.Add("id", SqlDbType.Int).Value = objTabela.Id;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
public List <AnimalEnt> Lista()
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM Animal ORDER BY nome ASC";
cn.Connection = con;
SqlDataReader dr;
List <AnimalEnt> lista = new List <AnimalEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
AnimalEnt dado = new AnimalEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Especie = Convert.ToString(dr["especie"]);
dado.Raca = Convert.ToString(dr["raca"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Proprietario = Convert.ToString(dr["proprietario"]);
dado.Telefone = Convert.ToString(dr["telefone"]);
dado.Email = Convert.ToString(dr["email"]);
dado.Cuidados_esp = Convert.ToString(dr["cuidados_esp"]);
dado.Alergico = Convert.ToString(dr["alergico"]);
if (dr["foto"] != DBNull.Value)
{
dado.Foto = (byte[])dr["foto"];
}
lista.Add(dado);
}
}
return(lista);
}
}
public int Editar(AnimalEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "UPDATE Animal SET especie = @especie, raca = @raca, nome = @nome, proprietario = @proprietario, telefone = @telefone, email = @email, cuidados_esp = @cuidados_esp, alergico = @alergico WHERE id = @id";
cn.Parameters.Add("especie", SqlDbType.VarChar).Value = objTabela.Especie;
cn.Parameters.Add("raca", SqlDbType.VarChar).Value = objTabela.Raca;
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("proprietario", SqlDbType.VarChar).Value = objTabela.Proprietario;
cn.Parameters.Add("telefone", SqlDbType.VarChar).Value = objTabela.Telefone;
cn.Parameters.Add("email", SqlDbType.VarChar).Value = objTabela.Email;
cn.Parameters.Add("cuidados_esp", SqlDbType.VarChar).Value = objTabela.Cuidados_esp;
cn.Parameters.Add("alergico", SqlDbType.VarChar).Value = objTabela.Alergico;
cn.Parameters.Add("id", SqlDbType.Int).Value = Convert.ToInt32(objTabela.Id);
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
public List <AnimalEnt> Buscar(AnimalEnt objTabela)
{
return(new AnimalDAO().Buscar(objTabela));
}
public static int Editar(AnimalEnt objTabela)
{
return(new AnimalDAO().Editar(objTabela));
}
public static int Excluir(AnimalEnt objTabela)
{
return(new AnimalDAO().Excluir(objTabela));
}
public static int Inseir(AnimalEnt objTabela)
{
return(new AnimalDAO().Inserir(objTabela));
}
