public int insert(Order order)
{
using(var db = new CustomDBContext())
{
try
{
DBOrder dbOrder = db.Orders.Add(new DBOrder()
{
ID = 0,
customerID = order.customer.ID,
lines = order.lines.Select(line => new DBOrderLine()
{
ID = 0,
itemID = line.item.ID,
quantity = line.quantity,
orderID = 0
}).ToList(),
orderTime = order.orderTime,
sentTime = order.sentTime
});
db.SaveChanges();
return dbOrder.ID;
}
catch (Exception e)
{
Debug.Write("Failed to insert data. Error: " + e.StackTrace.ToString());
return -1;
}
}
}
public Order selectOne(int ID)
{
using (var db = new CustomDBContext())
{
try
{
DBOrder dbOrder = db.Orders.Find(ID);
Order order = new Order()
{
ID = dbOrder.ID,
customer = new Customer()
{
ID = dbOrder.customer.ID,
firstName = dbOrder.customer.firstName,
lastName = dbOrder.customer.lastName,
email = dbOrder.customer.email,
password = dbOrder.customer.password,
adress = dbOrder.customer.adress,
zipCode = dbOrder.customer.zipCode,
area = dbOrder.customer.area.area
},
lines = dbOrder.lines.Select(line => new OrderLine()
{
ID = line.ID,
item = new Item()
{
ID = line.item.ID,
name = line.item.name,
country = line.item.country,
district = line.item.district,
year = line.item.year,
type = line.item.type,
price = line.item.price,
description = line.item.description,
stockCount = line.item.stockCount,
imgURL = line.item.imgURL
},
quantity = line.quantity
}).ToList(),
orderTime = dbOrder.orderTime,
sentTime = dbOrder.sentTime
};
if (order == null)
return null;
order.calculateTotalPrice();
return order;
}
catch (Exception e)
{
Debug.Write("Failed to read data. Error: " + e.StackTrace.ToString());
return null;
}
}
}
