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