Ejemplo n.º 1
0
        public IEnumerable <ItemQuantityDTO> GetAll(SearchCriteria <ItemQuantityDTO> criteria, out int totalCount)
        {
            IEnumerable <ItemQuantityDTO> catList = new List <ItemQuantityDTO>();

            totalCount = 0;
            try
            {
                if (criteria != null && criteria.CurrentUserId != -1)
                {
                    var warehouseList = new WarehouseService(true)
                                        .GetWarehousesPrevilegedToUser(criteria.CurrentUserId).ToList();
                    if (criteria.SelectedWarehouseId != null)
                    {
                        warehouseList = warehouseList.Where(w => w.Id == criteria.SelectedWarehouseId).ToList();
                    }

                    foreach (var warehouse in warehouseList.Where(w => w.Id != -1))
                    {
                        var pdto = Get();

                        foreach (var cri in criteria.FiList)
                        {
                            pdto.FilterList(cri);
                        }

                        #region By Warehouse
                        var warehouse1 = warehouse;
                        pdto.FilterList(p => p.WarehouseId == warehouse1.Id);
                        #endregion

                        IList <ItemQuantityDTO> pdtoList;
                        if (criteria.Page != 0 && criteria.PageSize != 0)
                        {
                            int totalCount2;
                            pdtoList   = pdto.GetPage(criteria.Page, criteria.PageSize, out totalCount2).ToList();
                            totalCount = totalCount2;
                        }
                        else
                        {
                            pdtoList = pdto.GetList().ToList();
                        }

                        catList = catList.Concat(pdtoList).ToList();
                    }
                }
                else
                {
                    catList = Get().Get().ToList();
                }
            }
            finally
            {
                Dispose(_disposeWhenDone);
            }

            return(catList);
        }
Ejemplo n.º 2
0
        public IEnumerable <BankAccountDTO> GetAll(SearchCriteria <BankAccountDTO> criteria = null)
        {
            IEnumerable <BankAccountDTO> accountList = new List <BankAccountDTO>();

            try
            {
                if (criteria != null && criteria.CurrentUserId != -1)
                {
                    var warehouseList = new WarehouseService(true)
                                        .GetWarehousesPrevilegedToUser(criteria.CurrentUserId).ToList();
                    if (criteria.SelectedWarehouseId != null)
                    {
                        warehouseList = warehouseList.Where(w => w.Id == criteria.SelectedWarehouseId).ToList();
                    }

                    foreach (var warehouse in warehouseList.Where(w => w.Id != -1))
                    {
                        var pdto = Get();

                        foreach (var cri in criteria.FiList)
                        {
                            pdto.FilterList(cri);
                        }

                        //#region By Warehouse
                        //var warehouse1 = warehouse;
                        //pdto.FilterList(p => p.CompanyId == warehouse1.Id);
                        //#endregion

                        IList <BankAccountDTO> pdtoList;
                        if (criteria.Page != 0 && criteria.PageSize != 0)
                        {
                            int totalCount;
                            pdtoList = pdto.GetPage(criteria.Page, criteria.PageSize, out totalCount).ToList();
                        }
                        else
                        {
                            pdtoList = pdto.GetList().ToList();
                        }

                        accountList = accountList.Concat(pdtoList).ToList();
                    }
                }
                else
                {
                    accountList = Get().Get().ToList();
                }
            }
            finally
            {
                Dispose(_disposeWhenDone);
            }

            return(accountList);
        }
Ejemplo n.º 3
0
        public IEnumerable <TransactionLineDTO> GetAllChilds(SearchCriteria <TransactionLineDTO> criteria,
                                                             out int totalCount)
        {
            totalCount = 0;
            IEnumerable <TransactionLineDTO> piList = new List <TransactionLineDTO>();

            try
            {
                if (criteria != null && criteria.CurrentUserId != -1)
                {
                    var warehouseList = new WarehouseService(true)
                                        .GetWarehousesPrevilegedToUser(criteria.CurrentUserId).ToList();

                    if (criteria.SelectedWarehouseId != null)
                    {
                        warehouseList = warehouseList.Where(w => w.Id == criteria.SelectedWarehouseId).ToList();
                    }

                    foreach (var warehouse in warehouseList.Where(w => w.Id != -1))
                    {
                        var pdto = GetChildsQuery();

                        foreach (var cri in criteria.FiList)
                        {
                            pdto.FilterList(cri);
                        }

                        #region By Warehouse

                        var warehouse1 = warehouse;
                        pdto.FilterList(p => p.Transaction.WarehouseId == warehouse1.Id);

                        #endregion

                        #region By Duration

                        if (criteria.BeginingDate != null)
                        {
                            var beginDate = new DateTime(criteria.BeginingDate.Value.Year,
                                                         criteria.BeginingDate.Value.Month,
                                                         criteria.BeginingDate.Value.Day, 0, 0, 0);
                            pdto.FilterList(p => p.Transaction.TransactionDate >= beginDate);
                        }

                        if (criteria.EndingDate != null)
                        {
                            var endDate = new DateTime(criteria.EndingDate.Value.Year, criteria.EndingDate.Value.Month,
                                                       criteria.EndingDate.Value.Day, 23, 59, 59);
                            pdto.FilterList(p => p.Transaction.TransactionDate <= endDate);
                        }

                        #endregion

                        IList <TransactionLineDTO> pdtoList;
                        if (criteria.Page != 0 && criteria.PageSize != 0)
                        {
                            int totalCount2;
                            pdtoList   = pdto.GetPage(criteria.Page, criteria.PageSize, out totalCount2).ToList();
                            totalCount = totalCount2;
                        }
                        else
                        {
                            pdtoList = pdto.GetList().ToList();
                        }

                        piList = piList.Concat(pdtoList).ToList();
                    }
                }
                else
                {
                    piList = GetChildsQuery().Get().ToList();
                }
            }
            finally
            {
                Dispose(_disposeWhenDone);
            }

            return(piList);
        }