예제 #1
0
        public List <EntityLayers.RoomType> BookNowDDLWCF()
        {
            try
            {
                SqlCommand _cmd = new SqlCommand("select RoomType, RoomTypeID from RoomType", _conObj);
                _conObj.Open();
                SqlDataReader dr = _cmd.ExecuteReader();

                List <EntityLayers.RoomType> _listObj1 = new List <EntityLayers.RoomType>();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        EntityLayers.RoomType _menuIDObj = new EntityLayers.RoomType()
                        {
                            _roomType   = dr[0].ToString(),
                            _roomTypeID = int.Parse(dr[1].ToString())
                        };
                        _listObj1.Add(_menuIDObj);
                    }
                }

                return(_listObj1);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                _conObj.Close();
            }
        }
        /// <summary>
        /// Method for Retreving values for Drop Down List for displaying Room Type
        /// </summary>
        /// <returns>Returns the list of Roomtype and RomTypeID</returns>
        public List <EntityLayers.RoomType> RoomTypes()
        {
            SqlConnection _conobj = new SqlConnection(constr);

            try
            {
                SqlCommand _cmd = new SqlCommand("select RoomType,RoomTypeID from RoomType", _conobj);
                _conobj.Open();

                SqlDataReader dr = _cmd.ExecuteReader();

                List <EntityLayers.RoomType> _listObj = new List <EntityLayers.RoomType>();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        EntityLayers.RoomType _roomtypeObj = new EntityLayers.RoomType()
                        {
                            _roomType   = dr[0].ToString(),
                            _roomTypeID = int.Parse(dr[1].ToString())
                        };
                        _listObj.Add(_roomtypeObj);
                    }
                }
                _cmd.Dispose();
                return(_listObj);
            }
            catch (SqlException)
            {
                throw;
            }
            finally
            {
                _conobj.Close();
            }
        }