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