public void Test_DeleteItem_RemovesAProductFromCart()
{
//Arrange
User testUser = new User("Allie", "Holcombe", "eylookturkeys", "password", false);
testUser.Save();
CartProduct testCartProduct = new CartProduct(testUser.GetId(), 2, 5);
testCartProduct.Save();
CartProduct secondCartProduct = new CartProduct(testUser.GetId(), 3, 5);
secondCartProduct.Save();
//Act
testUser.DeleteItem(2);
List <CartProduct> expected = new List <CartProduct> {
secondCartProduct
};
List <CartProduct> result = testUser.GetCartProducts();
Console.WriteLine(string.Format("EXPECTED Id: {0} user_id: {1} product_id: {2} quantity: {3}", expected[0].GetId(), expected[0].GetUserId(), expected[0].GetProductId(), expected[0].GetQuantity()));
Console.WriteLine(string.Format("RESULT Id: {0} user_id: {1} product_id: {2} quantity: {3}", result[0].GetId(), result[0].GetUserId(), result[0].GetProductId(), result[0].GetQuantity()));
//Assert
Assert.Equal(expected, result);
}
public void GetTotal_ReturnsTotalPriceOfAllItems_decimal()
{
//Arrange
User testUser = new User("Allie", "Holcombe", "eylookturkeys", "password", false);
testUser.Save();
Product firstProduct = new Product("Vegetti", 13, 5, 2.00m, "Great item for shredding zukes");
firstProduct.Save();
Product secondProduct = new Product("Vegetti", 13, 5, 20.00m, "Great item for shredding zukes");
secondProduct.Save();
CartProduct testCartProduct = new CartProduct(testUser.GetId(), firstProduct.GetId(), 1);
testCartProduct.Save();
CartProduct secondCartProduct = new CartProduct(testUser.GetId(), secondProduct.GetId(), 2);
secondCartProduct.Save();
//Act
List <Product> expected = new List <Product> {
firstProduct, secondProduct
};
List <Product> result = testUser.GetCart();
decimal actualResult = testUser.GetTotal();
decimal expectedResult = 42.00m;
Assert.Equal(expectedResult, actualResult);
}
//Gets the cart_products rows associated with the user
public List <CartProduct> GetCartProducts()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM cart_products WHERE user_id = @UserId;", conn);
cmd.Parameters.Add(new SqlParameter("@UserId", this.GetId().ToString()));
SqlDataReader rdr = cmd.ExecuteReader();
List <CartProduct> allCartProducts = new List <CartProduct> {
};
while (rdr.Read())
{
int id = rdr.GetInt32(0);
int userId = rdr.GetInt32(1);
int productId = rdr.GetInt32(2);
int quantity = rdr.GetInt32(3);
CartProduct newCartProduct = new CartProduct(userId, productId, quantity, id);
allCartProducts.Add(newCartProduct);
}
DB.CloseSqlConnection(conn, rdr);
return(allCartProducts);
}
public void GetCartProducts_GetsRowsFromCartProductsTable_List()
{
//Arrange
User testUser = new User("Allie", "Holcombe", "eylookturkeys", "password", false);
testUser.Save();
Product firstProduct = new Product("Vegetti", 13, 5, 20.99m, "Great item for shredding zukes");
firstProduct.Save();
Product secondProduct = new Product("Vegetti", 13, 5, 20.99m, "Great item for shredding zukes");
secondProduct.Save();
CartProduct testCartProduct = new CartProduct(testUser.GetId(), firstProduct.GetId(), 5);
testCartProduct.Save();
CartProduct secondCartProduct = new CartProduct(testUser.GetId(), secondProduct.GetId(), 5);
secondCartProduct.Save();
//Act
List <CartProduct> expected = new List <CartProduct> {
testCartProduct, secondCartProduct
};
List <CartProduct> result = testUser.GetCartProducts();
//Assert
Assert.Equal(expected, result);
}
public void GetCart_GetAllProductsFromUsersCart_ReturnTheListOfProductsFromTheUser()
{
//Arrange
User testUser = new User("Allie", "Holcombe", "eylookturkeys", "password", false);
testUser.Save();
Product firstProduct = new Product("Vegetti", 13, 5, 20.99m, "Great item for shredding zukes");
firstProduct.Save();
Product secondProduct = new Product("Vegetti", 13, 5, 20.99m, "Great item for shredding zukes");
secondProduct.Save();
CartProduct testCartProduct = new CartProduct(testUser.GetId(), firstProduct.GetId(), 5);
testCartProduct.Save();
CartProduct secondCartProduct = new CartProduct(testUser.GetId(), secondProduct.GetId(), 5);
secondCartProduct.Save();
CartProduct thirdCartProduct = new CartProduct(1, firstProduct.GetId(), 1);
thirdCartProduct.Save();
//Act
List <Product> expected = new List <Product> {
firstProduct, secondProduct
};
List <Product> result = testUser.GetCart();
//Assert
Assert.Equal(expected, result);
}
public void EmptyCart_RemovesAllProductsFromUsersCart_void()
{
//Arrange
User testUser = new User("Allie", "Holcombe", "eylookturkeys", "password", false);
testUser.Save();
CartProduct testCartProduct = new CartProduct(testUser.GetId(), 2, 5);
testCartProduct.Save();
CartProduct secondCartProduct = new CartProduct(testUser.GetId(), 3, 5);
secondCartProduct.Save();
CartProduct thirdCartProduct = new CartProduct(1, 3, 1);
thirdCartProduct.Save();
//Act
testUser.EmptyCart();
List <CartProduct> expected = new List <CartProduct> {
thirdCartProduct
};
List <CartProduct> result = CartProduct.GetAll();
//Assert
Assert.Equal(expected, result);
}
//Gets all rows in cartproducts
public static List <CartProduct> GetAll()
{
List <CartProduct> allCartProducts = new List <CartProduct> {
};
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM cart_products;", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int cartProductId = rdr.GetInt32(0);
int userId = rdr.GetInt32(1);
int productId = rdr.GetInt32(2);
int quantity = rdr.GetInt32(3);
CartProduct newCartProduct = new CartProduct(userId, productId, quantity, cartProductId);
allCartProducts.Add(newCartProduct);
}
DB.CloseSqlConnection(conn, rdr);
return(allCartProducts);
}
public static CartProduct Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM cart_products WHERE id = @ProductId;", conn);
cmd.Parameters.Add(new SqlParameter("@ProductId", id.ToString()));
SqlDataReader rdr = cmd.ExecuteReader();
int cartProductId = 0;
int userId = 0;
int productId = 0;
int quantity = 0;
while (rdr.Read())
{
cartProductId = rdr.GetInt32(0);
userId = rdr.GetInt32(1);
productId = rdr.GetInt32(2);
quantity = rdr.GetInt32(3);
}
CartProduct foundCartProduct = new CartProduct(userId, productId, quantity, cartProductId);
DB.CloseSqlConnection(conn, rdr);
return(foundCartProduct);
}
public void EqualOverride_CartProductsAreSame_true()
{
//Arrange, Act
CartProduct firstCartProduct = new CartProduct(2, 2, 5);
CartProduct secondCartProduct = new CartProduct(2, 2, 5);
Assert.Equal(firstCartProduct, secondCartProduct);
}
public void Dispose()
{
User.DeleteAll();
Product.DeleteAll();
Review.DeleteAll();
Profile.DeleteAll();
CartProduct.DeleteAll();
}
public void GetAll_ForNoCartProducts_EmptyList()
{
//Arrange, Act, Assert
List <CartProduct> actualResult = CartProduct.GetAll();
List <CartProduct> expectedResult = new List <CartProduct> {
};
Assert.Equal(expectedResult, actualResult);
}
public void UpdateQuantity_ChangesCartProductQuantity_void()
{
CartProduct testCartProduct = new CartProduct(2, 2, 2);
testCartProduct.Save();
testCartProduct.UpdateQuantity(5);
int expectedResult = 5;
int actualResult = testCartProduct.GetQuantity();
Assert.Equal(expectedResult, actualResult);
}
public void Test_Find_FindsCartProductInDatabase()
{
//Arrange
CartProduct testCartProduct = new CartProduct(2, 2, 5);
testCartProduct.Save();
// CartProduct secondCartProduct = new CartProduct(1,3,5);
// secondCartProduct.Save();
//Act
CartProduct foundCartProduct = CartProduct.Find(testCartProduct.GetId());
//Assert
Assert.Equal(testCartProduct, foundCartProduct);
}
public void Save_ForCartProduct_SavesToDatabase()
{
//Arrange
CartProduct newCartProduct = new CartProduct(2, 2, 5);
//Act
newCartProduct.Save();
//Assert
List <CartProduct> actualResult = CartProduct.GetAll();
List <CartProduct> expectedResult = new List <CartProduct> {
newCartProduct
};
Assert.Equal(expectedResult, actualResult);
}
public override bool Equals(System.Object otherCartProduct)
{
if (!(otherCartProduct is CartProduct))
{
return(false);
}
else
{
CartProduct newCartProduct = (CartProduct)otherCartProduct;
bool idEquality = this.GetId() == newCartProduct.GetId();
bool userIdEquality = this.GetUserId() == newCartProduct.GetUserId();
bool productIdEquality = this.GetProductId() == newCartProduct.GetProductId();
bool quantityEquality = this.GetQuantity() == newCartProduct.GetQuantity();
return(idEquality && userIdEquality && productIdEquality && quantityEquality);
}
}
public void Test_DeleteItem_RemovesAProductFromCart()
{
//Arrange
CartProduct testCartProduct = new CartProduct(2, 2, 5);
testCartProduct.Save();
CartProduct secondCartProduct = new CartProduct(1, 3, 5);
secondCartProduct.Save();
//Act
testCartProduct.DeleteItem();
List <CartProduct> expected = new List <CartProduct> {
secondCartProduct
};
List <CartProduct> result = CartProduct.GetAll();
Console.WriteLine(string.Format("EXPECTED Id: {0} user_id: {1} product_id: {2} quantity: {3}", expected[0].GetId(), expected[0].GetUserId(), expected[0].GetProductId(), expected[0].GetQuantity()));
Console.WriteLine(string.Format("RESULT Id: {0} user_id: {1} product_id: {2} quantity: {3}", result[0].GetId(), result[0].GetUserId(), result[0].GetProductId(), result[0].GetQuantity()));
//Assert
Assert.Equal(expected, result);
}
public void Checkout_ChecksoutProductsFromUser_updatesTables()
{
//Arrange
User testUser = new User("Allie", "Holcombe", "eylookturkeys", "password", false);
testUser.Save();
Product firstProduct = new Product("Vegetti", 13, 5, 2.00m, "Great item for shredding zukes");
firstProduct.Save();
Product secondProduct = new Product("Banana Corer", 13, 5, 20.99m, "Kind of weird");
secondProduct.Save();
CartProduct testCartProduct = new CartProduct(testUser.GetId(), firstProduct.GetId(), 5);
testCartProduct.Save();
CartProduct secondCartProduct = new CartProduct(testUser.GetId(), secondProduct.GetId(), 2);
secondCartProduct.Save();
//Act
testUser.Checkout();
//Checks that count was Updated
int expectedCount = 8;
// int actualCount = firstProduct.GetCount();
int actualCount = Product.Find(firstProduct.GetId()).GetCount();
Assert.Equal(expectedCount, actualCount);
//Checks that cart is empty
List <Product> expectedCart = new List <Product> {
};
List <Product> actualCart = testUser.GetCart();
Assert.Equal(expectedCart, actualCart);
}
//clears all rows in table
public void Dispose()
{
CartProduct.DeleteAll();
}
