public void DeleteCustomer()
{
// DataAccess da = new DataAccess();
Customer ca = new Customer();
Customer c = new Customer();
da.Connect();
bool inserted = ca.insertCustomer("Customer Test delete", "Customer Test2", "000", "*****@*****.**");
if (inserted)
{
SqlCommand command = new SqlCommand("SELECT TOP(1) CUST_ID FROM CUSTOMER ORDER BY 1 DESC", da.conn);
// command.Parameters.AddWithValue("@mail", "*****@*****.**");
// command.ExecuteNonQuery();
int primaryKey = Convert.ToInt32(command.ExecuteScalar());
bool deleted = ca.deleteCustomer(primaryKey);
// Customer c2 = da.GetCustomer(name);
da.Disconnect();
// Assert.IsNull(c2);
Assert.IsTrue(deleted);
}
}
public void UpdateCustomerTest()
{
// DataAccess da = new DataAccess();
Customer ca = new Customer();
da.Connect();
bool inserted = ca.insertCustomer("Customertestupdate", "Customer", "000", "*****@*****.**");
if (inserted)
{
SqlCommand command = new SqlCommand("SELECT TOP(1) CUST_ID FROM CUSTOMER ORDER BY 1 DESC", da.conn);
// command.Parameters.AddWithValue("@mail", "*****@*****.**");
// command.ExecuteNonQuery();
int primaryKey = Convert.ToInt32(command.ExecuteScalar());
bool updated = ca.updateCustomer(primaryKey, "CustomerUpdated", "CustomerTest", "222", "*****@*****.**");
bool updated2 = ca.updateCustomer(primaryKey, "", "CustomerTest", "222", "*****@*****.**");
Assert.IsTrue(updated);
Assert.IsFalse(updated2);
da.Disconnect();
}
}
public void InsertCustomerIntoDatabase()
{
Customer ca = new Customer();
bool inserted = ca.insertCustomer("CustomerTest", "Customer", "123", "*****@*****.**");
da.Disconnect();
Assert.IsTrue(inserted);
}
public void InsertCustomerIntoDatabaseCheckBlank() //Check blank
{
Customer ca = new Customer();
bool inserted = ca.insertCustomer("", "CustomerTest", "123", "*****@*****.**");
da.Disconnect();
Assert.IsFalse(inserted);
}
public void IfAnyCustomerFieldNullThrowArgumentException()
{
string name = null;
Customer ca = new Customer();
da.Connect();
// bool inserted = ca.insertCustomer(null, "CustomerTest", "666", "*****@*****.**");
Assert.Throws <ArgumentNullException>(() => ca.insertCustomer(name, "Customer Test2", "666", "*****@*****.**"));
// Assert.Fail("If we get here, an exception hasn't been thrown");
}
public void GetCustomerCheck()
{
Customer ca = new Customer();
da.Connect();
bool inserted = ca.insertCustomer("getCustomerCheck", "Customer Test2", "666", "*****@*****.**");
if (inserted)
{
DataTable datalist = new DataTable();
datalist = ca.getCustomers();
int count = datalist.Rows.Count;
Assert.AreNotEqual(0, count);
}
}
