private void btnAgregar_Click(object sender, EventArgs e)
{
try
{
bool tipo;
if (rbAdmin.Checked)
{
tipo = true;
}
else
{
tipo = false;
}
if (txtFullName.Text.Length >= 5 && txtUsername.Text.Length >= 5 && (rbAdmin.Checked || rbUser.Checked))
{
AppUserDAO.CrearNuevo(txtFullName.Text, txtUsername.Text, txtUsername.Text, tipo);
MessageBox.Show(
"Usuario agregado, los valores por defecto, la contraseña es el mismo usuario",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtFullName.Clear();
txtUsername.Clear();
actualizarDatos();
}
else
{
MessageBox.Show("Verifique que los datos ingresados sean válidos",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{
MessageBox.Show("Verifique que los datos ingresados sean válidos",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void pupulateControls()
{
cmbUsername.DataSource = null;
cmbUsername.ValueMember = "password";
cmbUsername.DisplayMember = "username";
cmbUsername.DataSource = AppUserDAO.getList();
}
public async Task<bool> Update(AppUser AppUser)
{
AppUserDAO AppUserDAO = DataContext.AppUser.Where(x => x.Id == AppUser.Id).FirstOrDefault();
if (AppUserDAO == null)
return false;
await DataContext.AppUserRoleMapping.Where(x => x.AppUserId == AppUser.Id).DeleteFromQueryAsync();
if (AppUser.AppUserRoleMappings != null)
{
List<AppUserRoleMappingDAO> AppUserRoleMappingDAOs = new List<AppUserRoleMappingDAO>();
foreach (var AppUserRoleMapping in AppUser.AppUserRoleMappings)
{
AppUserRoleMappingDAO AppUserRoleMappingDAO = new AppUserRoleMappingDAO
{
AppUserId = AppUser.Id,
RoleId = AppUserRoleMapping.RoleId
};
AppUserRoleMappingDAOs.Add(AppUserRoleMappingDAO);
}
await DataContext.AppUserRoleMapping.BulkMergeAsync(AppUserRoleMappingDAOs);
}
AppUserDAO.UpdatedAt = StaticParams.DateTimeNow;
await DataContext.SaveChangesAsync();
return true;
}
private void button1_Click(object sender, EventArgs e)
{
if ((txtPass1.Text.Equals(txtPass2.Text)) && txtPass1.Text.Length > 0)
{
try
{
AppUserDAO.UpdatePass(txtPass2.Text, user);
MessageBox.Show("Contraseña actualizada.", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
throw;
}
}
else
{
MessageBox.Show("Las contraseñas no coindicen", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Information);
txtPass1.Text = "";
txtPass2.Text = "";
}
}
private void frmCambiarContra_Load(object sender, EventArgs e)
{
comboBox1.DataSource = null;
comboBox1.ValueMember = "password";
comboBox1.DisplayMember = "iduser";
comboBox1.DataSource = AppUserDAO.getLista();
}
private void frmPrincipal_Load(object sender, EventArgs e)
{
cmbUsuarios.DataSource = null;
cmbUsuarios.ValueMember = "idUser";
cmbUsuarios.DisplayMember = "username";
cmbUsuarios.DataSource = AppUserDAO.GetLista();
cmbNegociosProd.DataSource = null;
cmbNegociosProd.ValueMember = "idBusiness";
cmbNegociosProd.DisplayMember = "name";
cmbNegociosProd.DataSource = BusinessDAO.GetLista();
cmbNegocios.DataSource = null;
cmbNegocios.ValueMember = "idBusiness";
cmbNegocios.DisplayMember = "name";
cmbNegocios.DataSource = BusinessDAO.GetLista();
cmbProds.DataSource = null;
cmbProds.ValueMember = "idProduct";
cmbProds.DisplayMember = "name";
cmbProds.DataSource = ProducDAO.GetProdsNeg();
dgUsuarios.DataSource = null;
dgUsuarios.DataSource = AppUserDAO.GetLista();
dgNegocios.DataSource = null;
dgNegocios.DataSource = BusinessDAO.GetLista();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text.Length > 0)
{
AppUserDAO.crearNuevo(textBox1.Text, textBox2.Text);
MessageBox.Show("¡Usuario agregado exitosamente! Valores por defecto: passwor igual a username y no admin",
"SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox1.Clear();
actualizarControles();
}
else
{
MessageBox.Show("Favor no deje campos vacios",
"SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception)
{
MessageBox.Show("El usuario que ha digitado, no se encuentra disponible.",
"SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PoblarControles()
{
comboBox1.DataSource = null;
comboBox1.ValueMember = "password";
comboBox1.DisplayMember = "username";
comboBox1.DataSource = AppUserDAO.getLista();
}
private void btnPwdChange_Click(object sender, EventArgs e)
{
bool actualIgual = Encryptor.CompararMD5(txtOld.Text, password);
bool nuevaIgual = txtNew.Text.Equals(txtConfirm.Text);
bool nuevaValida = txtNew.Text.Length > 0;
if (actualIgual && nuevaIgual && nuevaValida)
{
try
{
AppUserDAO.passwordChange(username, Encryptor.CrearMD5(txtNew.Text));
MessageBox.Show("Password updated successfully!",
"HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception)
{
MessageBox.Show("Error, try again please.",
"HUGO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Error, incorrect input.",
"HUGO", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnAddUser_Click(object sender, EventArgs e)
{
// Crear un cliente y llenar sus datos desde la vista
AppUser u = new AppUser();
u.fullname = textBox1.Text;
u.username = textBox2.Text;
u.admin = checkBox1.Checked;
try
{
// Enviar a modelo, el se encargara de almacenarlo en la BDD
AppUserDAO.addUser(u);
MessageBox.Show($"Usuario agregado exitosamente (contraseña provisional: {u.username})",
"HugoApp - Food Delivery",
MessageBoxButtons.OK, MessageBoxIcon.Information);
// Limpiar la vista, los eventos se pueden invocar desde codigo
btnClearUser_Click(sender, e);
// Actualizar la vista, los ComboBox de la primer pestana
actualizarControlesAdmin();
actualizarTablasAdmin();
}
catch (Exception exception)
{
MessageBox.Show("Error: " + exception.Message, "Error dialog",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnInicioSesion_Click(object sender, EventArgs e)
{
try
{
var user = AppUserDAO.GetUser(txtUser.Text, txtPass.Text);
if (user.fullName.Equals(""))
{
MessageBox.Show("Usuario y/o contraseña incorrectos", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Bienvenido", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Information);
frmPrincipal ventana = new frmPrincipal(user);
ventana.Show();
this.Hide();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
throw;
}
}
private void button1_Click(object sender, EventArgs e)
{
bool actualIgual = Encriptador.CompararMD5(textBox1.Text, comboBox1.SelectedValue.ToString());
bool nuevaIgual = textBox2.Text.Equals(textBox3.Text);
bool nuevaValida = textBox2.Text.Length > 0;
if (actualIgual && nuevaIgual && nuevaValida)
{
try
{
AppUserDAO.actualizarContra(comboBox1.Text, Encriptador.CrearMD5(textBox2.Text));
MessageBox.Show("¡Contraseña actualizada exitosamente!",
"SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception)
{
MessageBox.Show("¡Contraseña no actualizada! Favor intente mas tarde.",
"SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("¡¡Favor verifique que los datos sean correctos!",
"SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void actualizarControlesAdmin()
{
// Realizar consulta a la base de datos
List <AppUser> listaU = AppUserDAO.getLista();
cmbUserId.DataSource = null;
cmbUserId.ValueMember = "id_User";
cmbUserId.DisplayMember = "id_User";
cmbUserId.DataSource = listaU;
List <Business> listaB = BusinessDAO.getLista();
cmbBusinessiD.DataSource = null;
cmbBusinessiD.DisplayMember = "idBusiness";
cmbBusinessiD.ValueMember = "idBusiness";
cmbBusinessiD.DataSource = listaB;
cmbBiD.DataSource = null;
cmbBiD.DisplayMember = "idBusiness";
cmbBiD.ValueMember = "idBusiness";
cmbBiD.DataSource = listaB;
List <Product> listaP = ProductDAO.getLista();
cmbProductId.DataSource = null;
cmbProductId.DisplayMember = "idProduct";
cmbProductId.ValueMember = "idProduct";
cmbProductId.DataSource = listaP;
}
private void btnChangePass_Click(object sender, EventArgs e)
{
bool actualIgual = Encriptador.CompararMD5(txtOldPass.Text, cmbUser.SelectedValue.ToString());
bool nuevaIgual = txtNewPass.Text.Equals(txtConfirmar.Text);
bool nuevaValida = txtNewPass.Text.Length > 0;
if (actualIgual && nuevaIgual && nuevaValida)
{
try
{
AppUserDAO.actualizarContra(Convert.ToInt32(cmbUser.Text), Encriptador.CrearMD5(txtNewPass.Text));
MessageBox.Show("¡Contraseña actualizada exitosamente!",
"HugoApp - Food Delivery", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception)
{
MessageBox.Show("¡Contraseña no actualizada! Favor intente mas tarde.",
"Error dialog", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("¡¡Favor verifique que los datos sean correctos!",
"Error dialog", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnAddUser_Click(object sender, EventArgs e)
{
AppUser u = new AppUser();
u.fullname = textBox1.Text;
u.username = textBox2.Text;
u.userType = checkBox1.Checked;
try
{
AppUserDAO.addAppUser(u);
MessageBox.Show("User added successfully.", "HUGO",
MessageBoxButtons.OK, MessageBoxIcon.Information);
btnClearUser_Click(sender, e);
updateAdminControls();
}
catch (Exception exception)
{
MessageBox.Show("Error: " + exception.Message, "Error dialog",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmModUsuario_Load(object sender, EventArgs e)
{
// Actualizar ComboBox
cmbUser.DataSource = null;
cmbUser.ValueMember = "password";
cmbUser.DisplayMember = "id_User";
cmbUser.DataSource = AppUserDAO.getLista();
}
private void poblarControles()
{
// Actualizar ComboBox
cmbUsuario.DataSource = null;
cmbUsuario.ValueMember = "password";
cmbUsuario.DisplayMember = "username";
cmbUsuario.DataSource = AppUserDAO.getLista();
}
void actualizarDatos()
{
cmbUsuarios.DataSource = AppUserDAO.GetLista();
dgUsuarios.DataSource = AppUserDAO.GetLista();
cmbNegociosProd.DataSource = BusinessDAO.GetLista();
dgNegocios.DataSource = BusinessDAO.GetLista();
cmbNegocios.DataSource = BusinessDAO.GetLista();
dgOrdenes.DataSource = AppOrderDAO.GetLista();
cmbProds.DataSource = ProducDAO.GetProdsNeg();
}
private void button3_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que desea eliminar al usuario " + comboBox1.Text + "?",
"SourceCode", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
AppUserDAO.eliminar(comboBox1.Text);
MessageBox.Show("¡Usuario eliminado exitosamente!",
"SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarControles();
}
}
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
string username = CreateUserWizard1.UserName;
string password = CreateUserWizard1.Password;
string email = CreateUserWizard1.Email;
string question = CreateUserWizard1.Question;
string answer = CreateUserWizard1.Answer;
AppUser appUser = new AppUser(username, password, email, question, answer);
AppUserDAO dao = new AppUserDAO();
dao.createAppUser(appUser);
}
private void btnEliminar_Click(object sender, EventArgs e)
{
int idu = Convert.ToInt32(cmbUsuarios.SelectedValue.ToString());
if (MessageBox.Show("¿Seguro que desea eliminar el usuario?",
"Hugo App", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
AppUserDAO.EliminarUsuario(idu);
MessageBox.Show("Se eliminó el usuario",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarDatos();
}
}
private void actualizarTablasAdmin()
{
dGUser.DataSource = null;
dGUser.DataSource = AppUserDAO.getLista();
dGBusiness.DataSource = null;
dGBusiness.DataSource = BusinessDAO.getLista();
dGProduct.DataSource = null;
dGProduct.DataSource = ProductDAO.getLista();
dGTotalOrders.DataSource = null;
dGTotalOrders.DataSource = AppOrderDAO.getLista();
}
private void btnDeleteUser_Click(object sender, EventArgs e)
{
try
{
AppUserDAO.removeAppUser(comboBox1.Text);
MessageBox.Show("User deleted successfully.", "HUGO",
MessageBoxButtons.OK, MessageBoxIcon.Information);
updateAdminControls();
}
catch (Exception exception)
{
MessageBox.Show("Error: " + exception.Message, "Error dialog",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
AppUserDAO.CrearNuevo(txtFullname.Text, (txtUsername1.Text).ToLower(), rdbUser.Checked);
MessageBox.Show("Ingresado con exito",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
ActualizarControles();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message,
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
private void btnEliminarUser_Click(object sender, EventArgs e)
{
try
{
AppUserDAO.removeUser((int)cmbUserId.SelectedValue);
MessageBox.Show("Usuario eliminado exitosamente", "HugoApp - Food Delivery",
MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarControlesAdmin();
actualizarTablasAdmin();
}
catch (Exception exception)
{
MessageBox.Show("Error: " + exception.Message, "Error dialog",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnEliminar_Click(object sender, EventArgs e)
{
try
{
AppUserDAO.EliminarUser(txtUsername2.Text);
MessageBox.Show("Eliminado con exito",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
ActualizarControles();
}
catch (Exception exception)
{
MessageBox.Show("El usuario no existe.",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
private void updateAdminControls()
{
List <AppUser> listU = AppUserDAO.getList();
List <Business> listB = BusinessDAO.getList();
List <Product> listP = ProductDAO.getList();
List <FullOrder> listf = OrderDAO.consultOrders();
comboBox1.DataSource = null;
comboBox1.DisplayMember = "username";
comboBox1.DataSource = listU;
comboBox2.DataSource = null;
comboBox2.DisplayMember = "username";
comboBox2.DataSource = listU;
comboBox3.DataSource = null;
comboBox3.DisplayMember = "name";
comboBox3.DataSource = listB;
comboBox4.DataSource = null;
comboBox4.DisplayMember = "name";
comboBox4.DataSource = listP;
comboBox5.DataSource = null;
comboBox5.DisplayMember = "name";
comboBox5.ValueMember = "idbusiness";
comboBox5.DataSource = listB;
dataGridView1.DataSource = null;
dataGridView1.DataSource = listU;
dataGridView2.DataSource = null;
dataGridView2.DataSource = listB;
dataGridView3.DataSource = null;
dataGridView3.DataSource = listP;
dataGridView4.DataSource = null;
dataGridView4.DataSource = listf;
poblarGrafico();
}
private ActionResult InitAdmin()
{
RoleDAO Admin = DataContext.Role
.Where(r => r.Name == "Admin")
.FirstOrDefault();
if (Admin == null)
{
Admin = new RoleDAO
{
Name = "Admin",
Code = "Admin",
};
DataContext.Role.Add(Admin);
DataContext.SaveChanges();
}
AppUserDAO AppUser = DataContext.AppUser
.Where(au => au.Username.ToLower() == "Administrator".ToLower())
.FirstOrDefault();
if (AppUser == null)
{
AppUser = new AppUserDAO()
{
Username = "******",
Birthday = DateTime.Now,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
DeletedAt = null,
DisplayName = "Administrator",
Email = "",
Password = HashPassword(AdminPassword),
Phone = "",
SexId = SexEnum.OTHER.Id,
RoleId = RoleEnum.Admin.Id
};
DataContext.AppUser.Add(AppUser);
DataContext.SaveChanges();
}
return(Ok());
}
private void btnUpdateContra_Click(object sender, EventArgs e)
{
try
{
if (txtNcontra.Text.Equals(txtCcontra.Text))
{
AppUserDAO.ActualizarContra(user.idUser, txtCcontra.Text);
MessageBox.Show("Se actualizó la contraseña",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Datos incorrectos", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{
MessageBox.Show("Verifique que los datos ingresados sean válidos",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnIniciarSesion_Click(object sender, EventArgs e)
{
try
{
var user = AppUserDAO.GetUsuario(txtUsername.Text, txtPassword.Text);
if (user.username.Equals(" ") || user.password.Equals(" "))
{
MessageBox.Show("Usuario y/o contraseña incorrectos",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("!Bienvenido!", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
if (user.userType == true)
{
frmPrincipal ventana = new frmPrincipal(user);
ventana.Show();
this.Hide();
}
else if (user.userType == false)
{
frmUsuario ventana2 = new frmUsuario(user);
ventana2.Show();
this.Hide();
}
else
{
MessageBox.Show("Error", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception)
{
MessageBox.Show("Error", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
