private void btnAceptar_Click(object sender, EventArgs e)
{
if(this.txtConfirmarPassword.Text == "" || this.txtPassword.Text == "" || this.txtUsername.Text == "")
{
MessageBox.Show(this, "No pueden haber campos vacios", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (this.txtPassword.Text == this.txtConfirmarPassword.Text)
{
StringBuilder checkUser = new StringBuilder();
checkUser.AppendFormat("SELECT * FROM TRANSA_SQL.CuponeteUser CU WHERE CU.Username='******'", this.txtUsername.Text);
int userRows = Conexion.Instance.ejecutarQuery(checkUser.ToString()).Rows.Count;
if (userRows == 0)
{
int userTypeId;
int roleId;
if ((this.cmbTipoUsr.SelectedItem as string) == "Cliente")
{
userTypeId = 2;
roleId = 2;
}
else
{
userTypeId = 3;
roleId = 3;
}
string password = new LoginApplication().encriptarPassword(this.txtPassword.Text);
StringBuilder sentece = new StringBuilder();
sentece.AppendFormat("INSERT INTO TRANSA_SQL.CuponeteUser(Username, Password, FirstLogin, FailedAttemps, RoleId, Enabled, Deleted, UserTypeId) VALUES ('{0}','{1}',0,0,{2},1,0, '{3}')", this.txtUsername.Text, password, roleId, userTypeId);
Conexion.Instance.ejecutarQuery(sentece.ToString());
StringBuilder sentece2 = new StringBuilder();
sentece2.AppendFormat("SELECT TOP 1 CU.UserId FROM TRANSA_SQL.CuponeteUser CU ORDER BY CU.UserId DESC");
int newUserId = (int)Conexion.Instance.ejecutarQuery(sentece2.ToString()).Rows[0][0];
if (userTypeId == 2)
{
RegistrarCliente registrarCliente = new RegistrarCliente(newUserId);
registrarCliente.ShowDialog();
this.Close();
}
else if (userTypeId == 3)
{
RegristrarProveedor registrarProveedor = new RegristrarProveedor(newUserId);
registrarProveedor.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show(this, "El nombre de usuario ya existe", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(this, "Los passwords ingresados no coinciden", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAceptar_Click(object sender, EventArgs e)
{
if (this.txtConfirmarPassword.Text == "" || this.txtPassword.Text == "" || this.txtUsername.Text == "")
{
MessageBox.Show(this, "No pueden haber campos vacios", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (this.txtPassword.Text == this.txtConfirmarPassword.Text)
{
StringBuilder checkUser = new StringBuilder();
checkUser.AppendFormat("SELECT * FROM TRANSA_SQL.CuponeteUser CU WHERE CU.Username='******'", this.txtUsername.Text);
int userRows = Conexion.Instance.ejecutarQuery(checkUser.ToString()).Rows.Count;
if (userRows == 0)
{
int userTypeId;
int roleId;
if ((this.cmbTipoUsr.SelectedItem as string) == "Cliente")
{
userTypeId = 2;
roleId = 2;
}
else
{
userTypeId = 3;
roleId = 3;
}
string password = new LoginApplication().encriptarPassword(this.txtPassword.Text);
StringBuilder sentece = new StringBuilder();
sentece.AppendFormat("INSERT INTO TRANSA_SQL.CuponeteUser(Username, Password, FirstLogin, FailedAttemps, RoleId, Enabled, Deleted, UserTypeId) VALUES ('{0}','{1}',0,0,{2},1,0, '{3}')", this.txtUsername.Text, password, roleId, userTypeId);
Conexion.Instance.ejecutarQuery(sentece.ToString());
StringBuilder sentece2 = new StringBuilder();
sentece2.AppendFormat("SELECT TOP 1 CU.UserId FROM TRANSA_SQL.CuponeteUser CU ORDER BY CU.UserId DESC");
int newUserId = (int)Conexion.Instance.ejecutarQuery(sentece2.ToString()).Rows[0][0];
if (userTypeId == 2)
{
RegistrarCliente registrarCliente = new RegistrarCliente(newUserId);
registrarCliente.ShowDialog();
this.Close();
}
else if (userTypeId == 3)
{
RegristrarProveedor registrarProveedor = new RegristrarProveedor(newUserId);
registrarProveedor.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show(this, "El nombre de usuario ya existe", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(this, "Los passwords ingresados no coinciden", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}