using System.Collections.Generic;
using System.Data.Entity;
namespace HelloWorldMvcApp
public class HomeController : Controller
public ActionResult Index() {
return View(GetSampleViewModelMockData());
public ActionResult Index(int id) {
var viewModel = GetSampleViewModelMockData();
var appointmentToRemove = viewModel.Appointments.Where(a => a.AppointmentID == id).FirstOrDefault();
if(appointmentToRemove != null){
viewModel.Appointments.Remove(appointmentToRemove);
private SampleViewModel GetSampleViewModelMockData(){
var context = new EntityContext();
FiddleHelper.WriteTable("Employees", context.Employees.ToList());
FiddleHelper.WriteTable("Appointments", context.Appointments.ToList());
var viewModel = new SampleViewModel();
viewModel.Appointments = context.Appointments.Select(x => new AppointmentModel{
AppointmentName = x.Name,
Description = x.Description,
IsFinished = x.IsFinished,
EmployeeID = x.EmployeeID
for (int i = 0; i < viewModel.Appointments.Count(); i++)
foreach (Employee employee in context.Employees)
if (viewModel.Appointments[i].EmployeeID == employee.ID)
viewModel.Appointments[i].EmployeeName = employee.Name;
public class EntityContext
public List<Employee> Employees { get; set; }
public List<Appointment> Appointments { get; set; }
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 = 2, 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 = 3, 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 = 4, Name ="Installer Fryser", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.09 08:00"), IsFinished = false, EmployeeID = 2});
Appointments.Add(new Appointment() { ID = 5, Name ="Installer Toilet", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.09 10:00"), IsFinished = false, EmployeeID = 2});
Appointments.Add(new Appointment() { ID = 6, Name ="Installer Badekar", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.10 12:00"), IsFinished = false, EmployeeID = 2});
Appointments.Add(new Appointment() { ID = 7, Name ="Installer Loftlampe", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 13:00"), IsFinished = true, EmployeeID = 3});
Appointments.Add(new Appointment() { ID = 8, Name ="Installer Gulvlampe", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 14:00"), IsFinished = false, EmployeeID = 3});
Appointments.Add(new Appointment() { ID = 9, Name ="Vask bil", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 14:00"), IsFinished = false, EmployeeID = 1});
Appointments.Add(new Appointment() { ID = 10, Name ="Puds vinduer", Description = "Ingen beskrivelse angivet.", StartDate = DateTime.Parse("2019.10.11 14:00"), IsFinished = true, EmployeeID = 1});
public int ID { get; set; }
public string Name { get; set; }
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; }