public bool Insert(string RoomTypeName) { RoomTypeDAC roomtypeComponent = new RoomTypeDAC(); int RoomTypeId = 0; return(roomtypeComponent.InsertNewRoomType(ref RoomTypeId, RoomTypeName)); }
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); }
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); }
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); }
public void Delete(int Original_RoomTypeId) { RoomTypeDAC roomtypeComponent = new RoomTypeDAC(); roomtypeComponent.DeleteRoomType(Original_RoomTypeId); }
public bool Update(string RoomTypeName, int Original_RoomTypeId) { RoomTypeDAC roomtypeComponent = new RoomTypeDAC(); return(roomtypeComponent.UpdateRoomType(RoomTypeName, Original_RoomTypeId)); }
public bool Update(RoomType roomtype, int old_roomTypeId) { RoomTypeDAC roomtypeComponent = new RoomTypeDAC(); return(roomtypeComponent.UpdateRoomType(roomtype.RoomTypeName, old_roomTypeId)); }
public int UpdateDataset(System.Data.DataSet dataset) { RoomTypeDAC roomtypecomponent = new RoomTypeDAC(); return(roomtypecomponent.UpdateDataset(dataset)); }