public ActionResult GuestRespond (string rsvpID) { List<Guests> guestList = DAL.GetRSVPByID(rsvpID); if (guestList.FirstOrDefault().hasRSVPed) return View("AlreadyRSVPed"); RSVPs guestsOnThisRSVP = new RSVPs(guestList); guestsOnThisRSVP.SetUpForInitialRSVP(); return View(guestsOnThisRSVP); }
public ActionResult GuestRespond(RSVPs rsvps) { rsvps.hasRSVPed = true; if (DAL.UpdateRSVP(rsvps) == 1) { SendEmail(rsvps); return View("RSVPSuccess"); } else throw new Exception(); }
private void SendEmail(RSVPs rsvps) { SmtpClient smtpClient = new SmtpClient(); try { smtpClient.Host = System.Configuration.ConfigurationManager.AppSettings["SMTPserver"]; smtpClient.Port = 25; //smtpClient.Timeout = 10000; smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network; smtpClient.UseDefaultCredentials = false; smtpClient.Credentials = new NetworkCredential("*****@*****.**", "plastik5"); //String bodyText = fvm.ContactNumber + "\n" + fvm.EmailAddress + "\n" + fvm.FirstName + " " + fvm.LastName + "\n" + fvm.Comments; List<Guests> guestList = DAL.GetGuestsByID(rsvps.RsvpID.ToString()); string fullGuestNames = ""; foreach(var g in guestList) { fullGuestNames += g.firstName + " " + g.lastName + " "; } string guestRSVPing = guestList.FirstOrDefault().firstName + " " + guestList.FirstOrDefault().lastName; string subject = guestRSVPing + " RSVP!"; string body = "Names: " + fullGuestNames + "\n" + "rsvpID: " + rsvps.RsvpID + "\n" + "isAttending: " + (rsvps.isAttending ? "Yes" : "No") + "\n" + "numPeopleAttending: " + rsvps.NumPeopleAttending + "\n" + "namesOfPeopleAttending: " + rsvps.NamesOfPeopleAttending + "\n" + "rsvpComment: " + rsvps.rsvpComment; MailMessage mailMessage = new MailMessage("*****@*****.**", "*****@*****.**", subject, body); //mailMessage.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure; smtpClient.Send(mailMessage); } catch (Exception ex) { } }
public static int UpdateRSVP(RSVPs rsvp) { using (SqlConnection mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServerConnection"].ConnectionString)) { return mycon.Execute (@"update tblrsvp set hasRSVPed = @hasRSVPed, isAttending = @isAttending, numPeopleAttending = @numPeopleAttending, namesOfPeopleAttending = @namesOfPeopleAttending, rsvpComment = @rsvpComment where rsvpID = @rsvpID", new { rsvpID = rsvp.RsvpID, hasRSVPed = rsvp.hasRSVPed, isAttending = rsvp.isAttending, numPeopleAttending = rsvp.NumPeopleAttending, namesOfPeopleAttending = rsvp.NamesOfPeopleAttending, rsvpComment = rsvp.rsvpComment}); } }