protected void FormView1_DataBound(object sender, EventArgs e) { FormView fv = (FormView)sender; DataRowView dv = (DataRowView)fv.DataItem; if (dv != null) { int id = (int)dv["Id"]; AnniversaryBookSaleVolunteerDA DA = new AnniversaryBookSaleVolunteerDA(); StringBuilder sb = DA.GetEmailBody(id, Server.MapPath(MailUtil.AnniversaryBookSaleVolunteerInfoTemplate)); Literal litCurrentInfo = FormView1.FindControl("litCurrentInfo") as Literal; litCurrentInfo.Text = sb.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { int id; string email; AnniversaryBookSaleVolunteerDA bookSaleVolunteerDA = new AnniversaryBookSaleVolunteerDA(); DataTable dtVolunteers = bookSaleVolunteerDA.GetAllVolunteers(); foreach (DataRow row in dtVolunteers.Rows) { id = (int)row["Id"]; email = (string)row["Email"]; MailUtil.SendVolunteerEmail(email, bookSaleVolunteerDA.GetEmailBody(id, Server.MapPath(MailUtil.AnniversaryBookSaleVolunteerTemplate))); } bookSaleVolunteerDA = null; }
protected void btnInsert_Click(object sender, EventArgs e) { int newID = 0; if (IsValid) { SqlCommand cmd = null; try { cmd = new SqlCommand("dbo.FSFPL_AddAnniversaryBookSaleVolunteer"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text.Trim()); cmd.Parameters.AddWithValue("LastName", txtLastName.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("Email", txtEmail.Text.Trim()); cmd.Parameters.AddWithValue("HomePhone", txtHomePhone.Text.Trim()); cmd.Parameters.AddWithValue("Day1BoxMover", GetMultiCheckValues(cbxDay1BoxMover)); cmd.Parameters.AddWithValue("Day1TableMonitor", GetMultiCheckValues(cbxDay1TableMonitor)); cmd.Parameters.AddWithValue("Day2BoxMover", GetMultiCheckValues(cbxDay2BoxMover)); cmd.Parameters.AddWithValue("Day2TableMonitor", GetMultiCheckValues(cbxDay2TableMonitor)); cmd.Parameters.AddWithValue("Day2Cashier", GetMultiCheckValues(cbxDay2Cashier)); cmd.Parameters.AddWithValue("Day2Caller", GetMultiCheckValues(cbxDay2Caller)); cmd.Parameters.AddWithValue("Day3TableMonitor", GetMultiCheckValues(cbxDay3TableMonitor)); cmd.Parameters.AddWithValue("Day3Floater", GetMultiCheckValues(cbxDay3Floater)); cmd.Parameters.AddWithValue("Day3Cashier", GetMultiCheckValues(cbxDay3Cashier)); cmd.Parameters.AddWithValue("Day3Caller", GetMultiCheckValues(cbxDay3Caller)); cmd.Parameters.AddWithValue("Day4TableMonitor", GetMultiCheckValues(cbxDay4TableMonitor)); cmd.Parameters.AddWithValue("Day4Floater", GetMultiCheckValues(cbxDay4Floater)); cmd.Parameters.AddWithValue("Day4Cashier", GetMultiCheckValues(cbxDay4Cashier)); cmd.Parameters.AddWithValue("Day4Caller", GetMultiCheckValues(cbxDay4Caller)); cmd.Parameters.AddWithValue("Day5TableMonitor", GetMultiCheckValues(cbxDay5TableMonitor)); cmd.Parameters.AddWithValue("Day5Floater", GetMultiCheckValues(cbxDay5Floater)); cmd.Parameters.AddWithValue("Day5Cashier", GetMultiCheckValues(cbxDay5Cashier)); cmd.Parameters.AddWithValue("Day5Caller", GetMultiCheckValues(cbxDay5Caller)); cmd.Parameters.AddWithValue("Day6TableMonitor", GetMultiCheckValues(cbxDay6TableMonitor)); cmd.Parameters.AddWithValue("Day6Floater", GetMultiCheckValues(cbxDay6Floater)); cmd.Parameters.AddWithValue("Day6Cashier", GetMultiCheckValues(cbxDay6Cashier)); cmd.Parameters.AddWithValue("Day6Caller", GetMultiCheckValues(cbxDay6Caller)); cmd.Parameters.AddWithValue("Day6Packup", GetMultiCheckValues(cbxDay6Packup)); cmd.Parameters.AddWithValue("Day7Packup", GetMultiCheckValues(cbxDay7Packup)); 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; AnniversaryBookSaleVolunteerDA DA = new AnniversaryBookSaleVolunteerDA(); StringBuilder sbEmailBody = DA.GetEmailBody(newID, Server.MapPath(MailUtil.AnniversaryBookSaleVolunteerTemplate)); MailUtil.SendVolunteerEmail(txtEmail.Text, sbEmailBody); Response.Redirect(String.Format("/?Confirmation&id={0}&typeid={1}", Server.UrlEncode(Security.Encrypt(newID.ToString())), MailUtil.EmailType.AnniversaryBookSaleVolunteer.ToString("D")), true); } catch (Exception ex) { throw ex; } finally { if (cmd.Connection != null && cmd.Connection.State == ConnectionState.Open) { cmd.Connection.Close(); } cmd.Dispose(); } } }
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(MailUtil.DonationTemplate)); 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(MailUtil.MembershipTemplate)); 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(ID, Server.MapPath(MailUtil.VolunteerTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.StudentVolunteer.ToString("D")) { StudentVolunteerDA DA = new StudentVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.StudentVolunteerTemplate)); 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(MailUtil.AdvocacyTemplate)); 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(MailUtil.BigBookSaleVolunteerTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.BigBookSaleVolunteerTest.ToString("D")) { BigBookSaleVolunteerDA DA = new BigBookSaleVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.BigBookSaleVolunteerTemplateTest)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.BigBookSaleStudentVolunteer.ToString("D")) { BigBookSaleStudentVolunteerDA DA = new BigBookSaleStudentVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.BigBookSaleVolunteerTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.BigBookSaleStudentVolunteerTest.ToString("D")) { BigBookSaleStudentVolunteerDA DA = new BigBookSaleStudentVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.BigBookSaleVolunteerTemplateTest)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.BookAndPlantSaleVolunteer.ToString("D")) { BookAndPlantSaleVolunteerDA DA = new BookAndPlantSaleVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.BookAndPlantSaleVolunteerTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.AnniversaryBookSaleVolunteer.ToString("D")) { AnniversaryBookSaleVolunteerDA DA = new AnniversaryBookSaleVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.AnniversaryBookSaleVolunteerTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.BookDonation.ToString("D")) { BookDonationDA DA = new BookDonationDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.BookDonationTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.SpringBookSaleVolunteer.ToString("D")) { BigBookSaleVolunteerDA DA = new BigBookSaleVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.SpringBookSaleVolunteerTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } else if (strTypeID == MailUtil.EmailType.SpringBookSaleStudentVolunteer.ToString("D")) { BigBookSaleStudentVolunteerDA DA = new BigBookSaleStudentVolunteerDA(); StringBuilder sb = DA.GetEmailBody(ID, Server.MapPath(MailUtil.SpringBookSaleVolunteerTemplate)); litEmailBody.Text += sb.ToString(); pageName = "Volunteer_Confirmation_Template"; } } catch (Exception ex) { pageName = ""; litEmailBody.Text = ex.Message; } finally { masterPage.ComponentName = pageName; } }
protected void Page_Load(object sender, EventArgs e) { int id = 0; if (!String.IsNullOrEmpty(Request["typeid"])) { CSVExporter.ExportType exportType = (CSVExporter.ExportType)Enum.Parse(typeof(CSVExporter.ExportType), Request["typeid"]); if (Enum.IsDefined(typeof(CSVExporter.ExportType), exportType)) { if (!String.IsNullOrEmpty(Request["id"])) { if (Int32.TryParse(Request["id"], out id)) { switch (exportType) { case CSVExporter.ExportType.Advocacy: AdvocacyDA advocacyDA = new AdvocacyDA(); using (DataTable dt = advocacyDA.GetAdvocacy(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Advocacy, advocacyDA.DetailsViewName); } advocacyDA = null; break; case CSVExporter.ExportType.Donation: DonationDA donationDA = new DonationDA(); using (DataTable dt = donationDA.GetDonation(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Donation, donationDA.DetailsViewName); } donationDA = null; break; case CSVExporter.ExportType.Membership: MembershipDA membershipDA = new MembershipDA(); using (DataTable dt = membershipDA.GetMembership(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Membership, membershipDA.DetailsViewName); } membershipDA = null; break; case CSVExporter.ExportType.StudentVolunteer: StudentVolunteerDA studentVolunteerDA = new StudentVolunteerDA(); using (DataTable dt = studentVolunteerDA.GetVolunteer(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.StudentVolunteer, studentVolunteerDA.DetailsViewName); } studentVolunteerDA = null; break; case CSVExporter.ExportType.Volunteer: VolunteerDA volunteerDA = new VolunteerDA(); using (DataTable dt = volunteerDA.GetVolunteer(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Volunteer, volunteerDA.DetailsViewName); } volunteerDA = null; break; case CSVExporter.ExportType.BigBookSaleVolunteer: BigBookSaleVolunteerDA bookSaleVolunteerDA = new BigBookSaleVolunteerDA(); using (DataTable dt = bookSaleVolunteerDA.GetVolunteer(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BigBookSaleVolunteer, bookSaleVolunteerDA.DetailsViewName); } bookSaleVolunteerDA = null; break; case CSVExporter.ExportType.BookAndPlantSaleVolunteer: BookAndPlantSaleVolunteerDA bookAndPlantSaleVolunteerDA = new BookAndPlantSaleVolunteerDA(); using (DataTable dt = bookAndPlantSaleVolunteerDA.GetVolunteer(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BookAndPlantSaleVolunteer, bookAndPlantSaleVolunteerDA.DetailsViewName); } bookAndPlantSaleVolunteerDA = null; break; case CSVExporter.ExportType.BigBookSaleStudentVolunteer: BigBookSaleStudentVolunteerDA bookSaleStudentVolunteerDA = new BigBookSaleStudentVolunteerDA(); using (DataTable dt = bookSaleStudentVolunteerDA.GetVolunteer(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BigBookSaleStudentVolunteer, bookSaleStudentVolunteerDA.DetailsViewName); } bookSaleStudentVolunteerDA = null; break; case CSVExporter.ExportType.AnniversaryBookSaleVolunteer: AnniversaryBookSaleVolunteerDA anniversaryBookSaleVolunteerDA = new AnniversaryBookSaleVolunteerDA(); using (DataTable dt = anniversaryBookSaleVolunteerDA.GetVolunteer(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.AnniversaryBookSaleVolunteer, anniversaryBookSaleVolunteerDA.DetailsViewName); } anniversaryBookSaleVolunteerDA = null; break; case CSVExporter.ExportType.BookDonation: BookDonationDA bookDonationDA = new BookDonationDA(); using (DataTable dt = bookDonationDA.GetBookDonation(id)) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BookDonation, bookDonationDA.DetailsViewName); } bookDonationDA = null; break; } } } else if (!String.IsNullOrEmpty(Request["all"])) { switch (exportType) { case CSVExporter.ExportType.Advocacy: AdvocacyDA advocacyDA = new AdvocacyDA(); using (DataTable dt = advocacyDA.GetAllAdvocacy()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Advocacy, advocacyDA.DetailsViewName); } advocacyDA = null; break; case CSVExporter.ExportType.Donation: DonationDA donationDA = new DonationDA(); using (DataTable dt = donationDA.GetAllDonations()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Donation, donationDA.DetailsViewName); } donationDA = null; break; case CSVExporter.ExportType.Membership: MembershipDA membershipDA = new MembershipDA(); using (DataTable dt = membershipDA.GetAllMemberships()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Membership, membershipDA.DetailsViewName); } membershipDA = null; break; case CSVExporter.ExportType.StudentVolunteer: StudentVolunteerDA studentVolunteerDA = new StudentVolunteerDA(); using (DataTable dt = studentVolunteerDA.GetAllVolunteers()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.StudentVolunteer, studentVolunteerDA.DetailsViewName); } studentVolunteerDA = null; break; case CSVExporter.ExportType.Volunteer: VolunteerDA volunteerDA = new VolunteerDA(); using (DataTable dt = volunteerDA.GetAllVolunteers()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.Volunteer, volunteerDA.DetailsViewName); } volunteerDA = null; break; case CSVExporter.ExportType.BigBookSaleVolunteer: BigBookSaleVolunteerDA bookSaleVolunteerDA = new BigBookSaleVolunteerDA(); using (DataTable dt = bookSaleVolunteerDA.GetAllVolunteers()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BigBookSaleVolunteer, bookSaleVolunteerDA.DetailsViewName); } bookSaleVolunteerDA = null; break; case CSVExporter.ExportType.BookAndPlantSaleVolunteer: BookAndPlantSaleVolunteerDA bookAndPlantSaleVolunteerDA = new BookAndPlantSaleVolunteerDA(); using (DataTable dt = bookAndPlantSaleVolunteerDA.GetAllVolunteers()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BookAndPlantSaleVolunteer, bookAndPlantSaleVolunteerDA.DetailsViewName); } bookAndPlantSaleVolunteerDA = null; break; case CSVExporter.ExportType.BigBookSaleStudentVolunteer: BigBookSaleStudentVolunteerDA bookSaleStudentVolunteerDA = new BigBookSaleStudentVolunteerDA(); using (DataTable dt = bookSaleStudentVolunteerDA.GetAllVolunteers()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BigBookSaleStudentVolunteer, bookSaleStudentVolunteerDA.DetailsViewName); } bookSaleStudentVolunteerDA = null; break; case CSVExporter.ExportType.AnniversaryBookSaleVolunteer: AnniversaryBookSaleVolunteerDA anniversaryBookSaleVolunteerDA = new AnniversaryBookSaleVolunteerDA(); using (DataTable dt = anniversaryBookSaleVolunteerDA.GetAllVolunteers()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.AnniversaryBookSaleVolunteer, anniversaryBookSaleVolunteerDA.DetailsViewName); } anniversaryBookSaleVolunteerDA = null; break; case CSVExporter.ExportType.BookDonation: BookDonationDA bookDonationDA = new BookDonationDA(); using (DataTable dt = bookDonationDA.GetAllBookDonations()) { CSVExporter.WriteToCSV(dt, CSVExporter.ExportType.BookDonation, bookDonationDA.DetailsViewName); } bookDonationDA = null; break; } } } } }