//GET: Prices public ActionResult Prices() { var procedureTotalPrices = _procedureRepository.GetProcedureTotalPrices() .Select(x => new ProcedureTotalPriceViewModel() { Price = x.Price, MedRecord = new MedRecordViewModel() { FirstName = x.MedRecord.FirstName, SecondName = x.MedRecord.SecondName, MedRecordId = x.MedRecord.MedRecordId, DOB = x.MedRecord.DOB }, Procedure = new ProcedureViewModel() { Name = x.Procedure.Name, ProcedureId = x.Procedure.ProcedureId }, Journal = new JournalViewModel() { JournalId = x.Journal.JournalId, ExecutingDate = x.Journal.ExecutingDate } }); return(View(procedureTotalPrices)); }