public static string EncPrueba() { return("ServerPROD=" + EncryptDecryptPhrase.Encrypt("", key, iv) + "\nBDPROD=" + EncryptDecryptPhrase.Encrypt("", key, iv) + "\nServerTRN=" + EncryptDecryptPhrase.Encrypt("", key, iv) + "\nBDTRN=" + EncryptDecryptPhrase.Encrypt("", key, iv) + "\n\nID=" + EncryptDecryptPhrase.Encrypt("", key, iv) + "\nPASS="******"", key, iv)); }
public static List <cADM_USUARIOS> ADM_UsuarioLogin(string usuario, string pasword, string pcreg) { List <cADM_USUARIOS> obj = new List <cADM_USUARIOS>(); string Token = EncryptDecryptPhrase.Encrypt(usuario + ',' + pasword + ',' + DateTime.Now.ToShortDateString(), key, iv); OracleCommand comando = new OracleCommand() { CommandText = "SP_ADM_USUARIOSLOGIN", CommandType = CommandType.StoredProcedure, Connection = new OracleConnection(ConexionBD.GetConnectionBD()) }; comando.Parameters.Add(new OracleParameter("PUSUARIO", OracleDbType.NVarchar2)).Value = usuario; comando.Parameters.Add(new OracleParameter("PCONTRASENA", OracleDbType.NVarchar2)).Value = pasword; comando.Parameters.Add(new OracleParameter("PTOKEN", OracleDbType.NVarchar2)).Value = Token; comando.Parameters.Add(new OracleParameter("PPCREG", OracleDbType.NVarchar2)).Value = pcreg; comando.Parameters.Add(new OracleParameter("OIDUSUARIO", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("ONOMBRE", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("ONIDENTIFICACION", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OCODAREA", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OCODOFICINA", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OCORREO", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OPASSCORREO", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OUSUARIO", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OESTADO", OracleDbType.Int32)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OUSERREG", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OFECHAREG", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OPCREG", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OUSERMODIFY", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OFECHAMODIFY", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OPCMODIFY", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OOBSERVACION", OracleDbType.NVarchar2, 200)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OAREA", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Parameters.Add(new OracleParameter("OOFICINA", OracleDbType.NVarchar2, 100)).Direction = ParameterDirection.Output; comando.Connection.Open(); comando.ExecuteNonQuery(); comando.Connection.Close(); if (comando.Parameters["OIDUSUARIO"].Value.ToString() != "null") { DateTime?FECHAREG = null; if (comando.Parameters["OFECHAREG"].Value.ToString() != "null") { FECHAREG = Convert.ToDateTime(comando.Parameters["OFECHAREG"].Value.ToString()); } DateTime?FECHAMODIFY = null; if (comando.Parameters["OFECHAMODIFY"].Value.ToString() != "null") { FECHAMODIFY = Convert.ToDateTime(comando.Parameters["OFECHAMODIFY"].Value.ToString()); } obj.Add(new cADM_USUARIOS( Convert.ToString(comando.Parameters["OIDUSUARIO"].Value), Convert.ToString(comando.Parameters["ONOMBRE"].Value), Convert.ToString(comando.Parameters["ONIDENTIFICACION"].Value), Convert.ToString(comando.Parameters["OCODAREA"].Value), Convert.ToString(comando.Parameters["OCODOFICINA"].Value), Convert.ToString(comando.Parameters["OCORREO"].Value), Convert.ToString(comando.Parameters["OPASSCORREO"].Value), Convert.ToString(comando.Parameters["OUSUARIO"].Value), Convert.ToInt32(comando.Parameters["OESTADO"].Value.ToString()), Convert.ToString(comando.Parameters["OUSERREG"].Value), FECHAREG, Convert.ToString(comando.Parameters["OPCREG"].Value), Convert.ToString(comando.Parameters["OUSERMODIFY"].Value), FECHAMODIFY, Convert.ToString(comando.Parameters["OPCMODIFY"].Value), Convert.ToString(comando.Parameters["OOBSERVACION"].Value), Convert.ToString(comando.Parameters["OAREA"].Value), Convert.ToString(comando.Parameters["OOFICINA"].Value) )); } return(obj); }