public List <AddressClient> getAddressClients(int idClient)
{
address.Clear();
ConnectionDB connection = new ConnectionDB();
connection.openConnection();
string command = $"SELECT * FROM endereco WHERE Cliente_idcliente = {idClient};";
MySqlDataReader result = connection.select(command);
while (result.Read())
{
AddressClient tempAddress = new AddressClient();
tempAddress.idAddress = Convert.ToInt32(result[0]);
tempAddress.address = result[1].ToString();
tempAddress.number = result[2].ToString();
tempAddress.comp = result[3].ToString();
tempAddress.zipcode = result[4].ToString();
tempAddress.district = result[5].ToString();
tempAddress.city = result[6].ToString();
tempAddress.uf = result[7].ToString();
tempAddress.idProvider = Convert.ToInt32(result[10]);
tempAddress.idClient = idClient;
address.Add(tempAddress);
}
result.Close();
connection.closeConnection();
return(address);
}
public void saveAddressClient(AddressClient address)
{
try {
ConnectionDB connection = new ConnectionDB();
connection.openConnection();
string command = $"INSERT INTO endereco (idEndereco, rua, numero, complemento, cep, bairro, municipio, uf, criado, Fornecedor_idfornecedor, Cliente_idcliente) VALUES (null,'{address.address}', '{address.number}', '{address.comp}', '{address.zipcode}', '{address.district}', '{address.city}', '{address.uf}', NOW(), {IdProvider}, {address.idClient});";
connection.insert(command);
message = "Endereço inserido com sucesso !!";
caption = "Sucesso";
}
catch (Exception err)
{
Console.WriteLine(err.ToString());
message = "Falha ao inserir novo endereço.";
caption = "Falha";
icon = MessageBoxIcon.Error;
}
finally
{
MessageBox.Show(message, caption, buttons, icon);
}
}
