private void dgList_DoubleClick(object sender, EventArgs e)
{
Finance financeVO = new Finance();
financeVO.Id = int.Parse(dgList.CurrentRow.Cells["clId"].Value.ToString());
financeVO = FinanceDAO.GetByID(financeVO);
cmbCategory.SelectedItem = financeVO.FinanceCategorySub.FinanceCategory;
this.ShowCmbCategorySub();
cmbCategorySub.SelectedItem = financeVO.FinanceCategorySub;
cmbPaymentForm.SelectedItem = financeVO.PaymentForm;
txtValue.Text = financeVO.Value.ToString();
dtDateTime.Text = financeVO.Date.ToString();
if (financeVO.Situation == FinanceU.SITUATION_PAGO)
{
rbSituationPago.Checked = true;
}
else
{
rbSituationPendente.Checked = true;
}
cmbPriority.SelectedIndex = financeVO.Priority;
txtText.Text = financeVO.Text;
txtId.Text = financeVO.Id.ToString();
btnExcluir.Enabled = true;
}
private void showGrid()
{
FinanceCategory financeCategory = new FinanceCategory();
FinanceCategorySub financeCategorySub = new FinanceCategorySub();
Finance finance = new Finance();
if (cmbBuscarCategory.SelectedItem != null)
{
financeCategory = (FinanceCategory)cmbBuscarCategory.SelectedItem;
}
if (cmbBuscarCategorySub.SelectedItem != null)
{
financeCategorySub = (FinanceCategorySub)cmbBuscarCategorySub.SelectedItem;
}
financeCategory.Type = this.Type;
finance.FinanceCategorySub = financeCategorySub;
finance.FinanceCategorySub.FinanceCategory = financeCategory;
dgList.Rows.Clear();
foreach (Finance x in FinanceDAO.ListAllBy(finance))
{
dgList.Rows.Add(x.Id, x.FinanceCategorySub.FinanceCategory.Name + ", " + x.FinanceCategorySub.Name,
Util.moneyFormat_ptBR(x.Value), x.Date, FinanceU.ArraySituation[x.Situation],
x.PaymentForm.Name, FinanceU.ArrayPriority[x.Priority]);
}
}
private void showGrid()
{
DateTime dateIn = DateTime.Parse(dtDateIn.Text);
DateTime dateEnd = DateTime.Parse(dtDateEnd.Text);
Finance finance;
double ganhos, gastos, totalGanhos = 0, totalGastos = 0, saldo;
dgList.Rows.Clear();
foreach (PaymentForm p in PaymentFormDAO.ListAll())
{
finance = new Finance();
finance.FinanceCategorySub = new FinanceCategorySub();
finance.FinanceCategorySub.FinanceCategory = new FinanceCategory();
finance.FinanceCategorySub.FinanceCategory.Type = FinanceCategoryU.TYPE_GANHO;
finance.PaymentForm = p;
ganhos = 0;
foreach (Finance f in FinanceDAO.ListByFilter(finance, dateIn, dateEnd))
{
ganhos += f.Value;
}
finance.FinanceCategorySub.FinanceCategory.Type = FinanceCategoryU.TYPE_GASTO;
gastos = 0;
foreach (Finance f in FinanceDAO.ListByFilter(finance, dateIn, dateEnd))
{
gastos += f.Value;
}
dgList.Rows.Add(p.Name, Util.moneyFormat_ptBR(ganhos), Util.moneyFormat_ptBR(gastos), Util.moneyFormat_ptBR(FinanceBO.CalcSaldo(ganhos, gastos)));
totalGanhos += ganhos;
totalGastos += gastos;
}
txtGanhos.Text = Util.moneyFormat_ptBR(totalGanhos);
txtGastos.Text = Util.moneyFormat_ptBR(totalGastos);
saldo = FinanceBO.CalcSaldo(totalGanhos, totalGastos);
txtMeuSaldo.Text = Util.moneyFormat_ptBR(saldo);
if (saldo > 0)
{
txtMeuSaldo.ForeColor = System.Drawing.Color.Green;
}
else
{
txtMeuSaldo.ForeColor = System.Drawing.Color.Red;
}
}
private void btnExcluir_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Deseja mesmo este registro?", "Finança", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Finance financeVO = new Finance();
financeVO.Id = int.Parse(txtId.Text);
financeVO = FinanceDAO.GetByID(financeVO);
if (!FinanceDAO.UpdateDisable(financeVO))
{
MessageBox.Show("Erro: Ocorreu um erro inesperado excluir.");
}
else
{
MessageBox.Show("Excluído com sucesso.");
this.ClearFields();
this.showGrid();
}
}
}
private void btnSalvar_Click(object sender, EventArgs e)
{
Finance finance = new Finance();
int Id;
if (int.TryParse(txtId.Text, out Id))
{
finance.Id = Id;
finance = FinanceDAO.GetByID(finance);
}
FinanceCategorySub financeCategorySub = new FinanceCategorySub();
financeCategorySub = (FinanceCategorySub)cmbCategorySub.SelectedItem;
financeCategorySub = FinanceCategorySubDAO.GetByID(financeCategorySub);
finance.FinanceCategorySub = financeCategorySub;
PaymentForm paymentForm = new PaymentForm();
paymentForm = (PaymentForm)cmbPaymentForm.SelectedItem;
paymentForm = PaymentFormDAO.GetByID(paymentForm);
finance.PaymentForm = paymentForm;
finance.Date = dtDateTime.Value;
if (rbSituationPago.Checked)
{
finance.Situation = FinanceU.SITUATION_PAGO;
finance.DateClose = finance.Date;
}
else
{
finance.Situation = FinanceU.SITUATION_PENDENTE;
finance.DateClose = DateTime.Now;
}
finance.Text = txtText.Text;
if (this.validateForm(finance))
{
if (finance.Id > 0)
{
if (FinanceDAO.Update(finance))
{
MessageBox.Show("Alterado com sucesso.");
this.ClearFields();
this.showGrid();
return;
}
MessageBox.Show("Erro: Ocorreu um erro inesperado alterar.");
}
else
{
if (FinanceDAO.Insert(finance))
{
MessageBox.Show("Cadastrado com sucesso.");
this.ClearFields();
this.showGrid();
return;
}
MessageBox.Show("Erro: Ocorreu um erro inesperado cadastrar.");
}
}
}
