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