public void Sync(Model.Local.Customer Customer)
{
this.Semaphore.WaitOne();
try
{
Model.Sage.F_COMPTETRepository F_COMPTETRepository = new Model.Sage.F_COMPTETRepository();
if (F_COMPTETRepository.ExistId(Customer.Sag_Id))
{
Model.Sage.F_COMPTET F_COMPTET = new Model.Sage.F_COMPTET();
Model.Prestashop.PsAECCustomerPayementRepository PsAECPayementRepository = new Model.Prestashop.PsAECCustomerPayementRepository();
Model.Prestashop.PsAEcCustomerPayement PsAEcPayement = new Model.Prestashop.PsAEcCustomerPayement();
F_COMPTET = F_COMPTETRepository.Read(Customer.Sag_Id);
List <Model.Sage.F_REGLEMENTT> ListF_REGLEMENTT = new Model.Sage.F_REGLEMENTTRepository().ListCLient(F_COMPTET.CT_Num);
// <JG> 05/03/2015 ajout suppression de prestashop ni modèle n'existe plus dans Sage
IQueryable <Model.Prestashop.PsAEcCustomerPayement> ListCustomerPayement = PsAECPayementRepository.ListCustomer((uint)Customer.Pre_Id);
foreach (Model.Prestashop.PsAEcCustomerPayement PsAEcCustomerPayement in ListCustomerPayement)
{
if (ListF_REGLEMENTT.Count(rg => rg.cbMarq == (int)PsAEcCustomerPayement.IDSage) == 0)
{
PsAECPayementRepository.Delete(PsAEcCustomerPayement);
}
}
foreach (Model.Sage.F_REGLEMENTT F_REGLEMENTT in ListF_REGLEMENTT)
{
PsAEcPayement = new Model.Prestashop.PsAEcCustomerPayement();
PsAECPayementRepository = new Model.Prestashop.PsAECCustomerPayementRepository();
if (PsAECPayementRepository.ExistCustomerPayement((uint)Customer.Pre_Id, (uint)F_REGLEMENTT.cbMarq))
{
PsAEcPayement = PsAECPayementRepository.ReadCustomerPayement((uint)Customer.Pre_Id, (uint)F_REGLEMENTT.cbMarq);
PsAEcPayement.Payement = ReadPayement(F_REGLEMENTT.cbMarq);
PsAECPayementRepository.Save();
}
else
{
PsAEcPayement.IDCustomer = (uint)Customer.Pre_Id;
PsAEcPayement.IDSage = (uint)F_REGLEMENTT.cbMarq;
PsAEcPayement.Payement = ReadPayement(F_REGLEMENTT.cbMarq);
PsAECPayementRepository.Add(PsAEcPayement);
}
}
}
}
catch (Exception ex)
{
Core.Error.SendMailError(ex.ToString());
}
lock (this)
{
this.CurrentCount += 1;
}
this.ReportProgress(this.CurrentCount * 100 / this.ListCount);
this.Semaphore.Release();
}
public void Delete(PsAEcCustomerPayement Obj)
{
String TxtSQL = "delete from ps_aec_customer_payement where id_customer = " + Obj.IDCustomer + " AND Sag_Id = " + Obj.IDSage;
this.DBPrestashop.ExecuteCommand(TxtSQL);
// not working ...
//this.DBPrestashop.PsAEcCustomerPayement.DeleteOnSubmit(Obj);
}
public void Add(PsAEcCustomerPayement Obj)
{
this.DBPrestashop.PsAEcCustomerPayement.InsertOnSubmit(Obj);
this.Save();
}
