Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        //  private OnlineHotelReservationEntities db = new OnlineHotelReservationEntities();
        // GET: /RoomsforPublicView/
        public ActionResult Index()
        {
            RoomsForPublic rooms = new RoomsForPublic();

            return(View(rooms.GetAllRoomsForPublic()));
        }