public ActionResult FreeRoomReport(FreeRoomReportModel model)
{
var sql =
"select rm.* from Rooms rm " +
"where not exists(" +
"select * from Reservations rs " +
"where rs.RoomId = rm.Id and " +
"(rs.ArrivalDate < '{0}' and rs.DepartureDate > '{1}' or " +
"rs.ArrivalDate < '{0}' and rs.DepartureDate > '{1}' or rs.ArrivalDate >= '{0}' and rs.DepartureDate <= '{1}'));";
var from = DateTime.Parse(model.From);
var to = DateTime.Parse(model.To);
var formatSql = string.Format(sql, from.ToString("yyyy-MM-dd HH:mm:ss"), to.ToString("yyyy-MM-dd HH:mm:ss"));
var rooms = db.Rooms.SqlQuery(formatSql).ToList();
return View(rooms);
}
public ActionResult FreeRoomReport(FreeRoomReportModel model)
{
var sql =
"select rm.* from Rooms rm " +
"where not exists(" +
"select * from Reservations rs " +
"where rs.RoomId = rm.Id and " +
"(rs.ArrivalDate < '{0}' and rs.DepartureDate > '{1}' or " +
"rs.ArrivalDate < '{0}' and rs.DepartureDate > '{1}' or rs.ArrivalDate >= '{0}' and rs.DepartureDate <= '{1}'));";
var from = DateTime.Parse(model.From);
var to = DateTime.Parse(model.To);
var formatSql = string.Format(sql, from.ToString("yyyy-MM-dd HH:mm:ss"), to.ToString("yyyy-MM-dd HH:mm:ss"));
var rooms = db.Rooms.SqlQuery(formatSql).ToList();
return(View(rooms));
}
