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