/// <summary>
        /// Metoda de clasa pentru obtinerea unei liste de obiecte de tipul BUtilizatoriVenituri
        /// </summary>
        /// <param name="pId"></param>
        /// <returns>Lista ce corespunde parametrilor</returns>
        /// <remarks></remarks>
        public static BColectieUtilizatoriVenituri GetListByParam(int pIdUtilizator, CDefinitiiComune.EnumStare pStare, IDbTransaction pTranzactie)
        {
            BColectieUtilizatoriVenituri lstDUtilizatoriVenituri = new BColectieUtilizatoriVenituri();

            using (DataSet ds = DUtilizatoriVenituri.GetListByParam(pIdUtilizator, pStare, pTranzactie))
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    lstDUtilizatoriVenituri.Add(new BUtilizatoriVenituri(dr));
                }
            }
            return(lstDUtilizatoriVenituri);
        }
        public BColectieUtilizatoriVenituri Filtreaza(CDefinitiiComune.EnumStare pStare)
        {
            BColectieUtilizatoriVenituri SubLista = new BColectieUtilizatoriVenituri();

            foreach (BUtilizatoriVenituri Element in this)
            {
                if (Element.EsteActiv != (pStare == CDefinitiiComune.EnumStare.Activa || pStare == CDefinitiiComune.EnumStare.Toate))
                {
                    continue;
                }
                SubLista.Add(Element);
            }
            return(SubLista);
        }
        public static BColectieUtilizatoriVenituri getById(int pId, IDbTransaction pTranzactie)
        {
            BColectieUtilizatoriVenituri listaRetur = new BColectieUtilizatoriVenituri();

            if (pId > 0)
            {
                using (DataSet ds = DUtilizatoriVenituri.GetById(pId, pTranzactie))
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        listaRetur.Add(new BUtilizatoriVenituri(dr));
                    }
                }
            }
            return(listaRetur);
        }
        public static BColectieUtilizatoriVenituri getByListaId(List <int> pListaId, IDbTransaction pTranzactie)
        {
            BColectieUtilizatoriVenituri listaRetur = new BColectieUtilizatoriVenituri();

            if (!CUtil.EsteListaIntVida(pListaId))
            {
                using (DataSet ds = DUtilizatoriVenituri.GetByListaId(pListaId, pTranzactie))
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        listaRetur.Add(new BUtilizatoriVenituri(dr));
                    }
                }
            }
            return(listaRetur);
        }
        public BColectieUtilizatoriVenituri GetVenituriActiveInPerioada(int pIdUtilizator, DateTime pDataInceput, DateTime pDataSfarsit)
        {
            BColectieUtilizatoriVenituri listaRetur = new BColectieUtilizatoriVenituri();

            foreach (var item in this)
            {
                if (item.IdUtilizator != pIdUtilizator)
                {
                    continue;
                }

                if (item.EsteActivInPerioada(pDataInceput, pDataSfarsit))
                {
                    listaRetur.Add(item);
                }
            }

            return(listaRetur);
        }