public void SelectByIdTest()
{
Product item = ProductTestData.CreateProduct1();
Product find = this.Dao.SelectById(this.Context, item);
Assert.AreEqual(item.Id, find.Id);
ProductTestData.AssertAreEqual(item, find);
}
public void DeleteTest()
{
Product itemTest = ProductTestData.CreateProduct2();
int affectedRows = this.Service.Delete(itemTest, true);
List <Product> items = this.Service.SelectAll();
Assert.AreEqual(items.Count, ProductTestData.ProductCount - 1);
Assert.AreEqual(-1, affectedRows);
}
public void SelectByIdTest()
{
Product itemTest = ProductTestData.CreateProduct1();
Product find = this.Service.SelectById(new Product {
Id = itemTest.Id
});
Assert.IsNotNull(find);
ProductTestData.AssertAreEqual(itemTest, find);
}
public void UpdateTest()
{
Product item = ProductTestData.CreateProduct1();
Product beforeUpdate = this.Dao.SelectById(this.Context, item);
Assert.IsNotNull(beforeUpdate);
beforeUpdate.Name = string.Empty;
this.Dao.Update(this.Context, beforeUpdate);
Product afterUpdate = this.Dao.SelectById(this.Context, beforeUpdate);
ProductTestData.AssertAreEqual(beforeUpdate, afterUpdate);
}
public void UpdateTest()
{
Product itemTest = ProductTestData.CreateProduct1();
Product beforeUpdate = this.Service.SelectById(new Product {
Id = itemTest.Id
});
beforeUpdate.Name = string.Empty;
this.Service.Update(beforeUpdate, true);
Product afterUpdate = this.Service.SelectById(new Product {
Id = itemTest.Id
});
ProductTestData.AssertAreEqual(beforeUpdate, afterUpdate);
}
public void SelectByTest()
{
Product itemTest = ProductTestData.CreateProduct1();
List <Product> find = this.Service.SelectBy(new Product {
Name = itemTest.Name
}, new List <string> {
"Name"
});
Assert.IsNotNull(find);
foreach (Product item in find)
{
Assert.AreEqual(itemTest.Name, item.Name);
}
}
public void SelectByTest()
{
Product itemTest = ProductTestData.CreateProduct1();
List <Product> find = this.Service.SelectBy(new Product {
Description = itemTest.Description
}, new List <string> {
"Description"
});
Assert.IsNotNull(find);
foreach (Product item in find)
{
Assert.AreEqual(itemTest.Description, item.Description);
}
}
public void DeleteTest()
{
Product item = ProductTestData.CreateProduct1();
Product beforedelete = this.Dao.SelectById(this.Context, item);
Assert.IsNotNull(beforedelete);
int affectedRows = this.Dao.Delete(this.Context, beforedelete);
Assert.AreEqual(1, affectedRows);
Product afterDelete = this.Dao.SelectById(this.Context, beforedelete);
Assert.IsNull(afterDelete);
List <Product> items = this.Dao.SelectAll(this.Context);
Assert.AreEqual(ProductTestData.ProductCount - 1, items.Count);
}
public void InsertTest()
{
Product item = new Product
{
Name = string.Empty,
Description = string.Empty,
};
int affectedRows = this.Dao.Insert(this.Context, item);
Assert.AreEqual(1, affectedRows);
Product find = this.Dao.SelectById(this.Context, item);
ProductTestData.AssertAreEqual(item, find);
List <Product> items = this.Dao.SelectAll(this.Context);
Assert.AreEqual(ProductTestData.ProductCount + 1, items.Count);
}
public ProductDaoMock() : base(ProductTestData.CreateProduct())
{
}
public void TopTenProductListNoData()
{
var demoDataContext = new Mock <IDatabaseContext>();
demoDataContext.Setup(x => x.Products).Returns(UnitTestHelpers.GetQueryableMockDbSet(ProductTestData.Get(2)));
var productList = new ProductList(demoDataContext.Object);
var result = productList.GetTopTen();
Assert.Empty(result);
}
public List <ProductTestData> SendToDal(ProductTestData product)
{
ProductTestDAL pd = new ProductTestDAL();
return(pd.InsertToDB(product));
}
public IHttpActionResult GetData(ProductTestData product)
{
ProductTestBLL pb = new ProductTestBLL();
return(Ok(pb.SendToDal(product)));
}
public List <ProductTestData> InsertToDB(ProductTestData product)
{
List <ProductTestData> products = new List <ProductTestData>();
try
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Server=4X\\SQLEXPRESS;Database=ProductTest;Trusted_Connection=True";
conn.Open();
string insetProduct = "INSERT INTO Product VALUES(@ProductID,@ProductName,@ProductPrice)";
SqlCommand cmd = new SqlCommand(insetProduct, conn);
cmd.Parameters.Add(new SqlParameter("ProductID", product.ProductID));
cmd.Parameters.Add(new SqlParameter("ProductName", product.ProductName));
cmd.Parameters.Add(new SqlParameter("ProductPrice", product.ProductPrice));
cmd.ExecuteNonQuery();
string showInsert = "select * from Product where ProductID =" + product.ProductID;
cmd = new SqlCommand(showInsert, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
products.Add(new ProductTestData
{
ProductID = reader.GetString(0),
ProductName = reader.GetString(1),
ProductPrice = reader.GetDouble(2)
});
}
}catch (Exception e)
{
Console.Write(e.ToString());
}
/*string strConn = "Server=4X\\SQLEXPRESS;Database=ProductTest;Trusted_Connection=True";
* SqlConnection conn = new SqlConnection();
*
* List<ProductTestData> products = new List<ProductTestData>();
* try
* {
* conn = new SqlConnection(strConn);
* conn.Open();
*
* SqlCommand cmd = new SqlCommand("select * from Product", conn);
* SqlDataReader reader = cmd.ExecuteReader();
*
* while(reader.Read())
* {
* products.Add(new ProductTestData
* {
* ProductID = reader.GetString(0),
* ProductName = reader.GetString(1),
* ProductPrice = reader.GetDouble(2)
* });
* }
* }catch(Exception e)
* {
* Console.Write(e.ToString());
* }*/
/* SqlDataReader reader = command.ExecuteReader();
* ProductTestData data = new ProductTestData();
* while (reader.Read())
* {
*
* data.ProductID = reader[0].ToString();
* data.ProductName = reader[1].ToString();
* data.ProductPrice = double.Parse(reader[2].ToString());
* }*/
return(products);
}
