public List <custumer> consult_customer()
{
List <custumer> peoples = new List <custumer>();
try
{
con.connect();
string query = "SELECT `nm_customer`,`cpf_cnpj`, `is_active`, `vl_total` FROM `tb_customer_account` WHERE id_customer > 1500 and id_customer < 2700 and vl_total >560 ORDER BY vl_total DESC ";
command = new MySqlCommand(query, con.connection);
infos = command.ExecuteReader();
while (infos.Read())
{
custumer user = new custumer();
user.nm_customer = infos["nm_customer"].ToString();
user.cpf_cnpj = infos["cpf_cnpj"].ToString();
user.is_active = Convert.ToInt32(infos["is_active"]);
user.vl_total = Convert.ToInt32(infos["vl_total"]);
peoples.Add(user);
}
con.disconnect();
return(peoples);
}
catch (Exception excep)
{
throw new Exception("Erro de comandos!\n" + excep.Message);
}
}
public Form1()
{
InitializeComponent();
people = new custumer();
da = new dal();
generator = new massive_add();
}
public void add_customer(custumer people)
{
try
{
con.connect();
string query = "INSERT INTO tb_customer_account(cpf_cnpj,nm_customer,is_active,vl_total)VALUES('" + people.cpf_cnpj + "','" + people.nm_customer + "'," + people.is_active + "," + people.vl_total + ")";
command = new MySqlCommand(query, con.connection);
command.ExecuteNonQuery();
con.disconnect();
}
catch (Exception excep)
{
throw new Exception("Erro de comandos!\n" + excep.Message);
}
}
