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