}// /// <summary> /// /// </summary> /// <param name="login"></param> /// <param name="senha"></param> /// <param name="ativo"></param> /// <param name="perfil"></param> /// <param name="email"></param> /// <param name="con"></param> /// <returns></returns> public static Boolean cadastraUsuario(string login, string senha, bool ativo, int perfil, string email, OleDbConnection con) { bool flag = false; string sql = "Insert Into Usuarios(login,senha,ativo,perfil,email) values(?,?,?,?,?)"; try { OleDbCommand cmd = new OleDbCommand(sql, con); cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("login", login)); cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("senha", Acesso.GerarHash(senha))); cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("ativo", ativo)); cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("perfil", perfil)); cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("email", email)); int rg = cmd.ExecuteNonQuery(); if (rg > 0) { flag = true; } else { flag = false; } } catch (Exception ex) { throw ex; } return(flag); }//
}// /// <summary> /// /// /// </summary> /// <param name="login"></param> /// <param name="senha"></param> /// <param name="con"></param> /// <returns></returns> public static Boolean alteraSenha(string login, string senha, OleDbConnection con) { bool flag = false; string sql = "Update Usuarios set senha = ? Where login = ?"; try { OleDbCommand cmd = new OleDbCommand(sql, con); cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("login", login)); cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("senha", Acesso.GerarHash(senha))); int rg = cmd.ExecuteNonQuery(); if (rg > 0) { flag = true; } else { flag = false; } } catch (Exception ex) { throw ex; } return(flag); }//