public bool Delete(EL.REGISTRATIONS.products productEL)
{
return(productDL.Delete(productEL));
}
public long Insert(EL.REGISTRATIONS.products productEL)
{
return(productDL.Insert(productEL));
}
public bool Update(EL.REGISTRATIONS.products productEL)
{
return(productDL.Update(productEL));
}
public DataTable IsExisting(EL.REGISTRATIONS.products productEL)
{
return(productDL.IsExisting(productEL));
}
public bool Delete(EL.REGISTRATIONS.products productEL)
{
return(Helper.executeNonQueryBool("DELETE FROM products WHERE productid = '" + productEL.Productid + "' "));
}
public bool Update(EL.REGISTRATIONS.products productEL)
{
return(Helper.executeNonQueryBool("UPDATE products SET productcategoryid = '" + productEL.Productcategoryid + "', particularid = '" + productEL.Particularid + "', containertypeid = '" + productEL.Containertypeid + "', price = '" + productEL.Price + "' where productid = '" + productEL.Productid + "'"));
}
public long Insert(EL.REGISTRATIONS.products productEL)
{
return(Helper.executeNonQueryLong("INSERT INTO products (productcategoryid, particularid, containertypeid, price) VALUES ('" + productEL.Productcategoryid + "', " + productEL.Particularid + ", " + productEL.Containertypeid + ", '" + productEL.Price + "')"));
}
public DataTable IsExisting(EL.REGISTRATIONS.products productEL)
{
string sQuery = "SELECT * FROM products WHERE productcategoryid = '" + productEL.Productcategoryid + "' AND particularid = '" + productEL.Particularid + "' AND containertypeid = '" + productEL.Containertypeid + "' AND price = '" + productEL.Price + "' AND productid <> " + productEL.Productid + " ";
return(Helper.executeQuery(sQuery));
}
