// Update participants in table Contact with IdStatus = 10 public async Task <int> Update_Atelier(Model_Contact objContact) { var obj_Contact = new db.Contact(); try { var idcontact = objContact.Idcontact; obj_Contact = await _context.Contact.FirstOrDefaultAsync(x => x.Idcontact == idcontact && x.Idstatut == 11); if (obj_Contact.Idcontact > 0) { obj_Contact.PrenomContact = objContact.PrenomContact; obj_Contact.NomContact = objContact.NomContact; obj_Contact.TelephoneContact = objContact.TelephoneContact; obj_Contact.FonctionContact = objContact.FonctionContact; obj_Contact.EmailContact = objContact.EmailContact; obj_Contact.IdlisteFonction = objContact.IDListeFonction; obj_Contact.PortableContact = objContact.PortableContact; obj_Contact.Idcivilite = Convert.ToByte(objContact.Idcivilite); // update societe await _context.SaveChangesAsync(); return(1); } else { return(0); } } catch (System.Exception) { return(0); } }
public async Task <int> Insert_MediathequeDocument(int idContact, string nomDocument, string extension) { var contact = new db.Contact(); var objDocument = new db.MediathequeDocument(); try { contact = await _context.Contact.FirstOrDefaultAsync(x => x.Idcontact == idContact); objDocument.IdtypeDocument = 34038; // type of img objDocument.Idsociete = contact.Idsociete; objDocument.IdenqueteSociete = 0; objDocument.NomDocument = nomDocument; objDocument.Extension = extension; objDocument.Taille = 0; objDocument.Idstatut = 0; objDocument.DateMaj = DateTime.Now; objDocument.DateCreation = DateTime.Now; objDocument.Idutilisateur = contact.Idutilisateur; objDocument.IdlisteService = 0; objDocument.IdlisteSousService = 0; objDocument.Commentaire = ""; _context.MediathequeDocument.Add(objDocument); _context.SaveChanges(); return(1); } catch (System.Exception) { return(0); } }
public async Task <int> Delete_Atelier(int Idcontact) { var objContact = new db.Contact(); objContact = await _context.Contact.FirstOrDefaultAsync(x => x.Idcontact == Idcontact && x.Idstatut == 11); if (objContact != null) { _context.Contact.Remove(objContact); _context.SaveChanges(); return(1); } else { return(0); } }
// 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); } }