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