public void sendAttachedFile(dbData3060 p_dbData3060, string filename, byte[] data, bool bTilPBS)
{
string local_filename = filename.Replace('.', '_') + ".txt";
string SmtpUsername = p_dbData3060.GetSysinfo("SMTPUSER");
string SmtpPassword = p_dbData3060.GetSysinfo("SMTPPASSWD");
var smtp = new SmtpClient
{
Host = p_dbData3060.GetSysinfo("SMTPHOST"),
Port = int.Parse(p_dbData3060.GetSysinfo("SMTPPORT")),
EnableSsl = bool.Parse(p_dbData3060.GetSysinfo("SMTPSSL")),
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(SmtpUsername, SmtpPassword)
};
MailMessage email = new MailMessage();
if (bTilPBS)
{
#if (DEBUG)
email.Subject = "Test Til PBS: " + local_filename;
email.Body = "Test Til PBS: " + local_filename;
#else
email.Subject = "Til PBS: " + local_filename;
email.Body = "Til PBS: " + local_filename;
#endif
}
else
{
#if (DEBUG)
email.Subject = "Test Fra PBS: " + local_filename;
email.Body = "Test Fra PBS: " + local_filename;
#else
email.Subject = "Fra PBS: " + local_filename;
email.Body = "Fra PBS: " + local_filename;
#endif
}
email.To.Add(new MailAddress(p_dbData3060.GetSysinfo("MAILTOADDR"), p_dbData3060.GetSysinfo("MAILTONAME")));
email.From = new MailAddress(p_dbData3060.GetSysinfo("MAILFROM"));
email.ReplyToList.Add(new MailAddress(p_dbData3060.GetSysinfo("MAILREPLY")));
email.Attachments.Add(new Attachment(new MemoryStream(data), local_filename, "text/plain"));
smtp.Send(email);
}
public void overfoersel_mail(dbData3060 p_dbData3060, int lobnr)
{
var antal = (from c in p_dbData3060.tbltilpbs
where c.id == lobnr
select c).Count();
if (antal == 0)
{
throw new Exception("101 - Der er ingen PBS forsendelse for id: " + lobnr);
}
string SmtpUsername = p_dbData3060.GetSysinfo("SMTPUSER");
string SmtpPassword = p_dbData3060.GetSysinfo("SMTPPASSWD");
var smtp = new SmtpClient
{
Host = p_dbData3060.GetSysinfo("SMTPHOST"),
Port = int.Parse(p_dbData3060.GetSysinfo("SMTPPORT")),
EnableSsl = bool.Parse(p_dbData3060.GetSysinfo("SMTPSSL")),
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(SmtpUsername, SmtpPassword)
};
var qrykrd = from k in p_dbData3060.tblMedlem
join h in p_dbData3060.tbloverforsel on k.Nr equals h.Nr
where h.tilpbsid == lobnr
select new
{
k.Nr,
k.Email,
k.Kaldenavn,
k.Navn,
h.betalingsdato,
h.advistekst,
h.advisbelob,
h.bankregnr,
h.bankkontonr,
};
// Start loop over betalinger i tbloverforsel
int testantal = qrykrd.Count();
foreach (var krd in qrykrd)
{
// Create a new email object
MailMessage email = new MailMessage();
#if (DEBUG)
email.Subject = "TEST Bankoverførsel fra Puls 3060: skal sendes til " + p_dbData3060.GetSysinfo("MAILTONAME") + " - " + p_dbData3060.GetSysinfo("MAILTOADDR");
email.To.Add(new MailAddress(p_dbData3060.GetSysinfo("MAILTOADDR"), p_dbData3060.GetSysinfo("MAILTONAME")));
#else
email.Subject = "Bankoverførsel fra Puls 3060";
if (krd.Email.Length > 0)
{
email.To.Add(new MailAddress(krd.Email, krd.Navn));
email.Bcc.Add(new MailAddress(p_dbData3060.GetSysinfo("MAILTOADDR"), p_dbData3060.GetSysinfo("MAILTONAME")));
}
else
{
email.Subject += ": skal sendes til " + krd.Navn;
email.To.Add(new MailAddress(p_dbData3060.GetSysinfo("MAILTOADDR"), p_dbData3060.GetSysinfo("MAILTONAME")));
}
#endif
email.Body = new clsInfotekst
{
infotekst_id = 40,
numofcol = null,
kaldenavn = krd.Kaldenavn,
betalingsdato = krd.betalingsdato,
advisbelob = krd.advisbelob,
bankkonto = krd.bankregnr + "-" + krd.bankkontonr,
advistekst = krd.advistekst,
underskrift_navn = "\r\nMogens Hafsjold\r\nRegnskabsfører"
}.getinfotekst(p_dbData3060);
email.From = new MailAddress(p_dbData3060.GetSysinfo("MAILFROM"));
email.ReplyToList.Add(new MailAddress(p_dbData3060.GetSysinfo("MAILREPLY")));
smtp.Send(email);
}
}
