/// <summary> /// Make OrderViewModel /// </summary> /// <param name="cartList">List of product</param> /// <param name="customerId">The ID of the customer in DB</param> /// <param name="customerInput">The new customer info</param> /// <returns></returns> public OrderViewModel MakeOrderViewModel(List<CartViewModel> cartList, int? customerId, CustomerViewModel customerInput) { OrderViewModel result = new OrderViewModel(); // Create new order Order order = new Order(); if (customerId != null && customerInput == null) { order.CustomerUserId = customerId; //Add info for OrderView //Customer info Customer customer = db.Customers.FirstOrDefault(m => m.UserId == customerId && m.IsActive); if (customer != null) { result.OrderPersonName = customer.User.Fullname; result.OrderPersonAddress = customer.CustomerAddress; result.OrderPersonPhoneNumber = customer.CustomerPhoneNumber; result.OrderPersonTaxCode = customer.TaxCode; result.IsGuest = false; result.IsLoyal = customer.IsLoyal; } } else if (customerId == null && customerInput != null) { order.CustomerUserId = 0; //Add new customer info for OrderView //Customer info result.OrderPersonName = customerInput.CustomerName; result.OrderPersonAddress = customerInput.CustomerAddress; result.OrderPersonPhoneNumber = customerInput.CustomerPhoneNumber; result.OrderPersonTaxCode = customerInput.CustomerTaxCode; result.IsGuest = true; result.IsLoyal = false; } // Temp var for total amount int totalAmount = 0; // Taemp var for total quantity int totalQuantity = 0; // Creat OrderItemViewModel List and MaterialViewModelList List<OrderItem> orderItemList = new List<OrderItem>(); List<MaterialViewModel> materialViewModelList = new List<MaterialViewModel>(); foreach (CartViewModel cartViewModel in cartList) { if (cartViewModel.Quantity != 0) { //Create OrderItem and add to list OrderItem orderItem = new OrderItem(); Product product = db.Products.FirstOrDefault(m => m.ProductId == cartViewModel.ProductId); orderItem.Product = product; orderItem.Quantity = cartViewModel.Quantity; orderItem.RealPrice = cartViewModel.RealPrice; orderItem.Amount = cartViewModel.Quantity * cartViewModel.RealPrice; orderItemList.Add(orderItem); totalAmount += cartViewModel.Quantity * cartViewModel.RealPrice; totalQuantity += cartViewModel.Quantity; //Create MaterialViewModel and add to list // Get Product in DB if (product != null) { foreach (Recipe recipe in product.Recipes) { if (materialViewModelList.Count == 0) { MaterialViewModel materialViewModel = new MaterialViewModel(); // Get each product material and multiply with quantity materialViewModel.ProductMaterialId = recipe.ProductMaterialId; materialViewModel.ProductMaterialName = recipe.ProductMaterial.ProductMaterialName; materialViewModel.NeedQuantity = (int)Math.Floor(recipe.RecipeQuantity * cartViewModel.Quantity); materialViewModel.StorageQuantity = recipe.ProductMaterial.CurrentQuantity; // Add into MaterialViewModelList materialViewModelList.Add(materialViewModel); } else { bool check = true; foreach (MaterialViewModel materialViewModel in materialViewModelList) { if (materialViewModel.ProductMaterialId == recipe.ProductMaterialId) { materialViewModel.NeedQuantity += (int)Math.Floor(recipe.RecipeQuantity * cartViewModel.Quantity); check = false; } } if (check) { MaterialViewModel materialViewModel = new MaterialViewModel(); // Get each product material and multiply with quantity materialViewModel.ProductMaterialId = recipe.ProductMaterialId; materialViewModel.ProductMaterialName = recipe.ProductMaterial.ProductMaterialName; materialViewModel.NeedQuantity = (int)Math.Floor(recipe.RecipeQuantity * cartViewModel.Quantity); materialViewModel.StorageQuantity = recipe.ProductMaterial.CurrentQuantity; // Add into MaterialViewModelList materialViewModelList.Add(materialViewModel); } } } } } } // Complete attribute in order //Check enough material for order result.IsEnoughMaterial = true; foreach (MaterialViewModel materialViewModel in materialViewModelList) { if (materialViewModel.NeedQuantity > materialViewModel.StorageQuantity) { materialViewModel.IsEnough = false; result.IsEnoughMaterial = false; } else { materialViewModel.IsEnough = true; } } int discountAmount = 0; DiscountByQuantity discountByQuantity = db.DiscountByQuantities.FirstOrDefault( m => m.QuantityFrom <= totalQuantity && m.QuantityTo >= totalQuantity); if (discountByQuantity != null) { discountAmount = totalAmount * discountByQuantity.DiscountValue / 100; } int totalTax = 0; TaxRate taxRate = db.TaxRates.FirstOrDefault( m => m.TaxType.Abbreviation.Equals("GTGT") && m.BeginDate <= DateTime.Now && m.EndDate >= DateTime.Now); if (taxRate != null) { totalTax = (totalAmount - discountAmount) * taxRate.TaxRateValue / 100; } order.Amount = totalAmount; order.DiscountAmount = discountAmount; order.TaxAmount = totalTax; order.OrderItems = orderItemList; result.Order = order; result.MaterialList = materialViewModelList; // Calculate the Material cost List<InputMaterialViewModel> inputMaterialList = GetInputMaterialList(materialViewModelList); result.MaterialCost = GetMaterialCost(inputMaterialList); return result; }
public bool OrderProduct(string orderTime, DateTime planDeliveryDate, int Amount, int taxAmount, int discount, int cusUserId, List<CustomerCartViewModel> cart, string Note) { DbContextTransaction contextTransaction = db.Database.BeginTransaction(); Order order = new Order(); order.OrderCode = orderTime; order.CreateTime = DateTime.Now; order.PlanDeliveryTime = planDeliveryDate; order.DepositAmount = 0; order.IsStaffEdit = false; order.CustomerEditingFlag = false; order.OrderStatus = 0; order.Amount = Amount; order.TaxAmount = taxAmount; order.DiscountAmount = discount; order.CustomerUserId = cusUserId; order.OrderNote = Note; db.Orders.Add(order); db.SaveChanges(); order.OrderCode = CreateOrderCode(orderTime, order.OrderId); //string orderNumber = order.OrderId.ToString().PadLeft(4, '0'); //order.OrderCode = String.Format("{0}{1}{2}", 'O', orderTime, orderNumber); db.SaveChanges(); foreach (var item in cart) { OrderItem orderDetail = new OrderItem(); orderDetail.OrderId = order.OrderId; orderDetail.ProductId = item.ProductId; orderDetail.Quantity = item.Quantity; orderDetail.RealPrice = item.Price; orderDetail.Amount = item.Total; db.OrderItems.Add(orderDetail); } db.SaveChanges(); try { contextTransaction.Commit(); } catch (Exception) { contextTransaction.Rollback(); } finally { contextTransaction.Dispose(); } return true; }
public bool EditOrder(int orderId, DateTime planDeliveryDate, int Amount, int taxAmount, int discount, int cusUserId, List<CustomerCartViewModel> cart, string Note) { DbContextTransaction contextTransaction = db.Database.BeginTransaction(); Order order = db.Orders.Find(orderId); if (order == null) { return false; } order.PlanDeliveryTime = planDeliveryDate; order.Amount = Amount; order.TaxAmount = taxAmount; order.DiscountAmount = discount; order.CustomerUserId = cusUserId; order.OrderNote = Note; db.SaveChanges(); List<OrderItem> orderItem = db.OrderItems.Where(n => n.OrderId == order.OrderId).ToList(); for (int i = 0; i < orderItem.Count; i++) { db.OrderItems.Remove(orderItem[i]); } foreach (var item in cart) { OrderItem orderDetail = new OrderItem(); orderDetail.OrderId = order.OrderId; orderDetail.ProductId = item.ProductId; orderDetail.Quantity = item.Quantity; orderDetail.RealPrice = item.Price; orderDetail.Amount = item.Total; db.OrderItems.Add(orderDetail); } db.SaveChanges(); try { contextTransaction.Commit(); } catch (Exception) { contextTransaction.Rollback(); } finally { contextTransaction.Dispose(); } return true; }
public bool GuestOrderProduct(string orderTime, DateTime planDeliveryDate, int Amount, int taxAmount, int discount, List<CustomerCartViewModel> cart, string sName, string sPhone, string sAddress, string sEmail, string Note) { DbContextTransaction contextTransaction = db.Database.BeginTransaction(); Order order = new Order(); order.OrderCode = orderTime; order.CreateTime = DateTime.Now; order.PlanDeliveryTime = planDeliveryDate; order.DepositAmount = 0; order.IsStaffEdit = false; order.CustomerEditingFlag = false; order.OrderStatus = 0; order.Amount = Amount; order.TaxAmount = taxAmount; order.DiscountAmount = discount; order.OrderNote = Note; GuestInfo guestInfo = new GuestInfo(); guestInfo.GuestInfoName = sName; guestInfo.GuestInfoPhone = sPhone; guestInfo.GuestInfoAddress = sAddress; guestInfo.GuestInfoEmail = sEmail; db.GuestInfoes.Add(guestInfo); db.SaveChanges(); order.GuestInfoId = guestInfo.GuestInfoId; db.Orders.Add(order); db.SaveChanges(); order.OrderCode = CreateOrderCode(orderTime, order.OrderId); db.SaveChanges(); foreach (var item in cart) { OrderItem orderDetail = new OrderItem(); orderDetail.OrderId = order.OrderId; orderDetail.ProductId = item.ProductId; orderDetail.Quantity = item.Quantity; orderDetail.RealPrice = item.Price; orderDetail.Amount = item.Total; db.OrderItems.Add(orderDetail); } db.SaveChanges(); try { contextTransaction.Commit(); } catch (Exception) { contextTransaction.Rollback(); } finally { contextTransaction.Dispose(); } return true; }