public bool DeleteProducts(Product pd) { if (connection.DeleteProduct(pd.productId)) { return true; } else { return false; } }
public bool EditProducts(Product pd) { if (connection.UpdateProduct(pd.productId, pd.productName, pd.productPrice, pd.productQuantity)) { return true; } else { return false; } }
public bool AddProducts(Product pd) { if (connection.InsertProduct(pd.productId, pd.productName, pd.productPrice, pd.productQuantity)) { return true; } else { return false; } }
public List<Product> GetAllProduct() { string quary = "select * from ProductDB.dbo.Product"; SqlDataAdapter adapter = new SqlDataAdapter(quary, ProductDbConnection()); DataTable dt = new DataTable(); adapter.Fill(dt); List<Product> products=new List<Product>(); foreach (DataRow i in dt.Rows) { Product pr=new Product(); pr.productId = Convert.ToInt32(i["productId"]); pr.productName = (i["productName"]).ToString(); pr.productPrice = Convert.ToDecimal(i["productPrice"]); pr.productQuantity = Convert.ToInt32(i["productQuantity"]); products.Add(pr); } return products; }