void createHistoryRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DateTime createDate = (DateTime)e.Item.DataItem; Label createDateLabel = (Label)e.Item.FindControl("createDateLabel"); Label quantityLabel = (Label)e.Item.FindControl("quantityLabel"); CertificateNumberTableAdapter certificateNumberAdapter = new CertificateNumberTableAdapter(); int quantity = certificateNumberAdapter.GetByCertificateAndCreateDate(certificateId, createDate).Count; createDateLabel.Text = createDate.ToString("MM/dd/yyyy"); quantityLabel.Text = quantity.ToString(); } }
void emailButton_Click(object sender, EventArgs e) { String emailAddress = emailBox.Text.Trim(); if (emailAddress == String.Empty) { return; } RegexStringValidator regex = new RegexStringValidator(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"); try { regex.Validate(emailAddress); } catch { ErrorMessage = "E-mail address is not valid"; return; } String createDateStr = String.Empty; createDateStr = createDateList.SelectedValue; DollarSaverDB.CertificateNumberDataTable certificateNumbers; if (createDateStr == String.Empty) { certificateNumbers = certificate.AllNumbers; createDateStr = "All Dates"; } else { DateTime createDate = DateTime.Now; try { createDate = Convert.ToDateTime(createDateStr); createDateStr = createDate.ToString("MM/dd/yyyy"); } catch { ErrorMessage = "Create Date must by in the format MM/DD/YYYY"; return; } CertificateNumberTableAdapter certificateNumberAdapter = new CertificateNumberTableAdapter(); certificateNumbers = certificateNumberAdapter.GetByCertificateAndCreateDate(certificateId, createDate); } //MailMessage message = new MailMessage("*****@*****.**", "*****@*****.**"); MailMessage message = new MailMessage("\"DollarSaver\" <*****@*****.**>", emailAddress); message.IsBodyHtml = true; message.Subject = "Certificate Numbers For " + certificate.AdvertiserName; String body = "<html><body><span style=\"font-family: Verdana; font-size: 12pt;\">"; /* * body += "<table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"550px\">" + Environment.NewLine + * "<tr><td align=\"center\" style=\"font-size: 18pt;\">Advertiser: " + certificate.Advertiser.Name + "</td></tr>" + Environment.NewLine + * "<tr><td align=\"center\"><HR width=\"100%\" ></td></tr>" + Environment.NewLine + * "<tr><td align=\"left\">Station: " + Station.Name + "</td></tr>" + Environment.NewLine + * "<tr><td align=\"left\">Certificate: " + certificate.ShortName + "</td></tr>" + Environment.NewLine + * "<tr><td align=\"left\">Create Date: " + createDateStr + "</td></tr>" + Environment.NewLine + * "<tr><td align=\"left\">Quantity: " + certificateNumbers.Count + "</td></tr>" + Environment.NewLine + * "<tr><td align=\"center\"><HR width=\"100%\" ></td></tr>" + Environment.NewLine + * "<tr><td align=\"center\" style=\"font-size: 18pt;\"><U>CERTIFICATE NUMBERS</U></td></tr>" + Environment.NewLine + * "<tr><td align=\"center\"><B>Cross out number when certificate is redeemed</B></td></tr>" + Environment.NewLine + * "<tr><td align=\"center\"><B>--> Read numbers Left to Right --></B></td></tr>" + * "<tr><td align=\"center\"><HR width=\"100%\" ></td></tr>" + Environment.NewLine; */ body += "<table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"550px\">" + Environment.NewLine + "<tr><td align=\"center\" style=\"font-size: 14pt;\">" + certificateNumbers.Count + " Certificate Numbers for " + certificate.Advertiser.Name + "</td></tr>" + Environment.NewLine + "<tr><td align=\"center\" style=\"font-size: 10pt;\">Certificate: " + certificate.ShortName + "</td></tr>" + Environment.NewLine + "<tr><td align=\"center\" style=\"font-size: 8pt;\"><B>Cross out number when certificate is redeemed</B> --> Read numbers Left to Right --></B></td></tr>" + "<tr><td align=\"center\"><HR width=\"100%\" ></td></tr>" + Environment.NewLine; body += "<tr><td><table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">"; for (int i = 0; i < certificateNumbers.Count; i += 3) { body += "<tr><td style=\"font-size: 20pt\" align=\"center\">" + certificateNumbers[i].Number + "</td>" + Environment.NewLine; if (i + 1 < certificateNumbers.Count) { body += "<td style=\"font-size: 20pt\" align=\"center\">" + certificateNumbers[i + 1].Number + "</td>" + Environment.NewLine; } else { body += "<td style=\"font-size: 20pt\" align=\"center\"> </td>" + Environment.NewLine; } if (i + 2 < certificateNumbers.Count) { body += "<td style=\"font-size: 20pt\" align=\"center\">" + certificateNumbers[i + 2].Number + "</td></tr>" + Environment.NewLine; } else { body += "<td style=\"font-size: 20pt\" align=\"center\"> </td></tr>" + Environment.NewLine; } } body += "</table></tr></td>"; body += "<tr><td align=\"center\"><HR width=\"100%\" ></td></tr></table></body></html>"; // end message with a <CRLF>.<CRLF> ?? message.Body = body; bool success = false; try { //SmtpClient smtp = new SmtpClient("localhost", 25); //smtp.Send(message); Mailer mailer = new Mailer(); mailer.Send(message); InfoMessage = "Certificate Numbers sent to: " + emailAddress; success = true; } catch (Exception ex) { ErrorMessage = "Error Sending E-mail: " + ex.Message; } if (success) { Response.Redirect("~/admin/CertificateEdit.aspx?id=" + certificateId); } }