//Create User
private void btnCreateUser_Click(object sender, EventArgs e)
{
//try
//{
if (txtName.Text.Length >= 5)
{
APPUSERDAO.CreateUser(txtName.Text, txtUsername.Text);
MessageBox.Show("User added! " +
"at beginning password is the same fullname, no administrator",
"HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtName.Clear();
txtUsername.Clear();
actualizarControles();
}
else
{
MessageBox.Show("Minimum length 5",
"HUGO", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
//}
//catch (Exception)
//{
// MessageBox.Show("El usuario que ha digitado, no se encuentra disponible.",
// "Clase GUI 06", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}
private void populateControls()
{
cmbUsername.DataSource = null;
cmbUsername.ValueMember = "password";
cmbUsername.DisplayMember = "username";
cmbUsername.DataSource = APPUSERDAO.getList();
}
private void btnChangePassword_Click(object sender, EventArgs e)
{
bool currentPassword = Encryptor.CompareMD5(txtCurrentPassword.Text, cmbUsername.SelectedValue.ToString());
bool newEquals = txtNewPassword.Text.Equals(txtRepeatNewPassword.Text);
bool newValidate = txtNewPassword.Text.Length > 0;
if (currentPassword && newEquals && newValidate)
{
try
{
APPUSERDAO.updatePassword(cmbUsername.Text, Encryptor.CreateMD5(txtNewPassword.Text));
MessageBox.Show("Updated Password!", "HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception)
{
MessageBox.Show("Try Again :(", "HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Verify your data", "HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void frmChangePassword_Load(object sender, EventArgs e)
{
cmbUsername.DataSource = null;
cmbUsername.ValueMember = "password";
cmbUsername.DisplayMember = "username";
cmbUsername.DataSource = APPUSERDAO.getList();
}
//Update
private void actualizarControles()
{
// Realizar consulta a la base de datos
List <APPUSER> lista = APPUSERDAO.getList();
List <BUSINESS> list = BUSINESSDAO.getList();
List <PRODUCT> listado = PRODUCTDAO.getList();
List <APPORDER> listi = APPORDERDAO.getList();
List <ADDRESS> listo = ADDRESSDAO.getList();
// Tabla (data grid view)
dvgUser.DataSource = null;
dvgUser.DataSource = lista;
// Menu desplegable (combo box)
//txtName.DataSource = null;
cmbUsername.DataSource = null;
cmbUsername.ValueMember = "password";
cmbUsername.DisplayMember = "username";
cmbUsername.DataSource = lista;
cmbUsernameId.DataSource = null;
cmbUsernameId.ValueMember = "password";
cmbUsernameId.DisplayMember = "username";
cmbUsernameId.DataSource = lista;
//cmbUsuario.ValueMember = "contrasena";
//cmbUsuario.DisplayMember = "usuario";
//cmbUsuario.DataSource = lista;
// Grafico con estadisticas
//poblarGrafico();
dgvBusiness.DataSource = null;
dgvBusiness.DataSource = list;
cmbBusiness.DataSource = null;
cmbBusiness.ValueMember = "businessname";
cmbBusiness.DisplayMember = "businessname";
cmbBusiness.DataSource = list;
cmbUsernameAddress.DataSource = null;
cmbUsernameAddress.ValueMember = "password";
cmbUsernameAddress.DisplayMember = "username";
cmbUsernameAddress.DataSource = lista;
dgvProducts.DataSource = null;
dgvProducts.DataSource = listado;
dgvProductsOptions.DataSource = null;
dgvProductsOptions.DataSource = listado;
dgvOrders.DataSource = null;
dgvOrders.DataSource = listi;
dgvAllOrders.DataSource = null;
dgvAllOrders.DataSource = listi;
dgvAddressModify.DataSource = null;
dgvAddressModify.DataSource = listo;
}
//Add user
private void btnSave_Click(object sender, EventArgs e)
{
APPUSERDAO.updateAccess(cmbUsername.Text, rbAdministrator.Checked);
ADDRESSDAO.CreateAddress(txtAddress.Text, cmbUsername.Text);
MessageBox.Show("User updated!",
"HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarControles();
}
//Delete User
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Are you sure you want to delete " + cmbUsername.Text + "?",
"HUGO", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
APPUSERDAO.delete(cmbUsername.Text);
MessageBox.Show("Delete success!",
"HUGO", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarControles();
}
}
catch
{
MessageBox.Show("You can't delete an administrator");
}
}
