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