public long Insert(EL.Registrations.SupplierProducts supplierProductEL)
{
return(SupplierProductDL.Insert(supplierProductEL));
}
public bool Delete(EL.Registrations.SupplierProducts supplierProductEL)
{
return(SupplierProductDL.Delete(supplierProductEL));
}
public DataTable CheckIfExisting(EL.Registrations.SupplierProducts supplierProductEL)
{
return(SupplierProductDL.CheckIfExisting(supplierProductEL));
}
public bool Delete(EL.Registrations.SupplierProducts supplierProductEL)
{
return(Helper.executeNonQueryBool("delete from supplierproducts where supplierproductid = '" + supplierProductEL.Supplierproductid + "' "));
}
public bool Update(EL.Registrations.SupplierProducts supplierProductEL)
{
return(Helper.executeNonQueryBool("update supplierproducts set productid = '" + supplierProductEL.Productid + "', supplierid = '" + supplierProductEL.Supplierid + "' where supplierproductid = '" + supplierProductEL.Supplierproductid + "'"));
}
public long Insert(EL.Registrations.SupplierProducts supplierProductEL)
{
return(Helper.executeNonQueryLong("insert into supplierproducts (productid, supplierid) values ('" + supplierProductEL.Productid + "', '" + supplierProductEL.Supplierid + "')"));
}
public DataTable CheckIfExisting(EL.Registrations.SupplierProducts supplierProductEL)
{
string sQuery = "select * from supplierproducts_view where supplierid = " + supplierProductEL.Supplierid + " and productid = " + supplierProductEL.Productid + " ";
return(Helper.executeQuery(sQuery));
}
