// 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);
}
}
