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