Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 KB | None | 0 0
  1. <asp:SqlDataSource ID="userCourse" runat="server" ConnectionString='<%$ ConnectionStrings:ConnectionString %>' SelectCommand="SELECT DISTINCT tblCourse.courseTitle, tblCourse.advisorOfStudiesID, tblPersonalInfo.firstName, tblPersonalInfo.lastName, tblPersonalInfo.email FROM tblCourse INNER JOIN tblAdvisorOfStudies ON tblCourse.advisorOfStudiesID = tblAdvisorOfStudies.advisorOfStudiesID INNER JOIN tblUsers ON tblAdvisorOfStudies.userID = tblUsers.userID INNER JOIN tblPersonalInfo ON tblUsers.personalInfoID = tblPersonalInfo.personalInfoID WHERE (tblCourse.courseID = @userID)">
  2. <SelectParameters>
  3. <asp:SessionParameter SessionField="userID" Name="userID"></asp:SessionParameter>
  4. </SelectParameters>
  5. </asp:SqlDataSource>
  6. <asp:ListView ID="ListView1" runat="server" DataSourceID="userCourse">
  7. <ItemTemplate>
  8. <asp:Label ID="aosemail" runat="server" Text='<%# Eval("email") %>' />
  9. <asp:Label ID="aosname" hidden runat="server" Text='<%# Eval("firstName") %>' />
  10. </ItemTemplate>
  11. </asp:ListView>
  12.  
  13. private bool SendEmail()
  14. {
  15. string recipient = aosemail; //AOS Email textbox should go here
  16. MailMessage mm = new MailMessage("CSC3047@gmail.com", recipient);
  17. mm.Subject = "Student has chosen Manual Enrollment Process!";
  18. //AOS name textbox will be here
  19. mm.Body = "Hi " + aosename+ "<br><br>This is a quick email to inform you that " + Name.Text.ToString() + " has chosen the manual enrollment process. The reason we are emailing you is that you are their Advisor of Studies. Please email the user on " + Email.Text.ToString() + " <br><br>Regards";
  20. mm.IsBodyHtml = true;
  21. SmtpClient smtp = new SmtpClient();
  22. smtp.Host = "smtp.gmail.com";
  23. smtp.EnableSsl = true;
  24. NetworkCredential NetworkCred = new NetworkCredential();
  25. NetworkCred.UserName = "*************";
  26. NetworkCred.Password = "*********";
  27. smtp.UseDefaultCredentials = true;
  28. smtp.Credentials = NetworkCred;
  29. smtp.Port = 587;
  30. smtp.Send(mm);
  31. return true;
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement