public void TestInitialize() { context = new ApplicationDbContext(); deliveryOrderService = new DeliveryOrderService(context); deliveryOrderRepository = new DeliveryOrderRepository(context); purchaseOrderRepository = new PurchaseOrderRepository(context); inventoryRepository = new InventoryRepository(context); itemRepository = new ItemRepository(context); deliveryOrderDetailRepository = new DeliveryOrderDetailRepository(context); stockMovementRepository = new StockMovementRepository(context); statusRepository = new StatusRepository(context); //create test PO object and save to db PurchaseOrder PO = new PurchaseOrder() { PurchaseOrderNo = "VALLI", CreatedDateTime = DateTime.Now, Supplier = context.Supplier.Where(x => x.SupplierCode == "CHEP").First() }; purchaseOrderRepository.Save(PO); // create test DO object and save to db DeliveryOrder DO = new DeliveryOrder() { DeliveryOrderNo = "DOTEST", PurchaseOrder = PO, CreatedDateTime = DateTime.Now, Supplier = context.Supplier.Where(x => x.SupplierCode == "CHEP").First() }; deliveryOrderRepository.Save(DO); }
public void TestInitialize() { // Arrange context = new ApplicationDbContext(); deliveryOrderRepository = new DeliveryOrderRepository(context); deliveryOrderDetailRepository = new DeliveryOrderDetailRepository(context); }
DeliveryService(EventLog eventLog, DeliveryOrderRepository deliveryOrderRepository, OrderingService orderingService, KitchenService kitchenService) { this.eventLog = eventLog; this.deliveryOrderRepository = deliveryOrderRepository; this.orderingService = orderingService; this.kitchenService = kitchenService; this.eventLog.subscribe(new Topic("kitchen_orders"), e->{ KitchenOrderAssemblyFinishedEvent kitchenOrderAssemblyFinishedEvent = (KitchenOrderAssemblyFinishedEvent)e; addDeliveryOrderToRepository(kitchenOrderAssemblyFinishedEvent); });
public List <Delivery> GetDeliveries(int instanceNumber, DateTime begin, DateTime end, DeliveryOrder newDeliveryOrder) { List <Delivery> oldDeliveries = DeliveryOrderRepository.GetDeliveriesOrdersWithDeliveryOrderTrips(instanceNumber, begin, end); List <Delivery> newDeliveries = newDeliveryOrder.GetDeliveries(); List <Delivery> deliveries = new List <Delivery>(); deliveries.AddRange(newDeliveries); deliveries.AddRange(oldDeliveries); return(deliveries.OrderBy(d => d.ServiceTimeBegin).ToList()); }
public DeliveryOrderService(ApplicationDbContext context) { this.context = context; this.deliveryOrderRepository = new DeliveryOrderRepository(context); this.statusRepository = new StatusRepository(context); this.inventoryRepository = new InventoryRepository(context); this.purchaseOrderRepository = new PurchaseOrderRepository(context); this.stockMovementRepository = new StockMovementRepository(context); this.purchaseOrderDetailsRepository = new PurchaseOrderDetailRepository(context); this.itemRepository = new ItemRepository(context); this.deliveryOrderDetailRepository = new DeliveryOrderDetailRepository(context); this.purchaseOrderService = new PurchaseOrderService(context); }
public void TestInitialize() { context = new ApplicationDbContext(); purchaseOrderService = new PurchaseOrderService(context); purchaseOrderRepository = new PurchaseOrderRepository(context); purchaseOrderDetailRepository = new PurchaseOrderDetailRepository(context); statusRepository = new StatusRepository(context); itemRepository = new ItemRepository(context); itemPriceRepository = new ItemPriceRepository(context); supplierRepository = new SupplierRepository(context); deliveryOrderRepository = new DeliveryOrderRepository(context); deliveryOrderDetailRepository = new DeliveryOrderDetailRepository(context); }
public void TestCleanup() { // Delete DeliveryOrders var deliveryOrderRepository = new DeliveryOrderRepository(context); if (deliveryOrderRepository.FindAll().Where(x => x.InvoiceFileName == "IDSERVICETEST").Count() > 0) { deliveryOrderRepository.FindAll().Where(x => x.InvoiceFileName == "IDSERVICETEST").ToList().ForEach(x => deliveryOrderRepository.Delete(x)); } // Delete Disbursements var disbursementRepository = new DisbursementRepository(context); if (disbursementRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").Count() > 0) { disbursementRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").ToList().ForEach(x => disbursementRepository.Delete(x)); } // Delete Purchase Orders var purchaseOrderRepository = new PurchaseOrderRepository(context); if (purchaseOrderRepository.FindAll().Where(x => x.Status.StatusId == 16).Count() > 0) { purchaseOrderRepository.FindAll().Where(x => x.Status.StatusId == 16).ToList().ForEach(x => purchaseOrderRepository.Delete(x)); } // Delete Requisitions var requisitionRepository = new RequisitionRepository(context); if (requisitionRepository.FindAll().Where(x => x.EmployeeRemarks == "IDSERVICETEST").Count() > 0) { requisitionRepository.FindAll().Where(x => x.EmployeeRemarks == "IDSERVICETEST").ToList().ForEach(x => requisitionRepository.Delete(x)); } // Delete Retrievals var retrievalRepository = new RetrievalRepository(context); if (retrievalRepository.FindAll().Where(x => x.Status.StatusId == 16).Count() > 0) { retrievalRepository.FindAll().Where(x => x.Status.StatusId == 16).ToList().ForEach(x => retrievalRepository.Delete(x)); } // Delete StockAdjustments var stockAdjustmentRepository = new StockAdjustmentRepository(context); if (stockAdjustmentRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").Count() > 0) { stockAdjustmentRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").ToList().ForEach(x => stockAdjustmentRepository.Delete(x)); } }
public static string GetNewDeliveryOrderNo(ApplicationDbContext context) { string prefix = "DO"; int serialNo = new DeliveryOrderRepository(context) .FindByCreatedDateTime(DateTime.Now.Date.AddDays(1 - DateTime.Now.Date.Day), DateTime.Now.Date.AddDays(1)) .Where(x => x.DeliveryOrderNo.Length == 13) .Count() > 0 ? new DeliveryOrderRepository(context) .FindByCreatedDateTime(DateTime.Now.Date.AddDays(1 - DateTime.Now.Date.Day), DateTime.Now.Date.AddDays(1)) .Where(x => x.DeliveryOrderNo.Length == 13) .AsEnumerable() .Select(x => Int32.Parse(x.DeliveryOrderNo.Substring(x.DeliveryOrderNo.Length - 3))) .OrderByDescending(x => x) .FirstOrDefault() + 1 : 1; return($"{prefix}-{DateTime.Now.Year}{DateTime.Now.Month:00}-{serialNo:000}"); }
public void TestInitialize() { context = new ApplicationDbContext(); stockmovementService = new StockMovementService(context); itemService = new ItemService(context); stockmovementRepository = new StockMovementRepository(context); ddRepository = new DisbursementDetailRepository(context); sadRepository = new StockAdjustmentDetailRepository(context); dodRepository = new DeliveryOrderDetailRepository(context); disbursementRepository = new DisbursementRepository(context); doRepository = new DeliveryOrderRepository(context); saRepository = new StockAdjustmentRepository(context); //create new test object and save into db StockMovement sm = new StockMovement() { StockMovementId = IdService.GetNewStockMovementId(context), DisbursementId = "TEST", StockAdjustmentId = "TEST", DeliveryOrderNo = "TEST", Item = context.Item.Where(x => x.ItemCode == "C003").First(), CreatedDateTime = DateTime.Now, OriginalQuantity = 1, AfterQuantity = 2 }; stockmovementRepository.Save(sm); //create new disbursement object and save into db Disbursement disbursement = new Disbursement(); if (disbursementRepository.FindById("TEST") == null) { disbursement.DisbursementId = "TEST"; disbursement.CreatedDateTime = DateTime.Now; } else { disbursement = disbursementRepository.FindById("TEST"); } disbursementRepository.Save(disbursement); //create new DisbursementDetail object and save into db DisbursementDetail detail = new DisbursementDetail() { DisbursementId = "TEST", Item = context.Item.First(), PlanQuantity = 3, ActualQuantity = 3 }; ddRepository.Save(detail); //create new DO object and save into db DeliveryOrder d = new DeliveryOrder(); if (doRepository.FindById("TEST") == null) { d.DeliveryOrderNo = "TEST"; d.CreatedDateTime = DateTime.Now; } else { d = doRepository.FindById("TEST"); } doRepository.Save(d); //create new DO detail object and save into db DeliveryOrderDetail dod = new DeliveryOrderDetail() { DeliveryOrder = d, Item = context.Item.First(), PlanQuantity = 4, ActualQuantity = 4 }; dodRepository.Save(dod); //create new SA object and save into db StockAdjustment SA = new StockAdjustment(); if (saRepository.FindById("TEST") == null) { SA.StockAdjustmentId = "TEST"; SA.CreatedDateTime = DateTime.Now; } else { SA = saRepository.FindById("TEST"); } saRepository.Save(SA); //create new SA detail object and save into db StockAdjustmentDetail SADetail = new StockAdjustmentDetail() { StockAdjustment = SA, Item = context.Item.First(), OriginalQuantity = 2, AfterQuantity = 4 }; sadRepository.Save(SADetail); }
public RepositoryFactory() { Repository bankRepository = new Repository(new Bank()); CurrencyRepository ccyRepository = new CurrencyRepository(); Repository divRepository = new Repository(new Division()); Repository empRepository = new EmployeeRepository(new Employee()); Repository topRepository = new Repository(new TermOfPayment()); Repository unitRepository = new Repository(new Unit()); Repository cuscatRepository = new Repository(new CustomerCategory()); Repository supcatRepository = new Repository(new SupplierCategory()); Repository pricecatRepository = new Repository(new PriceCategory()); Repository taxRepository = new Repository(new Tax()); Repository prtGroupRepository = new Repository(new PartGroup()); Repository warehouseRepository = new Repository(new Warehouse()); Repository prtCategoryRepository = new Repository(new PartCategory()); Repository docTypeRepository = new Repository(new DocumentType()); Repository excRateRepository = new Repository(new ExchangeRate()); CustomerRepository customerRepository = new CustomerRepository(); SupplierRepository supplierRepository = new SupplierRepository(); Repository yearRepository = new YearRepository(); Repository partRepository = new PartRepository(new Part()); StockTakingRepository stocktakingRepository = new StockTakingRepository(); UserRepository userRepository = new UserRepository(new User()); GeneralSetupRepository generalsetupRepository = new GeneralSetupRepository(); PurchaseOrderRepository poRepository = new PurchaseOrderRepository(); PeriodRepository periodRepository = new PeriodRepository(); UserSettingsRepository usRepository = new UserSettingsRepository(); GoodReceiveNoteRepository grnRepository = new GoodReceiveNoteRepository(); PurchaseReturnRepository prRepository = new PurchaseReturnRepository(); SupplierInvoiceRepository siRepository = new SupplierInvoiceRepository(); SupplierOutStandingInvoiceRepository soiRepository = new SupplierOutStandingInvoiceRepository(); SupplierInvoiceJournalRepository sijRepository = new SupplierInvoiceJournalRepository(); PaymentRepository payRepository = new PaymentRepository(); APDebitNoteRepository apdnRepository = new APDebitNoteRepository(); ProcessTransactionRepository prtrRepository = new ProcessTransactionRepository(); SalesOrderRepository slsorderRepository = new SalesOrderRepository(); DeliveryOrderRepository doRepository = new DeliveryOrderRepository(); SalesReturnRepository srRepository = new SalesReturnRepository(); CustomerOutStandingInvoiceRepository coirRepository = new CustomerOutStandingInvoiceRepository(); CustomerInvoiceRepository cirRepository = new CustomerInvoiceRepository(); ReceiptRepository rcptRepository = new ReceiptRepository(); ARCreditNoteRepository arcrRepository = new ARCreditNoteRepository(); CustomerInvoiceJournalRepository cijRepository = new CustomerInvoiceJournalRepository(); OpeningStockRepository opstRepository = new OpeningStockRepository(); POSRepository posRepository = new POSRepository(); m_listService.Add(BANK_REPOSITORY, bankRepository); m_listService.Add(CURRENCY_REPOSITORY, ccyRepository); m_listService.Add(DIVISION_REPOSITORY, divRepository); m_listService.Add(EMPLOYEE_REPOSITORY, empRepository); m_listService.Add(TOP_REPOSITORY, topRepository); m_listService.Add(UNIT_REPOSITORY, unitRepository); m_listService.Add(CUSTOMER_CATEGORY_REPOSITORY, cuscatRepository); m_listService.Add(SUPPLIER_CATEGORY_REPOSITORY, supcatRepository); m_listService.Add(PRICE_CATEGORY_REPOSITORY, pricecatRepository); m_listService.Add(TAX_REPOSITORY, taxRepository); m_listService.Add(PART_GROUP_REPOSITORY, prtGroupRepository); m_listService.Add(WAREHOUSE_REPOSITORY, warehouseRepository); m_listService.Add(PART_CATEGORY_REPOSITORY, prtCategoryRepository); m_listService.Add(DOC_TYPE_REPOSITORY, docTypeRepository); m_listService.Add(EXCHANGE_RATE_REPOSITORY, excRateRepository); m_listService.Add(CUSTOMER_REPOSITORY, customerRepository); m_listService.Add(SUPPLIER_REPOSITORY, supplierRepository); m_listService.Add(YEAR_REPOSITORY, yearRepository); m_listService.Add(PART_REPOSITORY, partRepository); m_listService.Add(STOCKTAKING_REPOSITORY, stocktakingRepository); m_listService.Add(USER_REPOSITORY, userRepository); m_listService.Add(GENERAL_SETUP_REPOSITORY, generalsetupRepository); m_listService.Add(PURCHASEORDER_REPOSITORY, poRepository); m_listService.Add(PERIOD_REPOSITORY, periodRepository); m_listService.Add(USER_SETTING_REPOSITORY, usRepository); m_listService.Add(GOODRECEIVENOTE_REPOSITORY, grnRepository); m_listService.Add(PURCHASE_RETURN_REPOSITORY, prRepository); m_listService.Add(SUPPLIERINVOICE_REPOSITORY, siRepository); m_listService.Add(SUPPLIERINVOICE_JOURNAL_REPOSITORY, sijRepository); m_listService.Add(SUPPLIER_OUTSTANDING_INVOICE_REPOSITORY, soiRepository); m_listService.Add(PAYMENT_REPOSITORY, payRepository); m_listService.Add(APDEBITNOTE_REPOSITORY, apdnRepository); m_listService.Add(PROCESS_TRANSACTION_REPOSITORY, prtrRepository); m_listService.Add(SALES_ORDER_REPOSITORY, slsorderRepository); m_listService.Add(DELIVERY_ORDER_REPOSITORY, doRepository); m_listService.Add(SALES_RETURN_REPOSITORY, srRepository); m_listService.Add(CUSTOMER_OUTSTANDING_INVOICE_REPOSITORY, coirRepository); m_listService.Add(CUSTOMERINVOICE_REPOSITORY, cirRepository); m_listService.Add(RECEIPT_REPOSITORY, rcptRepository); m_listService.Add(ARCREDITNOTE_REPOSITORY, arcrRepository); m_listService.Add(CUSTOMERINVOICE_JOURNAL_REPOSITORY, cijRepository); m_listService.Add(OPENING_STOCK_REPOSITORY, opstRepository); m_listService.Add(POS_REPOSITORY, posRepository); }