public void SetProductIsTakenAside(int orderItemId, int productId, bool isTakenAside, ref string errorMessage) { try { var orderItemSetting = _context.AOOrderItemSettings.Where(o => o.OrderItemId == orderItemId).FirstOrDefault(); if (orderItemSetting == null) { orderItemSetting = new AOOrderItemSetting() { OrderItemId = orderItemId, IsTakenAside = isTakenAside, IsTakenAsideDate = DateTime.Now, IsOrdered = false, IsOrderedDate = Convert.ToDateTime("01-01-1970") }; _context.Add(orderItemSetting); } else { orderItemSetting.IsTakenAside = isTakenAside; orderItemSetting.IsTakenAsideDate = DateTime.Now; _context.Update(orderItemSetting); } _context.SaveChanges(); } catch (Exception ex) { errorMessage = ex.Message; _logger.Error(ex.Message, ex); } }
/// <summary> /// Insert Cart Items data /// </summary> /// <param name="cartMasterId"></param> /// <param name="cartItem"></param> /// <returns></returns> public bool InsertCartItems(int cartMasterId, InsertCartDetails cartItem) { try { if (cartMasterId == 0) { cartMasterId = (from cartMaster in _orderManagementContext.TblCartMaster where cartMaster.TblCustomerId == cartItem.CustomerId && cartMaster.TblRestaurantId == cartItem.RestaurantId && cartMaster.IsActive select cartMaster.Id).FirstOrDefault(); } if (cartMasterId == 0) { throw new Exception("Error adding cart item. Try again later"); } bool duplicateMenuCheck = (from cartItems in _orderManagementContext.TblCartItems where cartItems.TblCartMasterId == cartMasterId && cartItems.TblMenuId == cartItem.MenuId select cartItems.Id).Count() > 0; if (duplicateMenuCheck) { throw new Exception($"Menu {cartItem.MenuId} for Restaurant {cartItem.RestaurantId} already exists! Try updating the menu using the " + $"update endpoint."); } TblCartItems tblCartItems = new TblCartItems() { TblCartMasterId = cartMasterId, TblMenuId = cartItem.MenuId, Quantity = cartItem.Quantity, IsItemAvailable = true, RecordTimeStampCreated = DateTime.Now }; _orderManagementContext.Add(tblCartItems); return(SaveChanges()); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> Create([Bind("OrderID,FirstName,LastName,City,State,DOB,RowVersion")] Order order) { if (ModelState.IsValid) { _context.Add(order); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(order)); }
public virtual T Add(T entity) { return(_context .Add(entity) .Entity); }