public ActionResult VisitorHotelReport(VisitorHotelReportModel model) { var sql = "select min(hs.Title) as HotelTitle, min(rm.Number) as RoomNumber, Count(*) as Count from Visitors vs join Reservations rs on vs.Id = rs.VisitorId join Rooms rm on rm.Id = rs.RoomId join Hotels hs on hs.Id = rm.HotelId where vs.FirstName + vs.MiddleName + vs.SecondName like '%{0}%' group by rm.Id; "; var formatSql = string.Format(sql, model.VisitorName); var items = db.Database.SqlQuery<VisitorHotelItemModel>(formatSql).ToList(); return View(items); }
public ActionResult VisitorHotelReport(VisitorHotelReportModel model) { var sql = "select min(hs.Title) as HotelTitle, min(rm.Number) as RoomNumber, Count(*) as Count from Visitors vs join Reservations rs on vs.Id = rs.VisitorId join Rooms rm on rm.Id = rs.RoomId join Hotels hs on hs.Id = rm.HotelId where vs.FirstName + vs.MiddleName + vs.SecondName like '%{0}%' group by rm.Id; "; var formatSql = string.Format(sql, model.VisitorName); var items = db.Database.SqlQuery <VisitorHotelItemModel>(formatSql).ToList(); return(View(items)); }