private MnjTipoCuenta()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
loadAccountTypes("");
managePermission();
}
private MnjTipoMoneda()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
loadCurrenciesTypes("");
managePermission();
}
private MnjCuentaContable()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
loadCountablesAccounts("");
managePermission();
}
private MnjEntradaContable()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
loadPlacements("");
managePermission();
}
public Parametro()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
try
{
parameter = entities.parameters.First();
} catch (Exception e) {
parameter = null;
}
loadParamater();
}
public Usuario()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
userLevels = new List <UserLevel>()
{
new UserLevel {
name = "Administrador", value = 1
},
new UserLevel {
name = "Normal", value = 3
}
};
cbLevel.DataSource = userLevels;
cbLevel.DisplayMember = "name";
}
public Reporte()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
List <countables_accounts> accounts = entities.countables_accounts.ToList();
accounts.Insert(0, new countables_accounts {
description = "---- Todas ----"
});
cbAccounts.DataSource = accounts;
cbAccounts.DisplayMember = "description";
parameter = entities.parameters.First();
lblRnc.Text = parameter.rnc;
lblCloseMonth.Text = new DateTime(2010, parameter.month_close, 5).ToString("MMMM");
lblMonth.Text = new DateTime(2010, parameter.month, 5).ToString("MMMM");
lblYear.Text = parameter.year.ToString();
}
private EntradaContable()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
movements = new List <placements_movements>();
accounts = (from em in entities.countables_accounts
where em.allow_transaction == true && em.state == true
select em).ToList();
cbAccount.DataSource = accounts;
cbAccount.DisplayMember = "description";
currencies = (from em in entities.currencies_types
where em.state == true
select em).ToList();
cbCurrency.DataSource = currencies;
cbCurrency.DisplayMember = "description";
cbMovementType.DataSource = new string[] { "DB", "CR" };
}
private void btnDelete_Click(object sender, EventArgs e)
{
DataGridViewRow row = null;
if (dgvAccountTypes.SelectedRows.Count == 1)
{
row = dgvAccountTypes.SelectedRows[0];
}
else if (dgvAccountTypes.SelectedCells.Count == 1)
{
int i = dgvAccountTypes.SelectedCells[0].RowIndex;
row = dgvAccountTypes.Rows[i];
}
else
{
MessageBox.Show(
"Debe seleccionar solo 1 tipo de cuenta a eliminar",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
if (row != null)
{
int id = Int32.Parse(row.Cells[0].Value.ToString());
account_types accountType = (from em in entities.account_types
where em.id == id
select em).First();
if (accountType == null)
{
MessageBox.Show(
"Tipo de Cuenta no encontrada",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
else
{
DialogResult deleteIt = MessageBox.Show(
"¿Estás seguro que quieres eliminar este tipo de cuenta?",
"Confirmar",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question
);
if (deleteIt == DialogResult.Yes)
{
entities.account_types.Remove(accountType);
try
{
entities.SaveChanges();
MessageBox.Show(
"Tipo de Cuenta eliminada con éxito",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
loadAccountTypes("");
} catch (Exception ex) {
MessageBox.Show(
"¡Este Tipo de Cuenta se encuentra en uso!",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
ConnectionDB.getInstance().resetConnection();
}
}
}
}
}
private IniciarSesion()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
}
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();
}
}
}
}
}
private CuentaContable()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
initialize();
}
private Contabilidad()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
}
private MnjUsers()
{
InitializeComponent();
entities = ConnectionDB.getInstance().getEntities();
loadUsers("");
}
