public async Task DoWorkAsync(List <Articoli> lst, string percorso, int numRecord, string conNection)
{
try
{
/*<h2 >Articoli carenti INTERNI </h2>*/
var impoMail = GetMailImpo(1, conNection);
string textBody = "<h2 >ARTICOLI LAVORATI carenti </h2> <br/> <table border=" + 1 + " cellpadding=" + 0 + " cellspacing=" + 0 + " width = " + 700 + " style='border: 0.5px;'><tr bgcolor='#4da6ff'><td style='width:15%; text-align: center;'><b>Cod Articolo</b></td> <td style='text-align: center;'> <b> Descrizione</b> </td><td style='text-align: center;'><b>Min Maga</b></td> <td style='text-align: center;'> <b> Q.T.</b> </td></tr>";
foreach (var l in lst.Where(c => c.ArtInternoEsterno == 1))
{
textBody += "<tr><td>" + l.IdArticolo + "</td><td> " + l.DescriArticolo + "</td><td>" + l.MinMagazzino + "</td><td> " + l.QuantiInMagazzino + "</td> </tr>";
}
textBody += "</table> <br/>";
textBody += "<h2 >MATERIALI di CONSUMO carenti </h2> <br/> <table border=" + 1 + " cellpadding=" + 0 + " cellspacing=" + 0 + " width = " + 700 + " style='border: 0.5px;'><tr bgcolor='#4da6ff'><td style='width:15%; text-align: center;'><b>Cod Articolo</b></td> <td style='text-align: center;'> <b> Descrizione</b> </td><td style='text-align: center;'><b>Min Maga</b></td> <td style='text-align: center;'> <b> Q.T.</b> </td></tr>";
foreach (var l in lst.Where(c => c.ArtInternoEsterno == 0))
{
textBody += "<tr><td>" + l.IdArticolo + "</td><td> " + l.DescriArticolo + "</td><td>" + l.MinMagazzino + "</td><td> " + l.QuantiInMagazzino + "</td> </tr>";
}
textBody += "</table>";
await SendMailAsyncNew(impoMail, textBody, numRecord, conNection);
}
catch (Exception e)
{
//salvo il log della spedizione effettuata
var conMail = new MaylUtilityDac("System.Data.SqlClient", conNection);
conMail.SaveMailLog($"ERRORE: {e.Message} - SOURCE: {e.Source}", 0, 1);
}
}
public async Task SendMailAsyncNew(MailDto impoMail, string txtBody, int numRecord, string conNection)
{
var conMail = new MaylUtilityDac("System.Data.SqlClient", conNection);
var mailLog = new MailLogDto();
mailLog.Data = DateTime.Now;
try
{
var mail = new System.Net.Mail.MailMessage();
var smtpServer = new SmtpClient();
mail.SubjectEncoding = System.Text.Encoding.UTF8;
mail.BodyEncoding = System.Text.Encoding.UTF8;
mail.IsBodyHtml = true;
smtpServer.Host = impoMail.SmtPostaUscita;
if (impoMail.UseDefaultCredential != null)
{
smtpServer.UseDefaultCredentials = (bool)impoMail.UseDefaultCredential;
}
smtpServer.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpServer.Port = impoMail.SmtpPort;
smtpServer.Credentials = new System.Net.NetworkCredential(impoMail.UserMail, impoMail.Password);
if (impoMail.SsLAuto != null)
{
smtpServer.EnableSsl = (bool)impoMail.SsLAuto;
}
mail.From = new MailAddress(impoMail.UtenteFiguraInvio, impoMail.NominativoInvio);
List <string> destinatario = new List <string>();
if (impoMail.Destinatario != null)
{
destinatario = impoMail.Destinatario.Split(';').Select(s => s.Replace(";", "")).ToList();
}
if (!string.IsNullOrEmpty(impoMail.DestinatarioLst) && impoMail.DestinatarioLst.Length > 0)
{
destinatario.AddRange(impoMail.DestinatarioLst.Split(';').Select(s => s.Replace(";", "")).ToList());
}
if (destinatario.Count > 0)
{
foreach (var dest in destinatario)
{
if (!string.IsNullOrEmpty(dest.Trim()))
{
mail.To.Add(dest.Trim());
}
}
}
var destinatarioCc = impoMail.Cc.Split(';').Select(s => s.Replace(";", "")).ToList();
foreach (var dest in destinatarioCc)
{
if (!string.IsNullOrEmpty(dest.Trim()))
{
mail.CC.Add(dest.Trim());
}
}
mail.Subject = impoMail.Oggetto;
var bd = impoMail.Messaggio.Length > 3850 ? impoMail.Messaggio.Substring(0, 3850) : impoMail.Messaggio; //limito la lunghezza del mesaggio
bd += "<br /> <br />";
bd += $"<b>Numero Articoli trovati:{numRecord}</b>";
bd += "<br /> <br />";
bd += txtBody;
mail.Body = bd;
mailLog.Commenti = $"Invio file a {impoMail.Destinatario} Lista {impoMail.DestinatarioLst}; CC {impoMail.Cc}; messaggio: { impoMail.Messaggio}; ";
mail.Priority = MailPriority.High;
await smtpServer.SendMailAsync(mail);
mailLog.Esito = 1;
}
catch (Exception ex)
{
mailLog.Commenti =
$"Invio file a {impoMail.Destinatario} - Lista {impoMail.DestinatarioLst}; Errore: {ex.Message}";
mailLog.Esito = 0;
}
//salvo il log della spedizione effettuata
conMail.SaveMailLog(mailLog.Commenti, mailLog.Esito, mailLog.Tipo);
}