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