public void AddAppointment(Appointment apt)
{
using (var db = new AppointmentContext())
{
db.Appointments.Add(apt);
db.SaveChangesAsync();
}
}
public void AddAppointmentConsole()
{
using (var db = new AppointmentContext())
{
// create and save a new appointment
Console.WriteLine("Enter an Appointment Description: ");
var desc = Console.ReadLine();
// enter date
Console.WriteLine("APPOINTMENT DATE");
Console.Write("Enter Day (dd): ");
int dd = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter Month (mm): ");
int mm = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter Year (yyyy): ");
int yyyy = Convert.ToInt32(Console.ReadLine());
DateTime date = new DateTime(yyyy, mm, dd);
// enter organiser name
Console.WriteLine("ORGANISER NAME");
Console.WriteLine("First Name: ");
var fname = Console.ReadLine();
Console.WriteLine("Last Name: ");
var lname = Console.ReadLine();
Contact organiser = new Contact {
FirstName = fname, LastName = lname
};
//construct appointment
var appointment = new Appointment {
Description = desc, Date = date, Organiser = organiser
};
db.Appointments.Add(appointment);
db.SaveChanges();
//display all appointments from db
var query = from b in db.Appointments
orderby b.Date
select b;
Console.WriteLine("All Appointments in DB: ");
Console.WriteLine();
foreach (var item in query)
{
Console.WriteLine(item.Description + ", "
+ item.Date.ToShortDateString());
}
Console.WriteLine();
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
}
