public static bool PasswordChange(aeUser pUser, ref string result)
{
SqlConnection oCnnData = daConnection.Connect();
try
{
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = oCnnData;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spUsuarioUpdatePassword";
oCmd.Parameters.AddWithValue("@Alias", pUser.Alias);
oCmd.Parameters.AddWithValue("@Password", pUser.Password);
if (oCmd.ExecuteNonQuery() == 1)
{
oCnnData.Close();
return(true);
}
result = "El nombre de usuario no existe";
}
catch (Exception ex)
{
result = ex.Message;
}
oCnnData.Close();
return(false);
}
public static aeUser GetData(int pIdUsuario)
{
aeUser oRow = new aeUser();
SqlConnection oCnnData = new SqlConnection();
oCnnData = daConnection.Connect();
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = oCnnData;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spUsuarioSelectByIdUsuario";
oCmd.Parameters.Clear();
oCmd.Parameters.AddWithValue("@IdUsuario", pIdUsuario);
SqlDataReader oRdr;
oRdr = oCmd.ExecuteReader();
while (oRdr.Read())
{
oRow.IdUser = Convert.ToInt16(oRdr["IdUsuario"]);
oRow.Alias = (oRdr["Usuario"] == DBNull.Value) ? null : oRdr["Usuario"].ToString();
oRow.Password = (oRdr["Contraseña"] == DBNull.Value) ? null : oRdr["Contraseña"].ToString();
oRow.Estate = (oRdr["Estado"] == DBNull.Value) ? false : Convert.ToBoolean(oRdr["Estado"]);
oRow.IdPerson = (oRdr["IdPersona"] == DBNull.Value) ? 0 :Convert.ToInt16(oRdr["IdPersona"]);
}
oCnnData.Close();
return(oRow);
}
public static List <aeUser> GetDataByIdMenu(int pIdMenu, ref string pResult)
{
SqlConnection oCnnData = daConnection.Connect();
try
{
List <aeUser> oLista = new List <aeUser>();
SqlCommand oCmd = new SqlCommand("uspUserSelectByIdMenu", oCnnData);
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.Clear();
oCmd.Parameters.AddWithValue("@pIdMenu", pIdMenu);
SqlDataReader oRdr;
oRdr = oCmd.ExecuteReader();
while (oRdr.Read())
{
aeUser oRow = new aeUser();
oRow.IdUser = Convert.ToInt16(oRdr["IdUser"]);
oRow.Alias = (oRdr["Alias"] == DBNull.Value) ? null : oRdr["Alias"].ToString();
oRow.Password = (oRdr["Password"] == DBNull.Value) ? null : oRdr["Password"].ToString();
oRow.Estate = (oRdr["Estate"] == DBNull.Value) ? false : Convert.ToInt16(oRdr["Estate"]) == 1 ? true : false;
oRow.RowVersion = (oRdr["RowVersion"] == DBNull.Value) ? null : oRdr["RowVersion"].ToString();
oLista.Add(oRow);
}
oCnnData.Close();
return(oLista);
}
catch (Exception ex)
{
pResult = ex.Message;
}
oCnnData.Close();
return(null);
}
public static bool CreateUser(aeUser pUser, ref string pResult)
{
SqlConnection oCnnData = daConnection.Connect();
try
{
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = oCnnData;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "uspUsuarioInsert";
oCmd.Parameters.AddWithValue("@pAlias", pUser.Alias);
oCmd.Parameters.AddWithValue("@pPassword", pUser.Password);
oCmd.Parameters.Add("@pResult", SqlDbType.NVarChar, 250).Direction = ParameterDirection.Output;
//oCmd.Parameters.AddWithValue("@Result", pResult);
int e = oCmd.ExecuteNonQuery();
oCnnData.Close();
if (e == 1)
{
return(true);
}
pResult = oCmd.Parameters["@pResult"].Value.ToString();
}
catch (Exception ex)
{
oCnnData.Close();
pResult = ex.Message;
}
return(false);
}
public aeUser GetRow(string pUser, string pPassword, ref string pResult)
{
pResult = null;
aeUser oRow = new aeUser();
oRow = daUser.GetData(pUser, pPassword, ref pResult);
if (pResult != null)
{
return(null);
}
//roles del usuario
blRole rol = new blRole();
oRow.ListRoles = rol.GetRows(oRow.IdUser, ref pResult);
return(oRow);
}
public static aeUser GetData(string pAlias, string pPassword, ref string pResult)
{
SqlConnection oCnnData = daConnection.Connect();
try
{
aeUser oRow = new aeUser();
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = oCnnData;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "uspUsuarioLogin";
oCmd.Parameters.Clear();
oCmd.Parameters.AddWithValue("@pAlias", pAlias);
oCmd.Parameters.AddWithValue("@pPassword", pPassword);
oCmd.Parameters.Add("@pResult", SqlDbType.NVarChar, 250).Direction = ParameterDirection.Output;
SqlDataReader oRdr;
oRdr = oCmd.ExecuteReader();
if (oRdr.Read())
{
oRow.FirtsName = (oRdr["FirtsName"] == DBNull.Value) ? null : oRdr["FirtsName"].ToString();
oRow.LastName = (oRdr["LastName"] == DBNull.Value) ? null : oRdr["LastName"].ToString();
oRow.NroDocument = (oRdr["NroDocument"] == DBNull.Value) ? null : oRdr["NroDocument"].ToString();
oRow.IdUser = Convert.ToInt16(oRdr["IdUser"]);
oRow.Alias = (oRdr["Alias"] == DBNull.Value) ? null : oRdr["Alias"].ToString();
oRow.Password = (oRdr["Password"] == DBNull.Value) ? null : oRdr["Password"].ToString();
oRow.Estate = (oRdr["Estate"] == DBNull.Value) ? false: Convert.ToInt16(oRdr["Estate"]) == 1 ? true : false;
oRow.IdPerson = Convert.ToInt16(oRdr["IdPerson"]);
oRow.RowVersion = (oRdr["RowVersion"] == DBNull.Value) ? null : oRdr["RowVersion"].ToString();
oCnnData.Close();
return(oRow);
}
pResult = oCmd.Parameters["@pResult"].Value.ToString();
//result = "Usuario incorrecto";
}
catch (Exception ex)
{
pResult = ex.Message;
}
oCnnData.Close();
return(null);
}
private void mLinkRegister_Click(object sender, EventArgs e)
{
if (isValidate())
{
aeControlError v = new aeControlError();
aeUser oAeUser = new aeUser();
blUser oBlUser = new blUser();
oAeUser.Alias = txtUserNew.Text;
oAeUser.Password = Encriptar(txtPassNew.Text);
if (RegisterPanel)
{
if (oBlUser.CreateUser(oAeUser, ref result))
{
MetroMessageBox.Show(this, "User created!", "USER!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, result, "ATENCION!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
return;
}
else
{
if (oBlUser.PasswordChange(oAeUser, ref result))
{
MetroMessageBox.Show(this, "Contraseña actualizada", "Correcto!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, result, "ATENCION!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
}
this.tabLogin.SelectedIndex = 0;
CleanFields();
}
}
public bool PasswordChange(aeUser pUser, ref string result)
{
return(daUser.PasswordChange(pUser, ref result));
}
//daUser oDA = new daUser();
public bool CreateUser(aeUser pUser, ref string result)
{
pUser.Estate = true;
return(daUser.CreateUser(pUser, ref result));
}
