void Map(IEnumerable<MasterImportEntity> items) { if (!items.Any()) return; if(!Positions.Any()) using (var c = NestedContainer) { Positions = Using<IMapEntityColumnPosition>(c).GetEntityMapping(new ImportEntity() { EntityName = "commoditysupplier" }); } if (!Positions.Any()) { GotoHomePage(); return; } var paged = items.Select((row, index) => new CommoditySupplierImportVM() { Code =GetColumn(row,GetIndex("code")), Name =GetColumn(row,GetIndex("name")), Description =GetColumn(row,GetIndex("description")), AccountNo =GetColumn(row,GetIndex("AccountNo")), PinNo =GetColumn(row,GetIndex("PinNo")), JoinDate =DateTime.Parse(GetColumn(row, GetIndex("JoinDate"),handleDateTime:true)), BankBranchName =GetColumn(row,GetIndex("BankBranchName")), BankName =GetColumn(row,GetIndex("BankName")), CommoditySupplierType =Int32.Parse(GetColumn(row, GetIndex("CommoditySupplierType"),handleEnum:true)), IsChecked = false, SequenceNo = index + 1 }).AsQueryable(); PagedList = new PagenatedList<ImportItemVM>(paged, CurrentPage, ItemsPerPage, paged.Count()); CommoditySupplierImportVMList.Clear(); PagedList.ToList().ForEach(n => CommoditySupplierImportVMList.Add((CommoditySupplierImportVM)n)); }
protected override void Load(bool isFirstLoad = false) { LoadMemberFarmers(); AddFarmerEnabler(); Application.Current.Dispatcher.BeginInvoke( new Action( delegate { if (isFirstLoad) Setup(); using (var c = NestedContainer) { var query = new QueryCommodityOwner(); query.SupplierId = SupplierId; query.Take = ItemsPerPage; query.Skip = ItemsPerPage * (CurrentPage - 1); query.ShowInactive = ShowInactive; if (!string.IsNullOrWhiteSpace(SearchText)) query.Name = SearchText; var rawList = Using<ICommodityOwnerRepository>(c).Query(query); _pagedCommodityOwners = new PagenatedList<CommodityOwner>(rawList.Data.OfType<CommodityOwner>().AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count, true); ListOfCommodityOwners.Clear(); int rownumber = 0; _pagedCommodityOwners.ToList().ForEach(n => ListOfCommodityOwners.Add(new VmCommodityOwner { Id = n.Id, Code = n.Code, Surname = n.Surname, FirstName = n.FirstName, LastName = n.LastName, IdNo = n.IdNo, Email = n.Email, PhoneNumber = n.PhoneNumber, BusinessNumber = n.BusinessNumber, CommodityOwnerType = n.CommodityOwnerType, Status = n._Status, Action=n._Status==EntityStatus.Active?"Deactivate":"Activate", RowNumber = ++rownumber })); UpdatePagenationControl(); } })); }
private async void LoadImportsFromFile() { if (FileUtility.ValidateFile(SelectedPath)) { using (var c = NestedContainer) { try { ImportVmList.Clear(); ImportItems = await Using<IOutletImportService>(c).Import(SelectedPath); var productImports = ImportItems as List<OutletImport> ?? ImportItems.ToList(); if (productImports.Any()) { var items = productImports.Select((n, i) => new OutletImportVm() { SequenceNo = i + 1, Code = n.OutletCode, Name = n.Name, PinNo = n.PinNo, PostalAddress = n.PostalAddress, PhysicalAddress = n.PhysicalAddress, Status = n.Status, Tax = n.Tax, Currency =n.Currency, SalesmanCode = n.SalesmanCode, RouteName = n.RouteName, IsChecked = false }).AsQueryable(); PagedList = new PagenatedList<ImportItemVM>(items, CurrentPage, ItemsPerPage, items.Count()); PagedList.ToList().ForEach(n => ImportVmList.Add((OutletImportVm)n)); UpdatePagenationControl(); } } catch (Exception ex) { MessageBox.Show("Error getting data from file\nDetails=>" + ex.Message); } } } }
protected override void Load(bool isFirstLoad = false) { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { //if (isFirstLoad) using (var c = NestedContainer) { var query = new QueryServiceProvider(); query.Take = ItemsPerPage; query.Skip = ItemsPerPage * (CurrentPage - 1); query.ShowInactive = ShowInactive; if (!string.IsNullOrWhiteSpace(SearchText)) query.Name = SearchText; var rawList = Using<IServiceProviderRepository>(c).Query(query); _pagedServiceProvider = new PagenatedList<ServiceProvider>(rawList.Data.OfType<ServiceProvider>().AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count, true); ListOfServiceProviders.Clear(); int rownumber = 0; _pagedServiceProvider.ToList().ForEach(n => ListOfServiceProviders.Add(new VmServiceProvider { Id = n.Id, Code = n.Code, Name = n.Name, IdNo=n.IdNo, PinNo=n.PinNo, MobileNumber=n.MobileNumber, AccountName=n.AccountName, AccountNumber=n.AccountNumber, BankName=n.Bank!=null?n.Bank.Name:"", BankBranchName=n.BankBranch!=null?n.BankBranch.Name:"", Status = n._Status, Action = n._Status == EntityStatus.Active ? "Deactivate" : "Activate", RowNumber = ++rownumber })); UpdatePagenationControl(); } })); }
protected override void Load(bool isFirstLoad = false) { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { using (var c = NestedContainer) { var query = new QuerySupplierContact { SupplierId = SupplierId, Take = ItemsPerPage, Skip = ItemsPerPage*(CurrentPage - 1), ShowInactive = ShowInactive }; if (!string.IsNullOrWhiteSpace(SearchText)) query.Name = SearchText; var rawList = Using<IContactRepository>(c).Query(query); _pagedContacts = new PagenatedList<Contact>(rawList.Data.OfType<Contact>().AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count, true); ContactList.Clear(); int rownumber = 0; _pagedContacts.ToList().ForEach(n => ContactList.Add(new VmContact { Id = n.Id, FirstName = n.Firstname, LastName = n.Lastname, Email = n.Email, MobilePhone=n.MobilePhone, PhysicalAddress=n.PhysicalAddress, PostalAddress=n.PostalAddress, Status=n._Status, Action=n._Status==EntityStatus.Active?"Deactivate":"Activate", RowNumber = ++rownumber })); UpdatePagenationControl(); } })); }
private async void LoadProductImportFromImportFile() { if (FileUtility.ValidateFile(SelectedPath)) { using (var c = NestedContainer) { try { ImportVmList.Clear(); ImportItems = await Using<IProductImportService>(c).Import(SelectedPath); var productImports = ImportItems as List<ProductImport> ?? ImportItems.ToList(); if (productImports.Any()) { var items = productImports.Select((n, i) => new ProductImportVM() { SequenceNo = i + 1, BrandCode = n.BrandCode, Code = n.ProductCode, Description = n.Description, Status = n.Status, SellingPrice = n.SellingPrice, ExFactoryPrice = n.ExFactoryPrice, IsChecked = false }).AsQueryable(); PagedList = new PagenatedList<ImportItemVM>(items, CurrentPage, ItemsPerPage, items.Count()); PagedList.ToList().ForEach(n => ImportVmList.Add((ProductImportVM) n)); UpdatePagenationControl(); } } catch (Exception ex) { MessageBox.Show("Error getting data from file\nDetails=>" + ex.Message); } } } }
protected override void Load(bool isFirstLoad = false) { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { if (isFirstLoad) Setup(); using (var c = NestedContainer) { var query = new QuerySeason(); query.Take = ItemsPerPage; query.Skip = ItemsPerPage * (CurrentPage - 1); query.ShowInactive = ShowInactive; if (!string.IsNullOrWhiteSpace(SearchText)) query.Name = SearchText; var rawList = Using<ISeasonRepository>(c).Query(query); _pagedSeasons = new PagenatedList<Season>(rawList.Data.OfType<Season>().AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count, true); ListOfSeasons.Clear(); int rownumber = 0; _pagedSeasons.ToList().ForEach(n => ListOfSeasons.Add(new VmSeason { Id = n.Id, Code = n.Code, Name=n.Name, StartDate=n.StartDate.Date, EndDate=n.EndDate.Date, Status = n._Status, Action=n._Status == EntityStatus.Active? "Deactivate":"Activate", RowNumber = ++rownumber })); UpdatePagenationControl(); } })); }
private async void LoadImportFromFile() { if (FileUtility.ValidateFile(SelectedPath)) { using (var c = NestedContainer) { try { ImportVmList.Clear(); ImportItems = await Using<IShipToAddressImportService>(c).Import(SelectedPath); var productImports = ImportItems as List<ShipToAddressImport> ?? ImportItems.ToList(); if (productImports.Any()) { var items = productImports.Select((n, i) => new ShipToAddressImportVM() { SequenceNo = i + 1, OutletCode=n.OutletCode, OutletName=n.OutletName, PostalAddress=n.PostalAddress, ShipToCode=n.ShipToCode, ShipToName=n.ShipToName, IsChecked = false }).AsQueryable(); PagedList = new PagenatedList<ImportItemVM>(items, CurrentPage, ItemsPerPage, items.Count()); PagedList.ToList().ForEach(n => ImportVmList.Add((ShipToAddressImportVM)n)); UpdatePagenationControl(); } }catch(Exception ex) { MessageBox.Show("Error getting data from file\nDetails=>" + ex.Message); FileUtility.LogError(ex.Message); } } } }
private void Map(IEnumerable<MasterImportEntity> importItems) { if (!importItems.Any()) return; if (!Positions.Any()) using (var c = NestedContainer) { Positions = Using<IMapEntityColumnPosition>(c).GetEntityMapping(new ImportEntity(){EntityName = "Commodity"}); } var paged= importItems.Select((row, index) => new CommodityImportVM() { Code = GetColumn(row, GetIndex("code")), Name = GetColumn(row, GetIndex("name")), Description = GetColumn(row, GetIndex("description")), CommodityTypeCode =GetColumn(row, GetIndex("commoditytypecode")), IsChecked = false, SequenceNo = index + 1 }).AsQueryable(); PagedList = new PagenatedList<ImportItemVM>(paged, CurrentPage, ItemsPerPage, paged.Count()); CommodityImportVmList.Clear(); PagedList.ToList().ForEach(n => CommodityImportVmList.Add((CommodityImportVM)n)); }
private void LoadCommoditySupplierInventoryList(bool isSet) { using (var c = ObjectFactory.Container.GetNestedContainer()) { var query = new QueryCommoditySupplierInventory(); query.Skip = ItemsPerPage * (CurrentPage - 1); query.Take = ItemsPerPage; if(isSet) { query = QueryCommoditySupplierInventoryLevel; } //else //{ // query.Skip = 0; // query.Take = 5; //} var rawList = c.GetInstance<ICommoditySupplierInventoryRepository>().Query(query); var data = rawList.Data.OfType<CommoditySupplierInventoryLevel>(); WarehouseInventoryLevelsList.Clear(); RowNumber=1; //rawList.ForEach(n => WarehouseInventoryLevelsList.Add(Map(n))); _pagedCommoditySupplierInventoryLevel = new PagenatedList<CommoditySupplierInventoryLevel>(data.AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count, true); _pagedCommoditySupplierInventoryLevel.ForEach(n => WarehouseInventoryLevelsList.Add(Map(n))); UpdatePagenationControl(); } }
protected override void Load(bool isFirstLoad = false) { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { if (isFirstLoad) Setup(); using (var c = NestedContainer) { var rawList = Using<ICommoditySupplierRepository>(c).GetAll(ShowInactive); //.Where(n => n.CostCentreCode.ToLower().Contains(SearchText.ToLower()) || // n.Name.ToLower().Contains(SearchText.ToLower())); //var rawVmList =new List<VMCommoditySupplier>(); //foreach(var commoditySupplier in rawList) //{ // rawVmList.Add(new VMCommoditySupplier // { // SupplierId=commoditySupplier.Id, // AccountName=commoditySupplier.Name, // }); //} rawList = rawList.OrderBy(n => n.Name).ThenBy(n => n.CostCentreCode); _pagedCommodityOwners = new PagenatedList<CommoditySupplier>(rawList.OfType<CommoditySupplier>().AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count()); CommodityOwnersList.Clear(); _pagedCommodityOwners.Select((n, i) => Map(n, i + 1)).ToList().ForEach( n => CommodityOwnersList.Add(n)); UpdatePagenationControl(); } })); }
private void LoadContainerTypesList() { using (var c = NestedContainer) { var list = Using<IContainerTypeRepository>(c).GetAll(ShowInactive) .Where(n => n.Name.ToLower().Contains(SearchText.ToLower()) || n.Code.ToLower().Contains(SearchText.ToLower())) .OrderBy(n => n.Name).ThenBy(n => n.Code); _pagedList = new PagenatedList<ContainerType>(list.AsQueryable(), CurrentPage, ItemsPerPage, list.Count()); ContainerTypesList.Clear(); _pagedList.Select(Map).ToList().ForEach(ContainerTypesList.Add); UpdatePagenationControl(); } }
protected async virtual void ListOrders() { await Task.Factory.StartNew(() => { Application.Current.Dispatcher.BeginInvoke( new Action(delegate { if (SelectedOrderStatus != DocumentStatus.Confirmed) ShowApproveSelectedButton = Visibility.Collapsed; using (var container = NestedContainer) { OrdersSummaryList.Clear(); if (isUnconfirmedTab) { var orderSaveAndContinueService = Using<IOrderSaveAndContinueService>( container); var item =orderSaveAndContinueService.Query( StartDate, EndDate, SelectedOrderType); IPagenatedList<OrderSaveAndContinueLater> ItemList = new PagenatedList<OrderSaveAndContinueLater>( item.AsQueryable(), CurrentPage, ItemsPerPage, item.Count()); ItemList.Select(Map).ToList(). ForEach( OrdersSummaryList.Add); } else { //var orders = Using<IMainOrderRepository>( // container) // .GetMainOrderSummariyList(StartDate, EndDate, // SelectedOrderType, // SelectedOrderStatus, // SearchText); var orders = Using<IMainOrderRepository>(container). PagedDocumentList(CurrentPage, ItemsPerPage, StartDate, EndDate, SelectedOrderType, SelectedOrderStatus, SearchText); if (orders != null && orders.Any()) { PagedDocumentList = new PagenatedList<MainOrderSummary>( orders.AsQueryable(), CurrentPage, ItemsPerPage, orders.TotalItemCount,true); PagedDocumentList.Select(Map).ToList(). ForEach( OrdersSummaryList.Add); UpdatePagenationControl(); } } } })); }); }
protected override void Load(bool isFirstLoad = false) { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { if (isFirstLoad) Setup(); using (var c = NestedContainer) { var rawList = Using<IVehicleRepository>(c).GetAll(ShowInactive).OfType<Vehicle>() .Where(n => n.Code.ToLower().Contains(SearchText.ToLower()) || n.Name.ToLower().Contains(SearchText.ToLower()) || n.Make.ToLower().Contains(SearchText.ToLower()) || n.Model.ToLower().Contains(SearchText.ToLower()) || n.Description.ToLower().Contains(SearchText.ToLower()) ); rawList = rawList.OrderBy(n => n.Name).ThenBy(n => n.Code); _pagedList = new PagenatedList<Vehicle>(rawList.AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count()); VehiclesList.Clear(); _pagedList.Select((n, i) => Map(n, i + 1)).ToList().ForEach( n => VehiclesList.Add(n)); UpdatePagenationControl(); } })); }
private void Map(IEnumerable<MasterImportEntity> importItems) { if (!importItems.Any()) return; if(!Positions.Any()) using (var c = NestedContainer) { Positions = Using<IMapEntityColumnPosition>(c).GetEntityMapping(new ImportEntity() { EntityName = "commodityowner" }); } if (!Positions.Any()) { GotoHomePage(); return; } PagedListAll.Clear(); var paged= importItems.Select((row, index) => new CommodityOwnerImportVM() { Code = GetColumn(row, GetIndex("code")), Name = GetColumn(row, GetIndex("name")), Description = GetColumn(row, GetIndex("description")), FirstName = GetColumn(row,GetIndex("FirstName")), LastName = GetColumn(row,GetIndex("lastname")), BusinessNumber =GetColumn(row,GetIndex("businessnumber")), OfficeNumber =GetColumn(row,GetIndex("OfficeNumber")), Email =GetColumn(row,GetIndex("Email")), FaxNumber =GetColumn(row,GetIndex("FaxNumber")), IdNo =GetColumn(row,GetIndex("IdNo")), PinNo = GetColumn(row, GetIndex("PinNo")), PhoneNumber =GetColumn(row,GetIndex("PhoneNumber")), CommodityOwnerTypeName =GetColumn(row,GetIndex("CommodityOwnerTypeName")), PostalAddress =GetColumn(row,GetIndex("PostalAddress")), Surname =GetColumn(row,GetIndex("Surname")), CommoditySupplierName =GetColumn(row,GetIndex("CommoditySupplierName")), GenderEnum =GetColumn(row,GetIndex("GenderEnum"),handleEnum:true), DateOfBirth =GetColumn(row,GetIndex("DateOfBirth"),handleDateTime:true), IsChecked = false, SequenceNo = index + 1 }).AsQueryable(); PagedListAll.AddRange(paged.ToList()); PagedList = new PagenatedList<ImportItemVM>(paged, CurrentPage, ItemsPerPage, paged.Count()); CommodityOwnerImportVmList.Clear(); PagedList.ToList().ForEach(n => CommodityOwnerImportVmList.Add((CommodityOwnerImportVM)n)); UpdatePagenationControl(); }
protected override void Load(bool isFirstLoad = false) { if (isFirstLoad) Setup(); using (var c = NestedContainer) { var farmersRepository = Using<ICommodityOwnerRepository>(c); var farmers = farmersRepository.GetAll().OrderBy(n => n.FirstName).ThenBy(n => n.Surname).ToList (); var thefarmers = new List<CommodityOwner>(); if (SelectedBuyingCentre != null && SelectedBuyingCentre.Id != Guid.Empty) { var selectedCentreId = SelectedBuyingCentre.Id; var farmsByCentre = Using<IMasterDataAllocationRepository>(c).GetByAllocationType( MasterDataAllocationType.CommodityProducerCentreAllocation) .Where(n => n.EntityBId == selectedCentreId) .Select(n => n.EntityAId); var farmRepos = Using<ICommodityProducerRepository>(c); foreach (var farm in farmsByCentre) { var theFarm = farmRepos.GetById(farm); var supplier = theFarm.CommoditySupplier; thefarmers.AddRange(farmers.Where(p=>p.CommoditySupplier.Id==supplier.Id).ToList()); } _pagedCommodityOwners = new PagenatedList<CommodityOwner>(thefarmers.AsQueryable(), CurrentPage, ItemsPerPage, farmers.Count()); } else { _pagedCommodityOwners = new PagenatedList<CommodityOwner>(farmers.AsQueryable(), CurrentPage, ItemsPerPage, farmers.Count()); } FarmersList.Clear(); _pagedCommodityOwners.ToList().ForEach(n => FarmersList.Add(n)); UpdatePagenationControl(); } }
protected override void Load(bool isFirstLoad = false) { using (var c = NestedContainer) { if (isFirstLoad) Setup(); ContactsList.Clear(); List<Contact> contacts = new List<Contact>(); if (SelectedContactOwner != null && SelectedContactOwner.Id != Guid.Empty) { contacts = Using<IContactRepository>(c).GetByContactsOwnerId(SelectedContactOwner.Id); } else { contacts = Using<IContactRepository>(c).GetAll(ShowInactive).ToList(); } contacts = contacts .Where(n => n.Firstname.ToLower().Contains(SearchText.ToLower()) || n.Lastname.ToLower().Contains(SearchText.ToLower()) || n.MobilePhone.ToLower().Contains(SearchText.ToLower()) || n.PhysicalAddress.ToLower().Contains(SearchText.ToLower())) .OrderBy(n => n.Firstname).ThenBy(n => n.Lastname) .ToList(); _pagedList = new PagenatedList<Contact>(contacts.AsQueryable(), CurrentPage, ItemsPerPage, contacts.Count); contacts.ForEach( n => ContactsList.Add(new VMContactItem { Contact = n, IsDirty = false, IsNew = false })); } }
private void FilterFarmersInfo(string s) { FarmersList.Clear(); using (StructureMap.IContainer c = NestedContainer) { s = s.ToLower(); var farmers = Using<ICommodityOwnerRepository>(c).GetAll().Where( p =>p.FullName.ToLower().Contains(s) ||p.IdNo.ToLower().Contains(s)||p.PinNo.Contains(s)||p.Code.ToLower().Contains(s)).ToList(); _pagedCommodityOwners = new PagenatedList<CommodityOwner>(farmers.AsQueryable(), CurrentPage, ItemsPerPage, farmers.Count()); FarmersList.Clear(); _pagedCommodityOwners.ToList().ForEach(n => FarmersList.Add(n)); UpdatePagenationControl(); } }
protected override void Load(bool isFirstLoad = false) { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { if (isFirstLoad) LoadMemberFarms(); using (var c = NestedContainer) { var query = new QueryCommodityProducer(); query.Take = ItemsPerPage; query.Skip = ItemsPerPage*(CurrentPage - 1); query.SupplierId = SupplierId; query.ShowInactive = ShowInactive; if (!string.IsNullOrWhiteSpace(SearchText)) query.Name = SearchText; var rawList = Using<ICommodityProducerRepository>(c).Query(query); _pagedCommodityProducers = new PagenatedList<CommodityProducer>(rawList.Data.OfType<CommodityProducer>().AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count,true); ListOfCommodityProducers.Clear(); int rownumber = 0; _pagedCommodityProducers.ToList().ForEach(n => ListOfCommodityProducers.Add(new VmCommodityProducer { Id = n.Id, Code = n.Code, Acrage = n.Acrage, Name = n.Name, RegNo = n.RegNo, PhysicalAddress = n.PhysicalAddress, Description = n.Description, Status=n._Status, Action=n._Status==EntityStatus.Active?"Deactivate":"Activate", RowNumber = ++rownumber })); UpdatePagenationControl(); } })); }
private void LoadWeighingScalesList() { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { using (var c = NestedContainer) { var list = Using<IEquipmentRepository>(c).GetAll(ShowInactive).OfType<WeighScale>() .Where(n => (n.Name.ToLower().Contains(SearchText.ToLower()) || n.Code.ToLower().Contains(SearchText.ToLower()))); list = list.OrderBy(n => n.Name).ThenBy(n => n.Code); _pagedList = new PagenatedList<WeighScale>(list.AsQueryable(), CurrentPage, ItemsPerPage, list.Count()); WeighingScalesList.Clear(); var devices = from equipment in XElement.Load(@"ScalePrinterAssetsDB.xml").Elements("Equipment") select equipment; _pagedList.Select( (scale, i) => Map(scale, i, devices.FirstOrDefault(n => Guid.Parse(n.Element("Id").Value) == scale.Id))) .ToList().ForEach(WeighingScalesList.Add); UpdatePagenationControl(); } })); }
private void Load() { Application.Current.Dispatcher.BeginInvoke( new Action(delegate { using (var container = NestedContainer) { var orders = Using<IMainOrderRepository>(container) .PagedDocumentList(CurrentPage,ItemsPerPage,StartDate, EndDate, 0, DocumentStatus, SearchText); OrdersSummaryList.Clear(); if (orders != null && orders.Any()) { PagedDocumentList = new PagenatedList<MainOrderSummary>( orders.AsQueryable(), CurrentPage, ItemsPerPage, orders.TotalItemCount,true); UpdatePagenationControl(); if (DocumentStatus == DocumentStatus.Outstanding) MapOutstandingPayments(PagedDocumentList); else { MapUnConfirmedPayments(PagedDocumentList); } } } })); }
protected override void Load(bool isFirstLoad = false) { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { if (isFirstLoad) Setup(); using (var c = NestedContainer) { var query = new QueryCommoditySupplier(); query.Skip = ItemsPerPage*(CurrentPage-1); query.Take = ItemsPerPage; query.ShowInactive = ShowInactive; if (!string.IsNullOrWhiteSpace(SearchText)) query.Name = SearchText; var rawList = Using<ICommoditySupplierRepository>(c).Query(query); var data = rawList.Data.OfType<CommoditySupplier>(); _pagedCommoditySuppliers = new PagenatedList<CommoditySupplier>(data.AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count,true); CommoditySuppliersList.Clear(); int rownumber = 0; _pagedCommoditySuppliers.Select((n, i) => Map(n, i + 1)).ToList().ForEach( n => { if (n != null) CommoditySuppliersList.Add(new VMCommoditySupplier { SupplierId = n.CommoditySupplier.Id, CostCenterCode = n.CommoditySupplier.CostCentreCode ?? "", Name = n.CommoditySupplier.Name??"", AccountName = n.CommoditySupplier.AccountName??"", AccountNo = n.CommoditySupplier.AccountNo??"", Bank =n.CommoditySupplier.BankId!=Guid.Empty? Using<IBankRepository>(c).GetById(n.CommoditySupplier.BankId).Name:"", BankBranch =n.CommoditySupplier.BankBranchId!=Guid.Empty? Using<IBankBranchRepository>(c).GetById( n.CommoditySupplier.BankBranchId).Name:"", Status=n.CommoditySupplier._Status, Action=n.CommoditySupplier._Status==EntityStatus.Active?"Deactivate":"Activate", RowNumber=++rownumber }); }); UpdatePagenationControl(); } })); }
private void LoadWarehouseEntriesList() { using (var c = ObjectFactory.Container.GetNestedContainer()) { var query = new QueryDocument(); query.Skip = ItemsPerPage * (CurrentPage - 1); query.Take = ItemsPerPage; query.ShowInactive = true; query.DocumentSourcingStatusId = (int) DocumentSourcingStatus.Confirmed; //var rawList = c.GetInstance<ICommodityWarehouseStorageRepository>().Query(query).OfType<CommodityWarehouseStorageNote>().ToList(); //WarehouseEntryList.Clear(); //RowNumber = 1; //rawList.ForEach(n=>WarehouseEntryList.Add(Map(n))); var rawList = c.GetInstance<ICommodityWarehouseStorageRepository>().Query(query); var data = rawList.Data.OfType<CommodityWarehouseStorageNote>(); WarehouseEntryList.Clear(); RowNumber = 1; // rawList.ForEach(n => WarehousePendingStorageList.Add(Map(n))); _pagedCommoditySupplierInventoryLevel = new PagenatedList<CommodityWarehouseStorageNote>(data.AsQueryable(), CurrentPage, ItemsPerPage, rawList.Count, true); _pagedCommoditySupplierInventoryLevel.ForEach(n => WarehouseEntryList.Add(Map(n))); UpdatePagenationControl(); } }
void LoadContainersList() { Application.Current.Dispatcher.BeginInvoke( new Action( delegate { using (var c = NestedContainer) { var list = Using<IEquipmentRepository>(c).GetAll(ShowInactive).OfType<SourcingContainer>() .Where(n => (n.Name.ToLower().Contains(SearchText.ToLower()) || n.Code.ToLower().Contains(SearchText.ToLower()))); if (SelectedContainerType != null && SelectedContainerType.Id != Guid.Empty) list = list.Where(n => n.ContainerType.Id == SelectedContainerType.Id); list = list.OrderBy(n => n.Name).ThenBy(n => n.Code); _pagedList = new PagenatedList<SourcingContainer>(list.AsQueryable(), CurrentPage, ItemsPerPage, list.Count()); ContainersList.Clear(); _pagedList.Select(Map).ToList().ForEach(ContainersList.Add); UpdatePagenationControl(); } })); }