public List <WardRoomType> GetAll() { WardRoomTypeDAC _wardRoomTypeComponent = new WardRoomTypeDAC(); IDataReader reader = _wardRoomTypeComponent.GetAllWardRoomType().CreateDataReader(); List <WardRoomType> _wardRoomTypeList = new List <WardRoomType>(); while (reader.Read()) { if (_wardRoomTypeList == null) { _wardRoomTypeList = new List <WardRoomType>(); } WardRoomType _wardRoomType = new WardRoomType(); if (reader["WardRoomTypeId"] != DBNull.Value) { _wardRoomType.WardRoomTypeId = Convert.ToInt32(reader["WardRoomTypeId"]); } if (reader["WardRoomTypeName"] != DBNull.Value) { _wardRoomType.WardRoomTypeName = Convert.ToString(reader["WardRoomTypeName"]); } _wardRoomType.NewRecord = false; _wardRoomTypeList.Add(_wardRoomType); } reader.Close(); return(_wardRoomTypeList); }
public bool Insert(WardRoomType wardroomtype) { int autonumber = 0; WardRoomTypeDAC wardroomtypeComponent = new WardRoomTypeDAC(); bool endedSuccessfuly = wardroomtypeComponent.InsertNewWardRoomType(ref autonumber, wardroomtype.WardRoomTypeName); if (endedSuccessfuly) { wardroomtype.WardRoomTypeId = autonumber; } return(endedSuccessfuly); }
public WardRoomType GetByID(int _wardRoomTypeId) { WardRoomTypeDAC _wardRoomTypeComponent = new WardRoomTypeDAC(); IDataReader reader = _wardRoomTypeComponent.GetByIDWardRoomType(_wardRoomTypeId); WardRoomType _wardRoomType = null; while (reader.Read()) { _wardRoomType = new WardRoomType(); if (reader["WardRoomTypeId"] != DBNull.Value) { _wardRoomType.WardRoomTypeId = Convert.ToInt32(reader["WardRoomTypeId"]); } if (reader["WardRoomTypeName"] != DBNull.Value) { _wardRoomType.WardRoomTypeName = Convert.ToString(reader["WardRoomTypeName"]); } _wardRoomType.NewRecord = false; } reader.Close(); return(_wardRoomType); }
public bool Update(WardRoomType wardroomtype, int old_wardRoomTypeId) { WardRoomTypeDAC wardroomtypeComponent = new WardRoomTypeDAC(); return(wardroomtypeComponent.UpdateWardRoomType(wardroomtype.WardRoomTypeName, old_wardRoomTypeId)); }