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)); }