public void GetCustomerTest()
{
CustomerCRUD.addCustomer(88, "Joan", "Jett");
Assert.AreEqual(CustomerCRUD.GetCustomer(88).customer_f_name, "Joan");
Assert.AreEqual(CustomerCRUD.GetCustomerByLastName("Jett").customer_id, (88));
Assert.AreEqual(CustomerCRUD.GetCustomerByNames("Joan", "Jett").customer_id, 88);
CustomerCRUD.deleteCustomer(88);
}
public void UpdateCustomerTest()
{
CustomerCRUD.addCustomer(77, "Ellen", "DeGeneres");
Assert.IsTrue(CustomerCRUD.updateLastName(77, "Page"));
Assert.AreEqual(CustomerCRUD.GetCustomer(77).customer_l_name, "Page");
Assert.IsTrue(CustomerCRUD.updateName(77, "Elliot"));
Assert.AreEqual(CustomerCRUD.GetCustomerByLastName("Page").customer_f_name, "Elliot");
CustomerCRUD.deleteCustomer(77);
}
public void AddCustomerToDatabase()
{
Customers c = new Customers()
{
id = 101, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
}
public void DeleteCustomerFromDatabase()
{
Customers c = new Customers()
{
id = 102, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsTrue(CustomerCRUD.removeCustomer(c.id));
}
public void UpdateCustomerMoney()
{
Customers c = new Customers()
{
id = 105, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsTrue(CustomerCRUD.updateMoney(c.id, 300));
c = CustomerCRUD.getCustomer(c.id);
Assert.AreEqual(c.money, 400);
}
public void UpdateCustomerName()
{
Customers c = new Customers()
{
id = 104, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsTrue(CustomerCRUD.updateName(c.id, "Shawn"));
c = CustomerCRUD.getCustomer(c.id);
Assert.AreEqual(c.name, "Shawn");
}
public void GetCustomer()
{
Customers c = new Customers()
{
id = 103, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Customers c1 = CustomerCRUD.getCustomer(c.id);
Assert.AreEqual(c.id, c1.id);
Assert.AreEqual(c.name, c1.name);
}
public void BorrowNonExistingBookToCustomerWithMoney()
{
Books book = new Books()
{
id = 203, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 1
};
Customers c = new Customers()
{
id = 203, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsFalse(BorrowedBookCRUD.borrowBook(103, c.id, book.id));
}
public void GetCustomersTest()
{
CustomerCRUD.addCustomer(19, "Anna", "Kowalska");
CustomerCRUD.addCustomer(16, "Anna", "Nowak");
IEnumerable <customer> customers = CustomerCRUD.GetCustomersByName("Anna");
Assert.AreEqual(customers.Count(), 2);
Assert.AreEqual(customers.ElementAt(0).customer_l_name, "Nowak");
Assert.AreEqual(customers.ElementAt(1).customer_id, 19);
CustomerCRUD.deleteCustomer(19);
CustomerCRUD.deleteCustomer(16);
}
public void AddCustomer()
{
bool added = CustomerCRUD.addCustomer(newCustomer.customer_id, newCustomer.customer_f_name, newCustomer.customer_l_name);
if (added)
{
actionText = "Customer Added";
}
else
{
actionText = "Customer with such ID already exists in the database";
}
MessageBoxShowDelegate(ActionText);
}
public void BorrowBorrowedBookToCustomerWithMoney()
{
Books book = new Books()
{
id = 204, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 0
};
Assert.IsTrue(BookCRUD.addBook(book.id, book.title, book.author, book.type, book.penaltyCost, DateTime.Today, (int)book.state));
Customers c = new Customers()
{
id = 204, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsFalse(BorrowedBookCRUD.borrowBook(104, c.id, book.id));
}
public void BorrowExistingBookToCustomerWithMoney()
{
Books book = new Books()
{
id = 201, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 1
};
Assert.IsTrue(BookCRUD.addBook(book.id, book.title, book.author, book.type, book.penaltyCost, DateTime.Today, (int)book.state));
Customers c = new Customers()
{
id = 201, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsTrue(BorrowedBookCRUD.borrowBook(101, c.id, book.id));
Assert.AreEqual(BookCRUD.getBook(book.id).returnDate, DateTime.Today.AddDays(14));
Assert.AreEqual(BorrowedBookCRUD.getBorrowedBooks(book.id).customerId, c.id);
}
public void AddCustomerTest()
{
Assert.IsTrue(CustomerCRUD.addCustomer(67, "Michael", "Jackson"));
Assert.IsTrue(CustomerCRUD.deleteCustomer(67));
}
private void CustomerSave()
{
CustomerCRUD.addCustomer(this.CustomerId, this.Name, this.Money);
}