public Task <PRO_USER> Authenticate(string username, string password) { PRO_USER entities = null; List <OracleParameter> parameters = new List <OracleParameter>(); parameters.Add(new OracleParameter("P_SUSER", OracleDbType.NVarchar2, 20, username, ParameterDirection.Input)); parameters.Add(new OracleParameter("P_SPASSWORD", OracleDbType.NVarchar2, 100, password, ParameterDirection.Input)); parameters.Add(new OracleParameter("C_TABLE", OracleDbType.RefCursor, ParameterDirection.Output)); using (OracleDataReader dr = (OracleDataReader)_connectionBase.ExecuteByStoredProcedure("RAC_ADMINIST_SEGURIDAD.SP_SEL_USUARIO_CREDENCIALES", parameters, ConnectionBase.enuTypeDataBase.OracleConciliacion)) { if (dr.Read()) { //entities = dr.ReadFields<PRO_USER>(); entities = new PRO_USER(); entities.ID_USUARIO = Convert.ToInt32(dr["ID_USUARIO"].ToString()); entities.VC_COD_USUARIO = dr["VC_COD_USUARIO"].ToString(); entities.VC_NOMBRE_USUARIO = dr["VC_NOMBRE_USUARIO"].ToString(); entities.VC_APE_PATERNO = dr["VC_APE_PATERNO"].ToString(); entities.VC_APE_MATERNO = dr["VC_APE_MATERNO"].ToString(); } else { return(null); } } return(Task.FromResult <PRO_USER>(entities)); }
public Task <string> Update(PRO_USER _dato) { throw new NotImplementedException(); }