/// <summary>
/// Updates an excisting order in the database
/// </summary>
/// <param name="order"></param>
public void UpdateOrder(Order order)
{
using (var _context = new AalborgZooContainer())
{
var result = _context.OrderSet.SingleOrDefault(b => b.Id == order.Id);
if (result != null)
{
result.OrderLines = order.OrderLines;
result.DateOrdered = order.DateOrdered;
result.Note = order.Note;
result.OrderedByID = order.OrderedByID;
result.Status = order.Status;
result.ShoppingListId = order.ShoppingListId;
//Calls the database to save the changes
_context.SaveChanges();
}
else if (result == null)
{
throw new OrderDoesNotExistInDatabaseException();
}
}
}
/// <summary>
/// Adds a not yet excisting order to the database
/// </summary>
/// <param name="order"></param>
public Order AddOrder(Order order)
{
using (var _context = new AalborgZooContainer())
{
var temp1 = order.OrderLines.First().ProductVersion.Id;
Order tempOrder = new Order()
{
OrderedByID = order.OrderedByID,
DateCreated = order.DateCreated,
DepartmentID = order.DepartmentID,
Status = order.Status,
Note = order.Note,
DateOrdered = order.DateOrdered,
Id = order.Id,
DateCancelled = order.DateCancelled,
DeletedByID = order.DeletedByID,
OrderLines = new Collection <OrderLine>(),
ShoppingList = null,
ShoppingListId = null
};
List <OrderLine> tempOrderLines = new List <OrderLine>();
foreach (OrderLine item in order.OrderLines)
{
_context.ProductVersionSet.Attach(item.ProductVersion);
_context.OrderLineSet.Add(item);
tempOrder.OrderLines.Add(item);
}
_context.OrderSet.Add(tempOrder);
_context.SaveChanges();
return(tempOrder);
}
}
public void Add(ShoppingList shoppingList)
{
using (var context = new AalborgZooContainer())
{
context.ShoppingListSet.Add(shoppingList);
context.SaveChanges();
}
}
public Department AddDepartment(Department department)
{
using (var db = new AalborgZooContainer())
{
Department departmentWithID = db.DepartmentSet.Add(department);
db.SaveChanges();
return(departmentWithID);
}
}
public Product AddProduct(Product product)
{
using (var _context = new AalborgZooContainer())
{
Product productWithKey = _context.ProductSet.Add(product);
_context.SaveChanges();
return(productWithKey);
}
}
public void MakeProduct(int employeeID, string name)
{
var db = new AalborgZooContainer();
Product newProduct = new Product()
{
DateCreated = DateTime.Now,
CreatedByID = employeeID,
Name = name
};
db.ProductSet.Add(newProduct);
db.SaveChanges();
}
/// <summary>
/// Opdates the product and thereby also the ProductVersions contained in the product objekt.
/// </summary>
/// <param name="product"></param>
public void UpdateProductVersionList(Product product)
{
using (var _context = new AalborgZooContainer())
{
//Finds the current product in the database.
Product Outdated = _context.ProductSet.SingleOrDefault(x => x.Id == product.Id);
if (Outdated != null)
{
//Replaces it with the new version.
Outdated = product;
_context.SaveChanges();
}
else
{
throw new ProductDoNotExistInDatabaseException(product.Name);
}
}
}
public ShoppingList AddToShoppingList(List <Order> orders, int shopperId)
{
ShoppingList shoppingList = new ShoppingList();
shoppingList.CreatedByID = shopperId;
shoppingList.Shopper = (Shopper)_contextForShopper.EmployeeSet.FirstOrDefault(x => x is Shopper && x.Id == shopperId);
shoppingList.DateCreated = DateTime.Now;
shoppingList.Orders = orders;
foreach (Order order in orders)
{
order.ShoppingList = shoppingList;
_contextForShopper.Entry(order).State = System.Data.Entity.EntityState.Modified;
}
_contextForShopper.SaveChanges();
_contextForShopper.ShoppingListSet.Add(shoppingList);
_contextForShopper.Dispose();
return(shoppingList);
}
