public IEnumerable <RoomsForPublic> GetAllRoomsForPublic() { SqlConnection con = new SqlConnection(ConnectionString); string command = "[dbo].[RoomsForPublicView]"; SqlCommand cmd = new SqlCommand(command, con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader; List <RoomsForPublic> listofAllRooms = new List <RoomsForPublic>(); try { con.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { RoomsForPublic roomDetails = new RoomsForPublic(); roomDetails.ROOM_ID = reader["ROOM_ID"].ToString(); roomDetails.ROOM_TYPE = reader["ROOM_TYPE"].ToString(); roomDetails.DESCRIPTION = reader["DESCRIPTION"].ToString(); roomDetails.MAX_GUEST = Convert.ToDecimal(reader["MAX_GUEST"]); roomDetails.DISCOUNT = Convert.ToDecimal(reader["DISCOUNT"]); roomDetails.ROOM_PRICE = Convert.ToDecimal(reader["ROOM_PRICE"]); roomDetails.TOTAL_ROOMS = Convert.ToDecimal(reader["TOTAL_ROOMS"]); roomDetails.STATUS = reader["STATUS"].ToString(); listofAllRooms.Add(roomDetails); } } catch { throw; } reader.Close(); con.Close(); return(listofAllRooms); }
// private OnlineHotelReservationEntities db = new OnlineHotelReservationEntities(); // GET: /RoomsforPublicView/ public ActionResult Index() { RoomsForPublic rooms = new RoomsForPublic(); return(View(rooms.GetAllRoomsForPublic())); }