コード例 #1
0
        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));
        }
コード例 #2
0
 public Task <string> Update(PRO_USER _dato)
 {
     throw new NotImplementedException();
 }