static void TestaInclusao(string connectionString)
{
ClienteRepository cliRepo = new ClienteRepository(connectionString);
ClienteModel cli = new ClienteModel()
{
Codigo = 2,
Nome = "KELVIN CORREIA DO NASCIMENTO",
Email = "*****@*****.**",
Telefone = "(11)99999-9999"
};
if (cliRepo.Inserir(cli))
{
Console.WriteLine("Sucesso na inclusão!");
}
else
{
Console.WriteLine("Erro !");
}
}
public List <ClienteModel> Consultar()
{
var clientes = new List <ClienteModel>();
string sql = "SELECT * FROM CLIENTES order by NOME";
SqlConnection con = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
SqlDataReader reader;
con.Open();
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
var cli = new ClienteModel();
cli.Codigo = Convert.ToInt32(reader[0].ToString());
cli.Nome = reader[1].ToString();
cli.Email = reader[2].ToString();
cli.Telefone = reader[3].ToString();
clientes.Add(cli);
}
}
catch (Exception erro)
{
Console.WriteLine("Erro " + erro.ToString());
}
finally
{
con.Close();
}
return(clientes);
}
static void Inclusao(string connectionString)
{
ClienteModel cli = new ClienteModel()
{
Codigo = 2,
Nome = "Rodrigo Henrique Paulino",
Email = "*****@*****.**",
Telefone = "(11)99999-9999"
};
string comandoSql = $"INSERT INTO CLIENTES (codigo, nome, email, telefone ) values " +
$"( {cli.Codigo}, '{cli.Nome}', '{cli.Email}', '{cli.Telefone}' )";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(comandoSql, con);
cmd.CommandType = CommandType.Text;
con.Open();
try
{
var i = cmd.ExecuteNonQuery();
if (i > 0)
{
Console.WriteLine("Registro inserido com sucesso !");
}
}
catch (Exception erro)
{
Console.WriteLine("Erro " + erro.ToString());
throw;
}
finally
{
con.Close();
}
}
static void Listagem(string connectionString)
{
string sql = "SELECT * FROM CLIENTES order by NOME";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
SqlDataReader reader;
con.Open();
try
{
List <ClienteModel> clientes = new List <ClienteModel>();
reader = cmd.ExecuteReader();
while (reader.Read())
{
var cli = new ClienteModel();
cli.Codigo = Convert.ToInt32(reader[0].ToString());
cli.Nome = reader["nome"].ToString();
cli.Email = reader["email"].ToString();
cli.Telefone = reader["telefone"].ToString();
clientes.Add(cli);
}
}
catch (Exception erro)
{
Console.WriteLine("Erro " + erro.ToString());
}
finally
{
con.Close();
}
}
public ClienteModel Consultar(int codigo)
{
ClienteModel cli = new ClienteModel();
string sql = "SELECT * FROM CLIENTES where codigo=" + codigo;
SqlConnection con = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
SqlDataReader reader;
con.Open();
try
{
reader = cmd.ExecuteReader();
if (reader.Read())
{
cli.Codigo = Convert.ToInt32(reader[0].ToString());
cli.Nome = reader["nome"].ToString();
cli.Email = reader["email"].ToString();
cli.Telefone = reader["telefone"].ToString();
}
}
catch (Exception erro)
{
Console.WriteLine("Erro " + erro.ToString());
}
finally
{
con.Close();
}
return(cli);
}