public void setCuentaContable(countables_accounts countableAccount) { this.countableAccount = countableAccount; loadMayorAccount(countableAccount.level); txtDescription.Text = countableAccount.description; chkbAllowTransactions.Checked = countableAccount.allow_transaction; cbLevel.SelectedIndex = countableAccount.level - 1; for (int x = 0; x < cbMajorAccount.Items.Count; x++) { countables_accounts tempCountableAccount = (countables_accounts)cbMajorAccount.Items[x]; if (tempCountableAccount.id == countableAccount.account_major) { cbMajorAccount.SelectedIndex = x; break; } } if (countableAccount.state) { rbActive.Checked = true; rbInactive.Checked = false; } else { rbActive.Checked = false; rbInactive.Checked = true; } }
public bool saveAccountCountable(countables_accounts accountCountable, bool isNew) { // Validation string errors = validate(accountCountable); if (errors.Length > 0) { MessageBox.Show( errors, "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Error ); return(false); } if (isNew) { entities.countables_accounts.Add(accountCountable); } try { entities.SaveChanges(); MessageBox.Show( "¡Cambios guardados con éxito!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information ); loadCountablesAccounts(""); return(true); } catch (Exception ex) { MessageBox.Show( "¡No se pudo guardar los cambios!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error ); loadCountablesAccounts(""); return(false); } }
private void btnFilter_Click(object sender, EventArgs e) { String account = ""; countables_accounts cAccount = ((countables_accounts)cbAccounts.SelectedItem); if (cAccount.id != 0) { account = cAccount.description; } DateTime dateFrom = new DateTime(dtFrom.Value.Year, dtFrom.Value.Month, dtFrom.Value.Day); DateTime dateTo = new DateTime(dtTo.Value.Year, dtTo.Value.Month, dtTo.Value.Day); dateTo = dateTo.AddMilliseconds(-1); dateTo = dateTo.AddDays(1); loadMovements(account, txtDescription.Text, dateFrom, dateTo); }
private void btnSave_Click(object sender, EventArgs e) { bool saved = false; if (countableAccount == null) { countables_accounts newCountableAccount = new countables_accounts { description = txtDescription.Text, account_type = ((account_types)cbType.SelectedItem).id, allow_transaction = chkbAllowTransactions.Checked, level = (int)cbLevel.SelectedItem, balance = 0, state = rbActive.Checked }; if (newCountableAccount.level != 1) { newCountableAccount.account_major = ((countables_accounts)cbMajorAccount.SelectedItem).id; } saved = MnjCuentaContable.getInstance().saveAccountCountable(newCountableAccount, true); } else { countableAccount.description = txtDescription.Text; countableAccount.account_type = ((account_types)cbType.SelectedItem).id; countableAccount.allow_transaction = chkbAllowTransactions.Checked; countableAccount.level = (int)cbLevel.SelectedItem; countableAccount.state = rbActive.Checked; if (countableAccount.level != 1) { countableAccount.account_major = ((countables_accounts)cbMajorAccount.SelectedItem).id; } saved = MnjCuentaContable.getInstance().saveAccountCountable(countableAccount, false); } if (saved) { this.Close(); } }
public String validate(countables_accounts countableAccount) { StringBuilder sb = new StringBuilder(); foreach (var prop in countableAccount.GetType().GetProperties()) { if (prop.PropertyType == typeof(string)) { prop.SetValue(countableAccount, ((string)prop.GetValue(countableAccount)).Trim()); } } if (countableAccount.description.Length == 0) { sb.Append("- El campo descripción es obligatorio\n"); } if (countableAccount.level > 1 && countableAccount.account_major == null) { sb.Append("El campo cuenta mayor es obligatorio\n"); } return(sb.ToString()); }
private void btnModify_Click(object sender, EventArgs e) { DataGridViewRow row = null; if (dgvCountablesAccounts.SelectedRows.Count == 1) { row = dgvCountablesAccounts.SelectedRows[0]; } else if (dgvCountablesAccounts.SelectedCells.Count == 1) { int i = dgvCountablesAccounts.SelectedCells[0].RowIndex; row = dgvCountablesAccounts.Rows[i]; } else { MessageBox.Show( "Debe seleccionar solo 1 tipo de cuenta a modificar", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information ); } if (row != null) { int id = Int32.Parse(row.Cells[0].Value.ToString()); CuentaContable cuentaContable = CuentaContable.getInstance(); countables_accounts countableAccount = (from em in entities.countables_accounts where em.id == id select em).First(); cuentaContable.setCuentaContable(countableAccount); cuentaContable.ShowDialog(this); cuentaContable.Focus(); } }
private void btnDelete_Click(object sender, EventArgs e) { DataGridViewRow row = null; if (dgvCountablesAccounts.SelectedRows.Count == 1) { row = dgvCountablesAccounts.SelectedRows[0]; } else if (dgvCountablesAccounts.SelectedCells.Count == 1) { int i = dgvCountablesAccounts.SelectedCells[0].RowIndex; row = dgvCountablesAccounts.Rows[i]; } else { MessageBox.Show( "Debe seleccionar solo 1 tipo de cuenta a modificar", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information ); } if (row != null) { DialogResult deleteIt = MessageBox.Show( "¿Estás seguro de eliminar esta cuenta?", "Confirmar", MessageBoxButtons.YesNo, MessageBoxIcon.Question ); if (deleteIt == DialogResult.Yes) { int id = Int32.Parse(row.Cells[0].Value.ToString()); countables_accounts countableAccount = (from em in entities.countables_accounts where em.id == id select em).First(); if (countableAccount == null) { MessageBox.Show( "¡Cuenta no encontrada!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information ); } else { try { entities.countables_accounts.Remove(countableAccount); entities.SaveChanges(); MessageBox.Show( "¡Cuenta Eliminada con éxito!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information ); loadCountablesAccounts(""); } catch (Exception ex) { MessageBox.Show( "La cuenta no pudo ser eliminada porque se encuentra en uso", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error ); ConnectionDB.getInstance().resetConnection(); } } } } }