public ActionResult GetAppointmentDetails(appointments_table model)
{
var removeAppt = storeDB.appointments_table.FirstOrDefault(appt_table => appt_table.appointment_num == model.appointment_num);
// Marking the approved item as null will make it appear as a free appointment
removeAppt.approved = "";
removeAppt.user_num_request = null;
storeDB.Entry(removeAppt).State = System.Data.EntityState.Modified;
storeDB.SaveChanges();
return(RedirectToAction("Account", "Account"));
}
public ActionResult GetApptDetails(int id)
{
appointments_table currentAppt = new appointments_table();
foreach (var apptItem in storeDB.appointments_table)
{
if (apptItem.appointment_num == id)
{
currentAppt = apptItem;
}
}
return(View("Index", currentAppt));
}
public ActionResult GetApptDetails(appointments_table model)
{
var changeAppt = storeDB.appointments_table.FirstOrDefault(appt_table => appt_table.appointment_num == model.appointment_num);
changeAppt.approved = "Approved";
storeDB.Entry(changeAppt).State = System.Data.EntityState.Modified;
storeDB.SaveChanges();
// Send email to user that the appointment is ready
MailMessage mail = new MailMessage();
SmtpClient smtpServer = new SmtpClient("smtp.gmail.com");
smtpServer.Credentials = new System.Net.NetworkCredential("stevecoautoparts", "******");
smtpServer.Port = 587; // Gmail works on this port
string userEmail = "";
foreach (var userItem in storeDB.users_table)
{
if (userItem.user_num == changeAppt.user_num_request)
{
userEmail = userItem.user_email;
}
}
// Send the message that the store owner created
mail.From = new MailAddress("*****@*****.**");
mail.To.Add(userEmail);
mail.Subject = "Appointment update";
mail.Body = "Your appoinment has been approved! See you on: " + changeAppt.appointment_date.Value.ToShortDateString() + " at: " + changeAppt.appointment_time;
smtpServer.EnableSsl = true;
smtpServer.Send(mail);
return(RedirectToAction("Account", "Account"));
}
