public List <WardRoom> GetAll()
{
WardRoomDAC _wardRoomComponent = new WardRoomDAC();
IDataReader reader = _wardRoomComponent.GetAllWardRoom().CreateDataReader();
List <WardRoom> _wardRoomList = new List <WardRoom>();
while (reader.Read())
{
if (_wardRoomList == null)
{
_wardRoomList = new List <WardRoom>();
}
WardRoom _wardRoom = new WardRoom();
if (reader["WardRoomId"] != DBNull.Value)
{
_wardRoom.WardRoomId = Convert.ToInt32(reader["WardRoomId"]);
}
if (reader["WardId"] != DBNull.Value)
{
_wardRoom.WardId = Convert.ToInt32(reader["WardId"]);
}
if (reader["RoomColor"] != DBNull.Value)
{
_wardRoom.RoomColor = Convert.ToString(reader["RoomColor"]);
}
if (reader["RoomNumber"] != DBNull.Value)
{
_wardRoom.RoomNumber = Convert.ToInt32(reader["RoomNumber"]);
}
if (reader["BedsNumber"] != DBNull.Value)
{
_wardRoom.BedsNumber = Convert.ToInt32(reader["BedsNumber"]);
}
if (reader["Capacity"] != DBNull.Value)
{
_wardRoom.Capacity = Convert.ToInt32(reader["Capacity"]);
}
if (reader["IsPrivate"] != DBNull.Value)
{
_wardRoom.IsPrivate = Convert.ToBoolean(reader["IsPrivate"]);
}
if (reader["RoomPhone"] != DBNull.Value)
{
_wardRoom.RoomPhone = Convert.ToString(reader["RoomPhone"]);
}
if (reader["WardRoomTypeId"] != DBNull.Value)
{
_wardRoom.WardRoomTypeId = Convert.ToInt32(reader["WardRoomTypeId"]);
}
if (reader["IsClosed"] != DBNull.Value)
{
_wardRoom.IsClosed = Convert.ToBoolean(reader["IsClosed"]);
}
_wardRoom.NewRecord = false;
_wardRoomList.Add(_wardRoom);
}
reader.Close();
return(_wardRoomList);
}
public WardRoom GetByID(int _wardRoomId)
{
WardRoomDAC _wardRoomComponent = new WardRoomDAC();
IDataReader reader = _wardRoomComponent.GetByIDWardRoom(_wardRoomId);
WardRoom _wardRoom = null;
while (reader.Read())
{
_wardRoom = new WardRoom();
if (reader["WardRoomId"] != DBNull.Value)
{
_wardRoom.WardRoomId = Convert.ToInt32(reader["WardRoomId"]);
}
if (reader["WardId"] != DBNull.Value)
{
_wardRoom.WardId = Convert.ToInt32(reader["WardId"]);
}
if (reader["RoomTypeId"] != DBNull.Value)
{
_wardRoom.RoomTypeId = Convert.ToInt32(reader["RoomTypeId"]);
}
if (reader["RoomCode"] != DBNull.Value)
{
_wardRoom.RoomCode = Convert.ToString(reader["RoomCode"]);
}
if (reader["RoomDescription"] != DBNull.Value)
{
_wardRoom.RoomDescription = Convert.ToString(reader["RoomDescription"]);
}
if (reader["RoomColor"] != DBNull.Value)
{
_wardRoom.RoomColor = Convert.ToString(reader["RoomColor"]);
}
if (reader["Capacity"] != DBNull.Value)
{
_wardRoom.Capacity = Convert.ToInt32(reader["Capacity"]);
}
if (reader["BedsNumber"] != DBNull.Value)
{
_wardRoom.BedsNumber = Convert.ToInt32(reader["BedsNumber"]);
}
if (reader["RoomPhone"] != DBNull.Value)
{
_wardRoom.RoomPhone = Convert.ToString(reader["RoomPhone"]);
}
if (reader["IsClosed"] != DBNull.Value)
{
_wardRoom.IsClosed = Convert.ToBoolean(reader["IsClosed"]);
}
if (reader["ClosingReason"] != DBNull.Value)
{
_wardRoom.ClosingReason = Convert.ToString(reader["ClosingReason"]);
}
_wardRoom.NewRecord = false;
}
reader.Close();
return(_wardRoom);
}
public bool Insert(WardRoom wardroom)
{
int autonumber = 0;
WardRoomDAC wardroomComponent = new WardRoomDAC();
bool endedSuccessfuly = wardroomComponent.InsertNewWardRoom(ref autonumber, wardroom.WardId, wardroom.RoomColor, wardroom.RoomNumber, wardroom.BedsNumber, wardroom.Capacity, wardroom.IsPrivate, wardroom.RoomPhone, wardroom.WardRoomTypeId, wardroom.IsClosed);
if (endedSuccessfuly)
{
wardroom.WardRoomId = autonumber;
}
return(endedSuccessfuly);
}
public bool Update(WardRoom wardroom, int old_wardRoomId)
{
WardRoomDAC wardroomComponent = new WardRoomDAC();
return(wardroomComponent.UpdateWardRoom(wardroom.WardId, wardroom.RoomColor, wardroom.RoomNumber, wardroom.BedsNumber, wardroom.Capacity, wardroom.IsPrivate, wardroom.RoomPhone, wardroom.WardRoomTypeId, wardroom.IsClosed, old_wardRoomId));
}
public void GetAllWardRoomDetails(List <Ward> wards)
{
WardRoomDAC _wardRoomComponent = new WardRoomDAC();
IDataReader reader = _wardRoomComponent.ViewWardRoomBeds().CreateDataReader();
List <WardRoom> _wardRoomList = new List <WardRoom>();
while (reader.Read())
{
if (_wardRoomList == null)
{
_wardRoomList = new List <WardRoom>();
}
int wardId = Convert.ToInt32(reader["WardId"]);
Ward ward = GetWardFromListById(wards, wardId);
if (ward != null)
{
ward.SetWardRooms();
int wardRoomId = Convert.ToInt32(reader["WardRoomId"]);
WardRoom _wardRoom = GetWardRoomFromListById(ward.WardRooms, wardRoomId);
if (_wardRoom.NewRecord)
{
if (reader["WardRoomId"] != DBNull.Value)
{
_wardRoom.WardRoomId = Convert.ToInt32(reader["WardRoomId"]);
}
if (reader["WardId"] != DBNull.Value)
{
_wardRoom.WardId = Convert.ToInt32(reader["WardId"]);
}
if (reader["RoomNumber"] != DBNull.Value)
{
_wardRoom.RoomNumber = Convert.ToInt32(reader["RoomNumber"]);
}
if (reader["RoomColor"] != DBNull.Value)
{
_wardRoom.RoomColor = Convert.ToString(reader["RoomColor"]);
}
if (reader["BedsNumber"] != DBNull.Value)
{
_wardRoom.BedsNumber = Convert.ToInt32(reader["BedsNumber"]);
}
if (reader["Capacity"] != DBNull.Value)
{
_wardRoom.Capacity = Convert.ToInt32(reader["Capacity"]);
}
if (reader["IsPrivate"] != DBNull.Value)
{
_wardRoom.IsPrivate = Convert.ToBoolean(reader["IsPrivate"]);
}
if (reader["RoomPhone"] != DBNull.Value)
{
_wardRoom.RoomPhone = Convert.ToString(reader["RoomPhone"]);
}
if (reader["WardRoomTypeId"] != DBNull.Value)
{
_wardRoom.WardRoomTypeId = Convert.ToInt32(reader["WardRoomTypeId"]);
}
_wardRoom.NewRecord = false;
ward.WardRooms.Add(_wardRoom);
}
WardBed _wardBed = new WardBed();
if (reader["WardBedId"] != DBNull.Value)
{
_wardBed.WardBedId = Convert.ToInt32(reader["WardBedId"]);
}
if (reader["WardRoomId"] != DBNull.Value)
{
_wardBed.WardRoomId = Convert.ToInt32(reader["WardRoomId"]);
}
if (reader["BedNumber"] != DBNull.Value)
{
_wardBed.BedNumber = Convert.ToInt32(reader["BedNumber"]);
}
if (reader["BedCode"] != DBNull.Value)
{
_wardBed.BedCode = Convert.ToString(reader["BedCode"]);
}
if (reader["BedStatus"] != DBNull.Value)
{
_wardBed.BedStatus = Convert.ToString(reader["BedStatus"]);
}
if (reader["BedType"] != DBNull.Value)
{
_wardBed.BedType = Convert.ToString(reader["BedType"]);
}
if (reader["BedStatusPercentage"] != DBNull.Value)
{
_wardBed.BedStatusPercentage = Convert.ToInt32(reader["BedStatusPercentage"]);
}
_wardBed.NewRecord = false;
_wardRoom.SetWardBeds();
_wardRoom.WardBeds.Add(_wardBed);
}
}
reader.Close();
}
