public void WriteDateToDate(PsProduct Obj)
{
String TxtSQL = "update ps_specific_price "
+ " set ps_specific_price.from = '0000-00-00 00:00:00', "
+ " ps_specific_price.to = '0000-00-00 00:00:00' "
+ " where id_product = " + Obj.IDProduct;
if (Core.Global.GetConfig().ArticleFiltreDatePrixPrestashop)
{
TxtSQL += " and ps_specific_price.from = '0001-01-01 00:00:00' "
+ " and ps_specific_price.to = '0001-01-01 00:00:00' ";
}
this.DBPrestashop.ExecuteCommand(TxtSQL);
}
public void WriteReductionType(PsProduct Obj)
{
String TxtSQL = "update ps_specific_price "
+ " set ps_specific_price.reduction_type = 'percentage' "
+ " where id_product = " + Obj.IDProduct
+ " and reduction <> 0 ";
if (Core.Global.GetConfig().ArticleFiltreDatePrixPrestashop)
{
TxtSQL += " and ps_specific_price.from = '0001-01-01 00:00:00' "
+ " and ps_specific_price.to = '0001-01-01 00:00:00' ";
}
this.DBPrestashop.ExecuteCommand(TxtSQL);
}
public void Add(PsProduct Obj, UInt32 IDShop)
{
this.DBPrestashop.PsProduct.InsertOnSubmit(Obj);
this.Save();
//Si le produit n'existe pas dans la boutique, il est rajouté.
if (!ExistInShop(Obj.IDProduct, IDShop))
{
DBPrestashop.PsProductShop.InsertOnSubmit(new PsProductShop()
{
Active = Obj.Active,
AdditionalShippingCost = Obj.AdditionalShippingCost,
AdvancedStockManagement = Obj.AdvancedStockManagement,
AvailableDate = Obj.AvailableDate,
AvailableForOrder = Obj.AvailableForOrder,
CacheDefaultAttribute = Obj.CacheDefaultAttribute,
Customizable = Obj.Customizable,
DateAdd = Obj.DateAdd,
DateUpd = Obj.DateUpd,
EcOtAx = Obj.EcOtAx,
IDCategoryDefault = Obj.IDCategoryDefault,
IDProduct = Obj.IDProduct,
IDShop = IDShop,
IDTaxRulesGroup = Obj.IDTaxRulesGroup,
Indexed = Obj.Indexed,
MinimalQuantity = Obj.MinimalQuantity,
OnlineOnly = Obj.OnlineOnly,
OnSale = Obj.OnSale,
Price = Obj.Price,
ShowPrice = Obj.ShowPrice,
TextFields = Obj.TextFields,
UnitPriceRatio = Obj.UnitPriceRatio,
Unity = Obj.Unity,
UploadAbleFiles = Obj.UploadAbleFiles,
WholesalePrice = Obj.WholesalePrice,
#if (PRESTASHOP_VERSION_161 || PRESTASHOP_VERSION_172)
PackStockType = Obj.PackStockType,
#endif
});
DBPrestashop.SubmitChanges();
}
}
