public ActionResult RemoveAvail(int id) { TestDatabaseEntities context = new TestDatabaseEntities(); context.DeleteAvail(id); ViewBag.Message = "You have successfully deleted availability time."; return(RedirectToAction("ProfilePage")); }
public ActionResult ConfirmApt(string confirmCode) { TestDatabaseEntities context = new TestDatabaseEntities(); var v = context.Appointments.Where(x => x.confirmCode == new Guid(confirmCode)).FirstOrDefault(); var aptUser = context.UserLogins.Where(x => x.UserID == v.StudentUserID).FirstOrDefault(); var instructor = context.UserLogins.Where(x => x.UserID == v.InstructorUserID).FirstOrDefault(); var availId = v.OriginalAvailID; if (v != null) { context.ConfirmApt(v.AppointmentID, aptUser.UserID, instructor.UserID); var fromEmail = new MailAddress("*****@*****.**", "PrepIN Support"); var toEmail = new MailAddress(aptUser.Email); var fromEmailPassword = "******"; string subject = "Confirmation of Appointment"; string body = "</br> </br> Your appointment with " + instructor.Username.ToString() + " for " + v.Time.ToLongDateString() + " at " + v.Time.ToShortTimeString() + " has been confirmed!"; var smtp = new SmtpClient { Host = "lv-shared04.cpanelplatform.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(fromEmail.Address, fromEmailPassword) }; using (var message = new MailMessage(fromEmail, toEmail) { Subject = subject, Body = body, IsBodyHtml = true }) smtp.Send(message); ViewBag.Message = "You have successfully confirmed your appointment with " + aptUser.Username + "."; context.DeleteAvail(availId); return(RedirectToAction("ProfilePage")); } else { ViewBag.Message = "An error has occured. Redirecting you to profile page or login page."; return(RedirectToAction("ProfilePage")); } }