• PASSION CAMPING CAR
• PASSION CAMPING CAR LIBOURNE

Connect SQL server

81.93.244.139

---

Setup_CreateBDGp

@sBDGpNew : BDGpPassionccV4, @sBDGpModele : BD_GpModele4_Loisirs

1

---

Connect SQL server

81.93.244.137

---

Setup_InsertBDREF3

@sNomGroupeV4 : PassionccV4, @sBDGpNew : BDGpPassionccV4, @sURL_eSeller : passioncc.e-seller.selectup.com, @sURL_ServeurPub : passioncc.serveurpub.selectup.com, @sURL_BackOffice : passioncc.backoffice.selectup.com, @sURL_Reporting : passioncc.reporting.selectup.com, @iIDActivite : 4, @iIDTypeProduit : 1, @iFAM_FactureeSeller : 1, @sNomServeur : PROD-CRM-SQL3

---

Setup_PlaqueInsert

@iIDActivite : 4, @sNomSociete : PASSION CAMPING CAR, @sListeMailsCompte : contact@passioncc.fr, @sListeMarque : BURSTNER

1

---

Setup_SiteInsert

@iIDPlaque : 1, @sCodeSite : Bergerac, @sNomSite : PASSION CAMPING CAR, @sAdresse1 : Le Petit Brousse, @sAdresse2 : 74 Chemin de la Sabatière, @sCP : 24100, @sVille : Bergerac, @sEMail : contact@passioncc.fr, @sTel : 05 53 24 37 57, @sFax : , @iTypeSite : 1

1

---

Setup_PeopleInsert

@iIDSite : 1, @iDRPROFILE_ID : 1, @sNom : LOUGRAT, @sPrenom : Cédric, @sLogin : clougrat, @sPassword : 1234, @bAccesESeller : 1, @sEmail : cedric.lougrat@passioncc.fr, @sTelFixe : , @sTelPortable : 06 87 45 23 37, @bReceptionneLeads : 1, @sCodeVendeurNissan : , @sSrvBDRefNissan :

1

---

Setup_PlaqueInsert

@iIDActivite : 4, @sNomSociete : PASSION CAMPING CAR LIBOURNE, @sListeMailsCompte : contactlibourne@passioncc.fr, @sListeMarque : BURSTNER

2

---

Setup_SiteInsert

@iIDPlaque : 2, @sCodeSite : Libourne, @sNomSite : PASSION CAMPING CAR LIBOURNE, @sAdresse1 : ZA des Dagueys 2, @sAdresse2 : 5 rue François Vidal, @sCP : 33500, @sVille : Libourne, @sEMail : contactlibourne@passioncc.fr, @sTel : 05 57 55 24 87, @sFax : , @iTypeSite : 1

2

---

Setup_PeopleInsert

@iIDSite : 2, @iDRPROFILE_ID : 1, @sNom : LOUGRAT, @sPrenom : Carole, @sLogin : carolelou, @sPassword : 1234, @bAccesESeller : 1, @sEmail : carole.lougrat@passioncc.fr, @sTelFixe : , @sTelPortable : 06 09 49 58 35, @bReceptionneLeads : 1, @sCodeVendeurNissan : , @sSrvBDRefNissan :

2

---

Setup_DeleteLignesModele

1

---

Resume Plaque & Site

SELECT p.IDPlaque, p.Libelle AS Plaque, s.IDSite, s.Descr AS Site FROM Plaque p LEFT OUTER JOIN SITE s ON p.IDPlaque = s.IDPlaque ORDER BY p.IDPlaque, s.IDSite;

IDPlaque	Plaque	IDSite	Site
1	PASSION CAMPING CAR	1	PASSION CAMPING CAR
2	PASSION CAMPING CAR LIBOURNE	2	PASSION CAMPING CAR LIBOURNE

---

Resume People

SELECT pl.Libelle AS Societe, s.Descr AS Site, p.Lastname, p.Firstname, p.LoginWEB, p.Password FROM PEOPLE p LEFT OUTER JOIN Site_People sp ON p.IDCompany = sp.IDCompany AND p.IDPeople = sp.IDPeople LEFT OUTER JOIN SITE s ON sp.IDCompany = s.IDCompany AND sp.IDSite = s.IDSite LEFT OUTER JOIN Plaque pl ON s.IDPlaque = pl.IDPlaque ORDER BY p.IDPeople;

Societe	Site	Lastname	Firstname	LoginWEB	Password
		Passerelle(1)		pass1	pass1
PASSION CAMPING CAR	PASSION CAMPING CAR	LOUGRAT	Cédric	clougrat	1234
PASSION CAMPING CAR LIBOURNE	PASSION CAMPING CAR LIBOURNE	LOUGRAT	Carole	carolelou	1234

---

AddUrlToIIS

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/"> <soapenv:Header/> <soapenv:Body> <tem:ConfigIIS> <tem:sNomSiteCRM>passioncc.e-seller.selectup.com</tem:sNomSiteCRM> <tem:sNomSiteBackoffice>passioncc.backoffice.selectup.com</tem:sNomSiteBackoffice> <tem:sNomSitePub>passioncc.serveurpub.selectup.com</tem:sNomSitePub> <tem:sNomSiteReporting>passioncc.reporting.selectup.com</tem:sNomSiteReporting> <tem:isNissan>0</tem:isNissan> </tem:ConfigIIS> </soapenv:Body> </soapenv:Envelope>

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><ConfigIISResponse xmlns="http://tempuri.org/"><ConfigIISResult>2</ConfigIISResult></ConfigIISResponse></s:Body></s:Envelope>

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><ConfigIISResponse xmlns="http://tempuri.org/"><ConfigIISResult>2</ConfigIISResult></ConfigIISResponse></s:Body></s:Envelope>

---