public async Task <Model_Contact> LoadUserAtelier_ByID(int idContact)
{
var objContact = new Model_Contact();
objContact = await(from contact in _context.Contact
join contact_Civilite in _context.ContactCivilite on contact.Idcivilite equals contact_Civilite.Idcivilite
join liste_Fonction in _context.Liste_Fonction on contact.IdlisteFonction equals liste_Fonction.IDListeFonction
join photoID in _context.Liste_Contact_PhotoID on contact.Idutilisateur equals photoID.IDContact
where contact.Idcontact == idContact && contact.Idstatut == 11
select new Model_Contact()
{
Idcontact = contact.Idcontact,
PrenomContact = contact.PrenomContact,
NomContact = contact.NomContact,
EmailContact = contact.EmailContact,
TelephoneContact = contact.TelephoneContact,
FonctionContact = contact.FonctionContact,
PortableContact = contact.PortableContact,
Idcivilite = contact.Idcivilite,
FonctionGeneriqueAbrege = liste_Fonction.FonctionGeneriqueAbrege,
FonctionGenerique = liste_Fonction.FonctionGenerique,
IDTypeFonction = liste_Fonction.IDTypeFonction,
IDListeFonction = contact.IdlisteFonction,
PhotoUrl = photoID.UrlPhoto
}).FirstOrDefaultAsync();
return(objContact);
}
// 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);
}
}
private async Task EmailToCustomerAsync(Model_Contact model)
{
var mailBody = System.IO.File.ReadAllText(Server.MapPath(ConfigurationManager.AppSettings["templateConfirmation"]));
mailBody = mailBody.Replace("??FIRSTNAME??", model.Name);
using (var message = new MailMessage(_systemEmail, model.Email))
{
message.Sender = new MailAddress(_systemEmail);
message.Subject = "Your enquiry on the Janper website";
message.IsBodyHtml = true;
message.Body = mailBody;
await _smtpClient.SendMailAsync(message);
}
}
private async Task EmailToStaffAsync(Model_Contact model)
{
var mailBody = System.IO.File.ReadAllText(Server.MapPath(ConfigurationManager.AppSettings["templateNotification"]));
mailBody = mailBody.Replace("??FIRSTNAME??", model.Name);
mailBody = mailBody.Replace("??EMAIL??", model.Email);
mailBody = mailBody.Replace("??PHONE??", model.Phone);
mailBody = mailBody.Replace("??COMMENTS??", model.AdditionalComments);
using (var message = new MailMessage(_systemEmail, _receptionEmail))
{
message.Subject = "New enquiry from the Janper website";
message.IsBodyHtml = true;
message.Body = mailBody;
await _smtpClient.SendMailAsync(message);
}
}
public async Task <IActionResult> Update_Atelier([FromBody] Model_Contact obj)
{
try
{
var DA = new ContactDA(_context);
var res = DA.Update_Atelier(obj);
await Task.WhenAll(res);
if (res.Result == 1)
{
return(Ok(new ApiResultDTO(1)));
}
else
{
return(BadRequest(new ApiResultDTO(0, "400", "Bad Request")));
}
}
catch (Exception err)
{
return(BadRequest(new ApiResultDTO(0, "400", err.ToString())));
}
}
public async Task <ActionResult> ContactPost(Model_Contact model)
{
if (ModelState.IsValid && IsHuman())
{
try
{
//Email to customer
await EmailToCustomerAsync(model);
//email to staff
await EmailToStaffAsync(model);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(PartialView("_Enquiries", model));
}
else
{
return(PartialView("_Enquiries", model));
}
}
public ActionResult Index(Model_Contact form_data)
{
return(View(form_data));
}
// 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);
}
}