public List <PhoneClient> getPhoneClient(int idClient) { phones.Clear(); ConnectionDB connection = new ConnectionDB(); connection.openConnection(); string command = $"SELECT * FROM telefone WHERE Cliente_idcliente = {idClient};"; MySqlDataReader result = connection.select(command); while (result.Read()) { PhoneClient phone = new PhoneClient(Convert.ToInt32(result[0]), result[1].ToString(), result[2].ToString(), result[3].ToString(), idClient); phones.Add(phone); } result.Close(); connection.closeConnection(); return(phones); }
public void savePhoneClient(PhoneClient phone) { try { ConnectionDB connection = new ConnectionDB(); connection.openConnection(); string command = $"INSERT INTO telefone (idtelefone, tipo, codArea, numero, criado, Cliente_idcliente) VALUES (null,'{phone.type}', '{phone.code}', '{phone.number}', NOW(), {phone.idClient});"; connection.insert(command); message = "Contato inserido com sucesso !!"; caption = "Sucesso"; } catch (Exception err) { Console.WriteLine(err.ToString()); message = "Falha ao inserir novo contato."; caption = "Falha"; icon = MessageBoxIcon.Error; } finally { MessageBox.Show(message, caption, buttons, icon); } }