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