using System;

using System.Web.Mvc;

using System.Collections.Generic;

using System.Linq;

using System.Data.Entity;

​

namespace HelloWorldMvcApp

{

    public class HomeController : Controller

    {

        [HttpGet]

        public ActionResult Index()     {               

            var context = new EntityContext();      

            // This prints out the table content

            FiddleHelper.WriteTable("Employees", context.Employees.ToList());           

            FiddleHelper.WriteTable("Appointments", context.Appointments.ToList());                 

            var viewModel = new SampleViewModel();      

            viewModel.Appointments = context.Appointments.Select(x => new AppointmentModel{

                EmployeeName = "Somebody", 

                AppointmentName = x.Name,               

                Description = x.Description,        

                StartDate = x.StartDate,

                IsFinished = x.IsFinished,

                AppointmentID = x.ID

                }).ToList();

            return View();

        }

    }

    public class EntityContext

    {       

        public List<Employee> Employees { get; set; }

        public List<Appointment> Appointments { get; set; }

        public EntityContext()

        {

            GenerateDummyData();

        }

        public void GenerateDummyData()

        {

            Employees = new List<Employee>();

            Employees.Add(new Employee() { ID = 1, Name ="Ole Olesen"});

            Employees.Add(new Employee() { ID = 2, Name ="Simon Simonsen" });           

            Employees.Add(new Employee() { ID = 3, Name ="Kim Kimsen"});

            Appointments = new List<Appointment>();

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Ovn", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.08 12:00"), IsFinished = false, EmployeeID = 1});

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Emhætte", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.08 14:00"), IsFinished = true, EmployeeID = 1});

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Køleskab", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.08 16:00"), IsFinished = false, EmployeeID = 1});

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Fryser", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.09 08:00"), IsFinished = false, EmployeeID = 2});

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Toilet", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.09 10:00"), IsFinished = false, EmployeeID = 2});

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Badekar", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.10 12:00"), IsFinished = false, EmployeeID = 2});

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Loftlampe", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 13:00"), IsFinished = true, EmployeeID = 3});

            Appointments.Add(new Appointment() { ID = 1, Name ="Installer Gulvlampe", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 14:00"), IsFinished = false, EmployeeID = 3});

            Appointments.Add(new Appointment() { ID = 1, Name ="Vask bil", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 14:00"), IsFinished = false, EmployeeID = 1});

            Appointments.Add(new Appointment() { ID = 1, Name ="Puds vinduer", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 14:00"), IsFinished = true, EmployeeID = 1});

        }

    }

    public class Employee

    {

        public int ID { get; set; }

        public string Name { get; set; }

    }

    public class Appointment

    {

        public int ID { get; set; }

        public string Name { get; set; }

        public string Description { get; set; }

        public DateTime StartDate { get; set; }

        public Boolean IsFinished { get; set; }

        public int? EmployeeID { get; set; }

    }

}