public async Task <IActionResult> AddRessource([Bind("Id,Ressource")] Appointment appointment, int selectedRessource)
{
//load appointment from DB
appointment = _context
.Appointments
.Include(a => a.Survey)
.ThenInclude(s => s.Creator)
.Include(a => a.Survey)
.ThenInclude(s => s.Members)
.Include(a => a.Room)
.ThenInclude(r => r.RessourceBookedTimes)
.Include(a => a.Ressources)
.ThenInclude(res => res.RessourceBookedTimes)
.SingleOrDefault(a => a.Id == appointment.Id);
//load selected ressource object form DB
var newRessource = _context
.Ressources
.Include(r => r.RessourceBookedTimes)
.SingleOrDefault(r => r.Id == selectedRessource);
//check if ressource is already member of the appointment
if (appointment.Room.Id == selectedRessource)
{
return(RedirectToAction("Edit", appointment));
}
if (appointment.Ressources.Contains(newRessource))
{
return(RedirectToAction("Edit", appointment));
}
//get bookedtime that belongs to this appointment
var bookedTime = (_context
.RessourceBookedTimes
.Include(r => r.BookedTime)
.Include(r => r.Ressource)
.SingleOrDefault(r => r.Ressource.Id == appointment.Room.Id &&
r.BookedTime.StartTime == appointment.StartTime &&
r.BookedTime.EndTime == appointment.EndTime)
).BookedTime;
//if ressource has never been booked befor, create new RBT list
if (newRessource.RessourceBookedTimes == null)
{
newRessource.RessourceBookedTimes = new List <RessourceBookedTime>();
}
//add ressource to appointment and book it
var newRBT = new RessourceBookedTime
{
BookedTime = bookedTime,
BookedTimeId = bookedTime.Id,
Ressource = newRessource,
RessourceId = newRessource.Id
};
bookedTime.RessourcesBookedTimes.Add(newRBT);
newRessource.RessourceBookedTimes.Add(newRBT);
appointment.Ressources.Add(newRessource);
//write changes into DB
_context.Add(newRBT);
_context.Update(bookedTime);
_context.Update(newRessource);
_context.Update(appointment);
await _context.SaveChangesAsync();
//create room list for view to be passed
ViewBag.RoomList = _context
.Rooms
.OrderBy(r => r.Name)
.ToList();
ViewBag.RessourceList = _context
.Ressources
.OrderBy(r => r.Name)
.ToList();
return(RedirectToAction("Edit", appointment));
}
public async Task <IActionResult> Create(
[Bind("Id,StartTime,EndTime,SelectedRoom,SelectedRessource,Survey")] Appointment appointment)
{
//create variables
var bookedTime = new BookedTime
{
StartTime = appointment.StartTime,
EndTime = appointment.EndTime,
RessourcesBookedTimes = new List <RessourceBookedTime>()
};
var ressourceList = new List <Ressource>();
var rbt = new RessourceBookedTime();
appointment.Ressources = new Collection <Ressource>();
//get related Survey object from database and store it into the Appointment object
appointment.Survey = _context
.Surveys
.Include(s => s.Creator)
.FirstOrDefault(s => s.Id == appointment.Survey.Id);
//get selected Room
appointment.Room = (Room)_context
.Ressources
.Include(r => r.RessourceBookedTimes)
.ThenInclude(s => s.Ressource)
.Include(r => r.RessourceBookedTimes)
.ThenInclude(s => s.BookedTime)
.SingleOrDefault(r => r.Id == appointment.SelectedRoom);
//add selected ressources to the ressource list
if (appointment.SelectedRessource != null)
{
foreach (var item in appointment.SelectedRessource)
{
ressourceList.Add(
_context
.Ressources
.Include(r => r.RessourceBookedTimes)
.ThenInclude(s => s.Ressource)
.Include(r => r.RessourceBookedTimes)
.ThenInclude(s => s.BookedTime)
.SingleOrDefault(r => r.Id == item)
);
}
}
rbt = new RessourceBookedTime
{
BookedTime = bookedTime,
BookedTimeId = bookedTime.Id,
Ressource = appointment.Room,
RessourceId = appointment.Room.Id
};
//book all ressources
appointment.Room.RessourceBookedTimes.Add(rbt);
bookedTime.RessourcesBookedTimes.Add(rbt);
_context.Add(rbt);
if (appointment.SelectedRessource != null)
{
foreach (var item in ressourceList)
{
if (item.RessourceBookedTimes == null)
{
item.RessourceBookedTimes = new List <RessourceBookedTime>();
}
rbt = new RessourceBookedTime
{
BookedTime = bookedTime,
BookedTimeId = bookedTime.Id,
Ressource = item,
RessourceId = item.Id
};
item.RessourceBookedTimes.Add(rbt);
bookedTime.RessourcesBookedTimes.Add(rbt);
_context.Add(rbt);
appointment.Ressources.Add(item);
}
}
//survey is explicitly loaded. SelectedMember is a direct entity. This
//entity will never be saved into database. Everytime it's null.
//It's a requuired entity for the survey and is also checked during
//appointment validation. Without this line it will always be unvalidated!
appointment.Survey.SelectedMember = new Collection <string>();
//After model binding and validation are complete, you may want to repeat parts
//of it. For example, a user may have entered text in a field expecting an
//integer, or you may need to compute a value for a model's property.
ModelState.Clear();
TryValidateModel(appointment);
if (ModelState.IsValid)
{
_context.Add(appointment);
_context.Add(bookedTime);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", "Surveys", new { id = appointment.Survey.Id }));
}
else
{
appointment.Ressources = _context.Ressources.ToList();
ViewBag.RoomList = _context
.Rooms
.OrderBy(r => r.Name)
.ToList();
}
return(View(appointment));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,StartTime,EndTime,SelectedRoom")] Appointment appointment)
{
if (id != appointment.Id)
{
return(NotFound());
}
//initialize necessary temp variables:
var newStartTime = appointment.StartTime;
var newEndTime = appointment.EndTime;
var newSelectedRoom = appointment.SelectedRoom;
var oldRoom = new Room();
var newRoom = _context
.Rooms
.Include(r => r.RessourceBookedTimes)
.SingleOrDefault(r => r.Id == appointment.SelectedRoom);
var oldBookedTime = new BookedTime();
var newBookedTime = new BookedTime();
var oldRessourceBookedTime = new RessourceBookedTime();
var newRessourceBookedTime = new RessourceBookedTime();
//loading appointment data from database
appointment = await _context.Appointments
.Include(a => a.Survey)
.ThenInclude(s => s.Creator)
.Include(a => a.Survey)
.ThenInclude(s => s.Members)
.Include(a => a.Room)
.ThenInclude(r => r.RessourceBookedTimes)
.Include(a => a.Ressources)
.ThenInclude(res => res.RessourceBookedTimes)
.SingleOrDefaultAsync(m => m.Id == id);
//avoid model validation problem
if (appointment.Survey.SelectedMember == null)
{
appointment.Survey.SelectedMember = new Collection <string>();
}
//test if Room or Time changed.
if (appointment.Room == newRoom)
{
//Room did not change
}
else
{
//room changed
oldRessourceBookedTime = _context
.RessourceBookedTimes
.Include(r => r.BookedTime)
.ThenInclude(b => b.RessourcesBookedTimes)
.Include(r => r.Ressource)
.SingleOrDefault(r => r.Ressource.Id == appointment.Room.Id &&
r.BookedTime.StartTime == appointment.StartTime &&
r.BookedTime.EndTime == appointment.EndTime);
//get old room and old bookedtime
oldBookedTime = oldRessourceBookedTime.BookedTime;
oldRoom = (Room)oldRessourceBookedTime.Ressource;
//remove connection between ressource and bookedtime in the objects itself
oldRoom.RessourceBookedTimes.Remove(oldRessourceBookedTime);
oldBookedTime.RessourcesBookedTimes.Remove(oldRessourceBookedTime);
//set connection between new room and booked time
newRessourceBookedTime.BookedTime = oldBookedTime;
newRessourceBookedTime.BookedTimeId = oldBookedTime.Id;
newRessourceBookedTime.Ressource = newRoom;
newRessourceBookedTime.RessourceId = newRoom.Id;
newRoom.RessourceBookedTimes.Add(newRessourceBookedTime);
//set new Room in appointment
appointment.Room = newRoom;
}
if (appointment.StartTime == newStartTime && appointment.EndTime == newEndTime)
{
//time did not change!!
}
else
{
//time changed and must be updated in room and all ressources
oldRessourceBookedTime = _context
.RessourceBookedTimes
.Include(r => r.BookedTime)
.Include(r => r.Ressource)
.SingleOrDefault(r => r.Ressource.Id == appointment.Room.Id &&
r.BookedTime.StartTime == appointment.StartTime &&
r.BookedTime.EndTime == appointment.EndTime);
//get old bookedtime
oldBookedTime = oldRessourceBookedTime.BookedTime;
//get all RessourceBookedTimes with the same BookedTime ID
var rbtList = _context
.RessourceBookedTimes
.Include(r => r.BookedTime)
.ThenInclude(b => b.RessourcesBookedTimes)
.Include(r => r.Ressource)
.Where(r => r.BookedTimeId == oldBookedTime.Id);
//create new bookedTime that will be referenced in all ressources by the RessourceBookedTime object
newBookedTime = new BookedTime()
{
StartTime = newStartTime,
EndTime = newEndTime,
RessourcesBookedTimes = new List <RessourceBookedTime>()
};
//update all RessourceBookedTime elements with the new BookedTime
foreach (var rbt in rbtList)
{
rbt.BookedTime = newBookedTime;
rbt.BookedTimeId = newBookedTime.Id;
newBookedTime.RessourcesBookedTimes.Add(rbt);
//update the rbt object
_context.Update(rbt);
}
_context.Update(newBookedTime);
//remove old bookedtime from db. No longer used / refereced
_context.BookedTimes.Remove(oldBookedTime);
}
//create List of all rooms for dropdown menue to be selected
ViewBag.RoomList = _context
.Rooms
.OrderBy(r => r.Name)
.ToList();
//create List of all ressources for dropdown menue to be selected
ViewBag.RessourceList = _context
.Ressources
.OrderBy(r => r.Name)
.ToList();
ModelState.Clear();
TryValidateModel(appointment);
if (ModelState.IsValid)
{
try
{
_context.Update(appointment);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AppointmentExists(appointment.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(
"Details", //controller action
"Surveys", //controller
//Man muss ein neues Objekt erzeugen, das wie die Variable der
//empfangenden Methode des Controllers heißt.
//Das Übergeben der id als direkte INT - Zahl funktioniert nicht.
new { id = appointment.Survey.Id }));
}
return(View(appointment));
}
public void Add(RessourceBookedTime newRessourceBookedTime)
{
_context.Add(newRessourceBookedTime);
_context.SaveChanges();
}
