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