示例#1
0
        public ClassResultV Usp_Perfil_GetAll()
        {
            ClassResultV cr = new ClassResultV();

            try
            {
                SqlDataReader reader = SqlHelper.ExecuteReader(objCn, CommandType.StoredProcedure, "Usp_Perfil_GetAll");
                cr.List = new List <DtoB>();
                while (reader.Read())
                {
                    DtoPerfil dtoP = new DtoPerfil();
                    dtoP.codPerfil   = getValue("codPerfil", reader).Value_Int32;
                    dtoP.descripcion = getValue("descripcion", reader).Value_String;
                    cr.List.Add(dtoP);
                }
            }
            catch (Exception ex)
            {
                cr.DT         = null;
                cr.LugarError = ex.StackTrace;
                cr.ErrorEx    = ex.Message;
                cr.ErrorMsj   = "Error al consultar Perfiles";
            }
            objCn.Close();
            return(cr);
        }
示例#2
0
        public DtoPerfil Usp_Perfil_Insert(DtoPerfil dtoBase)
        {
            var cr  = new ClassResultV();
            var dto = (DtoPerfil)dtoBase;
            var pr  = new SqlParameter[1];

            try
            {
                pr[0]       = new SqlParameter("@descripcion", SqlDbType.VarChar, 500);
                pr[0].Value = dto.descripcion;

                SqlDataReader reader = SqlHelper.ExecuteReader(objCn, CommandType.StoredProcedure, "Usp_Perfil_Insert", pr);
            }
            catch (Exception ex)
            {
                cr.LugarError = ex.StackTrace;
                cr.ErrorEx    = ex.Message;
                cr.ErrorMsj   = "Error al registrar perfil";
            }
            objCn.Close();
            return(dto);
        }
示例#3
0
 public DtoPerfil Usp_Perfil_Insert(DtoPerfil dto)
 {
     return(new DaoPerfil().Usp_Perfil_Insert(dto));
 }