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