public CartPage()
{
InitializeComponent();
OrderDetailVM vm = new OrderDetailVM();
BindingContext = vm;
}
public async Task <IActionResult> CheckoutSubmitAsync(OrderDetailVM orderDetailVM)
{
if (!ModelState.IsValid)
{
return(Redirect("Checkout"));
}
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var listOrderItem = _getOrderItemsInSession(HttpContext);
if (listOrderItem == null)
{
return(Redirect("/Order"));
}
//
var fees = HttpContext.Session.GetString(PageHelper.KEY_FEE_SESSION);
orderDetailVM.Fees = fees;
orderDetailVM.UserId = userId;
orderDetailVM.OrderItems = listOrderItem;
var result = await _requestOrder.CreateAsync(orderDetailVM, listOrderItem);
// listCartItem
if (result == null)
{
Redirect("/Error");
}
return(View("~/Views/Home/Ordered.cshtml"));
}
// GET: /PendingOrder/ordersDetail/id
public ActionResult OrderDetails(int id, string status, string total, string date)
{
List <OrderDetailVM> DetailList = new List <OrderDetailVM>();
var details = dc.OrderDetails.Where(x => x.OrderID == id).ToList();
if (details != null)
{
foreach (var v in details)
{
OrderDetailVM Orderdetail = new OrderDetailVM();
Orderdetail.ItemId = (int)v.ItemID;
Orderdetail.ItemName = v.ItemName;
Orderdetail.VendorName = v.VendorName;
Orderdetail.Category = v.Category;
Orderdetail.Quanitity = (int)v.Quantity;
Orderdetail.Price = (decimal)v.Price;
Orderdetail.TotalAmount = (decimal)v.TotalAmount;
DetailList.Add(Orderdetail);
}
ViewData["OrderId"] = id;
ViewData["OrderStatus"] = status;
ViewData["OrderDate"] = date;
ViewData["GTotal"] = total;
return(View(DetailList));
}
return(View(DetailList));
}
//Step 2: Order Details
public ActionResult fillInOrderDetails(int orderId)
{
OrderDetailVM od = new OrderDetailVM();
var order = db.Orders.Find(orderId);
List <Product> products = new List <Product>();
od.Order = order;
od.OrderId = orderId;
var customer = db.Customers.Find(order.CustomerId);
foreach (Product p in db.Products)
{
var prodDetails = p.Description + p.ProductId + p.UnitPrice;
products.Add(p);
//od.ProductList.Add(p.Description);
}
od.OrderDetailsId = orderId;
od.ProductList = products;
od.Customer = customer;
db.SaveChanges();
return(View(od));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Order o = db.Orders.Find(id);
OrderDetailVM vm = new OrderDetailVM()
{
OrderID = o.OrderID,
OrderProducts = o.OrderDetails.Select(x => new OrderProductVM
{
Discount = x.Discount,
SalesPrice = x.Product.SalesPrice,
ProductName = x.Product.ProductName,
Quantity = x.Quantity,
SubTotal = x.SubTotal
}),
RecipientName = o.RecipientName,
RecipientPhone = o.RecipientPhone,
RecipientAddress = o.RecipientAddress
};
if (vm == null)
{
return(HttpNotFound());
}
return(View(vm));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Order o = db.Orders.Find(id);
OrderDetailVM vm = new OrderDetailVM()
{
OrderID = o.OrderID,
OrderProducts = o.OrderDetails.Select(x => new OrderProductVM
{
Discount = x.Discount,
SalesPrice = x.Product.SalesPrice,
ProductName = x.Product.ProductName,
Quantity = x.Quantity,
SubTotal = x.SubTotal
}),
RecipientName = o.RecipientName,
RecipientPhone = o.RecipientPhone,
RecipientAddress = o.RecipientAddress,
MemberName = o.Member.Name,
OrderDate = o.OrderDate,
TotalPrice = o.OrderDetails.Sum(y => y.SubTotal),
ShipperName = o.Shipper.ShipperName,
PaymentStatus = o.PaymentStatus,
PaymentMethod = o.Payment.PaymentMethod
};
if (vm == null)
{
return(HttpNotFound());
}
return(View(vm));
}
public ActionResult OrderDetail(string OrderNumber)
{
OrderDetailVM odvm = new OrderDetailVM();
odvm = op.SiparisDetay(OrderNumber);
return(View(odvm));
}
public PastOrderDetail(int cart_id, string order_type)
{
InitializeComponent();
_cart_id = cart_id;
_order_type = order_type;
ViewModel = new OrderDetailVM();
BindingContext = ViewModel;
}
public IActionResult Details(int id)
{
OrderVM = new OrderDetailVM()
{
OrderHeader = _unitOfWork.OrderHeader.GetFirstOrDefault(u => u.Id == id, includeProperties: "ApplicationUser"),
OrderDetails = _unitOfWork.OrderDetail.GetAll(u => u.OrderId == id, includeProperties: "Product")
};
return(View(OrderVM));
}
public ActionResult Sequences()
{
List <OrderDetail> sequences = new List <OrderDetail>();
List <Customer> customers = new List <Customer>();
using (var context = new MainContext())
{
foreach (var orderDetail in context.OrderDetails)
{
//get customer Name for last order
var ClientOrder = context.Orders.Where(c => c.OrderId == orderDetail.OrderId);
customers.Add(ClientOrder.Select(c => c.Customer).First());
var ClientSequence = context.OrderDetails.Where(c => c.OrderId == orderDetail.OrderId).First();
sequences.Add(ClientSequence);
}
}
SequenceViewModel seqVM = new SequenceViewModel();
foreach (var customer in customers)
{
var cId = customer.CustomerId;
var cName = customer.Name;
var cVM = new CustomerVM();
cVM.customerId = cId;
cVM.customerName = cName;
seqVM.Customer.Add(cVM);
}
foreach (var orderDetail in sequences)
{
var oId = orderDetail.OrderId;
var bPrefix = orderDetail.barcodePrefix;
var bStartSequence = orderDetail.startSequence;
var bSuffix = orderDetail.barcodeSuffix;
var bEndSequence = orderDetail.endSequence;
var odVM = new OrderDetailVM();
odVM.OrderId = oId;
odVM.barcodePrefix = bPrefix;
odVM.startSequence = bStartSequence;
odVM.barcodeSuffix = bSuffix;
odVM.endSequence = bEndSequence;
seqVM.OrderDetails.Add(odVM);
}
return(View(seqVM));
}
public async Task <IActionResult> Details(int id)
{
OrderVM = new OrderDetailVM()
{
OrderHeader = await _context.OrderHeaders.GetFirstOrDefault(u => u.Id == id,
includeProps : "MyUser"),
OrderDetails = await _context.OrderDetails.GetAll(o => o.OrderId == id, includeProps : "Product")
};
return(View(OrderVM));
}
public ActionResult AddItemsToOrder(int oid)
{
var order = db.Orders.Find(oid);
OrderDetailVM odVM = new OrderDetailVM();
odVM.OrderDetailsId = oid;
odVM.OrderId = oid;
return(View(odVM));
}
public ActionResult UpdateOrderDetail(int id)
{
OrderDetailVM ovm = new OrderDetailVM
{
OrderDetail = odRep.Find(id),
Orders = oRep.GetActives(),
Products = pRep.GetActives()
};
return(View(ovm));
}
public ActionResult AddOrderDetail()
{
OrderDetailVM odvm = new OrderDetailVM
{
OrderDetail = new OrderDetail(),
Orders = oRep.GetActives(),
Products = pRep.GetActives()
};
return(View(odvm));
}
public OrderDetailPage(int cart_id, string order_type)
{
InitializeComponent();
_cart_id = cart_id;
_order_type = order_type;
ViewModel = new OrderDetailVM();
BindingContext = ViewModel;
MessagingCenter.Subscribe <App>((App)Application.Current, "Closed", (sender) => {
GetOrderDeliveryDates();
});
}
// GET: OrderController/Details/5
/// <summary>
/// View the details of specific orders(lcoation,Customer,Total,producsts, quantity)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Details(int id)
{
Order o = _partsBL.GetOrderById(id);
OrderDetailVM od = new OrderDetailVM();
od.CustomerName = _partsBL.GetCustomerById(o.CustomerId).CustomerName;
od.LocationName = _partsBL.GetLocationById(o.LocationId).LocationName;
od.ProductName = _partsBL.GetProductById(o.ProductId).ProductName;
od.Quanity = o.Quantity;
od.Total = o.Total;
return(View(od));
}
public static OrderDetailVM ToDetailVM(this OrderDetailModel model)
{
var viewModel = new OrderDetailVM()
{
Id = model.Id,
Date = model.Date,
FullName = model.FullName,
OrderItems = model.OrderItems.Select(x => x.ToViewModel())
};
return(viewModel);
}
// GET: Manager/OrderDetail
public ActionResult OrderDetailList(int?page)
{
OrderDetailVM odvm = new OrderDetailVM
{
PagedOrderDetails = odRep.GetAll().ToPagedList(page ?? 1, 15)
};
if (true)
{
TempData["ordID"] = true;
}
return(View(odvm));
}
public IActionResult DetailOrder(long ID_ZAKAZ)
{
if (!User.Identity.IsAuthenticated)// если неавторизован то редирект на авторизацию
{
Uri location = new Uri($"{Request.Scheme}://{Request.Host}/Account/Login");
return(Redirect(location.AbsoluteUri));
}
OrderDetailVM VM = new OrderDetailVM(ID_ZAKAZ);
//Order order = Order.GetOrderSite(ID_ZAKAZ);
return(View(VM));
}
public ActionResult <OrderDetailVM> Create(OrderDetailVM orderDetailVM)
{
if (!ModelState.IsValid || orderDetailVM.UserId == null)
{
return(BadRequest());
}
var result = _orderSer.Add(orderDetailVM);
if (result == null)
{
return(Problem("Can't add new order"));
}
return(CreatedAtAction(nameof(Get), new { id = result.Id }, result));
}
public ActionResult fillInOrderDetails([Bind(Include = "OrderId,ProductId,Quantity,UnitPrice,Description,barcodePrefix,startSequence,endSequence,barcodeSuffix")] OrderDetailVM o)
{
if (ModelState.IsValid)
{
OrderDetail od = new OrderDetail();
var item = o.ProductId;
var description = (from p in db.Products where (p.ProductId == o.ProductId) select p.Description).FirstOrDefault();
var quantity = od.Quantity = o.Quantity;
var oid = od.OrderId = o.OrderId;
var orderDetailsId = oid = o.OrderDetailsId;
var price = (from p in db.Products where (p.ProductId == o.ProductId) select p.UnitPrice).FirstOrDefault();
//Barcode Sequence Data
var barcodePrefix = od.barcodePrefix;
var startSequence = od.startSequence;
var endSequence = od.startSequence + od.Quantity;
var barcodeSuffix = od.barcodeSuffix;
List <OrderDetail> items = new List <OrderDetail>();
od.UnitPrice = price;
od.ProductId = item;
od.Description = description;
od.Quantity = quantity;
od.OrderId = oid;
//od.OrderDetailsId = oid;
od.UnitPrice = price;
od.barcodePrefix = barcodePrefix;
od.barcodeSuffix = o.barcodeSuffix;
od.startSequence = o.startSequence;
od.endSequence = o.startSequence + quantity;
//db.OrderDetails.Add(od);
//db.SaveChanges();
}
decimal total = 0;
foreach (var item in db.OrderDetails.Where(d => d.OrderId == o.OrderId))
{
total += (item.UnitPrice * item.Quantity) * 115 / 100;
}
var updateTotal = o.Quantity * o.UnitPrice;
return(RedirectToAction("updateOrderTotal", new { amount = total, oid = o.OrderId }));
}
public async Task <IEnumerable <OrderVM> > GetAllOrders()
{
List <OrderVM> orders = new List <OrderVM>();
List <OrderDetailVM> orderDetails;
OrderVM o;
OrderDetailVM od;
var query = "select id,creation_date,`status`, complete_date,cancel_date from orders";
var query2 = "select id, id_order, product_id, quantity from order_detail where id_order = @OrderId";
var query3 = "select id,sku_number,description,creation_date,status, fn_getInventory(id) as quantity from products where id = @ProductId";
var objOrderstmp = await _connection.QueryAsync <Order>(query);
foreach (var objorder in objOrderstmp)
{
orderDetails = new List <OrderDetailVM>();
o = new OrderVM();
o.OrderId = objorder.id;
o.status_code = objorder.status;
o.creation_date = objorder.creation_date;
o.complete_date = objorder.complete_date;
o.cancel_date = objorder.cancel_date;
var details = await _connection.QueryAsync <OrderDetailVM>(query2, new { OrderId = o.OrderId });
foreach (var item in details)
{
od = new OrderDetailVM();
od.product_id = item.product_id;
od.quantity = item.quantity;
var products = await _connection.QueryFirstOrDefaultAsync <Products>(query3, new { ProductId = od.product_id });
od.SKuCode = products.sku_number;
od.description = products.description;
orderDetails.Add(od);
}
o.order_items = orderDetails;
orders.Add(o);
}
return(orders);
}
public ActionResult AddItemsToOrder(OrderDetailVM detailsVM)
{
if (ModelState.IsValid)
{
var itemToAdd = new OrderDetail();
var orderId = detailsVM.OrderId;
var orderDetailId = detailsVM.OrderDetailsId;
var itemId = detailsVM.Product.ProductId;
var itemQuantity = detailsVM.Quantity;
itemToAdd.OrderId = orderId;
itemToAdd.OrderDetailsId = orderDetailId;
itemToAdd.Product.ProductId = itemId;
itemToAdd.Quantity = itemQuantity;
db.SaveChanges();
}
return(View());
}
public ActionResult Edit(int id)
{
var order = db.Orders.Find(id);
var status = db.StatusOrders.ToList();
ViewBag.Status = status;
var oldOrderDetails = db.OrderDetails.Where(x => x.OrderId == id).ToList();
OrderDetailVM OrderDetail;
List <OrderDetailVM> listOrderDetail = new List <OrderDetailVM>();
double subTotal = 0;
foreach (var item in oldOrderDetails)
{
OrderDetail = new OrderDetailVM();
OrderDetail.Id = item.Id;
OrderDetail.ProductName = item.Product.ProductName;
OrderDetail.UnitPrice = item.UnitPrice - ((item.UnitPrice * item.DiscountRatio.Value) / 100);
OrderDetail.Quantity = item.Quantity;
OrderDetail.Color = item.ColorName;
OrderDetail.Size = item.SizeName;
listOrderDetail.Add(OrderDetail);
double Tien = OrderDetail.UnitPrice * OrderDetail.Quantity;
subTotal += Tien;
}
ViewBag.listOrderDetail = listOrderDetail;
ViewBag.SubTotal = (subTotal * 1.1).ToString();
int FindProId = oldOrderDetails[0].ProductId;
var colors = db.ProductColors.Where(x => x.ProductId == FindProId).ToList();
ViewBag.Colors = colors;
var sizes = db.ProductSizes.Where(x => x.ProductId == FindProId).ToList();
ViewBag.Sizes = sizes;
return(View(order));
}
public async Task <IList <OrderDetailVM> > getDetailOrder(Guid idcustomer)
{
//List<Guid> id = ctx.Order.Where(s => s.CustomerId == idcustomer).ToListAsync();
//List<OrderProductSize> list= ctx.OrderProductSize.Where(s=>s.OrderId==)
//List<OrderProductSize> list = new List<OrderProductSize>();
List <Guid> id = ctx.Order.Where(s => s.CustomerId == idcustomer).Select(s => s.OrderId).ToList();
List <OrderDetailVM> list = new List <OrderDetailVM>();
foreach (Guid i in id)
{
//
List <OrderProductSize> order = ctx.OrderProductSize.Where(s => s.OrderId == i).ToList();
Order listorder = await ctx.Order.Where(s => s.OrderId == i).FirstOrDefaultAsync();
foreach (OrderProductSize item in order)
{
OrderDetailVM orderdetail = new OrderDetailVM();
orderdetail.OrderId = item.OrderId;
orderdetail.CreatedDate = listorder.CreatedDate;
orderdetail.Name = ctx.Product.Where(s => s.ProductId == item.ProductId).Select(s => s.Name).FirstOrDefault();
orderdetail.ImageUrl = ctx.ProductColor.Where(s => s.ProductId == item.ProductId).Select(s => s.ImageUrl).FirstOrDefault();
orderdetail.Quantity = item.Quantity;
orderdetail.Price = item.Price;
orderdetail.TotalPrice = listorder.TotalPrice + listorder.DeliveryPrice;
orderdetail.StatusName = ctx.Status.Where(s => s.StatusId == listorder.StatusId).Select(s => s.Name).FirstOrDefault();
list.Add(orderdetail);
}
//orderdetail.OrderId = order.OrderId;
//orderdetail.CreatedDate = listorder.CreatedDate;
//orderdetail.Name = ctx.Product.Where(s => s.ProductId == order.ProductId).Select(s => s.Name).FirstOrDefault();
//orderdetail.ImageUrl = ctx.ProductColor.Where(s => s.ProductId == order.ProductId).Select(s => s.ImageUrl).FirstOrDefault();
//orderdetail.Quantity = order.Quantity;
//orderdetail.Price = order.Price;
//orderdetail.TotalPrice = listorder.TotalPrice;
//orderdetail.StatusName = ctx.Status.Where(s => s.StatusId == listorder.StatusId).Select(s => s.Name).FirstOrDefault();
//list.Add(orderdetail);
}
return(list);
}
public async Task <OrderVM> GetOrderById(int id)
{
List <OrderDetailVM> orderDetails = new List <OrderDetailVM>();
OrderVM o = new OrderVM();;
OrderDetailVM od;
var query = "select id,creation_date,`status`, complete_date,calcel_date from orders where id = @OrderId";
var query2 = "select id, id_order, product_id, quantity from order_detail where id_order = @OrderId";
var query3 = "select id,sku_number,description from products where id = @ProductId";
var objtmp = await _connection.QueryFirstOrDefaultAsync <Order>(query, new { OrderId = id });
o.OrderId = objtmp.id;
o.status_code = objtmp.status;
o.creation_date = objtmp.creation_date;
o.complete_date = objtmp.complete_date;
o.cancel_date = objtmp.cancel_date;
var details = await _connection.QueryAsync <OrderDetail>(query2, new { OrderId = o.OrderId });
foreach (var item in details)
{
od = new OrderDetailVM();
od.product_id = item.product_id;
od.quantity = item.quantity;
var products = await _connection.QueryFirstOrDefaultAsync <Products>(query3, new { ProductId = od.product_id });
od.SKuCode = products.sku_number;
od.description = products.description;
orderDetails.Add(od);
}
o.order_items = orderDetails;
return(o);
}
public ActionResult LookOrderDetails(int?id)
{
if (id == null)
{
return(RedirectToAction("Index", "Home"));
}
Order o = db.Orders.Find(id);
OrderDetailVM vm = new OrderDetailVM()
{
OrderID = o.OrderID,
OrderProducts = o.OrderDetails.Select(x => new OrderProductVM
{
Discount = x.Discount,
SalesPrice = x.Product.SalesPrice,
ProductName = x.Product.ProductName,
Quantity = x.Quantity,
SubTotal = x.SubTotal
}),
MemberID = o.MemberID,
RecipientName = o.RecipientName,
RecipientPhone = o.RecipientPhone,
RecipientAddress = o.RecipientAddress,
MemberName = o.Member.Name,
OrderDate = o.OrderDate,
TotalPrice = o.OrderDetails.Sum(y => y.SubTotal),
ShipperName = o.Shipper.ShipperName,
PaymentMethod = o.Payment.PaymentMethod,
PaymentStatus = o.PaymentStatus
};
if (vm == null)
{
return(RedirectToAction("Index", "Home"));
}
return(View(vm));
}
public async Task <OrderDetailVM> CreateAsync(OrderDetailVM orderDetailVM, List <OrderItemVM> listItem)
{
return(await _request.PostAsync <OrderDetailVM>(routeName, orderDetailVM));
}
public ActionResult AddItemToOrderDetail(OrderDetailVM od)
{
try
{
var validSequence = false;
//Barcode Sequence Data
var barcodePrefix = od.barcodePrefix;
var startSequence = od.startSequence;
//var endSequence = od.startSequence + od.Quantity;
var barcodeSuffix = od.barcodeSuffix ?? "";
int ss = Int32.Parse(startSequence);
String.Format("sequenceLen");
//Barcode Sequence Validation - Used to check existing barcodes sequences to prevent duplication errors ---
var customerId = db.Orders.FirstOrDefault(c => c.OrderId == od.OrderId).CustomerId;
List <Order> listOfOrders = new List <Order>();
foreach (var order in db.Orders.Where(i => i.CustomerId == customerId))
{
listOfOrders.Add(order);
}
foreach (var order in listOfOrders)
{
var detail = db.OrderDetails.Find(order.OrderId);
if (detail != null)
{
int existingSequece = Int32.Parse(detail.endSequence);
if (ss > existingSequece)
{
validSequence = true;
}
}
else
{
validSequence = true;
}
}
if (validSequence == true)
{
OrderDetail o = new OrderDetail();
var item = od.ProductId;
var description = (from p in db.Products where (p.ProductId == item) select p.Description).First();
var quantity = od.Quantity;
var oid = od.OrderId;
var orderDetailsId = oid;
var price = (from p in db.Products where (p.ProductId == item) select p.UnitPrice).First();
int es = ss + quantity;
List <OrderDetail> items = new List <OrderDetail>();
od.UnitPrice = price;
o.ProductId = item;
o.Description = description;
o.Quantity = quantity;
o.OrderId = oid;
o.OrderDetailsId = oid;
o.UnitPrice = price;
o.barcodePrefix = barcodePrefix;
o.barcodeSuffix = o.barcodeSuffix;
o.startSequence = startSequence;
var sequenceSize = new string('0', startSequence.Length);
o.endSequence = es.ToString(sequenceSize);
db.OrderDetails.Add(o);
db.SaveChanges();
}
return(View());
}
catch (Exception)
{
throw;
}
}
public CheckoutPage()
{
InitializeComponent();
BindingContext = new OrderDetailVM();
}
