public static Order FindCheckedOutOrder(Guid orderID)
{
//load the order
var order = Order.SingleOrDefault(x => x.OrderID == orderID);
//if it's not null, pull the products
if (order != null)
{
KonaDB db = new KonaDB();
var qry = (from p in db.Products
join oi in db.OrderItems on p.SKU equals oi.SKU
where oi.OrderID == orderID
select p).ToList();
foreach (var item in order.OrderItems)
{
item.Item = qry.SingleOrDefault(x => x.SKU == item.SKU);
}
//get the addresses
order.ShippingAddress = Address.SingleOrDefault(x => x.AddressID == order.ShippingAddressID);
order.BillingAddress = Address.SingleOrDefault(x => x.AddressID == order.BillingAddressID);
}
return(order);
}
public static Order ReadyOrderForPayment(string userName, PaymentMethod payment)
{
Order result = Order.SingleOrDefault(x => x.UserName == userName && x.OrderStatusID == (int)OrderStatus.NotCheckedOut);
if (result == null)
{
throw new InvalidOperationException("There is no Order in queue for " + userName);
}
result.PaymentMethod = payment;
return(result);
}
public static Order FindCurrentOrCreateNew(string userName)
{
var db = new KonaDB();
Order result = Order.SingleOrDefault(x => x.UserName == userName && x.OrderStatusID == (int)OrderStatus.NotCheckedOut);
if (result == null)
{
result = new Order();
result.OrderID = Guid.NewGuid();
result.UserName = userName;
result.UserLanguageCode = System.Globalization.CultureInfo.CurrentCulture.TwoLetterISOLanguageName;
result.OrderStatusID = (int)OrderStatus.NotCheckedOut;
result.Add("");
}
else
{
result.ShippingAddress = Address.SingleOrDefault(x => x.AddressID == result.ShippingAddressID);
result.BillingAddress = Address.SingleOrDefault(x => x.AddressID == result.BillingAddressID);
}
return(result);
}
