public void UpdatePurchasing(long ProductID, long MatrxID, long SupplierID, int BaseUnitID, decimal UnitCost)
{
try
{
string SQL = "UPDATE tblProducts SET " +
"SupplierID = @SupplierID " +
"WHERE ProductID = @ProductID " +
"AND BaseUnitID = @BaseUnitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@SupplierID", SupplierID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@BaseUnitID", BaseUnitID);
base.ExecuteNonQuery(cmd);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.UpdatePurchasing(ProductID, MatrxID, BaseUnitID, 1, UnitCost);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}