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 bool validateForm(FinanceCategorySub financeCategorySub)
{
if (cmbType.SelectedIndex.Equals(0) || cmbType.Text.Trim().Equals(""))
{
lblErrorType.Text = "Campo obrigatório";
cmbType.Focus();
return(false);
}
lblErrorType.Text = "";
if (cmbCategory.SelectedItem == null)
{
lblErrorCategory.Text = "Campo obrigatório";
cmbCategory.Focus();
return(false);
}
lblErrorCategory.Text = "";
financeCategorySub.Name = txtName.Text.Trim();
if (financeCategorySub.Name.Equals(""))
{
lblErrorName.Text = "Campo obrigatório.";
txtName.Focus();
return(false);
}
if (FinanceCategorySubDAO.CountByName(financeCategorySub) > 0)
{
lblErrorName.Text = "Já consta cadastrado.";
return(false);
}
lblErrorName.Text = "";
return(true);
}
public static int CountByName(FinanceCategorySub financeCategorySubVO)
{
DBEntities db = SingletonObjectContext.Instance.Context;
try
{
return(db.FinanceCategoriesSubs.Count(x => x.Id != financeCategorySubVO.Id && x.Status > 0 && x.FinanceCategory.Id.Equals(financeCategorySubVO.FinanceCategory.Id) && x.Name.Equals(financeCategorySubVO.Name)));
}
catch
{
return(0);
}
}
public static FinanceCategorySub GetByID(FinanceCategorySub financeCategorySubVO)
{
DBEntities db = SingletonObjectContext.Instance.Context;
try
{
return(db.FinanceCategoriesSubs.FirstOrDefault(x => x.Id.Equals(financeCategorySubVO.Id) && x.Status > 0));
}
catch
{
return(null);
}
}
private void dgList_DoubleClick(object sender, EventArgs e)
{
FinanceCategorySub financeCategorySubVO = new FinanceCategorySub();
financeCategorySubVO.Id = int.Parse(dgList.CurrentRow.Cells["clId"].Value.ToString());
financeCategorySubVO = FinanceCategorySubDAO.GetByID(financeCategorySubVO);
cmbType.SelectedIndex = financeCategorySubVO.FinanceCategory.Type;
this.ShowCmbCategory();
cmbCategory.SelectedItem = financeCategorySubVO.FinanceCategory;
txtName.Text = financeCategorySubVO.Name;
txtId.Text = financeCategorySubVO.Id.ToString();
btnExcluir.Enabled = true;
}
public static IOrderedEnumerable <FinanceCategorySub> ListAllBy(FinanceCategorySub financeCategorySubVO)
{
DBEntities db = SingletonObjectContext.Instance.Context;
if (financeCategorySubVO.FinanceCategory.Id > 0)
{
return(db.FinanceCategoriesSubs.Include("FinanceCategory").Where(x => x.Status > 0 && x.FinanceCategory.Id.Equals(financeCategorySubVO.FinanceCategory.Id)).ToList().OrderBy(x => x.Name));
}
if (financeCategorySubVO.FinanceCategory.Type > 0)
{
return(db.FinanceCategoriesSubs.Include("FinanceCategory").Where(x => x.Status > 0 && x.FinanceCategory.Type.Equals(financeCategorySubVO.FinanceCategory.Type)).ToList().OrderBy(x => x.Name));
}
return(db.FinanceCategoriesSubs.Include("FinanceCategory").Where(x => x.Status > 0).ToList().OrderBy(x => x.Name));
}
public static bool Update(FinanceCategorySub financeCategorySubVO)
{
DBEntities db = SingletonObjectContext.Instance.Context;
try
{
financeCategorySubVO.DateUpdate = DateTime.Now;
db.Entry(financeCategorySubVO).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool Insert(FinanceCategorySub financeCategorySubVO)
{
DBEntities db = SingletonObjectContext.Instance.Context;
try
{
financeCategorySubVO.Status = SystemU.STATUS_ATIVO;
financeCategorySubVO.DatePost = DateTime.Now;
financeCategorySubVO.DateUpdate = DateTime.Now;
db.FinanceCategoriesSubs.Add(financeCategorySubVO);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
private void btnExcluir_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Deseja mesmo este registro?", "Sub-Categoria", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinanceCategorySub financeCategorySubVO = new FinanceCategorySub();
financeCategorySubVO.Id = int.Parse(txtId.Text);
financeCategorySubVO = FinanceCategorySubDAO.GetByID(financeCategorySubVO);
if (!FinanceCategorySubDAO.UpdateDisable(financeCategorySubVO))
{
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)
{
FinanceCategorySub financeCategorySub = new FinanceCategorySub();
int Id;
if (int.TryParse(txtId.Text, out Id))
{
financeCategorySub.Id = Id;
financeCategorySub = FinanceCategorySubDAO.GetByID(financeCategorySub);
}
FinanceCategory financeCategory = new FinanceCategory();
financeCategory = (FinanceCategory)cmbCategory.SelectedItem;
financeCategory = FinanceCategoryDAO.GetByID(financeCategory);
financeCategorySub.FinanceCategory = financeCategory;
if (this.validateForm(financeCategorySub))
{
if (financeCategorySub.Id > 0)
{
if (FinanceCategorySubDAO.Update(financeCategorySub))
{
MessageBox.Show("Alterado com sucesso.");
this.ClearFields();
this.showGrid();
return;
}
MessageBox.Show("Erro: Ocorreu um erro inesperado alterar.");
}
else
{
if (FinanceCategorySubDAO.Insert(financeCategorySub))
{
MessageBox.Show("Cadastrado com sucesso.");
this.ClearFields();
this.showGrid();
return;
}
MessageBox.Show("Erro: Ocorreu um erro inesperado cadastrar.");
}
}
}
private void showGrid()
{
FinanceCategory financeCategory = new FinanceCategory();
FinanceCategorySub financeCategorySub = new FinanceCategorySub();
if (cmbBuscarType.SelectedIndex != 0)
{
financeCategory.Type = cmbBuscarType.SelectedIndex;
}
if (cmbBuscarCategory.SelectedItem != null)
{
financeCategory = (FinanceCategory)cmbBuscarCategory.SelectedItem;
}
financeCategorySub.FinanceCategory = financeCategory;
dgList.Rows.Clear();
foreach (FinanceCategorySub x in FinanceCategorySubDAO.ListAllBy(financeCategorySub))
{
dgList.Rows.Add(x.Id, x.Name, x.FinanceCategory.Name);
}
}
private void ShowCmbCategorySub()
{
FinanceCategorySub fcSub = new FinanceCategorySub();
fcSub.FinanceCategory = (FinanceCategory)cmbCategory.SelectedItem;
if (cmbCategory.SelectedItem == null)
{
return;
}
cmbCategorySub.Items.Clear();
cmbCategorySub.Items.Add("Carregando ...");
cmbCategorySub.Items.Clear();
foreach (FinanceCategorySub x in FinanceCategorySubDAO.ListAllBy(fcSub))
{
cmbCategorySub.Items.Add(x);
}
cmbCategorySub.ValueMember = "Id";
cmbCategorySub.DisplayMember = "Name";
}
private void cmbBuscarCategory_SelectedValueChanged(object sender, EventArgs e)
{
FinanceCategorySub fcSub = new FinanceCategorySub();
fcSub.FinanceCategory = (FinanceCategory)cmbBuscarCategory.SelectedItem;
if (fcSub.FinanceCategory == null)
{
return;
}
cmbBuscarCategorySub.Items.Clear();
cmbBuscarCategorySub.Items.Add("Carregando ...");
cmbBuscarCategorySub.Items.Clear();
foreach (FinanceCategorySub x in FinanceCategorySubDAO.ListAllBy(fcSub))
{
cmbBuscarCategorySub.Items.Add(x);
}
cmbBuscarCategorySub.ValueMember = "Id";
cmbBuscarCategorySub.DisplayMember = "Name";
}
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.");
}
}
}
