public bool saveAccountType(account_types accountType, bool isNew)
{
// Validation
string errors = validate(accountType);
if (errors.Length > 0)
{
MessageBox.Show(
errors,
"Error de validación",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
return(false);
}
if (isNew)
{
entities.account_types.Add(accountType);
}
entities.SaveChanges();
loadAccountTypes("");
return(true);
}
public bool saveCurrencyType(currencies_types currencyType, bool isNew)
{
// Validating
string errors = validate(currencyType);
if (errors.Length > 0)
{
MessageBox.Show(
errors,
"Error de validación",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
return(false);
}
// End validtion
if (isNew)
{
entities.currencies_types.Add(currencyType);
}
entities.SaveChanges();
loadCurrenciesTypes("");
return(true);
}
public void mayorize(placements placement, bool revert)
{
var movements = (from em in entities.placements_movements
where em.placement_id == placement.id
select em).ToList();
foreach (var movement in movements)
{
updateBalance(movement.account, movement.movement_type, movement.amount, revert);
}
entities.SaveChanges();
}
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 btnSave_Click(object sender, EventArgs e)
{
String errors = "";
parameters parameterLocal = null;
if (parameter == null)
{
parameterLocal = new parameters
{
rnc = txtRnc.Text,
year = Int32.Parse(dtYear.Text),
month = Int32.Parse(dtMonth.Text),
month_close = Int32.Parse(dtCloseMonth.Text),
processed = "S"
};
errors = validate(parameterLocal);
}
else
{
parameter = entities.parameters.First(el => el.id == parameter.id);
parameter.rnc = txtRnc.Text;
parameter.year = Int32.Parse(dtYear.Text);
parameter.month = Int32.Parse(dtMonth.Text);
parameter.month_close = Int32.Parse(dtCloseMonth.Text);
parameter.processed = "S";
errors = validate(parameter);
}
if (errors.Length > 0)
{
MessageBox.Show(
errors,
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
else
{
if (parameter == null)
{
entities.parameters.Add(parameterLocal);
}
entities.SaveChanges();
MessageBox.Show(
"¡Datos almacenados con éxito!",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
this.Close();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
bool created = false;
placements placement = new placements()
{
description = txtDescription.Text,
auxiliary_id = 1,
date = DateTime.Now,
currency_type = ((currencies_types)cbCurrency.SelectedItem).id,
exchange_rate = ((currencies_types)cbCurrency.SelectedItem).exchange_rate,
state = "R"
};
String errors = validate(placement);
if (errors.Length > 0)
{
MessageBox.Show(
errors,
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
return;
}
using (var transaction = entities.Database.BeginTransaction()) {
try
{
entities.placements.Add(placement);
foreach (var el in movements)
{
el.placement_id = placement.id;
entities.placements_movements.Add(el);
}
entities.SaveChanges();
MnjEntradaContable.getInstance().mayorize(placement);
transaction.Commit();
created = true;
}
catch (Exception ex)
{
Console.WriteLine(ex);
transaction.Rollback();
}
};
if (created)
{
MessageBox.Show(
"Asiento registrado con éxito",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
MnjEntradaContable.getInstance().loadPlacements("");
this.Close();
}
else
{
MessageBox.Show(
"El asiento no pudo ser registrado",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DataGridViewRow row = null;
if (dgvUsers.SelectedRows.Count == 1)
{
row = dgvUsers.SelectedRows[0];
}
else if (dgvUsers.SelectedCells.Count == 1)
{
int i = dgvUsers.SelectedCells[0].RowIndex;
row = dgvUsers.Rows[i];
}
else
{
MessageBox.Show(
"Debes seleccionar solo 1 usuario a eliminar",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
if (row != null)
{
DialogResult deleteIt = MessageBox.Show(
"¿Estas seguro de eliminar este usuario?",
"Confirmar",
MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Question
);
if (deleteIt != DialogResult.Yes)
{
return;
}
int id = Int32.Parse(row.Cells[0].Value.ToString());
users localUser = (from em in entities.users
where em.id == id
select em).First();
if (localUser == null)
{
MessageBox.Show(
"El Usuario seleccionado no existe",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
loadUsers("");
}
else
{
int adminTotal = entities.users.Count(el => el.permission == 1);
if (adminTotal == 1 && localUser.permission == 1)
{
MessageBox.Show(
"No puedes eliminar al único administrador",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
else
{
bool delete = true;
bool sameAsLogged = false;
if (localUser.id == Contabilidad.user.id)
{
delete = false;
sameAsLogged = true;
DialogResult response = MessageBox.Show(
"Estas a punto de eliminar tu usuario. Esta acción te expulsará del sistema\n\n¿Deseas continuar?",
"Confirmar",
MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Question
);
if (response == DialogResult.Yes)
{
delete = true;
}
}
if (delete)
{
entities.users.Remove(localUser);
entities.SaveChanges();
MessageBox.Show(
"¡Usuario eliminado con éxito!",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
if (sameAsLogged)
{
IniciarSesion.getInstance().Show();
Contabilidad.showLogin = true;
Contabilidad.getInstance().Close();
}
else
{
loadUsers("");
}
}
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
users userLocal = null;
if (user == null)
{
userLocal = new users
{
name = txtName.Text,
created_at = DateTime.Now,
permission = ((UserLevel)cbLevel.SelectedItem).value,
username = txtUsername.Text
};
using (MD5 md5 = MD5.Create())
{
byte[] hash = Encoding.ASCII.GetBytes(txtPassword.Text);
hash = md5.ComputeHash(hash);
StringBuilder sb = new StringBuilder();
foreach (var x in hash)
{
sb.Append(x.ToString("x2"));
}
userLocal.password = sb.ToString();
}
}
else
{
user = entities.users.First(el => el.id == user.id);
user.name = txtName.Text;
user.updated_at = DateTime.Now;
user.permission = ((UserLevel)cbLevel.SelectedItem).value;
user.username = txtUsername.Text;
if (txtPassword.Modified)
{
using (MD5 md5 = MD5.Create())
{
byte[] hash = Encoding.ASCII.GetBytes(txtPassword.Text);
hash = md5.ComputeHash(hash);
StringBuilder sb = new StringBuilder();
foreach (var x in hash)
{
sb.Append(x.ToString("x2"));
}
user.password = sb.ToString();
}
}
}
String errors = "";
if (userLocal == null)
{
errors = validate(user);
}
else
{
errors = validate(userLocal);
}
if (errors.Length > 0)
{
MessageBox.Show(
errors,
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
else
{
if (userLocal != null)
{
entities.users.Add(userLocal);
}
entities.SaveChanges();
MessageBox.Show(
"¡Usuario guardado con éxito!",
"Información",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
MnjUsers.getInstance().loadUsers("");
this.Close();
}
}
