public void GetOrderDetailTest() { //Arrange var options = new DbContextOptionsBuilder <StoreAppContext>() .UseInMemoryDatabase(databaseName: "GetOrderDetailTest") .Options; //Act using (var db = new StoreAppContext(options)) { Store location = new Store { Location = "Maryland" }; db.Add(location); db.SaveChanges(); Customer customer = new Customer { FirstName = "Michael", LastName = "Hall", UserName = "******", Password = "******" }; db.Add(customer); db.SaveChanges(); Product product = new Product { StoreId = 1, ProductName = "bar", Inventory = 5, Price = 10 }; db.Add(product); db.SaveChanges(); Order order = new Order { CustomerId = 1, ProductId = 1, Quantity = 3, }; db.Add(order); db.SaveChanges(); } //Assert using (var context = new StoreAppContext(options)) { var repo = new OrderRepo(); var orderTest = repo.GetOrderDetails(context, 1); Assert.Equal(1, orderTest.Id); } }
public void GetOrdersTest() { //Arrange var options = new DbContextOptionsBuilder <StoreAppContext>() .UseInMemoryDatabase(databaseName: "GetOrdersTest") .Options; //Act using (var db = new StoreAppContext(options)) { Order location = new Order { CustomerId = 5, ProductId = 10, Quantity = 3, }; db.Add(location); db.SaveChanges(); } //Assert using (var context = new StoreAppContext(options)) { var repo = new OrderRepo(); var orders = repo.GetOrders(context); Assert.Equal(1, orders.Count()); var order1 = context.Orders.Where(o => o.Id == 1).FirstOrDefault(); Assert.Equal(1, order1.Id); Assert.Equal(5, order1.CustomerId); Assert.Equal(10, order1.ProductId); Assert.Equal(3, order1.Quantity); } }
public adminDashboard() { InitializeComponent(); orderDB = new OrderRepo(); adminDB = new DatabaseAdmin(); dataGridView1.DataSource = adminDB.table(); }
public JsonResult Index(OrderViewModel orderViewModel) { OrderRepo orderRepo = new OrderRepo(); orderRepo.AddOrder(orderViewModel); return(Json("Order placed! Total: " + orderViewModel.FinalTotal.ToString(), JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> CreateLocation(CreateLocationViewModel model) { var locationRepository = new LocationRepo(); var orderRepository = new OrderRepo(); var customerRepository = new CustomerRepo(); var userId = User.Identity.GetUserId(); var location = new Models.Location { Title = model.Title, SecondTitle = model.SecondTitle, Customer = model.Customer, }; var order = new Order { LocationId = location.LocationId, UserId = userId }; location.UsersId.Add(userId); var testCustIds = await customerRepository.GetAllAsync(); await locationRepository.AddAsync(location); await orderRepository.AddAsync(order); return(RedirectToAction("Index", "Home", new { area = "" })); }
public ActionResult BookSeats(CartModel Model) { var success = false; var message = Resources.ErrorGeneral; if (Model != null && Model.Tickets != null && Model.Tickets.Any()) { var xmlInputModel = new TicketBooking { CustomerID = CurrentUser.ID, StockCode = 1, Details = Model.Tickets.Select(t => new TicketBookingDetail { ScheduleID = t.SessionID, SeatID = t.SeatID, IsPaidBooking = false }).ToList() }; OrderRepo.TX_Order(2, xmlInputModel.ToXml()); if (!OrderRepo.IsError) { success = true; message = Resources.OperationSuccessful; } } return(Json(new { Success = success, Message = message }, JsonRequestBehavior.AllowGet)); }
// GET: Order/Details/5 public ActionResult Details(int id) { IEnumerable <P1B.Customer> customers = CustomerRepo.GetAllCustomers(); IEnumerable <P1B.Location> locations = LocRepo.GetAllLocations(); List <Project1.BLL.Cupcake> cupcakes = CupcakeRepo.GetAllCupcakes().OrderBy(c => c.Id).ToList(); List <Project1.BLL.OrderItem> orderItems = OrderItemRepo.GetOrderItems(id).ToList(); Project1.BLL.Order order = OrderRepo.GetOrder(id); var viewModel = new OrderViewModel { OrderId = id, LocationId = order.OrderLocation, LocationName = locations.Single(l => l.Id == order.OrderLocation).Name, CustomerId = order.OrderCustomer, CustomerName = customers.Single(c => c.Id == order.OrderCustomer).ReturnFullName(), OrderTime = order.OrderTime, Locations = LocRepo.GetAllLocations().ToList(), Customers = CustomerRepo.GetAllCustomers().ToList(), Cupcakes = cupcakes, OrderItems = orderItems, OrderTotal = OrderRepo.GetOrder(order.Id).GetTotalCost(OrderItemRepo.GetOrderItems(order.Id).ToList(), cupcakes.ToList()) }; // give the Create view values for its dropdown return(View(viewModel)); }
public async Task <IActionResult> CreateAdd([Bind("Id,ProductId,CustomerId,Quantity,Timestamp")] Order order) { var check = new OrderLogic(); var products = new ProductRepo(); if (ModelState.IsValid && check.IsWithinInventory(products.GetInventory(_context, order.ProductId), order.Quantity)) { try { products.UpdateInventory(_context, order.ProductId, order.Quantity); _context.Add(order); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } catch (Exception ex) { _logger.LogInformation(ex, "Something in the order wasn't able to be added"); } } var repo = new OrderRepo(); ViewData["ProductInfo"] = repo.ProductList(_context); return(View(order)); }
public void TestAddOrder(OrderToAddDTO order) { // arrange _dbContext = _dbContext ?? Configurations.GetDbContext(); _mapperProvider = _mapperProvider ?? Configurations.GetMapperProvider(); _mapper = _mapper ?? Configurations.GetMapper(); // act var result = new OrderRepo(_dbContext, _mapperProvider, _mapper).AddOrder(order); // assert Assert.IsType <ResultDTO_AddOrder>(result); if (result.SkuIdsOverStock.Any()) { Assert.True(result.OrderId == -1); } else { Assert.True(result.OrderId > 0); Assert.All(result.Skus, sku => { Assert.True(sku.Quantity == 0); }); Assert.True(result.StyleStates.First().SoldOut); } }
public JsonResult Index(OrderViewModel objOrderViewModel) { OrderRepo objOrderRepo = new OrderRepo(); objOrderRepo.AddOrder(objOrderViewModel); return(Json(data: "order thành công :>", JsonRequestBehavior.AllowGet)); }
// GET: Orders/Details/5 /// <summary> /// Gets the order details from a specific order using /// the given id and returns the view displaying its info /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } try { var repo = new OrderRepo(); var order = await repo.GetOrderDetails(_context, (int)id); if (order == null) { return(NotFound()); } return(View(order)); } catch (Exception ex) { _logger.LogInformation(ex, "Wasn't able to get the order data"); return(RedirectToAction(nameof(Index))); } }
public OrderController(PizzaStoreDBContext dbContext, OrderRepo orderRepo, CartViewModel cart, UserManager <IdentityUser> userMnger) { _context = dbContext; _orderRepo = orderRepo; _cart = cart; _userMnger = userMnger; }
public OrderRepoTests() { _repo = new OrderRepo(new OrderDetailRepo()); StoreDataInitializer.ClearData(_repo.Context); StoreDataInitializer.InitializeData(_repo.Context); }
private void SiparisFiyatHesapla() { if (cmbOrderName.SelectedIndex == -1) { return; } PackageRepo db = new PackageRepo(); OrderRepo dbOrder = new OrderRepo(); foreach (var item1 in dbOrder.GetAll()) { decimal total = 0; if (cmbOrderName.SelectedItem.ToString() == item1.OrderName.ToString()) { foreach (var item in db.GetAll()) { if (item.OrderId == (cmbOrderName.SelectedItem as Order).OrderId) { total += item.PackagePurchasingPrice; } } lblOrderPriceText.Text = total.ToString(); break; } } }
private void btnOrderDelete_Click(object sender, EventArgs e) { OrderRepo db = new OrderRepo(); if (cmbOrderName.SelectedIndex == -1) { return; } var seciliOrder = cmbOrderName.SelectedItem as Order; foreach (var item in db.GetAll()) { if (item.OrderId == seciliOrder.OrderId) { db.Delete(seciliOrder); cmbOrderName.Text = ""; break; } } cmbOrderName.DataSource = db.GetAll(); lstOrder.Items.Clear(); lstOrder.Items.AddRange(new PackageRepo().GetAll(x => x.OrderId == (cmbOrderName.SelectedItem as Order).OrderId).ToArray()); SiparisFiyatHesapla(); if (cmbOrderName.Items.Count == 0) { lblOrderPriceText.Text = "0"; } }
public PlannerService(IPreactor preactor) { this._preactor = preactor; _planningBoard = _preactor.PlanningBoard; ordRepo = new OrderRepo(_preactor); resRepo = new ResourceRepo(_preactor); }
public OrderNumberPage(ObservableCollection <OrderNumber> orderNoList, int jobCardId, OrderNumber orderNo = null) : this() { Repo = new OrderRepo(); Model = orderNo ?? new OrderNumber(); ModelList = orderNoList ?? new ObservableCollection <OrderNumber>(); JobCardId = jobCardId; DataContext = Model; }
public IndexController() { cs = new CustomerRepo(); pr = new ProductRepo(); cr = new CartRepo(); cp = new ContactRepo(); op = new OrderRepo(); }
public void add_test() { OrderRepo orp = new OrderRepo(new Provider.OptionDbCtx()); var o = orp.CreateOrder(1, 1, Core.TradeDirectType.卖, OrderPolicy.限价申报, 10, 100); var r = orp.Add(o); Assert.AreEqual(true, r); }
public Orders(Login l) { InitializeComponent(); this.l = l; emp = new Employee(); or = new OrderRepo(); DeleteBtn.Enabled = false; }
public ActionResult ShowAllOrders() { OrderRepo op = new OrderRepo(); var lst = op.GetAllOrders(); return(View(lst)); }
// GET: Order/Details/5 public ActionResult Orders(int id, string sortOrder) { ViewData["TimeSortParm"] = String.IsNullOrEmpty(sortOrder) ? "time_desc" : ""; ViewData["OrderTotalSortParm"] = sortOrder == "OrderTotal" ? "order_total_desc" : "OrderTotal"; IEnumerable <P1B.Customer> customers = CustomerRepo.GetAllCustomers(); IEnumerable <P1B.Location> locations = LocRepo.GetAllLocations(); List <Project1.BLL.Cupcake> cupcakes = CupcakeRepo.GetAllCupcakes().OrderBy(c => c.Id).ToList(); IEnumerable <P1B.Order> orders = LocRepo.GetLocationOrderHistory(id).ToList(); List <OrderViewModel> viewModels = new List <OrderViewModel>(); ViewData["LocationName"] = locations.Single(l => l.Id == id).Name; ViewData["LocationId"] = id; switch (sortOrder) { case "time_desc": orders = orders.OrderByDescending(o => o.OrderTime); break; case "OrderTotal": orders = orders.OrderBy(o => o.GetTotalCost(OrderItemRepo.GetOrderItems(o.Id).ToList(), cupcakes.ToList())); break; case "order_total_desc": orders = orders.OrderByDescending(o => o.GetTotalCost(OrderItemRepo.GetOrderItems(o.Id).ToList(), cupcakes.ToList())); break; default: orders = orders.OrderBy(o => o.OrderTime); break; } foreach (var order in orders) { viewModels.Add(new OrderViewModel { OrderId = order.Id, LocationId = order.OrderLocation, LocationName = locations.Single(l => l.Id == order.OrderLocation).Name, CustomerId = order.OrderCustomer, CustomerName = customers.Single(c => c.Id == order.OrderCustomer).ReturnFullName(), OrderTime = order.OrderTime, Locations = locations.ToList(), Customers = customers.ToList(), Cupcakes = cupcakes, OrderItems = OrderItemRepo.GetOrderItems(order.Id).ToList(), OrderTotal = OrderRepo.GetOrder(order.Id).GetTotalCost(OrderItemRepo.GetOrderItems(order.Id).ToList(), cupcakes.ToList()) }); } return(View(viewModels)); }
public PlaceOrderPage(Login l) { this.pr = new ProductRepo(); InitializeComponent(); this.or = new OrderRepo(); this.l = l; WelcomeLabel.Text += l.Id; }
private void GoodsAcceptanceForm_Load(object sender, EventArgs e) { OrderRepo db = new OrderRepo(); var cmbOrders = db.GetAll(); cmbOrderProduct.Items.Clear(); cmbGoodsAcceptanceOrders.Items.AddRange(cmbOrders.ToArray()); }
public async Task UpdateOrder([FromBody] Order order) { order.OrderItems.ForEach(item => item.ProductItem = null ); order.OrderStatus = null; await OrderRepo.UpdateOrder(order); }
public async Task RemoveItemFromOrder([FromRoute] string orderId, [FromRoute] string productId) { Guid orderguid, productguid; if (Guid.TryParse(orderId, out orderguid) && Guid.TryParse(productId, out productguid)) { await OrderRepo.RemoveItemFromOrder(orderguid, productguid); } }
public Orders CreateOrder(string productChoice, string taxChoice, DateTime DT, string name, string height, string length) { // adding appropriate file class info into the order class //creating variables var products = new ProductRepo(); var productInfo = products.GrabInfo(productChoice); var taxes = new TaxRepo(); var taxInfo = taxes.GrabInfo(taxChoice); var orderInfo = new Orders(); var ordersFile = new OrderRepo(); var orderCount = ordersFile.GrabDate(DT); int count; if (orderCount.Count() == 0) { count = 0; } else { count = orderCount.Max(c => c.OrderNum); } foreach (var t in taxInfo) { if (t.StateAbrev == taxChoice) { orderInfo.TaxRate = t.TaxRate; orderInfo.State = t.StateAbrev; } } foreach (var p in productInfo) { if (p.ProductType == productChoice) { orderInfo.ProductType = p.ProductType; orderInfo.LaborCostPerSquareFoot = p.LaborCost; orderInfo.CostPerSquareFoot = p.CostSqFeet; } } orderInfo.OrderNum = count + 1; orderInfo.CustomerName = name; orderInfo.Area = CalculateArea(decimal.Parse(height), decimal.Parse(length)); orderInfo.MaterialsCost = MaterialCost(orderInfo.Area, orderInfo.CostPerSquareFoot); orderInfo.LaborCost = LaborCost(orderInfo.Area, orderInfo.LaborCostPerSquareFoot); orderInfo.Tax = TaxCost(orderInfo.MaterialsCost, orderInfo.LaborCost, orderInfo.TaxRate); orderInfo.Total = TotalCost(orderInfo.MaterialsCost, orderInfo.LaborCost, orderInfo.Tax); //var writeOrders = new OrderRepo(); ordersFile.Write(DT, orderInfo); return(orderInfo); }
public void ShouldProcessAnOrder() { var orders1 = new OrderRepo(new OrderDetailRepo()).GetAll(); Assert.Equal(1, orders1.ToList().Count); _repo.Purchase(0); var orders2 = new OrderRepo(new OrderDetailRepo()).GetAll(); Assert.Equal(2, orders2.ToList().Count); }
public ActionResult Orders(DateTime?Start, DateTime?End) { Start = Start ?? DateTime.Today.AddMonths(-1); End = End ?? DateTime.Today; ViewBag.Start = Start; ViewBag.End = End; var model = OrderRepo.GetUserOrders(CurrentUser.ID, Start.Value, End.Value.AddDays(1).AddMilliseconds(-1)); return(View(model)); }
public OrderManagementService(IPreactor preactor) { _preactor = preactor; shtRepo = new ShortagesRepo(_preactor); ignShtRepo = new IgnoreShortagesRepo(_preactor); ordRepo = new OrderRepo(_preactor); prdRepo = new ProductRepo(_preactor); resSqlRepo = new ResourceRepoSql(_preactor); resList = resSqlRepo.getAll(); }
public OrderRepoTests() { _repo = new OrderRepo(new OrderDetailRepo()); StoreDataInitializer.InitializeData(_repo.Context); }