public void GetShipperByIDTest() { Order_ManagerDAL dal = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); var result = dal.GetOrder_ManagerById(13); Assert.IsTrue(result.O_M_id == 13, "returned ID does not match request"); }
public void DeleteShipperTest() { Order_ManagerDAL dal = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); dal.DeleteOrder_Manager(13); Assert.IsTrue(dal.GetOrder_ManagerById(13).O_M_id != 13, "item still in db"); ; }
public void Menu(int user) { string conn = ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString; UserDAL userDAL = new UserDAL(conn); OrderDAL orderDAL = new OrderDAL(conn); Order_listDAL order_listDAL = new Order_listDAL(conn); Order_ManagerDAL order_managerDAL = new Order_ManagerDAL(conn); }
public void GetCustomerTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); Assert.IsTrue(result.GetCustomer(2).Customer_id == 2, "Cannot find the customer"); }
public void LogTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); result.Log("Test2", "Test2"); Assert.IsTrue(result.Log("Test2", "Test2") == true, "Customer was not logged"); }
public void DeleteCustomerTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); result.RemoveCustomer(3); Assert.IsTrue(result.GetCustomer(3).Customer_id != 3, "Customer was not deleted"); }
public void DeletePositionTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); result.DeletePosition(1); Assert.IsTrue(result.SameOrderPositions(1).Count == 0, "Position was not deleted"); }
public void GetItemTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); result.GetItem(1); Assert.IsTrue(result.GetItem(1).Item_id == 1, "Item was not found"); }
public void DeleteShipperTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL); result.RemoveOrder_Manager(4); Assert.IsTrue(result.GetOrder_Manager(4).ShipperID != 4, "Shipper was not deleted"); }
public void UpdateCustomerTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); var customer = new CustomerDTO { Customer_id = 2, Customer_e_mail = "EmailTest", Customer_login = "******" }; Assert.IsTrue(result.ChangeCustomer(customer).Customer_e_mail == "EmailTest", "Customer was not updated"); }
public void UpdateShipperTest() { Order_ManagerDAL dal = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); var shupper = dal.GetOrder_ManagerById(13); Order_ManagerDTO upd = new Order_ManagerDTO { Userid = 2, O_M_frist_name = "fname", O_M_last_name = "lname", O_M_login = "******", O_M_e_mail = "email1", salary = 10000, }; var result = dal.UpdateOrder_Manager(upd); Assert.IsTrue(result.O_M_e_mail == "Updated", "Order_Manager was not updated"); }
public void AddCustomerTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); var customer = new CustomerDTO { Customer_id = 2, Customer_e_mail = "Test2", Customer_login = "******", }; result.AddCustomer(customer); Assert.IsTrue(customer.Customer_id >= 0, "returned ID should be more than zero"); }
public void CreateShipperTest() { Order_ManagerDAL dal = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); var result = new Order_ManagerDTO { Userid = 2, O_M_frist_name = "fname", O_M_last_name = "lname", O_M_login = "******", O_M_e_mail = "email1", salary = 10000, }; result = dal.CreateOrder_Manager(result); Assert.IsTrue(result.O_M_id >= 0, "returned ID should be more than zero"); }
public void AddOrderTest() { ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Order_ManagerDAL shipperDAL = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);; AddDAL addtoorderDAL = new AddDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL); var order = new OrderDTO { OrderManagerid = 2, Customerid = 2, Value = 0, Date = DateTime.Now, }; var r = result.AddOrder(order); Assert.IsTrue(r.Order_id != 0, "returned ID should be more than zero"); }