public void SearchOrdersWithQuotesSearchesCorrectlyAndPreventsInjection() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "Order A's"; ordersRowA.Description = "Description A"; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRowA); OrdersManagementDataSet.OrdersRow ordersRowB = ds.Orders.NewOrdersRow(); ordersRowB.OrderId = 2; ordersRowB.OrderName = "Order B"; ordersRowB.Description = "Description B"; ordersRowB.Approver = "User"; ordersRowB.Creator = "User"; ordersRowB.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRowB); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ICollection <Order> orders = ordersService.SearchOrders("'"); Assert.AreEqual(1, orders.Count); IEnumerator <Order> enumerator = orders.GetEnumerator(); enumerator.Reset(); enumerator.MoveNext(); Assert.AreEqual(1, enumerator.Current.OrderId); }
public void GetSavedDraftOrdersRetrievesOrdersWithDraftStatusAndForCurrentUser() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "WhoCares"; ordersRow.Creator = "CurrentUser"; ordersRow.OrderName = "Test Order"; ordersRow.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRow); OrdersManagementDataSet.OrderDetailsRow detailRow = ds.OrderDetails.NewOrderDetailsRow(); detailRow.OrdersRow = ordersRow; detailRow.ProductId = 11; detailRow.Quantity = 3; ds.OrderDetails.AddOrderDetailsRow(detailRow); ds.AcceptChanges(); FakeProductService productService = new FakeProductService(); productService.Products.Add(new Product(11, null, null, 2.99m, null)); OrdersService ordersService = new OrdersService(ds, productService); IList <Order> orders = ordersService.GetSavedDraftOrders("CurrentUser"); Assert.IsNotNull(orders); Assert.AreEqual(1, orders.Count); Order order = orders[0]; Assert.AreEqual("Test Order", order.OrderName); Assert.IsNotNull(order); Assert.AreEqual(1, order.Details.Count); Assert.AreEqual((short)3, order.Details[0].Quantity); Assert.AreEqual(2.99m, order.Details[0].UnitPrice); }
public void DeleteRemovesOnlyExpectedOrderFromRepository() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 3; ordersRowA.OrderName = "Order A"; ordersRowA.Description = "Description A"; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRowA); OrdersManagementDataSet.OrdersRow ordersRowB = ds.Orders.NewOrdersRow(); ordersRowB.OrderId = 2; ordersRowB.OrderName = "Order B"; ordersRowB.Description = "Description B"; ordersRowB.Approver = "User"; ordersRowB.Creator = "User"; ordersRowB.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowB); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ordersService.DeleteOrder(3); Assert.AreEqual(1, ds.Orders.Count); Assert.AreEqual(2, ds.Orders[0].OrderId); }
private void AddCustomer(OrdersManagementDataSet ds, string customerId, string companyName) { OrdersManagementDataSet.CustomersRow row = ds.Customers.NewCustomersRow(); row.CustomerId = customerId; row.CompanyName = companyName; row.City = string.Empty; row.Region = string.Empty; row.PostalCode = string.Empty; row.Address = string.Empty; ds.Customers.AddCustomersRow(row); ds.AcceptChanges(); }
private void AddCustomer(OrdersManagementDataSet ds, string customerId, string companyName, string city, string state, string zipCode, string address) { OrdersManagementDataSet.CustomersRow row = ds.Customers.NewCustomersRow(); row.CustomerId = customerId; row.CompanyName = companyName; row.City = city; row.Region = state; row.PostalCode = zipCode; row.Address = address; ds.Customers.AddCustomersRow(row); ds.AcceptChanges(); }
public void ShouldGetAllApprovers() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); ds.Employees.AddEmployeesRow("jblack", "Black", "Joe"); ds.Employees.AddEmployeesRow("a-jdoe", "Doe", "John"); ds.AcceptChanges(); EmployeeService employeeService = new EmployeeService(ds); List<Employee> employees = new List<Employee>(employeeService.AllApprovers); Assert.IsNotNull(employees); Assert.AreEqual(1, employees.Count); Assert.AreEqual("a-jdoe", employees[0].EmployeeId); Assert.AreEqual("Doe", employees[0].LastName); }
public void ShouldGetEmployeeById() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); ds.Employees.AddEmployeesRow("11", "Black", "Joe"); ds.Employees.AddEmployeesRow("12", "Doe", "John"); ds.AcceptChanges(); EmployeeService employeeService = new EmployeeService(ds); Employee employee = employeeService.GetEmployeeById("11"); Assert.IsNotNull(employee); Assert.AreEqual("11", employee.EmployeeId); Assert.AreEqual("Black", employee.LastName); }
public void ShouldGetAllApprovers() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); ds.Employees.AddEmployeesRow("jblack", "Black", "Joe"); ds.Employees.AddEmployeesRow("a-jdoe", "Doe", "John"); ds.AcceptChanges(); EmployeeService employeeService = new EmployeeService(ds); List <Employee> employees = new List <Employee>(employeeService.AllApprovers); Assert.IsNotNull(employees); Assert.AreEqual(1, employees.Count); Assert.AreEqual("a-jdoe", employees[0].EmployeeId); Assert.AreEqual("Doe", employees[0].LastName); }
public void GetSavedDraftOrdersDoesNotRetrieveOrderForApproversWhoAreNotTheCurrentLoggedInOne() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "DifferentWhoCares"; ordersRow.Creator = "DifferentUser"; ordersRow.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRow); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); IList <Order> orders = ordersService.GetOrdersForApprover("CurrentUser"); Assert.IsNotNull(orders); Assert.AreEqual(0, orders.Count); }
public void DeleteNonDraftOrderThrowsException() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "Order A"; ordersRowA.Description = "Description A"; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowA); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ordersService.DeleteOrder(1); }
public void DeleteRemovesOrderFromRepository() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "Order A"; ordersRowA.Description = "Description A"; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRowA); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ordersService.DeleteOrder(1); Assert.AreEqual(0, ds.Orders.Count); }
public void GetSavedDraftOrdersDoesNotRetrieveOrdersWithoutDraftStatus() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "WhoCares"; ordersRow.Creator = "CurrentUser"; ordersRow.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRow); ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "WhoCares"; ordersRow.Creator = "CurrentUser"; ordersRow.OrderStatus = (int)OrderStatusEnum.Approved; ds.Orders.AddOrdersRow(ordersRow); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); IList <Order> orders = ordersService.GetSavedDraftOrders("CurrentUser"); Assert.IsNotNull(orders); Assert.AreEqual(0, orders.Count); }
public void GetOrderWithDetailsGetsBothOrderAndDetails() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.CustomerId = "11"; ordersRow.Description = "MyDescription"; ordersRow.Approver = "MyEmployeeId"; ordersRow.Creator = "MyEmployeeId"; ordersRow.OrderName = "MyOrderName"; ordersRow.OrderStatus = (int)OrderStatusEnum.Draft; ordersRow.ShipAddress = "MyShipAddress"; ordersRow.ShipCity = "MyShipCity"; ordersRow.ShipPostalCode = "MyZip"; ordersRow.ShipRegion = "MyShipRegion"; ds.Orders.AddOrdersRow(ordersRow); OrdersManagementDataSet.OrderDetailsRow detailRow = ds.OrderDetails.NewOrderDetailsRow(); detailRow.OrdersRow = ordersRow; detailRow.ProductId = 11; detailRow.Quantity = 3; ds.OrderDetails.AddOrderDetailsRow(detailRow); ds.AcceptChanges(); FakeProductService productService = new FakeProductService(); productService.Products.Add(new Product(11, null, null, 2.99m, null)); OrdersService ordersService = new OrdersService(ds, productService); Order order = ordersService.GetOrderWithDetails(ordersRow.OrderId); Assert.IsNotNull(order); Assert.AreEqual(ordersRow.OrderId, order.OrderId); Assert.AreEqual("MyDescription", order.Description); Assert.IsNotNull(order.Details); Assert.AreEqual(1, order.Details.Count); Assert.AreEqual((short)3, order.Details[0].Quantity); Assert.AreEqual(2.99m, order.Details[0].UnitPrice); }
public void SearchOrdersRetrievesOrdersByName() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "OrderA"; ordersRowA.Description = string.Empty; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowA); OrdersManagementDataSet.OrdersRow ordersRowB = ds.Orders.NewOrdersRow(); ordersRowB.OrderId = 2; ordersRowB.OrderName = "OrderB"; ordersRowB.Description = string.Empty; ordersRowB.Approver = "User"; ordersRowB.Creator = "User"; ordersRowB.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowB); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ICollection <Order> foundOrders = ordersService.SearchOrders("OrderA"); Assert.AreEqual(1, foundOrders.Count); IEnumerator <Order> enumerator = foundOrders.GetEnumerator(); enumerator.Reset(); enumerator.MoveNext(); Assert.AreEqual(1, enumerator.Current.OrderId); }
private static OrdersManagementDataSet InitOrdersManagementDataSet() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "Order A"; ordersRowA.Description = "Description A"; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowA); OrdersManagementDataSet.OrdersRow ordersRowB = ds.Orders.NewOrdersRow(); ordersRowB.OrderId = 2; ordersRowB.OrderName = "Order B"; ordersRowB.Description = "Description B"; ordersRowB.Approver = "User"; ordersRowB.Creator = "User"; ordersRowB.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowB); OrdersManagementDataSet.OrdersRow ordersRowC = ds.Orders.NewOrdersRow(); ordersRowC.OrderId = 3; ordersRowC.OrderName = "Order C"; ordersRowC.Description = "C"; ordersRowC.Approver = "User"; ordersRowC.Creator = "User"; ordersRowC.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowC); ds.AcceptChanges(); return(ds); }
public void DeleteRemovesOrderDetailsFromRepository() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.OrderId = 2; ordersRow.Approver = "CurrentUser"; ordersRow.Creator = "CurrentUser"; ordersRow.OrderName = "Test Order"; ordersRow.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRow); OrdersManagementDataSet.OrderDetailsRow detailRow = ds.OrderDetails.NewOrderDetailsRow(); detailRow.OrdersRow = ordersRow; detailRow.ProductId = 11; detailRow.Quantity = 3; ds.OrderDetails.AddOrderDetailsRow(detailRow); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ordersService.DeleteOrder(2); Assert.AreEqual(0, ds.Orders.Count); Assert.AreEqual(0, ds.OrderDetails.Count); }
private static OrdersManagementDataSet InitOrdersManagementDataSet() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "Order A"; ordersRowA.Description = "Description A"; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowA); OrdersManagementDataSet.OrdersRow ordersRowB = ds.Orders.NewOrdersRow(); ordersRowB.OrderId = 2; ordersRowB.OrderName = "Order B"; ordersRowB.Description = "Description B"; ordersRowB.Approver = "User"; ordersRowB.Creator = "User"; ordersRowB.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowB); OrdersManagementDataSet.OrdersRow ordersRowC = ds.Orders.NewOrdersRow(); ordersRowC.OrderId = 3; ordersRowC.OrderName = "Order C"; ordersRowC.Description = "C"; ordersRowC.Approver = "User"; ordersRowC.Creator = "User"; ordersRowC.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowC); ds.AcceptChanges(); return ds; }
public void SearchOrdersWithQuotesSearchesCorrectlyAndPreventsInjection() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "Order A's"; ordersRowA.Description = "Description A"; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRowA); OrdersManagementDataSet.OrdersRow ordersRowB = ds.Orders.NewOrdersRow(); ordersRowB.OrderId = 2; ordersRowB.OrderName = "Order B"; ordersRowB.Description = "Description B"; ordersRowB.Approver = "User"; ordersRowB.Creator = "User"; ordersRowB.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRowB); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ICollection<Order> orders = ordersService.SearchOrders("'"); Assert.AreEqual(1, orders.Count); IEnumerator<Order> enumerator = orders.GetEnumerator(); enumerator.Reset(); enumerator.MoveNext(); Assert.AreEqual(1, enumerator.Current.OrderId); }
public void SearchOrdersRetrievesOrdersByName() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRowA = ds.Orders.NewOrdersRow(); ordersRowA.OrderId = 1; ordersRowA.OrderName = "OrderA"; ordersRowA.Description = string.Empty; ordersRowA.Approver = "User"; ordersRowA.Creator = "User"; ordersRowA.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowA); OrdersManagementDataSet.OrdersRow ordersRowB = ds.Orders.NewOrdersRow(); ordersRowB.OrderId = 2; ordersRowB.OrderName = "OrderB"; ordersRowB.Description = string.Empty; ordersRowB.Approver = "User"; ordersRowB.Creator = "User"; ordersRowB.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRowB); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); ICollection<Order> foundOrders = ordersService.SearchOrders("OrderA"); Assert.AreEqual(1, foundOrders.Count); IEnumerator<Order> enumerator = foundOrders.GetEnumerator(); enumerator.Reset(); enumerator.MoveNext(); Assert.AreEqual(1, enumerator.Current.OrderId); }
public void GetSavedDraftOrdersRetrievesOrdersWithDraftStatusAndForCurrentUser() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "WhoCares"; ordersRow.Creator = "CurrentUser"; ordersRow.OrderName = "Test Order"; ordersRow.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRow); OrdersManagementDataSet.OrderDetailsRow detailRow = ds.OrderDetails.NewOrderDetailsRow(); detailRow.OrdersRow = ordersRow; detailRow.ProductId = 11; detailRow.Quantity = 3; ds.OrderDetails.AddOrderDetailsRow(detailRow); ds.AcceptChanges(); FakeProductService productService = new FakeProductService(); productService.Products.Add(new Product(11, null, null, 2.99m, null)); OrdersService ordersService = new OrdersService(ds, productService); IList<Order> orders = ordersService.GetSavedDraftOrders("CurrentUser"); Assert.IsNotNull(orders); Assert.AreEqual(1, orders.Count); Order order = orders[0]; Assert.AreEqual("Test Order", order.OrderName); Assert.IsNotNull(order); Assert.AreEqual(1, order.Details.Count); Assert.AreEqual((short)3, order.Details[0].Quantity); Assert.AreEqual(2.99m, order.Details[0].UnitPrice); }
public void GetSavedDraftOrdersDoesNotRetrieveOrdersWithoutDraftStatus() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "WhoCares"; ordersRow.Creator = "CurrentUser"; ordersRow.OrderStatus = (int)OrderStatusEnum.Submitted; ds.Orders.AddOrdersRow(ordersRow); ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "WhoCares"; ordersRow.Creator = "CurrentUser"; ordersRow.OrderStatus = (int)OrderStatusEnum.Approved; ds.Orders.AddOrdersRow(ordersRow); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); IList<Order> orders = ordersService.GetSavedDraftOrders("CurrentUser"); Assert.IsNotNull(orders); Assert.AreEqual(0, orders.Count); }
public void GetSavedDraftOrdersDoesNotRetrieveOrderForApproversWhoAreNotTheCurrentLoggedInOne() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); OrdersManagementDataSet.OrdersRow ordersRow = ds.Orders.NewOrdersRow(); ordersRow.Approver = "DifferentWhoCares"; ordersRow.Creator = "DifferentUser"; ordersRow.OrderStatus = (int)OrderStatusEnum.Draft; ds.Orders.AddOrdersRow(ordersRow); ds.AcceptChanges(); OrdersService ordersService = new OrdersService(ds, new FakeProductService()); IList<Order> orders = ordersService.GetOrdersForApprover("CurrentUser"); Assert.IsNotNull(orders); Assert.AreEqual(0, orders.Count); }
public void ShouldGetEmployeeById() { OrdersManagementDataSet ds = new OrdersManagementDataSet(); ds.Employees.AddEmployeesRow("11", "Black", "Joe"); ds.Employees.AddEmployeesRow("12", "Doe", "John"); ds.AcceptChanges(); EmployeeService employeeService = new EmployeeService(ds); Employee employee= employeeService.GetEmployeeById("11"); Assert.IsNotNull(employee); Assert.AreEqual("11", employee.EmployeeId); Assert.AreEqual("Black", employee.LastName); }