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