public static CashOrderViewModel CreateNewOrder(int id = 0) { CashOrderViewModel model = new CashOrderViewModel(); model.Order = new CashOrder(); using (FreeMarketEntities db = new FreeMarketEntities()) { if (id != 0) { CashCustomer customer = db.CashCustomers.Find(id); if (customer != null) { model.Order.CashCustomerId = customer.Id; model.Order.CustomerDeliveryAddress = customer.DeliveryAddress; model.Order.CustomerEmail = customer.Email; model.Order.CustomerName = customer.Name; model.Order.CustomerPhone = customer.PhoneNumber; } } model.Products = ProductCollection.GetAllProducts(); model.Custodians = db.Custodians.Select (c => new SelectListItem { Text = c.CustodianName, Value = c.CustodianNumber.ToString() }).ToList(); } model.OrderDetails = new List <CashOrderDetail>(); return(model); }
public void InitializeActivatedProducts() { ActivatedProducts = new ProductCollection(); using (FreeMarketEntities db = new FreeMarketEntities()) { ProductCollection products = new ProductCollection(); products = ProductCollection.GetAllProducts(); if (products == null) { return; } foreach (Product item in products.Products) { if (db.ProductCustodians.Any(c => c.ProductNumber == item.ProductNumber && c.SupplierNumber == item.SupplierNumber && c.CustodianNumber == CustodianNumber && c.Active == true)) { item.CustodianActivated = true; ActivatedProducts.Products.Add(item); } else { item.CustodianActivated = false; ActivatedProducts.Products.Add(item); } } } }
public static CashOrderViewModel GetOrder(int id) { CashOrderViewModel model = new CashOrderViewModel(); if (id == 0) { return(model); } using (FreeMarketEntities db = new FreeMarketEntities()) { model.Order = db.CashOrders.Find(id); CashCustomer customer = db.CashCustomers.Find(model.Order.CashCustomerId); model.Order.CustomerDeliveryAddress = customer.DeliveryAddress; model.Order.CustomerEmail = customer.Email; model.Order.CustomerName = customer.Name; model.Order.CustomerPhone = customer.PhoneNumber; model.OrderDetails = db.GetCashOrderDetails(model.Order.OrderId) .Select(c => new CashOrderDetail { CashOrderId = c.CashOrderId, CashOrderItemId = c.CashOrderItemId, CustodianNumber = c.CustodianNumber, Price = c.Price, ProductNumber = c.ProductNumber, Quantity = c.Quantity, SupplierNumber = c.SupplierNumber, Description = c.Description, SupplierName = c.SupplierName, Weight = (int)c.Weight, OrderItemTotal = c.OrderItemTotal }) .ToList(); model.Products = ProductCollection.GetAllProducts(); for (int i = 0; i < model.Products.Products.Count; i++) { CashOrderDetail qty = model.OrderDetails .Where(c => c.ProductNumber == model.Products.Products[i].ProductNumber && c.SupplierNumber == model.Products.Products[i].SupplierNumber) .FirstOrDefault(); if (qty != null) { model.Products.Products[i].CashQuantity = qty.Quantity; } else { model.Products.Products[i].CashQuantity = 0; } } model.Custodians = db.Custodians.Select (c => new SelectListItem { Text = c.CustodianName, Value = c.CustodianNumber.ToString() }).ToList(); } return(model); }