public bool insertProdDAL(ProdProps p)
{
string query = "INSERT INTO products VALUES('" + p.Prd_id + "','" + p.Prd_title + "','" + p.Prd_price + "','" + p.Prd_stock + "','" + p.Prd_expiry + "','" + p.Prd_manufact + "','" + p.Prd_image + "')";
return(db.query_iud(query));
}
public bool deleteProdDAL(ProdProps p)
{
string query = "delete from products where Prd_id ='" + p.Prd_id + "'";
return(db.query_iud(query));
}
public DataTable getProdDAL(ProdProps p)
{
string query = "select * from products where Prd_title ='" + p.Prd_title + "'";
return(db.search(query));
}
public DataTable searchProdBLL(ProdProps p)
{
ProdDAL obj = new ProdDAL();
return(obj.searchProdDAL(p));
}
public bool updatePImgBLL(ProdProps p)
{
ProdDAL obj = new ProdDAL();
return(obj.updatePImgDAL(p));
}
public bool deleteProdBLL(ProdProps p)
{
ProdDAL obj = new ProdDAL();
return(obj.deleteProdDAL(p));
}
public bool insertProdBLL(ProdProps p)
{
ProdDAL obj = new ProdDAL();
return(obj.insertProdDAL(p));
}