public IActionResult UploadProduct(ProductsViewModel model) { if (ModelState.IsValid) { string uniqueFileName = null; if (model.Image != null) { string uploadsFolder = Path.Combine(_hostingEnvironment.WebRootPath, "Images"); //if the same image is uploaded twice, the previous image is erased. So, to ensure uniqueness, we append our filename with a guid. uniqueFileName = Guid.NewGuid().ToString() + "_" + model.Image.FileName; string filePath = Path.Combine(uploadsFolder, uniqueFileName); //to copy the incoming image from the browser to the Images folder in wwwroot. model.Image.CopyTo(new FileStream(filePath, FileMode.Create)); } Products product = new Products(); product.ProductName = model.ProductName; product.Category = model.Category; product.Supplier = model.Supplier; product.ProductDescription = model.ProductDescription; product.AvailableUnits = model.AvailableUnits; product.Price = model.Price; product.ImageData = uniqueFileName; _context.Productss.Add(product); _context.SaveChanges(); return(View(model)); } return(View()); }
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); } }
public void Add(params T[] items) { foreach (T item in items) { _context.Entry(item).State = Microsoft.EntityFrameworkCore.EntityState.Added; } _context.SaveChanges(); }
public IActionResult RegisterUser(Users user) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } _context.Userss.Add(user); _context.SaveChanges(); return(RedirectToAction("Login", "Accounts")); }
public int PlaceOrder(TblFoodOrder OrderedFoodDetails) { try { _context.TblFoodOrder.Add(OrderedFoodDetails); _context.SaveChanges(); return(OrderedFoodDetails.Id); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IActionResult Checkout(OrderViewModel vm) { if (ModelState.IsValid) { string session = HttpContext.User.Identity.Name; Users usr = _context.Userss.Where(a => a.EmailID.Equals(session)).FirstOrDefault(); //Entering values into the OrderDetails database string uniqueID = Guid.NewGuid().ToString(); List <ShoppingCartItem> currentcart = _shoppingCart.RetrieveUserCart(usr.UserId); foreach (var item in currentcart) { OrderDetails details = new OrderDetails { SessionID = session, OrderDetailID = uniqueID, ProductId = item.ProductId, UserName = (usr.FirstName + usr.LastName), NumberOfUnits = item.NumberOfUnits, Price = item.Price }; _context.OrderDetailss.Add(details); _context.SaveChanges(); } //Entering values into the Order table using view model Order order = new Order(); order.SessionID = session; order.OrderDetailID = uniqueID; order.UserID = usr.UserId; order.FirstName = vm.FirstName; order.LastName = vm.LastName; order.AddressLine1 = vm.AddressLine1; order.AddressLine2 = vm.AddressLine2; order.ZipCode = vm.ZipCode; order.State = vm.State; order.Country = vm.Country; order.PhoneNumber = vm.PhoneNumber; order.Email = vm.Email; order.OrderTotal = _shoppingCart.GetShoppingCartTotal(usr.UserId); order.TimeOfOrder = DateTime.Now; _context.Orderss.Add(order); _context.SaveChanges(); _shoppingCart.ClearCart(usr.UserId); return(RedirectToAction("CheckOutComplete")); } return(View()); }
public int ChangeQuantity(int reOrderItemId, int quantity) { AOReOrderItem reOrderItem = _context.AOReOrderItems.Where(r => r.Id == reOrderItemId).FirstOrDefault(); if (reOrderItem == null) { throw new ArgumentException("No AOReOrderItem found with id: " + reOrderItemId); } reOrderItem.Quantity += quantity; // When negative we decrease _context.Update(reOrderItem); _context.SaveChanges(); return(reOrderItem.Quantity); }
public Order.Domain.Model.Order AddAsync(Order.Domain.Model.Order order) { var entity = _context.Orders.Add(order).Entity; _context.SaveChanges(); return(entity); }
public bool BookYourTable(TblTableOrder tblTableOrder) { int?paymentId = null; if (tblTableOrder != null) { tblTableOrder.TblOrderStatusId = 1; tblTableOrder.TblPaymentTypeId = 4; tblTableOrder.UserCreated = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1; tblTableOrder.UserModified = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1; tblTableOrder.ToDate = tblTableOrder.FromDate; _orderManagementContext.Set <TblTableOrder>().Add(tblTableOrder); _orderManagementContext.SaveChanges(); return(true); } return(false); }
/// <summary> /// Updates IsItemsAvailable to false for all rows in cart items having the provided restaurantId & menuId /// </summary> /// <param name="restaurantId"></param> /// <param name="menuId"></param> /// <returns></returns> public bool UpdateCartItemsForOutOfStock(int restaurantId, int?menuId) { try { List <TblCartItems> tblCartItems = (from cartMaster in _orderManagementContext.TblCartMaster join cartItems in _orderManagementContext.TblCartItems on cartMaster.Id equals cartItems.TblCartMasterId where cartMaster.TblRestaurantId == restaurantId && cartMaster.IsActive && cartItems.TblMenuId == menuId select cartItems).ToList(); foreach (var item in tblCartItems) { item.IsItemAvailable = false; _orderManagementContext.SaveChanges(); } return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }
public int MakePaymentForOrder(TblOrderPayment orderPaymentDetails) { _context.TblOrderPayment.Add(orderPaymentDetails); _context.SaveChanges(); return(orderPaymentDetails.Id); }
public int AddToCart(TblFoodCart foodCartDetails) { _context.TblFoodCart.Add(foodCartDetails); _context.SaveChanges(); return(foodCartDetails.Id); }
public int PlaceOrder(TblFoodOrder OrderedFoodDetails) { _context.TblFoodOrder.Add(OrderedFoodDetails); _context.SaveChanges(); return(OrderedFoodDetails.Id); }
public bool SaveAll() { return(_ctx.SaveChanges() > 0); }
public int Complete() { return(_context.SaveChanges()); }
public int AddCart(TblCart tblcart) { if (tblcart != null) { List <TblCart> cart = _context.TblCart.Where(ca => ca.TblCustomerID == tblcart.TblCustomerID).ToList <TblCart>(); if (cart.Count() > 0) { foreach (var item in cart) { if (tblcart.TblRestaurantID != item.TblRestaurantID) { _context.TblCart.RemoveRange(_context.TblCart.Where(c => c.TblCustomerID == tblcart.TblCustomerID)); tblcart.status = true; tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; _context.Set <TblCart>().Add(tblcart); _context.SaveChanges(); return(1); } if (tblcart.TblMenuID == item.TblMenuID) { item.TblCustomerID = tblcart.TblCustomerID; item.TblRestaurantID = tblcart.TblRestaurantID; item.TblMenuID = tblcart.TblMenuID; item.Price = tblcart.Price; item.Quantity = tblcart.Quantity; item.status = tblcart.status; item.RecordTimeStampCreated = DateTime.Now; item.offer = tblcart.offer; item.RecordTimeStamp = DateTime.Now; _context.SaveChanges(); return(1); } if (tblcart.TblRestaurantID == item.TblRestaurantID && tblcart.TblMenuID != item.TblMenuID) { tblcart.status = true; tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; _context.Set <TblCart>().Add(tblcart); _context.SaveChanges(); return(1); } } } else { tblcart.status = true; tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; _context.Set <TblCart>().Add(tblcart); _context.SaveChanges(); return(1); } //if (cart != null) //{ // if (cart.TblRestaurantID != tblcart.TblRestaurantID ) // { // _context.TblCart.RemoveRange(_context.TblCart.Where(c => c.TblCustomerID == tblcart.TblCustomerID)); // //List<TblCart> removecartlist = _context.TblCart.Where(d => d.TblCustomerID == tblcart.TblCustomerID).ToList<TblCart>(); // //_context.Remove(removecartlist); // //_context.SaveChanges(); // tblcart.status = true; // tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // _context.Set<TblCart>().Add(tblcart); // _context.SaveChanges(); // return 1; // } // else if (cart.TblRestaurantID == tblcart.TblRestaurantID && cart.TblMenuID == tblcart.TblMenuID) // { // cart.TblCustomerID = tblcart.TblCustomerID; // cart.TblRestaurantID = tblcart.TblRestaurantID; // cart.TblMenuID = tblcart.TblMenuID; // cart.Price = tblcart.Price; // cart.Quantity = tblcart.Quantity; // cart.status = tblcart.status; // cart.RecordTimeStampCreated = DateTime.Now; // cart.offer = tblcart.offer; // cart.RecordTimeStamp = DateTime.Now; // _context.SaveChanges(); // return 1; // } // else // { // tblcart.status = true; // tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // _context.Set<TblCart>().Add(tblcart); // _context.SaveChanges(); // return 1; // } //} //else //{ // tblcart.status = true; // tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // _context.Set<TblCart>().Add(tblcart); // _context.SaveChanges(); // return 1; //} } return(0); }
public void Commit() { _context.SaveChanges(); }
private void UpdateItem(OrderItem orderItem, Domain.AOReOrderItem reOrderItem) { reOrderItem.Quantity += orderItem.Quantity; _context.AOReOrderItems.Update(reOrderItem); _context.SaveChanges(); }
/// <summary> /// Save all changes to the database. /// Additionaly, we can implement UnitOfWork design pattern /// to enhance this example and coordinate database changes from one place. /// </summary> public void SaveChanges() { _context.SaveChanges(); }