// Dec 10, 2011 : Obsolete, change to ChangeTax //public void ChangeVAT(decimal OldVAT, decimal NewVAT) //{ // try // { // string SQL = "UPDATE tblProducts SET " + // "VAT = @NewVAT " + // "WHERE VAT = @OldVAT;"; // // MySqlCommand cmd = new MySqlCommand(); // // // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // MySqlParameter prmNewVAT = new MySqlParameter("@NewVAT",MySqlDbType.Decimal); // prmNewVAT.Value = NewVAT; // cmd.Parameters.Add(prmNewVAT); // MySqlParameter prmOldVAT = new MySqlParameter("@OldVAT",MySqlDbType.Decimal); // prmOldVAT.Value = OldVAT; // cmd.Parameters.Add(prmOldVAT); // base.ExecuteNonQuery(cmd); // MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction); // clsMatrixPackage.ChangeVAT(OldVAT, NewVAT); // ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); // clsProductVariationsMatrix.ChangeVAT(OldVAT, NewVAT); // ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction); // clsProductPackage.ChangeVAT(OldVAT, NewVAT); // } // catch (Exception ex) // { // // // { // // // // // } // throw base.ThrowException(ex); // } //} //// Dec 10, 2011 : Obsolete, change to ChangeTax //public void ChangeEVAT(decimal OldEVAT, decimal NewEVAT) //{ // try // { // string SQL = "UPDATE tblProducts SET " + // "EVAT = @NewEVAT " + // "WHERE EVAT = @OldEVAT;"; // // MySqlCommand cmd = new MySqlCommand(); // // // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // MySqlParameter prmNewEVAT = new MySqlParameter("@NewEVAT",MySqlDbType.Decimal); // prmNewEVAT.Value = NewEVAT; // cmd.Parameters.Add(prmNewEVAT); // MySqlParameter prmOldEVAT = new MySqlParameter("@OldEVAT",MySqlDbType.Decimal); // prmOldEVAT.Value = OldEVAT; // cmd.Parameters.Add(prmOldEVAT); // base.ExecuteNonQuery(cmd); // MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction); // clsMatrixPackage.ChangeEVAT(OldEVAT, NewEVAT); // ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); // clsProductVariationsMatrix.ChangeEVAT(OldEVAT, NewEVAT); // ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction); // clsProductPackage.ChangeEVAT(OldEVAT, NewEVAT); // } // catch (Exception ex) // { // // // { // // // // // } // throw base.ThrowException(ex); // } //} //// Dec 10, 2011 : Obsolete, change to ChangeTax //public void ChangeLocalTax(decimal OldLocalTax, decimal NewLocalTax) //{ // try // { // string SQL = "UPDATE tblProducts SET " + // "LocalTax = @NewLocalTax " + // "WHERE LocalTax = @OldLocalTax;"; // // MySqlCommand cmd = new MySqlCommand(); // // // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // MySqlParameter prmNewLocalTax = new MySqlParameter("@NewLocalTax",MySqlDbType.Decimal); // prmNewLocalTax.Value = NewLocalTax; // cmd.Parameters.Add(prmNewLocalTax); // MySqlParameter prmOldLocalTax = new MySqlParameter("@OldLocalTax",MySqlDbType.Decimal); // prmOldLocalTax.Value = OldLocalTax; // cmd.Parameters.Add(prmOldLocalTax); // base.ExecuteNonQuery(cmd); // MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction); // clsMatrixPackage.ChangeLocalTax(OldLocalTax, NewLocalTax); // ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); // clsProductVariationsMatrix.ChangeLocalTax(OldLocalTax, NewLocalTax); // ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction); // clsProductPackage.ChangeLocalTax(OldLocalTax, NewLocalTax); // } // catch (Exception ex) // { // // // { // // // // // } // throw base.ThrowException(ex); // } //} /// <summary> /// Update Products VAT, EVAT and LocalTax /// This will also update ProductPackage, ProductVariationsMatrix and MatrixPackage /// </summary> /// <param name="ProductGroupID"></param> /// <param name="ProductSubGroupID"></param> /// <param name="ProductID"></param> /// <param name="NewVAT"></param> /// <param name="NewEVAT"></param> /// <param name="NewLocalTax"></param> public void ChangeTax(long ProductGroupID, long ProductSubGroupID, long ProductID, decimal NewVAT, decimal NewEVAT, decimal NewLocalTax, string CreatedBy) { try { ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction); clsProductPackage.ChangeTax(ProductGroupID, ProductSubGroupID, ProductID, NewVAT, NewEVAT, NewLocalTax, CreatedBy); } catch (Exception ex) { throw base.ThrowException(ex); } }