public ActionResult ListAllOrders() { CustomerOrderRepository cor = new CustomerOrderRepository(ConstantUtil.MyConnectionString); List <CustomerOrder> customerOrders = cor.GetAll(); return(View(customerOrders)); }
public String Delete(int id) { CustomerOrderRepository cor = new CustomerOrderRepository(ConstantUtil.MyConnectionString); cor.Delete(id); return("You successfully deleted the order with id: " + id); }
public ActionResult GetIndex(int id) { ViewBag.Customers = CustomerRepository.GetCustomerList(); ViewBag.Products = ProductRepository.GetProductList(); var OrderViewDataModel = CustomerOrderRepository.GetOrder(id); List <OrderBox> BoxList = new List <OrderBox>(); foreach (var item in OrderViewDataModel.CustomerOrder) { BoxList.Add(new OrderBox() { Amount = item.Amount, Barcode = item.Barcode, Description = item.Description, GUID = item.GUID, Price = Convert.ToDecimal(item.Price), ProductId = item.ProductId, CustomerOrderId = item.CustomerOrderId, ProductName = item.ProductName }); } Session["OrderBoxList"] = BoxList; return(View("Index", OrderViewDataModel)); }
public void TestFindOrdersByCustomerFail() { var customerOrderRepository = new CustomerOrderRepository(null, mContext); var ordersByCustomer = customerOrderRepository.FindOrdersByCustomerAsync(-1).Result; Assert.Empty(ordersByCustomer); }
/// <summary> /// convert foundry order part to project part view model /// </summary> /// <param name="foundryOrderPart"></param> /// <returns></returns> public FoundryOrderPartViewModel ConvertToProjectPartView(FoundryOrderPart foundryOrderPart) { FoundryOrderPartViewModel model = new FoundryOrderPartViewModel(); var _foundryOrderRepository = new FoundryOrderRepository(); var _customerOrderRepository = new CustomerOrderRepository(); var _projectPartRepository = new ProjectPartRepository(); var _dynamicsReceiptRepository = new ReceiptDynamicsRepository(); var customerOrderPart = _customerOrderRepository.GetCustomerOrderPart(foundryOrderPart.CustomerOrderPartId); var projectPart = _projectPartRepository.GetProjectPart(foundryOrderPart.ProjectPartId); var customerOrder = _customerOrderRepository.GetCustomerOrder((customerOrderPart != null) ? customerOrderPart.CustomerOrderId : Guid.Empty); model.FoundryOrderPartId = foundryOrderPart.FoundryOrderPartId; model.CustomerOrderPartId = foundryOrderPart.CustomerOrderPartId; model.FoundryOrderId = foundryOrderPart.FoundryOrderId; model.ProjectPartId = foundryOrderPart.ProjectPartId; model.CustomerOrderId = (customerOrderPart != null) ? customerOrderPart.CustomerOrderId : Guid.Empty; model.AvailableQuantity = (customerOrderPart != null) ? customerOrderPart.AvailableQuantity : 0; model.FoundryOrderQuantity = foundryOrderPart.Quantity; model.PartNumber = (projectPart != null && !string.IsNullOrEmpty(projectPart.Number)) ? projectPart.Number : "N/A"; model.PartDescription = (projectPart != null && !string.IsNullOrEmpty(projectPart.Description)) ? projectPart.Description : "N/A"; model.PONumber = (customerOrder != null && !string.IsNullOrEmpty(customerOrder.PONumber)) ? customerOrder.PONumber : "N/A"; model.ShipCode = (!string.IsNullOrEmpty(foundryOrderPart.ShipCode)) ? foundryOrderPart.ShipCode : "N/A"; model.ShipCodeNotes = (!string.IsNullOrEmpty(foundryOrderPart.ShipCodeNotes)) ? foundryOrderPart.ShipCodeNotes : "N/A"; model.EstArrivalDate = (foundryOrderPart.EstArrivalDate != null) ? foundryOrderPart.EstArrivalDate : DateTime.MinValue; model.EstArrivalDateStr = (foundryOrderPart.EstArrivalDate != null) ? foundryOrderPart.EstArrivalDate.Value.ToShortDateString() : "N/A"; model.ShipDate = (foundryOrderPart.ShipDate != null) ? foundryOrderPart.ShipDate : DateTime.MinValue; model.ShipDateStr = (foundryOrderPart.ShipDate != null) ? foundryOrderPart.ShipDate.Value.ToShortDateString() : "N/A"; model.Cost = foundryOrderPart.Cost; model.Price = foundryOrderPart.Price; model.IsScheduled = foundryOrderPart.IsScheduled; model.HasBeenReceived = foundryOrderPart.HasBeenReceived; model.ReceiptDate = (foundryOrderPart.ReceiptDate != null) ? foundryOrderPart.ReceiptDate : DateTime.MinValue; model.ReceiptDateStr = (foundryOrderPart.ReceiptDate != null) ? foundryOrderPart.ReceiptDate.Value.ToShortDateString() : "N/A"; model.ReceiptQuantity = foundryOrderPart.ReceiptQuantity; if (_foundryOrderRepository != null) { _foundryOrderRepository.Dispose(); _foundryOrderRepository = null; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } if (_projectPartRepository != null) { _projectPartRepository.Dispose(); _projectPartRepository = null; } if (_dynamicsReceiptRepository != null) { _dynamicsReceiptRepository.Dispose(); _dynamicsReceiptRepository = null; } return(model); }
/// <summary> /// convert foundry order part view model to domain /// </summary> /// <param name="model"></param> /// <returns></returns> public FoundryOrderPart ConvertToDomain(FoundryOrderPartViewModel model) { FoundryOrderPart part = new FoundryOrderPart(); var _customerOrderRepository = new CustomerOrderRepository(); var customerOrderPart = _customerOrderRepository.GetCustomerOrderPart(model.CustomerOrderPartId); part.FoundryOrderPartId = model.FoundryOrderPartId; part.ProjectPartId = (customerOrderPart != null) ? customerOrderPart.ProjectPartId : null; part.PartId = (customerOrderPart != null) ? customerOrderPart.PartId : null; part.CustomerOrderPartId = model.CustomerOrderPartId; part.AvailableQuantity = model.AvailableQuantity; part.Quantity = model.Quantity; part.EstArrivalDate = model.EstArrivalDate; part.ShipDate = model.ShipDate; part.ShipCode = model.ShipCode; part.ShipCodeNotes = model.ShipCodeNotes; part.Price = model.Price; part.Cost = model.Cost; part.IsScheduled = model.IsScheduled; part.HasBeenReceived = model.HasBeenReceived; part.ReceiptDate = model.ReceiptDate; part.ReceiptQuantity = model.ReceiptQuantity; if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } return(part); }
public async Task <IDictionary <Guid, Customer> > ByOrders(string orderIds) { var manyToManyRepo = new CustomerOrderRepository(); var _orderIds = orderIds.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries) .Select(id => Guid.Parse(id)) .ToList(); var allCustomers = await _repository.Customers(); var allManyToMany = await manyToManyRepo.CustomerOrderRelationships(); var data = allManyToMany .Where(r => _orderIds.Contains(r.OrderId)) .Join(allCustomers, r => r.CustomerId, c => c.Id, (r, c) => { return(new { Customer = c, OrderId = r.OrderId }); }) .ToDictionary(a => a.OrderId, a => a.Customer); return(data); }
#pragma warning disable IDE0060 // Remove unused parameter static void Main(string[] args) { #pragma warning restore IDE0060 // Remove unused parameter ILoggerFactory MyLoggerFactory = LoggerFactory.Create(builder => { builder.AddConsole(); }); string connectionString = ConnectionString.mConnectionString; DbContextOptions <Project0Context> options = new DbContextOptionsBuilder <Project0Context> () // .UseLoggerFactory (MyLoggerFactory) .UseSqlServer(connectionString) .Options; var handler = new IOHandler(); var storeRepository = new StoreRepository(options); var customerRepository = new CustomerRepository(options); var orderRepository = new CustomerOrderRepository(options); var stockRepository = new StoreStockRepository(options); // Let the customer input their name handler.AcceptCustomerName(customerRepository); // Let the customer choose which store to order from handler.AcceptStoreChoice(storeRepository, customerRepository); bool running = true; while (running) { // The customer can choose to see their orders, // see orders placed at the current store, // create a new order, or quit the application switch (handler.AcceptCustomerOption()) { case IOHandler.Option.LIST_CUSTOMER_ORDERS: handler.ListCustomerOrders(orderRepository); break; case IOHandler.Option.LIST_STORE_ORDERS: handler.ListStoreOrders(orderRepository); break; case IOHandler.Option.NEW_ORDER: handler.NewCustomerOrder(orderRepository, stockRepository); break; case IOHandler.Option.QUIT: running = false; break; default: break; } } }
//public String CheckOut(IEnumerable<ShoppingCartProduct> Model) //{ // CustomerRepository customerRepo = new CustomerRepository(ConstantUtil.MyConnectionString); // Customer customer = customerRepo.GetById(1); // CustomerOrder co = new CustomerOrder(1, 25); // CustomerOrderRepository cor = new CustomerOrderRepository(ConstantUtil.MyConnectionString); // int orderId = cor.Insert(co); // List<CustomerOrderProduct> cops = new List<CustomerOrderProduct>(); // foreach (int scp in myModel.products) // { // CustomerOrderProduct temp = new CustomerOrderProduct(orderId, scp); // ProductRepository pr = new ProductRepository(ConstantUtil.MyConnectionString); // Product prod = pr.GetById(scp); // temp.Quantity = 100; // temp.UnitOfMeasure = prod.UnitOfMeasure; // temp.UnitPrice = prod.UnitPrice; // temp.CreatedBy = prod.CreatedBy; // temp.CreatedDate = prod.CreatedDate; // temp.LastModifiedBy = prod.LastModifiedBy; // temp.LastModifiedDate = prod.LastModifiedDate; // temp.Subtotal = 0; // cops.Add(temp); // } // return "Successfully"; //} public String CheckOut() { CustomerRepository customerRepo = new CustomerRepository(ConstantUtil.MyConnectionString); Customer customer = customerRepo.GetById(1); CustomerOrder co = new CustomerOrder(1, 25); CustomerOrderRepository cor = new CustomerOrderRepository(ConstantUtil.MyConnectionString); int orderId = cor.Insert(co); List <CustomerOrderProduct> cops = new List <CustomerOrderProduct>(); ShoppingCartProductRepository scpr = new ShoppingCartProductRepository(ConstantUtil.MyConnectionString); IEnumerable <ShoppingCartProduct> myModel = scpr.GetAll(); foreach (ShoppingCartProduct scp in myModel) { CustomerOrderProduct temp = new CustomerOrderProduct(orderId, scp.ProductId); //ProductRepository pr = new ProductRepository(ConstantUtil.MyConnectionString); //Product prod = pr.GetById(scp); temp.Quantity = scp.Quantity; temp.UnitOfMeasure = scp.UnitOfMeasure; temp.UnitPrice = scp.UnitPrice; temp.CreatedBy = scp.CreatedBy; temp.CreatedDate = scp.CreatedDate; temp.LastModifiedBy = scp.LastModifiedBy; temp.LastModifiedDate = scp.LastModifiedDate; temp.Subtotal = scp.SubTotal; //cops.Add(temp); CustomerOrderProductRepository copr = new CustomerOrderProductRepository(ConstantUtil.MyConnectionString); copr.Insert(temp); } return("Successfully"); }
public void TestFindOrdersByCustomer() { var customerOrderRepository = new CustomerOrderRepository(null, mContext); var ordersByCustomer = customerOrderRepository.FindOrdersByCustomerAsync(1).Result; Assert.Single(ordersByCustomer); Assert.Equal(1, ordersByCustomer.First().CustomerId); }
public ActionResult GetByStatus(int statusId) { CustomerOrderRepository cor = new CustomerOrderRepository(ConstantUtil.MyConnectionString); statusId = ViewBag.Status; List <CustomerOrder> customerOrders = cor.GetCustomerOrderWithStatusId(statusId); return(View(customerOrders)); }
private void btnSave_Click(object sender, EventArgs e) { try { var status = cmbStatus.Text; OrderStatus orderStatus; //if ((status.ToUpper().Contains("OK") || status.ToUpper().Contains("REJECT")) ) //{ if (status.ToUpper().Contains("OK")) { orderStatus = OrderStatus.Approved; } else if (status.ToUpper().Contains("REJECT")) { orderStatus = OrderStatus.Rejected; } else if (status.ToUpper().Contains("SKIP")) { orderStatus = OrderStatus.Skip; } else { MessageBox.Show("Please select valid status"); return; } var saveStatus = new CustomerOrderRepository().ApproveRejectOrder(_orderID, orderStatus, txtReason.Text); if (saveStatus) { MessageBox.Show("Status updated successfully."); if (inspDashboard != null) { inspDashboard.LoadGridData(); new ScreensRepository().UpdateScreenReload(3, true); } if (dashboard != null) { dashboard.LoadGridData(); } this.Close(); } else { MessageBox.Show("Error while updating status, please contact administrator."); } //} //else { // MessageBox.Show("Please select valid status"); //} } catch (Exception ex) { LogException(ex); } }
/// <summary> /// convert customer order part to project part view model /// </summary> /// <param name="customerOrderPart"></param> /// <returns></returns> public CustomerOrderPartViewModel ConvertToProjectPartView(CustomerOrderPart customerOrderPart) { CustomerOrderPartViewModel model = new CustomerOrderPartViewModel(); var _priceSheetRepository = new PriceSheetRepository(); var _projectPartRepository = new ProjectPartRepository(); var _customerOrderRepository = new CustomerOrderRepository(); var _foundryOrderRepository = new FoundryOrderRepository(); var priceSheetPart = _priceSheetRepository.GetPriceSheetPart(customerOrderPart.PriceSheetPartId); var projectPart = _projectPartRepository.GetProjectPart((customerOrderPart.ProjectPartId != null) ? customerOrderPart.ProjectPartId : Guid.Empty); var priceSheet = _priceSheetRepository.GetPriceSheet((priceSheetPart != null) ? priceSheetPart.PriceSheetId : Guid.Empty); var customerOrder = _customerOrderRepository.GetCustomerOrder(customerOrderPart.CustomerOrderId); var receivedQuantity = _foundryOrderRepository.GetFoundryOrderParts().Where(x => x.CustomerOrderPartId == customerOrderPart.CustomerOrderPartId && x.HasBeenReceived).Select(y => y.ReceiptQuantity).Sum(); model.CustomerOrderPartId = customerOrderPart.CustomerOrderPartId; model.CustomerOrderId = customerOrderPart.CustomerOrderId; model.PONumber = (!string.IsNullOrEmpty(customerOrder.PONumber)) ? customerOrder.PONumber : "N/A"; model.ProjectPartId = customerOrderPart.ProjectPartId; model.PriceSheetPartId = customerOrderPart.PriceSheetPartId; model.PriceSheetId = (priceSheet != null) ? priceSheet.PriceSheetId : Guid.Empty; model.AvailableQuantity = customerOrderPart.AvailableQuantity; model.CustomerOrderQuantity = customerOrderPart.Quantity; model.PartNumber = (projectPart != null && !string.IsNullOrEmpty(projectPart.Number)) ? projectPart.Number : "N/A"; model.PartDescription = (projectPart != null && !string.IsNullOrEmpty(projectPart.Description)) ? projectPart.Description : "N/A"; model.PriceSheetNumber = (priceSheet != null && !string.IsNullOrEmpty(priceSheet.Number)) ? priceSheet.Number : "N/A"; model.EstArrivalDate = (customerOrderPart.EstArrivalDate != null) ? customerOrderPart.EstArrivalDate : DateTime.MinValue; model.EstArrivalDateStr = (customerOrderPart.EstArrivalDate != null) ? customerOrderPart.EstArrivalDate.Value.ToShortDateString() : "N/A"; model.ReceiptQuantity = receivedQuantity; model.Cost = customerOrderPart.Cost; model.Price = customerOrderPart.Price; if (_priceSheetRepository != null) { _priceSheetRepository.Dispose(); _priceSheetRepository = null; } if (_projectPartRepository != null) { _projectPartRepository.Dispose(); _projectPartRepository = null; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } return(model); }
public ActionResult Get(Int32 id) { CustomerOrderRepository customerOrderRepository = new CustomerOrderRepository(ConstantUtil.AzureDb); CustomerOrder customerOrder = customerOrderRepository.GetById(id); if (customerOrder != null) { return(View(customerOrder)); } return(View(customerOrder)); }
public ActionResult Insert(CustomerOrder model) { CustomerOrderRepository customerOrderRepository = new CustomerOrderRepository(ConstantUtil.AzureDb); //String connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; //CategoryRepository categoryRepository = new CategoryRepository(connectionString); //if (customerOrderRepository.Insert(model)) // return View("Index", model); return(View("Index", model)); }
/// <summary> /// convert container part to packlingList part view model /// </summary> /// <param name="containerPart"></param> /// <returns></returns> public PackingListPartViewModel ConvertToView(ContainerPart containerPart) { PackingListPartViewModel model = new PackingListPartViewModel(); var _foundryOrderRepository = new FoundryOrderRepository(); var _partRepository = new PartRepository(); var _dynamicsPartRepository = new PartDynamicsRepository(); var _customerOrderRepository = new CustomerOrderRepository(); var foundryOrderPart = _foundryOrderRepository.GetFoundryOrderPart(containerPart.FoundryOrderPartId); var part = _partRepository.GetPart(foundryOrderPart.PartId); var dynamicsPart = _dynamicsPartRepository.GetPartMaster((part != null) ? part.Number : null); var customerOrderPart = _customerOrderRepository.GetCustomerOrderPart(foundryOrderPart.CustomerOrderPartId); var customerOrder = _customerOrderRepository.GetCustomerOrder(customerOrderPart.CustomerOrderId); model.ShipCode = foundryOrderPart.ShipCode; model.PartNumber = (part != null && !string.IsNullOrEmpty(part.Number)) ? part.Number : "N/A"; model.PartWeight = (dynamicsPart != null) ? (dynamicsPart.ITEMSHWT / 100.00m) : 0.00m; model.PartQuantity = containerPart.Quantity; model.PalletNumber = (!string.IsNullOrEmpty(containerPart.PalletNumber)) ? containerPart.PalletNumber : "N/A"; model.PONumber = (customerOrder != null && !string.IsNullOrEmpty(customerOrder.PONumber)) ? customerOrder.PONumber : "N/A"; model.PalletQuantity = containerPart.Quantity; model.InvoiceNumber = "Will fill in later"; if (_foundryOrderRepository != null) { _foundryOrderRepository.Dispose(); _foundryOrderRepository = null; } if (_partRepository != null) { _partRepository.Dispose(); _partRepository = null; } if (_dynamicsPartRepository != null) { _dynamicsPartRepository.Dispose(); _dynamicsPartRepository = null; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } return(model); }
public HttpResponseMessage DeleteOrder(int id) { HttpResponseMessage message = null; try { CustomerOrderRepository customerRepo = new CustomerOrderRepository(); customerRepo.DeleteOrder(id); message = Request.CreateResponse(HttpStatusCode.Accepted, "Silme Başarılı"); customerRepo = null; } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString()); } return(message); }
public HttpResponseMessage GetOrder(int id) { HttpResponseMessage message = null; try { CustomerOrderRepository orderRepo = new CustomerOrderRepository(); var order = orderRepo.GetOrder(id); message = Request.CreateResponse(HttpStatusCode.Accepted, order); order = null; } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString()); } return(message); }
public HttpResponseMessage GetAllOrders() { HttpResponseMessage message = null; try { CustomerOrderRepository customerRepo = new CustomerOrderRepository(); var OrderList = customerRepo.GetAllOrders(); message = Request.CreateResponse(HttpStatusCode.Accepted, OrderList); customerRepo = null; } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString()); } return(message); }
/// <summary> /// convert packlingList part to view model /// </summary> /// <param name="packingListPart"></param> /// <returns></returns> public PackingListPartViewModel ConvertToView(PackingListPart packingListPart) { PackingListPartViewModel model = new PackingListPartViewModel(); var _partRepository = new PartRepository(); var _customerOrderRepository = new CustomerOrderRepository(); var _dynamicsPartRepository = new PartDynamicsRepository(); var part = _partRepository.GetPart(packingListPart.PartNumber); var dynamicsPart = _dynamicsPartRepository.GetPartMaster((part != null) ? part.Number : null); var customerOrder = _customerOrderRepository.GetCustomerOrder(packingListPart.PONumber); model.PackingListPartId = packingListPart.PackingListPartId; model.PackingListId = packingListPart.PackingListId; model.PartId = (part != null) ? part.PartId : Guid.Empty; model.ShipCode = (!string.IsNullOrEmpty(packingListPart.ShipCode)) ? packingListPart.ShipCode : "N/A"; model.PartNumber = (!string.IsNullOrEmpty(packingListPart.PartNumber)) ? packingListPart.PartNumber : "N/A"; model.PartWeight = (dynamicsPart != null) ? (dynamicsPart.ITEMSHWT / 100.00m) : 0.00m; model.PartQuantity = packingListPart.PalletQuantity; model.PalletNumber = (!string.IsNullOrEmpty(packingListPart.PalletNumber)) ? packingListPart.PalletNumber : "N/A"; model.PalletQuantity = packingListPart.PalletQuantity; model.PalletWeight = packingListPart.PalletWeight; model.PalletTotal = packingListPart.PalletTotal; model.TotalPalletQuantity = packingListPart.TotalPalletQuantity; model.PONumber = (!string.IsNullOrEmpty(packingListPart.PONumber)) ? packingListPart.PONumber : "N/A"; model.CustomerOrderId = (customerOrder != null) ? customerOrder.CustomerOrderId : Guid.Empty; model.InvoiceNumber = (!string.IsNullOrEmpty(packingListPart.InvoiceNumber)) ? packingListPart.InvoiceNumber : "N/A"; if (_partRepository != null) { _partRepository.Dispose(); _partRepository = null; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } return(model); }
public HttpResponseMessage PutOrder(int id, CustomerOrderHeaderDTO customerOrderHeaderDTO) { HttpResponseMessage message = null; try { CustomerOrderRepository customerRepo = new CustomerOrderRepository(); customerRepo.PostOrder(customerOrderHeaderDTO); message = Request.CreateResponse(HttpStatusCode.Accepted, "Ekleme İşlem Tamamlandı"); customerRepo = null; } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString()); } return(message); }
public static void DisplayOrders() { List <Customer> customers = new List <Customer>(); CustomerOrder customerOrder = new CustomerOrder(); CustomerOrderRepository customerOrderRepository = new CustomerOrderRepository(); customers = customerOrderRepository.LoadAllCustomers(); foreach (var cust in customers) { customerOrder.orders = customerOrderRepository.LoadAllOrders(cust.CustomerId); Console.WriteLine("***************************************************"); Console.WriteLine("Customer Name : " + cust.Name); Console.WriteLine("Orders: "); foreach (var order in customerOrder.orders) { Console.WriteLine("\tOrder ID: " + order.OrderId); Console.WriteLine("\tOrder Amount:" + order.Amount); } } }
public CustomerOrderService() { _repo = new CustomerOrderRepository(); }
/// <summary> /// convert container part to warehouse inventory list model /// </summary> /// <param name="containerPart"></param> /// <returns></returns> public WarehouseInventoryViewModel ConvertToListView(ContainerPart containerPart) { WarehouseInventoryViewModel model = new WarehouseInventoryViewModel(); var _foundryOrderRepository = new FoundryOrderRepository(); var _customerOrderRepository = new CustomerOrderRepository(); var _partRepository = new PartRepository(); var _dynamicsPartRepository = new PartDynamicsRepository(); var _containerRepository = new ContainerRepository(); var foundryOrderPart = _foundryOrderRepository.GetFoundryOrderPart(containerPart.FoundryOrderPartId); var customerOrderPart = _customerOrderRepository.GetCustomerOrderPart((foundryOrderPart != null) ? foundryOrderPart.CustomerOrderPartId : Guid.Empty); var part = _partRepository.GetPart((foundryOrderPart != null) ? foundryOrderPart.PartId : Guid.Empty); var dynamicsPart = _dynamicsPartRepository.GetPartMaster((part != null) ? part.Number : string.Empty); var container = _containerRepository.GetContainer(containerPart.ContainerId); model.CustomerId = (part != null) ? part.CustomerId : "N/A"; model.ShipCode = (foundryOrderPart != null) ? foundryOrderPart.ShipCode : "N/A"; model.PartNumber = (part != null && !string.IsNullOrEmpty(part.Number)) ? part.Number : "N/A"; model.PartWeight = (dynamicsPart != null) ? (dynamicsPart.ITEMSHWT / 100.00m) : 0.00m; model.PalletNumber = (!string.IsNullOrEmpty(part.Number)) ? containerPart.PalletNumber : "N/A"; model.PalletQuantity = containerPart.Quantity; model.TotalQuantity = containerPart.Quantity; model.ContainerNumber = (!string.IsNullOrEmpty(part.Number)) ? container.Number : "N/A"; model.PONumber = (customerOrderPart != null && !string.IsNullOrEmpty(customerOrderPart.CustomerOrder.PONumber)) ? customerOrderPart.CustomerOrder.PONumber : "N/A"; model.WarehouseDate = (foundryOrderPart != null) ? foundryOrderPart.ReceiptDate : DateTime.MinValue; model.WarehouseDateStr = (foundryOrderPart != null && foundryOrderPart.ReceiptDate != null) ? foundryOrderPart.ReceiptDate.Value.ToShortDateString() : "N/A"; model.SixtyDaysDate = (foundryOrderPart != null && foundryOrderPart.ReceiptDate != null) ? foundryOrderPart.ReceiptDate.Value.AddDays(60) : DateTime.MinValue; model.SixtyDaysDateStr = (model.SixtyDaysDate != null) ? model.SixtyDaysDate.Value.ToShortDateString() : "N/A"; if (_foundryOrderRepository != null) { _foundryOrderRepository.Dispose(); _foundryOrderRepository = null; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } if (_partRepository != null) { _partRepository.Dispose(); _partRepository = null; } if (_dynamicsPartRepository != null) { _dynamicsPartRepository.Dispose(); _dynamicsPartRepository = null; } if (_containerRepository != null) { _containerRepository.Dispose(); _containerRepository = null; } return(model); }
/// <summary> /// convert customer order to view model /// </summary> /// <param name="order"></param> /// <returns></returns> public CustomerOrderViewModel ConvertToView(CustomerOrder order) { CustomerOrderViewModel model = new CustomerOrderViewModel(); var _projectRepository = new ProjectRepository(); var _customerDynamicsRepository = new CustomerDynamicsRepository(); var _customerAddressDynamicsRepository = new CustomerAddressDynamicsRepository(); var _stateRepository = new StateRepository(); var _foundryDynamicsRepository = new FoundryDynamicsRepository(); var _siteDynamicsRepository = new SiteDynamicsRepository(); var _orderTermRepository = new OrderTermRepository(); var _priceSheetRepository = new PriceSheetRepository(); var _customerOrderRepository = new CustomerOrderRepository(); var project = _projectRepository.GetProject(order.ProjectId); var dynamicsCustomer = _customerDynamicsRepository.GetCustomer(order.CustomerId); var dynamicsFoundry = _foundryDynamicsRepository.GetFoundry(order.FoundryId); var dynamicsAddress = _customerAddressDynamicsRepository.GetCustomerAddress(order.CustomerAddressId); var state = _stateRepository.GetState((dynamicsAddress != null && !string.IsNullOrEmpty(dynamicsAddress.STATE)) ? dynamicsAddress.STATE : string.Empty); var stateName = (state != null && !string.IsNullOrEmpty(state.Name)) ? ", " + state.Name : string.Empty; var dynamicsSite = _siteDynamicsRepository.GetSite((dynamicsAddress != null && !string.IsNullOrEmpty(dynamicsAddress.LOCNCODE)) ? dynamicsAddress.LOCNCODE : string.Empty); var orderTerm = _orderTermRepository.GetOrderTerm(order.ShipmentTermsId); var customerOrderParts = _customerOrderRepository.GetCustomerOrderParts().Where(x => x.CustomerOrderId == order.CustomerOrderId).ToList(); model.CustomerOrderId = order.CustomerOrderId; model.OrderDate = order.PODate; model.PONumber = (!string.IsNullOrEmpty(order.PONumber)) ? order.PONumber : "N/A"; model.PODate = order.PODate; model.PODateStr = (order.PODate != null) ? order.PODate.ToShortDateString() : "N/A"; model.ProjectId = order.ProjectId; model.ProjectName = (project != null && !string.IsNullOrEmpty(project.Name)) ? project.Name : "N/A"; model.CustomerId = order.CustomerId; model.CustomerName = (dynamicsCustomer != null && !string.IsNullOrEmpty(dynamicsCustomer.SHRTNAME)) ? dynamicsCustomer.SHRTNAME : "N/A"; model.CustomerAddressId = order.CustomerAddressId; model.CustomerAddress = (dynamicsAddress != null) ? dynamicsAddress.ADDRESS1 + " " + dynamicsAddress.CITY + stateName : "N/A"; model.FoundryId = order.FoundryId; model.FoundryName = (dynamicsFoundry != null && !string.IsNullOrEmpty(dynamicsFoundry.VENDSHNM)) ? dynamicsFoundry.VENDSHNM : "N/A"; model.SiteId = order.SiteId; model.SiteDescription = (dynamicsSite != null && !string.IsNullOrEmpty(dynamicsSite.LOCNDSCR)) ? dynamicsSite.LOCNDSCR : "N/A"; model.ShipmentTermsId = order.ShipmentTermsId; model.ShipmentTerms = (orderTerm != null && !string.IsNullOrEmpty(orderTerm.Description)) ? orderTerm.Description : "N/A"; model.PortDate = (order.PortDate != null) ? order.PortDate : DateTime.MinValue; model.PortDateStr = (order.PortDate != null) ? order.PortDate.Value.ToShortDateString() : "N/A"; model.ShipDate = (order.ShipDate != null) ? order.ShipDate : DateTime.MinValue; model.ShipDateStr = (order.ShipDate != null) ? order.ShipDate.Value.ToShortDateString() : "N/A"; model.DueDate = (order.DueDate != null) ? order.DueDate : DateTime.MinValue; model.DueDateStr = (order.DueDate != null) ? order.DueDate.Value.ToShortDateString() : "N/A"; model.EstArrivalDate = (order.EstArrivalDate != null) ? order.EstArrivalDate : DateTime.MinValue; model.EstArrivalDateStr = (order.EstArrivalDate != null) ? order.EstArrivalDate.Value.ToShortDateString() : "N/A"; model.OrderNotes = (!string.IsNullOrEmpty(order.Notes)) ? order.Notes : "N/A"; model.IsOpen = order.IsOpen; model.IsHold = order.IsHold; model.HoldExpirationDate = (order.HoldExpirationDate != null) ? order.HoldExpirationDate : DateTime.MinValue; model.HoldExpirationDateStr = (order.HoldExpirationDate != null) ? order.HoldExpirationDate.Value.ToShortDateString() : "N/A"; model.HoldNotes = (!string.IsNullOrEmpty(order.HoldNotes)) ? order.HoldNotes : "N/A"; model.IsCanceled = order.IsCanceled; model.CanceledDate = (order.CanceledDate != null) ? order.CanceledDate : DateTime.MinValue; model.CanceledDateStr = (order.CanceledDate != null) ? order.CanceledDate.Value.ToShortDateString() : "N/A"; model.CancelNotes = (!string.IsNullOrEmpty(order.CancelNotes)) ? order.CancelNotes : "N/A"; model.IsComplete = order.IsComplete; model.CompletedDate = (order.CompletedDate != null) ? order.CompletedDate : DateTime.MinValue; model.CompletedDateStr = (order.CompletedDate != null) ? order.CompletedDate.Value.ToShortDateString() : "N/A"; model.Status = order.IsOpen ? "Open" : order.IsCanceled ? "Canceled" : order.IsComplete ? "Completed" : order.IsHold ? "On Hold" : "N/A"; model.IsSample = order.IsSample; model.IsTooling = order.IsTooling; model.IsProduction = order.IsProduction; model.OrderTypeDescription = order.IsSample ? "Sample" : order.IsTooling ? "Tooling" : order.IsProduction ? "Production" : "N/A"; model.CustomerOrderParts = new List <CustomerOrderPartViewModel>(); var totalPrice = 0.00m; if (customerOrderParts != null && customerOrderParts.Count > 0) { foreach (var customerOrderPart in customerOrderParts) { CustomerOrderPartViewModel partModel = new CustomerOrderPartViewModel(); if (model.OrderTypeDescription.Equals("Sample") || model.OrderTypeDescription.Equals("Tooling")) { partModel = new CustomerOrderPartConverter().ConvertToProjectPartView(customerOrderPart); } else { partModel = new CustomerOrderPartConverter().ConvertToPartView(customerOrderPart); } model.CustomerOrderParts.Add(partModel); totalPrice += (partModel.Price * partModel.CustomerOrderQuantity); } } model.TotalPrice = Math.Round(totalPrice, 2); model.CustomerOrderParts = model.CustomerOrderParts.OrderByDescending(y => y.EstArrivalDate).ThenBy(y => y.PartNumber).ToList(); if (_projectRepository != null) { _projectRepository.Dispose(); _projectRepository = null; } if (_customerDynamicsRepository != null) { _customerDynamicsRepository.Dispose(); _customerDynamicsRepository = null; } if (_customerAddressDynamicsRepository != null) { _customerAddressDynamicsRepository.Dispose(); _customerAddressDynamicsRepository = null; } if (_foundryDynamicsRepository != null) { _foundryDynamicsRepository.Dispose(); _foundryDynamicsRepository = null; } if (_stateRepository != null) { _stateRepository.Dispose(); _stateRepository = null; } if (_siteDynamicsRepository != null) { _siteDynamicsRepository.Dispose(); _siteDynamicsRepository = null; } if (_orderTermRepository != null) { _orderTermRepository.Dispose(); _orderTermRepository = null; } if (_priceSheetRepository != null) { _priceSheetRepository.Dispose(); _priceSheetRepository = null; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } return(model); }
/// <summary> /// convert foundry order view model to domain /// </summary> /// <param name="model"></param> /// <returns></returns> public FoundryOrder ConvertToDomain(FoundryOrderViewModel model) { var _customerOrderRepository = new CustomerOrderRepository(); FoundryOrder order = new FoundryOrder(); order.FoundryOrderId = model.FoundryOrderId; order.Number = model.OrderNumber; order.CustomerId = model.CustomerId; order.ProjectId = model.ProjectId; order.CustomerAddressId = model.CustomerAddressId; order.FoundryId = model.FoundryId; order.SiteId = model.SiteId; order.ShipmentTermsId = model.ShipmentTermsId; order.OrderDate = model.OrderDate ?? DateTime.Now; order.ShipDate = model.ShipDate; order.EstArrivalDate = model.EstArrivalDate; order.DueDate = model.DueDate; order.PortDate = model.PortDate; order.Notes = model.OrderNotes; order.ShipVia = model.ShipVia; order.TransitDays = model.TransitDays; order.IsConfirmed = model.IsConfirmed; order.ConfirmedDate = model.ConfirmedDate; order.IsOpen = model.IsOpen; order.IsHold = model.IsHold; order.HoldExpirationDate = (model.IsHold) ? model.HoldExpirationDate : null; order.HoldNotes = (model.IsHold) ? model.HoldNotes : null; order.IsCanceled = model.IsCanceled; order.CanceledDate = (model.IsCanceled) ? model.CanceledDate : null; order.CancelNotes = (model.IsCanceled) ? model.CancelNotes : null; order.IsComplete = model.IsComplete; order.CompletedDate = model.CompletedDate; order.IsSample = model.IsSample; order.IsTooling = model.IsTooling; order.IsProduction = model.IsProduction; if (model.FoundryOrderParts != null && model.FoundryOrderParts.Count > 0) { var foundryOrderParts = new List <FoundryOrderPart>(); foreach (var foundryOrderPart in model.FoundryOrderParts) { var customerOrderPart = _customerOrderRepository.GetCustomerOrderPart(foundryOrderPart.CustomerOrderPartId); if (model.IsSample || model.IsTooling) { foundryOrderPart.ProjectPartId = (customerOrderPart != null) ? customerOrderPart.ProjectPartId : null; foundryOrderPart.PartId = null; } else { foundryOrderPart.ProjectPartId = null; foundryOrderPart.PartId = (customerOrderPart != null) ? customerOrderPart.PartId : null; } foundryOrderPart.FoundryOrderId = model.FoundryOrderId; FoundryOrderPart orderPart = new FoundryOrderPartConverter().ConvertToDomain(foundryOrderPart); foundryOrderParts.Add(orderPart); } order.FoundryOrderParts = foundryOrderParts; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } return(order); }
/// <summary> /// convert foundry order to view model /// </summary> /// <param name="order"></param> /// <returns></returns> public FoundryOrderViewModel ConvertToView(FoundryOrder order) { FoundryOrderViewModel model = new FoundryOrderViewModel(); var _projectRepository = new ProjectRepository(); var _customerDynamicsRepository = new CustomerDynamicsRepository(); var _customerAddressDynamicsRepository = new CustomerAddressDynamicsRepository(); var _stateRepository = new StateRepository(); var _foundryDynamicsRepository = new FoundryDynamicsRepository(); var _siteDynamicsRepository = new SiteDynamicsRepository(); var _orderTermRepository = new OrderTermRepository(); var _billOfLadingRepository = new BillOfLadingRepository(); var _customerOrderRepository = new CustomerOrderRepository(); var _foundryOrderRepository = new FoundryOrderRepository(); var project = _projectRepository.GetProject(order.ProjectId); var dynamicsCustomer = _customerDynamicsRepository.GetCustomer(order.CustomerId); var dynamicsCustomerAddress = _customerAddressDynamicsRepository.GetCustomerAddress(order.CustomerAddressId); var state = _stateRepository.GetState((dynamicsCustomerAddress != null && !string.IsNullOrEmpty(dynamicsCustomerAddress.STATE)) ? dynamicsCustomerAddress.STATE : string.Empty); var stateName = (state != null && !string.IsNullOrEmpty(state.Name)) ? ", " + state.Name : string.Empty; var dynamicsFoundry = _foundryDynamicsRepository.GetFoundry(order.FoundryId); var dynamicsSite = _siteDynamicsRepository.GetSite((dynamicsCustomerAddress != null && !string.IsNullOrEmpty(dynamicsCustomerAddress.LOCNCODE)) ? dynamicsCustomerAddress.LOCNCODE : string.Empty); var orderTerm = _orderTermRepository.GetOrderTerm(order.ShipmentTermsId); var billOfLading = _billOfLadingRepository.GetBillOfLadings().FirstOrDefault(x => x.FoundryId.Replace(" ", string.Empty).ToLower() == order.FoundryId.Replace(" ", string.Empty).ToLower()); var parts = _foundryOrderRepository.GetFoundryOrderParts().Where(x => x.FoundryOrderId == order.FoundryOrderId).ToList(); model.FoundryOrderId = order.FoundryOrderId; model.BillOfLadingId = (billOfLading != null) ? billOfLading.BillOfLadingId : Guid.Empty; model.OrderNumber = (!string.IsNullOrEmpty(order.Number)) ? order.Number : "N/A"; model.CustomerId = order.CustomerId; model.CustomerName = (dynamicsCustomer != null && !string.IsNullOrEmpty(dynamicsCustomer.SHRTNAME)) ? dynamicsCustomer.SHRTNAME : "N/A"; model.CustomerAddressId = order.CustomerAddressId; model.CustomerAddress = (dynamicsCustomerAddress != null) ? dynamicsCustomerAddress.ADDRESS1 + " " + dynamicsCustomerAddress.CITY + ", " + stateName : "N/A"; model.ProjectId = order.ProjectId; model.ProjectName = (project != null) ? project.Name : "N/A"; model.FoundryId = order.FoundryId; model.FoundryName = (dynamicsFoundry != null && !string.IsNullOrEmpty(dynamicsFoundry.VENDSHNM)) ? dynamicsFoundry.VENDSHNM : "N/A"; model.OrderNotes = (!string.IsNullOrEmpty(order.Notes)) ? order.Notes : "N/A"; model.ShipmentTermsId = order.ShipmentTermsId; model.ShipmentTerms = (orderTerm != null) ? orderTerm.Description : "N/A"; model.OrderDate = order.OrderDate; model.PODate = (order.OrderDate != null) ? order.OrderDate : DateTime.MinValue; model.PODateStr = (order.OrderDate != null) ? order.OrderDate.ToShortDateString() : "N/A"; model.DueDate = (order.DueDate != null) ? order.DueDate : DateTime.MinValue; model.DueDateStr = (order.DueDate != null) ? order.DueDate.Value.ToShortDateString() : "N/A"; model.PortDate = (order.PortDate != null) ? order.PortDate : DateTime.MinValue; model.PortDateStr = (order.PortDate != null) ? order.PortDate.Value.ToShortDateString() : "N/A"; model.ShipDate = (order.ShipDate != null) ? order.ShipDate : DateTime.MinValue; model.ShipDateStr = (order.ShipDate != null) ? order.ShipDate.Value.ToShortDateString() : "N/A"; model.EstArrivalDate = (order.EstArrivalDate != null) ? order.EstArrivalDate : DateTime.MinValue; model.EstArrivalDateStr = (order.EstArrivalDate != null) ? order.EstArrivalDate.Value.ToShortDateString() : "N/A"; model.ShipVia = (!string.IsNullOrEmpty(order.ShipVia)) ? order.ShipVia : "N/A"; model.TransitDays = order.TransitDays; model.SiteId = order.SiteId; model.SiteDescription = (dynamicsSite != null && !string.IsNullOrEmpty(dynamicsSite.LOCNDSCR)) ? dynamicsSite.LOCNDSCR : "N/A"; model.IsOpen = order.IsOpen ? true : false; model.IsConfirmed = order.IsConfirmed; model.ConfirmedDate = (order.ConfirmedDate != null) ? order.ConfirmedDate : DateTime.MinValue; model.ConfirmedDateStr = (order.ConfirmedDate != null) ? order.ConfirmedDate.Value.ToShortDateString() : "N/A"; model.IsHold = order.IsHold; model.HoldExpirationDate = (order.HoldExpirationDate != null) ? order.HoldExpirationDate : DateTime.MinValue; model.HoldExpirationDateStr = (order.HoldExpirationDate != null) ? order.HoldExpirationDate.Value.ToShortDateString() : "N/A"; model.HoldNotes = (!string.IsNullOrEmpty(order.HoldNotes)) ? order.HoldNotes : "N/A"; model.IsCanceled = order.IsCanceled; model.CanceledDate = (order.CanceledDate != null) ? order.CanceledDate : DateTime.MinValue; model.CanceledDateStr = (order.CanceledDate != null) ? order.CanceledDate.Value.ToShortDateString() : "N/A"; model.CancelNotes = (!string.IsNullOrEmpty(order.CancelNotes)) ? order.CancelNotes : "N/A"; model.IsComplete = order.IsComplete; model.CompletedDate = (order.CompletedDate != null) ? order.CompletedDate : DateTime.MinValue; model.CompletedDateStr = (order.CompletedDate != null) ? order.CompletedDate.Value.ToShortDateString() : "N/A"; model.Status = order.IsOpen ? "Open" : order.IsCanceled ? "Canceled" : order.IsComplete ? "Completed" : order.IsHold ? "On Hold" : "N/A"; model.IsSample = order.IsSample; model.IsTooling = order.IsTooling; model.IsProduction = order.IsProduction; model.OrderTypeDescription = order.IsSample ? "Sample" : order.IsTooling ? "Tooling" : order.IsProduction ? "Production" : "N/A"; if (parts != null && parts.Count > 0) { var foundryOrderParts = new List <FoundryOrderPartViewModel>(); var totalPrice = 0.00m; foreach (var part in parts) { FoundryOrderPartViewModel foundryOrderPart = new FoundryOrderPartViewModel(); if (model.OrderTypeDescription.Equals("Sample") || model.OrderTypeDescription.Equals("Tooling")) { foundryOrderPart = new FoundryOrderPartConverter().ConvertToProjectPartView(part); } else { foundryOrderPart = new FoundryOrderPartConverter().ConvertToPartView(part); } foundryOrderParts.Add(foundryOrderPart); totalPrice += (foundryOrderPart.Price * foundryOrderPart.FoundryOrderQuantity); } model.TotalPrice = Math.Round(totalPrice, 2); model.FoundryOrderParts = foundryOrderParts; } if (_projectRepository != null) { _projectRepository.Dispose(); _projectRepository = null; } if (_customerDynamicsRepository != null) { _customerDynamicsRepository.Dispose(); _customerDynamicsRepository = null; } if (_customerAddressDynamicsRepository != null) { _customerAddressDynamicsRepository.Dispose(); _customerAddressDynamicsRepository = null; } if (_stateRepository != null) { _stateRepository.Dispose(); _stateRepository = null; } if (_foundryDynamicsRepository != null) { _foundryDynamicsRepository.Dispose(); _foundryDynamicsRepository = null; } if (_siteDynamicsRepository != null) { _siteDynamicsRepository.Dispose(); _siteDynamicsRepository = null; } if (_orderTermRepository != null) { _orderTermRepository.Dispose(); _orderTermRepository = null; } if (_billOfLadingRepository != null) { _billOfLadingRepository.Dispose(); _billOfLadingRepository = null; } if (_customerOrderRepository != null) { _customerOrderRepository.Dispose(); _customerOrderRepository = null; } if (_foundryOrderRepository != null) { _foundryOrderRepository.Dispose(); _foundryOrderRepository = null; } return(model); }
public CustomerOrderBusiness(CustomerOrderRepository customerOrderRepository) { this._customerOrderRepository = customerOrderRepository; }