private void BindIssues()
{
IssueTableAdapter issueAdapter = new IssueTableAdapter();
DollarSaverDB.IssueDataTable issues;
if (openIssues)
{
issues = issueAdapter.GetOpen();
}
else
{
issues = issueAdapter.GetClosed();
}
if (issues.Count > 0)
{
issueHolder.Visible = true;
noDataFoundHolder.Visible = false;
issueGrid.DataSource = issues.Rows;
issueGrid.DataBind();
}
else
{
issueHolder.Visible = false;
noDataFoundHolder.Visible = true;
}
}
private void BindData()
{
IssueTableAdapter issueAdapter = new IssueTableAdapter();
DollarSaverDB.IssueDataTable openIssues = issueAdapter.GetOpen();
if (openIssues.Count > 0)
{
issueLink.Text = "Issues (" + openIssues.Count.ToString() + ")";
}
else
{
issueLink.Text = "Issues";
}
}
private void Form_Report_Load(object sender, EventArgs e)
{
DataSet_Exam myDataSet_Exam = new DataSet_Exam();
IssueTableAdapter myIssueTableAdapter = new IssueTableAdapter();
myIssueTableAdapter.Connection = new SqlConnection(Properties.Settings.Default.zwjConn);
myIssueTableAdapter.Fill(myDataSet_Exam.Issue);
ReportDataSource myReportDataSource = new ReportDataSource("ZCWelderSQL", myDataSet_Exam.Issue);
this.reportViewer_frame.LocalReport.DataSources.Clear();
this.reportViewer_frame.LocalReport.DataSources.Add(myReportDataSource);
this.reportViewer_frame.LocalReport.ReportEmbeddedResource = "ZCWelder.Report.焊工考试班级统计报表.rdlc";
this.reportViewer_frame.LocalReport.SetParameters(myReportParameterRange);
this.reportViewer_frame.RefreshReport();
}
void submitButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
String firstName = firstNameBox.Text.Trim();
String lastName = lastNameBox.Text.Trim();
String emailAddress = emailBox.Text.Trim();
String confirmEmailAddress = confirmEmailBox.Text.Trim();
int advertiserId = Convert.ToInt32(advertiserList.SelectedValue);
String orderIdStr = orderIdBox.Text.Trim();
String message = messageBox.Text.Trim();
if (firstName == String.Empty)
{
ErrorMessage = "First Name is required";
return;
}
else if (firstName.Length > 50)
{
firstName = firstName.Substring(0, 50);
}
if (lastName == String.Empty)
{
ErrorMessage = "Last Name is required";
return;
}
else if (lastName.Length > 50)
{
lastName = lastName.Substring(0, 50);
}
if (emailAddress == String.Empty)
{
ErrorMessage = "E-mail is required";
return;
}
if (emailAddress != confirmEmailAddress)
{
ErrorMessage = "E-mail address do not match";
return;
}
if (!Regex.IsMatch(emailAddress, @"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$"))
{
ErrorMessage = "E-mail address is not valid";
return;
}
int orderId = 0;
if (orderIdStr != String.Empty)
{
try {
orderId = Convert.ToInt32(orderIdStr);
if (orderId <= 0)
{
throw new Exception();
}
} catch {
ErrorMessage = "Order ID is not valid";
return;
}
}
if (message == String.Empty)
{
ErrorMessage = "Please enter a message";
return;
}
else if (message.Length > 5000)
{
message = message.Substring(0, 5000);
}
IssueTableAdapter issueAdapter = new IssueTableAdapter();
int issueId = Convert.ToInt32(issueAdapter.InsertPK(StationId, true, DateTime.Now, Globals.ConvertToNull(advertiserId), Globals.ConvertToNull(orderId),
message, emailAddress, firstName, lastName, null, null, null, null, null, null, null));
MailMessage emailMessage = new MailMessage("\"" + firstName + " " + lastName + "\" <" + emailAddress + ">",
"\"DollarSaver Help\" <*****@*****.**>");
emailMessage.IsBodyHtml = false;
emailMessage.Subject = Station.SiteNamePlainText + " DollarSaver Issue #" + issueId;
String body = Station.SiteNamePlainText + " DollarSaver Issue #" + issueId + Environment.NewLine + Environment.NewLine;
body += "From: " + firstName + " " + lastName + " - " + emailAddress + Environment.NewLine;
if (advertiserId > 0)
{
AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter();
DollarSaverDB.AdvertiserRow advertiser = advertiserAdapter.GetAdvertiser(advertiserId)[0];
body += "Advertiser: " + advertiser.Name + Environment.NewLine;
}
if (orderId > 0)
{
body += "Order #: " + orderId + Environment.NewLine;
}
body += Environment.NewLine + "Message:" + Environment.NewLine;
body += message;
emailMessage.Body = body;
try {
Mailer mailer = new Mailer();
mailer.Send(emailMessage);
} catch { }
InfoMessage = "Thank you for your message. You should receive a response within 48 hours.";
DollarSaverRedirect("~/Default.aspx");
}
}
