public void Delete_Orderchosen(int IDEnqueteSociete, int idEnquete)
{
var objEnquete_Contact_Ex = new db.Enquete_Contact_Ex();
var obj = _context.Enquete_Contact_Ex.FirstOrDefault(x => x.IDEnqueteSociete == IDEnqueteSociete && x.IDIDEnquete == idEnquete);
if (obj != null)
{
var lst = _context.Enquete_Contact_Ex.Where(x => x.IDIDEnquete == idEnquete).ToList();
for (int i = obj.OrderLevel; i < lst.Count; i++)
{
var objSearch = _context.Enquete_Contact_Ex.FirstOrDefault(x => x.IDEnqueteSociete == lst[i].IDEnqueteSociete && x.IDIDEnquete == lst[i].IDIDEnquete);
objSearch.OrderLevel = objSearch.OrderLevel - 1;
}
_context.SaveChanges();
_context.Enquete_Contact_Ex.Remove(obj);
_context.SaveChanges();
}
}
// Insert, update Parametres_ServicePrograme
public async Task <int> InsertUpdate_Parametres(int IDParametreServicePrograme, int IDListeService, string Temps, string Titres, string Contenu)
{
var obj_Parametres = new db.Parametres_ServicePrograme();
try
{
var idParametreServicePrograme = IDParametreServicePrograme;
//If idParametreServicePrograme > 0 ? Update : Insert
if (idParametreServicePrograme > 0)
{
obj_Parametres = await _context.Parametres_ServicePrograme.FirstOrDefaultAsync(x => x.IDParametreServicePrograme == idParametreServicePrograme);
obj_Parametres.IDListeService = IDListeService;
obj_Parametres.Temps = Temps;
obj_Parametres.Titres = Titres;
obj_Parametres.Contenu = Contenu;
_context.SaveChanges();
return(1);
}
else
{
obj_Parametres.IDListeService = IDListeService;
obj_Parametres.Temps = Temps;
obj_Parametres.Titres = Titres;
obj_Parametres.Contenu = Contenu;
_context.Parametres_ServicePrograme.Add(obj_Parametres);
_context.SaveChanges();
return(1);
}
}
catch (System.Exception)
{
return(0);
}
}
// Insert Parameter
public async Task <string> Insert_Parameter(db.Liste_Parametres_Service obj)
{
try
{
var parametre = await _context.ParametresService.FirstOrDefaultAsync(x => x.IdparametreService == obj.IDListeService);
if (parametre == null)
{
var obj_Parameter = new db.ParametresService();
obj_Parameter.CodeSiteGoogleAnalytics = obj.CodeSiteGoogleAnalytics;
obj_Parameter.LienTweet = obj.Lien_Tweet;
obj_Parameter.LienLinkedin = obj.Lien_Linkedin;
obj_Parameter.LienFacebook = obj.Lien_Facebook;
// obj_Parameter.LienViadeoAsupprimer =
obj_Parameter.CallToAction = obj.CallToAction;
// obj_Parameter.IdresponsableVendeur=
obj_Parameter.IdadminCommunaute = obj.IDAdminCommunaute;
obj_Parameter.BackgroundColor = obj.BackgroundColor;
obj_Parameter.TypeEvenement = obj.TypeEvenement;
obj_Parameter.IdsiteEvenement = obj.IDSiteEvenement;
// obj_Parameter.BaseLine =
obj_Parameter.FonctionAchCible = obj.Fonction_ACH_Cible;
obj_Parameter.DefaultFolder = obj.Default_Folder;
obj_Parameter.ISActivePUB = obj.ISActivePUB;
obj_Parameter.ISActiveAterlie = obj.ISActiveAterlie;
obj_Parameter.ODCDate = obj.ODC_Date;
obj_Parameter.FDCDate = obj.FDC_Date;
obj_Parameter.MapLink = obj.MapLink;
obj_Parameter.MapBus = obj.MapBus;
obj_Parameter.MapCar = obj.MapCar;
obj_Parameter.MapPlane = obj.MapPlane;
//save file pub
obj_Parameter.PUBFileName = obj.PUB_FileName;
obj_Parameter.PUBFilePath = obj.PUB_FilePath;
obj_Parameter.PUBFileExtend = obj.PUB_FileExtend;
_context.ParametresService.Add(obj_Parameter);
_context.SaveChanges();
}
return("Succsess");
}
catch (System.Exception err)
{
return(err.ToString());
}
}
// Insert participants in table Contact with IdStatus = 10
public async Task <int> Insert_Contact(Model_Contact obj)
{
var contact = new db.Contact();
var objContact = new db.Contact();
try
{
var idcontact = obj.Idcontact;
if (idcontact > 0)
{
contact = await _context.Contact.FirstOrDefaultAsync(x => x.Idcontact == idcontact);
objContact.Acheteur = contact.Acheteur;
objContact.DateCreationContact = contact.DateCreationContact;
objContact.DateMajcontact = contact.DateMajcontact;
objContact.DateMajmanuelleContact = contact.DateMajmanuelleContact;
objContact.EmailContact = contact.EmailContact;
objContact.EmailContact2 = contact.EmailContact2;
objContact.FaxContact = contact.FaxContact;
objContact.FonctionContact = contact.FonctionContact;
objContact.Idcivilite = contact.Idcivilite;
objContact.Idcontact = 0;
objContact.IdlisteBase = contact.IdlisteBase;
objContact.IdlisteFonction = contact.IdlisteFonction;
objContact.IdnomContact = contact.IdnomContact;
objContact.Idsociete = contact.Idsociete;
objContact.Idstatut = 10;
objContact.IdtypeUtilisateur = contact.IdtypeUtilisateur;
objContact.Idutilisateur = contact.Idutilisateur;
objContact.IdutilisateurCreateur = contact.IdutilisateurCreateur;
objContact.ImportanceContact = contact.ImportanceContact;
objContact.ListeRougeFax = contact.ListeRougeFax;
objContact.ListeRougeMail = contact.ListeRougeMail;
objContact.ListeRougePortable = contact.ListeRougePortable;
objContact.ListeRougeTelephone = contact.ListeRougeTelephone;
objContact.Login = contact.Login;
objContact.MailCorrect = contact.MailCorrect;
objContact.MotdePasse = contact.MotdePasse;
objContact.NomContact = contact.NomContact;
objContact.NombreRefusEmail = contact.NombreRefusEmail;
objContact.OldIdcontact = contact.OldIdcontact;
objContact.PortableContact = contact.PortableContact;
objContact.PrenomContact = contact.PrenomContact;
objContact.TelephoneContact = contact.TelephoneContact;
objContact.Vendeur = contact.Vendeur;
_context.Contact.Add(objContact);
_context.SaveChanges();
return(objContact.Idcontact);
}
else
{
objContact.EmailContact = obj.EmailContact;
objContact.Idcivilite = Convert.ToByte(obj.Idcivilite);
objContact.Idcontact = 0;
objContact.FonctionContact = obj.FonctionContact;
objContact.IdlisteFonction = obj.IDListeFonction;
objContact.Idsociete = obj.IdSociete;
objContact.Idstatut = 10;
objContact.Idutilisateur = obj.Idutilisateur;
objContact.NomContact = obj.NomContact;
objContact.PortableContact = obj.PortableContact;
objContact.PrenomContact = obj.PrenomContact;
objContact.TelephoneContact = obj.TelephoneContact;
_context.Contact.Add(objContact);
_context.SaveChanges();
return(objContact.Idcontact);
}
}
catch (System.Exception)
{
return(0);
}
}
