/// <summary>
/// Send Mail, sends email about new ContentProvider (teacher) registration.
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
private string GetMailMessage(ContentProviderInfo entity)
{
//Subject line for e-mail.
StringBuilder strBody = new StringBuilder();
strBody.Append("<html><body>");
//Contact Information.
strBody.Append("<fieldset id='personal'>");
strBody.Append("<legend><b>Contact Information</b></legend>");
strBody.Append("<div><label for='firstname'><b>First name:</b></label> ");
strBody.Append(entity.FirstName);
strBody.Append(" </div>");
strBody.Append("<div><label for='lastname'><b>Last name:</b></label> ");
strBody.Append(entity.LastName);
strBody.Append(" </div>");
strBody.Append("<div><label for='day_phone'><b>Daytime Phone:</b></label> ");
strBody.Append(entity.DaytimePhone);
strBody.Append(" </div>");
strBody.Append(" </div>");
strBody.Append("<div><label for='eve_phone'><b>Evening Phone:</b></label> ");
strBody.Append(entity.EveningPhone);
strBody.Append(" </div>");
strBody.Append("<label for='email'>");
strBody.Append("<b>Email Address:</b></label> ");
strBody.Append(entity.EmailAddress);
strBody.Append("</fieldset>");
//Company Information.
strBody.Append("<fieldset id='company'>");
strBody.Append("<legend><b>Company Information</b></legend>");
strBody.Append("<div><label for='company_name'><b>Company Name:</b></label> ");
strBody.Append(entity.CompanyName);
strBody.Append(" </div>");
strBody.Append("<div><label for='company_city'><b>Company City:</b></label> ");
strBody.Append(entity.CompanyCity);
strBody.Append(" </div>");
strBody.Append("<div><label for='company_state'><b>Company State:</b></label> ");
strBody.Append(entity.CompanyState);
strBody.Append(" </div>");
strBody.Append("<div><label for='company_country'><b>Company Country:</b></label> ");
strBody.Append(entity.CompanyCountry);
strBody.Append(" </div>");
strBody.Append("<div><label for='company_started'><b>Started (year):</b></label> ");
strBody.Append(entity.CompanyStartedYear);
strBody.Append(" </div></fieldset>");
//Other Information.
strBody.Append("<fieldset id='other'>");
strBody.Append("<legend><b>Other Information</b></legend>");
strBody.Append("<div>");
strBody.Append("<label for='other_course_amt'>");
strBody.Append("<b>Do you have a merchant account ?</b></label> ");
strBody.Append(entity.HaveMerchantAccount.ToString().ToUpper());
strBody.Append(" </div>");
strBody.Append("<div><label for='other_course_amt'><b>How many students are you anticipating ?</b></label> ");
strBody.Append(entity.StudentsAnticipated);
strBody.Append(" </div>");
strBody.Append("<div><label for='other_course_amt'><b>How Many Courses are you planning on offering to your students?</b></label> ");
strBody.Append(entity.CoursesOffered);
strBody.Append(" </div>");
strBody.Append("<div><label for='other_course_amt'><b>What kind of material would you like to offer?</b></label> ");
strBody.Append("<br />");
strBody.Append("Financial Education, Specialized Training, Company Specific Training");
strBody.Append(" </div>");
strBody.Append("<div><label for='other_course_amt'><b>Would you like to schedule a demo of the system?</b></label> ");
strBody.Append(entity.ScheduleDemo);
strBody.Append(" </div>");
strBody.Append("<div><label for='comments'><b>Comments</b></label><br />");
strBody.Append(entity.Comments);
strBody.Append("</div></fieldset>");
strBody.Append("</body></html>");
// Send the message...
return strBody.ToString();
}
/// <summary>
/// ContentProvider(Teacher) Signup, Registers new teacher.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SignupButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string strSelectedMaterialItems = "";
//Get selected materials list.
if (chkBusinessEducation.Checked)
strSelectedMaterialItems += chkBusinessEducation.Value + ",";
if (chkCompanySpecificTraining.Checked)
strSelectedMaterialItems += chkCompanySpecificTraining.Value + ",";
if (chkFinancialEducation.Checked)
strSelectedMaterialItems += chkFinancialEducation.Value + ",";
if (chkSpecializedTraining.Checked)
strSelectedMaterialItems += chkSpecializedTraining.Value + ",";
if (chkTraditionalEducation.Checked)
strSelectedMaterialItems += chkTraditionalEducation.Value + ",";
strSelectedMaterialItems = strSelectedMaterialItems.TrimEnd(',');
//Set properties.
ContentProviderInfo entity = new ContentProviderInfo
{
Comments = CommentTextBox.Text,
CompanyCity = CompanyCityTextBox.Text,
CompanyCountry = CountryDropDown.SelectedItem.Value,
CompanyName = CompanyNameTextBox.Text,
CompanyStartedYear = int.Parse(CompanyStartedYearTextbox.Text),
CompanyState = StateDropDown.SelectedItem.Value,
CoursesOffered = CoursesOfferedDropDown.SelectedItem.Text,
DaytimePhone = DaytimePhoneTextBox.Text,
EmailAddress = EmailTextBox.Text,
EveningPhone = EveningPhoneTextBox.Text,
FirstName = FirstNameTextBox.Text,
HaveMerchantAccount = chkHaveMerchantAccount.Checked,
LastName = LastNameTextBox.Text,
ScheduleDemo = Convert.ToInt32(chkScheduleDemo.Checked),
StudentsAnticipated = StudentsAnticipatedDropDown.SelectedItem.Text,
KindOfMaterialOffered = strSelectedMaterialItems,
};
try
{
//Insert record of new teacher into database.
ContentProviderInfo.Insert(entity);
string subject = string.Format("Content Provider Lead : {0}", entity.FirstName + " " + entity.LastName);
MailMessage msg = new MailMessage("*****@*****.**", "*****@*****.**", subject, GetMailMessage(entity));
msg.IsBodyHtml = true;
msg.Priority = MailPriority.High;
new SmtpClient().Send(msg);
}
catch (SqlException ex)
{
// log this error...
}
catch (SmtpException ex)
{
// log this error...
}
catch (Exception ex)
{
// log this error...
}
finally
{
// always redirect to the thanks page if it passes validation...
Response.Redirect("~/Application/Thanks.aspx");
}
}
}
//public void Update()
//{
// ContentProviderInfo.Update(this);
//}
#endregion
#region [ Static Methods ]
public static void Insert(ContentProviderInfo entity)
{
DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.mon_elrn_INSERT_CONTENTPROVIDER");
cmd.AddInputParam("@FirstName", DbType.AnsiString, entity.FirstName);
cmd.AddInputParam("@LastName", DbType.AnsiString, entity.LastName);
cmd.AddInputParam("@DaytimePhone", DbType.AnsiString, entity.DaytimePhone);
cmd.AddInputParam("@EveningPhone", DbType.AnsiString, entity.EveningPhone);
cmd.AddInputParam("@EmailAddress", DbType.AnsiString, entity.EmailAddress);
cmd.AddInputParam("@CompanyName", DbType.AnsiString, entity.CompanyName);
cmd.AddInputParam("@CompanyCity", DbType.AnsiString, entity.CompanyCity);
cmd.AddInputParam("@CompanyState", DbType.String, entity.CompanyState);
cmd.AddInputParam("@CompanyCountry", DbType.String, entity.CompanyCountry);
cmd.AddInputParam("@CompanyStartedYear", DbType.Int32, entity.CompanyStartedYear);
cmd.AddInputParam("@HaveMerchantAccount", DbType.Boolean, entity.HaveMerchantAccount);
cmd.AddInputParam("@StudentsAnticipated", DbType.AnsiString, entity.StudentsAnticipated);
cmd.AddInputParam("@CoursesOffered", DbType.AnsiString, entity.CoursesOffered);
cmd.AddInputParam("@KindOfMaterialOffered", DbType.AnsiString, entity.KindOfMaterialOffered);
cmd.AddInputParam("@PercentageDesired", DbType.Int32, entity.PercentageDesired);
cmd.AddInputParam("@ScheduleDemo", DbType.Int32, entity.ScheduleDemo);
cmd.AddInputParam("@Comments", DbType.AnsiString, entity.Comments);
entity.Id = Convert.ToInt32(SqlHelpers.ExecuteScalar(cmd));
}