Пример #1
0
        public bool Insert(string RoomTypeName)
        {
            RoomTypeDAC roomtypeComponent = new RoomTypeDAC();
            int         RoomTypeId        = 0;

            return(roomtypeComponent.InsertNewRoomType(ref RoomTypeId, RoomTypeName));
        }
Пример #2
0
        public List <RoomType> GetAll()
        {
            RoomTypeDAC     _roomTypeComponent = new RoomTypeDAC();
            IDataReader     reader             = _roomTypeComponent.GetAllRoomType().CreateDataReader();
            List <RoomType> _roomTypeList      = new List <RoomType>();

            while (reader.Read())
            {
                if (_roomTypeList == null)
                {
                    _roomTypeList = new List <RoomType>();
                }
                RoomType _roomType = new RoomType();
                if (reader["RoomTypeId"] != DBNull.Value)
                {
                    _roomType.RoomTypeId = Convert.ToInt32(reader["RoomTypeId"]);
                }
                if (reader["RoomTypeName"] != DBNull.Value)
                {
                    _roomType.RoomTypeName = Convert.ToString(reader["RoomTypeName"]);
                }
                _roomType.NewRecord = false;
                _roomTypeList.Add(_roomType);
            }
            reader.Close();
            return(_roomTypeList);
        }
Пример #3
0
        public bool Insert(RoomType roomtype)
        {
            int         autonumber        = 0;
            RoomTypeDAC roomtypeComponent = new RoomTypeDAC();
            bool        endedSuccessfuly  = roomtypeComponent.InsertNewRoomType(ref autonumber, roomtype.RoomTypeName);

            if (endedSuccessfuly)
            {
                roomtype.RoomTypeId = autonumber;
            }
            return(endedSuccessfuly);
        }
Пример #4
0
        public RoomType GetByID(int _roomTypeId)
        {
            RoomTypeDAC _roomTypeComponent = new RoomTypeDAC();
            IDataReader reader             = _roomTypeComponent.GetByIDRoomType(_roomTypeId);
            RoomType    _roomType          = null;

            while (reader.Read())
            {
                _roomType = new RoomType();
                if (reader["RoomTypeId"] != DBNull.Value)
                {
                    _roomType.RoomTypeId = Convert.ToInt32(reader["RoomTypeId"]);
                }
                if (reader["RoomTypeName"] != DBNull.Value)
                {
                    _roomType.RoomTypeName = Convert.ToString(reader["RoomTypeName"]);
                }
                _roomType.NewRecord = false;
            }
            reader.Close();
            return(_roomType);
        }
Пример #5
0
        public void Delete(int Original_RoomTypeId)
        {
            RoomTypeDAC roomtypeComponent = new RoomTypeDAC();

            roomtypeComponent.DeleteRoomType(Original_RoomTypeId);
        }
Пример #6
0
        public bool Update(string RoomTypeName, int Original_RoomTypeId)
        {
            RoomTypeDAC roomtypeComponent = new RoomTypeDAC();

            return(roomtypeComponent.UpdateRoomType(RoomTypeName, Original_RoomTypeId));
        }
Пример #7
0
        public bool Update(RoomType roomtype, int old_roomTypeId)
        {
            RoomTypeDAC roomtypeComponent = new RoomTypeDAC();

            return(roomtypeComponent.UpdateRoomType(roomtype.RoomTypeName, old_roomTypeId));
        }
Пример #8
0
        public int UpdateDataset(System.Data.DataSet dataset)
        {
            RoomTypeDAC roomtypecomponent = new RoomTypeDAC();

            return(roomtypecomponent.UpdateDataset(dataset));
        }