////add text to GenerateReport.cshtml public ActionResult MakeReport(ReportsHomeVM vm) { ReportsHomeVM model = new ReportsHomeVM(); if (vm.ChosenRehearsal == null) { vm.ChosenRehearsal = new Rehearsal(Globals.rID); } GetDAL get = new GetDAL(); get.OpenConnection(); Rehearsal r = get.GetRehearsalByID(vm.ChosenRehearsal.IntRehearsalID); Globals.rID = r.IntRehearsalID; //Rehearsal r = vm.ChosenRehearsal; List <RehearsalPart> rehearsalPartsForToday = get.GetRehearsalPartsByRehearsal(r); model.EventName = r.Event.StrName;; model.GroupName = r.Event.Group.StrName; model.Location = r.StrLocation; model.StartTime = r.DtmStartDateTime.ToString(); model.EndTime = r.DtmEndDateTime.ToString(); model.RehearsalDate = r.DtmStartDateTime.Date.ToString(); foreach (RehearsalPart rp in rehearsalPartsForToday) { rp.AttendancePlanned = get.GetAttendancePlannedByRehearsalPart(rp); rp.AttendanceActual = new List <AttendanceActual>(); foreach (AttendancePlanned ap in rp.AttendancePlanned) { rp.AttendanceActual = rp.AttendanceActual.Concat(get.GetAttendanceActualByPlanned(ap)).ToList(); } } model.Notes = r.StrNotes; model.LstAllRehearsalParts = rehearsalPartsForToday; get.CloseConnection(); Globals.PDF = model; return(View("GenerateReport", model)); }