protected void Page_Load(object sender, EventArgs e) { int ID = 0; string strID = Security.Decrypt(Request["id"]); string strTypeID = Request["typeid"]; masterPage = (masterpages_Site)Master; if (!String.IsNullOrEmpty(strID)) { Int32.TryParse(strID, out ID); } try { if (strTypeID == MailUtil.EmailType.Donation.ToString("D")) { DonationDA DA = new DonationDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath("~/App_Data/DonationEmail.xsl")); litEmailBody.Text += sb.ToString(); pageName = "Donation_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.Membership.ToString("D")) { MembershipDA DA = new MembershipDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath("~/App_Data/MembershipEmail.xsl")); litEmailBody.Text += sb.ToString().Replace("Please keep this email as receipt for your order.", "Please keep this as receipt for your order."); pageName = "Membership_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.Volunteer.ToString("D")) { VolunteerDA DA = new VolunteerDA(); StringBuilder sb = DA.GetEmailBody_Test(ID, Server.MapPath("~/App_Data/VolunteerEmail_Test.xsl")); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.StudentVolunteer.ToString("D")) { StudentVolunteerDA DA = new StudentVolunteerDA(); StringBuilder sb = DA.GetEmailBody_Test(ID, Server.MapPath("~/App_Data/StudentVolunteerEmail_Test.xsl")); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.Advocacy.ToString("D")) { AdvocacyDA DA = new AdvocacyDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath("~/App_Data/AdvocacyEmail.xsl")); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.BigBookSaleVolunteer.ToString("D")) { BigBookSaleVolunteerDA DA = new BigBookSaleVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath("~/App_Data/BigBookSaleVolunteerEmail.xsl")); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } } catch (Exception ex) { pageName = ""; litEmailBody.Text = ex.Message; } finally { masterPage.ComponentName = pageName; } }
protected void btnInsert_Click(object sender, EventArgs e) { int newID = 0; if (IsValid) { SqlCommand cmd = null; try { cmd = new SqlCommand("dbo.FSFPL_AddDonation"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("Amount", txtDonationAmount.Text); cmd.Parameters.AddWithValue("TypeId", GetDonationType()); cmd.Parameters.AddWithValue("TypeDetails", GetDonationTypeDetails()); cmd.Parameters.AddWithValue("Title", txtTitle.Text.Trim()); cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text.Trim()); cmd.Parameters.AddWithValue("MiddleName", txtMiddleName.Text.Trim()); cmd.Parameters.AddWithValue("LastName", txtLastName.Text.Trim()); cmd.Parameters.AddWithValue("Suffix", txtSuffix.Text.Trim()); cmd.Parameters.AddWithValue("Address1", txtAddress1.Text.Trim()); cmd.Parameters.AddWithValue("Address2", txtAddress2.Text.Trim()); cmd.Parameters.AddWithValue("City", txtCity.Text.Trim()); cmd.Parameters.AddWithValue("StateCode", ddlState.SelectedValue); cmd.Parameters.AddWithValue("ZipCode", txtZipCode.Text.Trim()); cmd.Parameters.AddWithValue("HomePhone", txtHomePhone.Text.Trim()); cmd.Parameters.AddWithValue("WorkPhone", txtWorkPhone.Text.Trim()); cmd.Parameters.AddWithValue("Email", txtEmail.Text.Trim()); cmd.Parameters.AddWithValue("LocalLibrary", String.Empty); cmd.Parameters.AddWithValue("GiftTypeId", rbGiftType.SelectedValue); cmd.Parameters.AddWithValue("AltTitle", txtAltTitle.Text.Trim()); cmd.Parameters.AddWithValue("AltFirstName", txtAltFirstName.Text.Trim()); cmd.Parameters.AddWithValue("AltMiddleName", txtAltMiddleName.Text.Trim()); cmd.Parameters.AddWithValue("AltLastName", txtAltLastName.Text.Trim()); cmd.Parameters.AddWithValue("AltSuffix", txtAltSuffix.Text.Trim()); cmd.Parameters.AddWithValue("AltAddress1", txtAltAddress1.Text.Trim()); cmd.Parameters.AddWithValue("AltAddress2", txtAltAddress2.Text.Trim()); cmd.Parameters.AddWithValue("AltCity", txtAltCity.Text.Trim()); cmd.Parameters.AddWithValue("AltStateCode", ddlAltState.SelectedValue); cmd.Parameters.AddWithValue("AltZipCode", txtAltZipCode.Text.Trim()); cmd.Parameters.AddWithValue("InfoTypeIdList", GetSelectedItemsList(cbxInfoType)); cmd.Parameters.AddWithValue("CreditCardName", txtCreditCardName.Text.Trim()); string creditCardNumber = txtCreditCardNumber.Text.Trim(); cmd.Parameters.AddWithValue("CreditCardNumber", Security.Encrypt(creditCardNumber)); cmd.Parameters.AddWithValue("Last4Digits", creditCardNumber.Substring(creditCardNumber.Length - 4, 4)); cmd.Parameters.AddWithValue("ExpMonth", ddlExpMonth.SelectedValue); cmd.Parameters.AddWithValue("ExpYear", ddlExpYear.SelectedValue); string securityCode = txtSecurityCode.Text.Trim(); cmd.Parameters.AddWithValue("SecurityCode", Security.Encrypt(securityCode)); cmd.Parameters.AddWithValue("NewsLetter", cbxNewsLetter.Checked); cmd.Parameters.AddWithValue("EmployerMatch", cbxEmployerMatch.Checked); cmd.Parameters.AddWithValue("Anonymous", cbxAnonymous.Checked); cmd.Parameters.AddWithValue("Message", txtMessage.Text.Trim()); if (rbDonationType2.Checked) { // Neighborhood Library Campaign cmd.Parameters.AddWithValue("NLC", ddlNLC.SelectedValue); cmd.Parameters.AddWithValue("NLCNaming", txtNLCNaming.Text.Trim()); } else { cmd.Parameters.AddWithValue("NLC", DBNull.Value); cmd.Parameters.AddWithValue("NLCNaming", DBNull.Value); } cmd.Parameters.AddWithValue("DoNotShareName", cbxDoNotShareName.Checked); SqlParameter param = new SqlParameter("Id", SqlDbType.Int); param.Size = 8; param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); cmd.Connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["FSFPL"].ConnectionString); cmd.Connection.Open(); cmd.ExecuteNonQuery(); newID = (int)cmd.Parameters["Id"].Value; DonationDA DA = new DonationDA(); StringBuilder sbEmailBody = DA.GetEmailBody(newID, Server.MapPath(MailUtil.DonationTemplate)); MailUtil.SendDonationEmail(txtEmail.Text, sbEmailBody); //Response.Redirect(String.Format("/?Confirmation&id={0}&typeid={1}", newID, MailUtil.EmailType.Donation.ToString("D")), true); Response.Redirect(String.Format("/?Confirmation&id={0}&typeid={1}", Server.UrlEncode(Security.Encrypt(newID.ToString())), MailUtil.EmailType.Donation.ToString("D")), true); } catch (Exception ex) { throw ex; } finally { if (cmd.Connection != null && cmd.Connection.State == ConnectionState.Open) { cmd.Connection.Close(); } cmd.Dispose(); } } }