public void AddItemsToOrder(ItemsToOrder toAdd)
{
using (PoolContext db = new PoolContext())
{
db.ItemsToOrders.AddObject(toAdd);
db.SaveChanges();
}
}
public void AddItem(Item itToAdd)
{
using (PoolContext db = new PoolContext())
{
db.Items.AddObject(itToAdd);
db.SaveChanges();
}
}
public void AddOrder(Order orderToAdd)
{
using (PoolContext db = new PoolContext())
{
db.Orders.AddObject(orderToAdd);
db.SaveChanges();
}
}
public void AddItems(List <Item> m_lstTempItems)
{
using (PoolContext db = new PoolContext())
{
foreach (Item item in m_lstTempItems)
{
db.Items.AddObject(item);
db.SaveChanges();
}
}
}
public void DeleteOrder(Order orderToDelete)
{
using (PoolContext db = new PoolContext())
{
// Getting the item with given id
Order toDelete =
db.Orders.First(order => order.OrderId == orderToDelete.OrderId);
db.Orders.DeleteObject(toDelete);
db.SaveChanges();
}
}
public void DeleteItem(Item itToDelete)
{
using (PoolContext db = new PoolContext())
{
// Getting the item with given id
Item toDelete =
db.Items.First(item => item.ItemId == itToDelete.ItemId);
db.Items.DeleteObject(toDelete);
db.SaveChanges();
}
}
/// <summary>
/// Save safely data to db
/// </summary>
/// <param name="db"></param>
private void SafeSave(PoolContext db)
{
try
{
db.SaveChanges();
}
catch (Exception ex)
{
// TODO: write to log
throw new Exception("שגיאה ארעה בשמירת הנתונים", ex);
}
}
public void AddOrder(Order orderToAdd)
{
using (PoolContext db = new PoolContext())
{
foreach (ItemsToOrder item in orderToAdd.ItemsToOrder)
{
item.Item = null;
}
db.Orders.AddObject(orderToAdd);
db.SaveChanges();
}
}
public void UpdateItem(Item itUpdated)
{
using (PoolContext db = new PoolContext())
{
// Getting the item with given id
Item toUdpate =
db.Items.First(item => item.ItemId == itUpdated.ItemId);
// Update the detaild
toUdpate.Name = itUpdated.Name;
toUdpate.Price = itUpdated.Price;
// Save changes
db.SaveChanges();
}
}
public void UpdateOrder(Order orderToUpdate)
{
using (PoolContext db = new PoolContext())
{
// Getting the item with given id
Order toUpdate =
db.Orders.Include("ItemsToOrder.Item").First(order => order.OrderId == orderToUpdate.OrderId);
toUpdate.Date = orderToUpdate.Date;
toUpdate.GameHoursTime = orderToUpdate.GameHoursTime;
// Compare the list of items to order
int nIndex = 0;
List <int> toDeleteIndexes = new List <int>();
foreach (ItemsToOrder current1 in toUpdate.ItemsToOrder)
{
bool bIsStillExists = false;
// Checking it exists in the update list
foreach (ItemsToOrder current2 in orderToUpdate.ItemsToOrder)
{
if ((current1.ItemId == current2.ItemId) &&
(current1.OrderId == current2.OrderId))
{
current1.Amount = current2.Amount;
bIsStillExists = true;
break;
}
}
if (!bIsStillExists)
{
toDeleteIndexes.Add(nIndex);
}
++nIndex;
}
// Delete all the not existsing elements
foreach (int nCurrentIndex in toDeleteIndexes)
{
toUpdate.ItemsToOrder.RemoveAt(nCurrentIndex);
}
List <ItemsToOrder> lstToAdd = new List <ItemsToOrder>();
foreach (ItemsToOrder current1 in orderToUpdate.ItemsToOrder)
{
bool bIsNewElement = true;
// Checking it exists in the update list
foreach (ItemsToOrder current2 in toUpdate.ItemsToOrder)
{
if ((current1.ItemId == current2.ItemId) &&
(current1.OrderId == current2.OrderId))
{
current1.Amount = current2.Amount;
bIsNewElement = false;
break;
}
}
if (bIsNewElement)
{
lstToAdd.Add(current1);
}
}
// Adding all the new elements
foreach (ItemsToOrder currentToAdd in lstToAdd)
{
toUpdate.ItemsToOrder.Add(currentToAdd);
}
db.SaveChanges();
}
}
