public List <InstrutorEnt> Lista()
{
using (SqlConnection con = new SqlConnection()) //Instanciando conexão
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM instrutor ORDER BY id ASC";
cn.Connection = con;
SqlDataReader dr;
List <InstrutorEnt> Lista = new List <InstrutorEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
InstrutorEnt dado = new InstrutorEnt();
dado.Id = Convert.ToString(dr["id"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Cpf = Convert.ToString(dr["cpf"]);
dado.Rg = Convert.ToString(dr["rg"]);
dado.Telefone = Convert.ToString(dr["telefone"]);
Lista.Add(dado);
}
}
return(Lista);
}
}
public List <InstrutorEnt> Buscar(InstrutorEnt objtabela)
{
using (SqlConnection con = new SqlConnection()) //Instanciando conexão
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM instrutor WHERE nome LIKE @nome";
//Parâmetros Instrutor
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objtabela.Nome + "%";
cn.Connection = con;
SqlDataReader dr;
List <InstrutorEnt> Lista = new List <InstrutorEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
InstrutorEnt dado = new InstrutorEnt();
dado.Id = Convert.ToString(dr["id"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Cpf = Convert.ToString(dr["cpf"]);
dado.Rg = Convert.ToString(dr["rg"]);
dado.Telefone = Convert.ToString(dr["telefone"]);
Lista.Add(dado);
}
}
return(Lista);
}
}
public int Excluir(InstrutorEnt objtabela)
{
using (SqlConnection con = new SqlConnection()) //Instanciando conexão
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "DELETE FROM instrutor WHERE id = @id";
//Parâmetros Instrutor
cn.Parameters.Add("id", SqlDbType.VarChar).Value = objtabela.Id;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
Console.Write(qtd);
return(qtd);
}
}
public int Inserir(InstrutorEnt objtabela)
{
using (SqlConnection con = new SqlConnection()) //Instanciando conexão
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "INSERT INTO instrutor ([nome], [cpf], [rg], [telefone]) VALUES (@nome, @cpf, @rg, @telefone)";
//Parâmetros Instrutor
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objtabela.Nome;
cn.Parameters.Add("cpf", SqlDbType.VarChar).Value = objtabela.Cpf;
cn.Parameters.Add("rg", SqlDbType.VarChar).Value = objtabela.Rg;
cn.Parameters.Add("telefone", SqlDbType.VarChar).Value = objtabela.Telefone;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
Console.Write(qtd);
return(qtd);
}
}
public int Editar(InstrutorEnt objtabela)
{
using (SqlConnection con = new SqlConnection()) //Instanciando conexão
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "";
cn.CommandText = "UPDATE instrutor SET nome = @nome, cpf = @cpf, rg = @rg, telefone = @telefone WHERE id = @id";
//Parâmetros Instrutor
cn.Parameters.Add("id", SqlDbType.VarChar).Value = objtabela.Id;
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objtabela.Nome;
cn.Parameters.Add("cpf", SqlDbType.VarChar).Value = objtabela.Cpf;
cn.Parameters.Add("rg", SqlDbType.VarChar).Value = objtabela.Rg;
cn.Parameters.Add("telefone", SqlDbType.VarChar).Value = objtabela.Telefone;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
Console.Write(qtd);
return(qtd);
}
}
public static int Editar(InstrutorEnt objtabela) //Método Editar
{
return(new InstrutorControl().Editar(objtabela));
}
public static int Excluir(InstrutorEnt objtabela) //Método Excluir
{
return(new InstrutorControl().Excluir(objtabela));
}
public List <InstrutorEnt> Buscar(InstrutorEnt objtabela) //Método Buscar
{
return(new InstrutorControl().Buscar(objtabela));
}
public static int Inserir(InstrutorEnt objtabela) //Método Inserir
{
return(new InstrutorControl().Inserir(objtabela));
}
