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));
}
