private void btnAlterar_Click(object sender, EventArgs e)
{
try
{
Database.Entities.tb_account account = new Database.Entities.tb_account();
account.id_account = Convert.ToInt32(nudId.Value);
account.nm_account = txtNome.Text.Trim();
account.nr_identification = mtxtIdentificação.Text.Trim();
account.vl_value = Convert.ToDecimal(nudValor.Value);
account.ds_note = rtxtDescrição.Text.Trim();
Business.AccountBusiness busaccount = new Business.AccountBusiness();
busaccount.Alterar(account);
MessageBox.Show("Produto alterado com sucesso");
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Consulta()
{
Database.Entities.tb_account account = new Database.Entities.tb_account();
account.nm_account = txtNome.Text.Trim();
account.nr_identification = mtxtIdentificação.Text.Trim();
Business.AccountBusiness busaccount = new Business.AccountBusiness();
List <Database.Entities.tb_account> accountlista = busaccount.Consultar(account);
dgvConsultarConta.DataSource = accountlista;
}
public void Alterar(Database.Entities.tb_account account)
{
if (account.nm_account == string.Empty)
{
throw new ArgumentException("O campo nome deve ser preenchido");
}
if (account.nr_identification == string.Empty)
{
throw new ArgumentException("O campo identificação deve ser definido");
}
if (account.vl_value == Convert.ToDecimal("0,00"))
{
throw new ArgumentException("O campo quantidade deve ser preenchido");
}
db.Alterar(account);
}
private void dgvConsultarConta_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
Database.Entities.tb_account account = new Database.Entities.tb_account();
DataGridViewRow row = this.dgvConsultarConta.Rows[e.RowIndex];
}
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <Database.Entities.tb_account> Consultar(Database.Entities.tb_account account)
{
List <Database.Entities.tb_account> list = new List <Database.Entities.tb_account>();
if (account.nm_account != null && account.nr_identification == "-")
{
list = db.ConsultarPorNome(account);
}
else if (account.nm_account == null || account.nm_account == string.Empty && account.nr_identification != "-")
{
list = db.ConsultarPorIdentificação(account);
}
else if (account.nm_account != null && account.nr_identification != "-")
{
list = db.ConsultarPorNomeIdentificação(account);
}
return(list);
}
private void nudId_ValueChanged(object sender, EventArgs e)
{
int id = Convert.ToInt32(nudId.Value);
Business.AccountBusiness busaccount = new Business.AccountBusiness();
Database.Entities.tb_account account = busaccount.ConsultarPorID(id);
if (account == null)
{
txtNome.Text = string.Empty;
mtxtIdentificação.Text = string.Empty;
nudValor.Value = Convert.ToDecimal("0,00");
rtxtDescrição.Text = string.Empty;
}
else
{
txtNome.Text = account.nm_account;
mtxtIdentificação.Text = account.nr_identification;
nudValor.Value = Convert.ToDecimal(account.vl_value);
rtxtDescrição.Text = account.ds_note;
}
}
private void btnCadastrar_Click(object sender, EventArgs e)
{
try
{
Database.Entities.tb_account account = new Database.Entities.tb_account();
account.nm_account = txtNome.Text.Trim();
account.nr_identification = mtxtIdentificação.Text.Trim();
account.ds_note = rtxtDescrição.Text;
account.vl_value = nudValor.Value;
Business.AccountBusiness busaccount = new Business.AccountBusiness();
busaccount.Inserir(account);
MessageBox.Show("Conta cadastrado com sucesso", "OK", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Database.Entities.tb_account ConsultarPorID(int id)
{
Database.Entities.tb_account account = db.ConsultaPorID(id);
return(account);
}
