public List <WardBed> GetAll()
{
WardBedDAC _wardBedComponent = new WardBedDAC();
IDataReader reader = _wardBedComponent.GetAllWardBed().CreateDataReader();
List <WardBed> _wardBedList = new List <WardBed>();
while (reader.Read())
{
if (_wardBedList == null)
{
_wardBedList = new List <WardBed>();
}
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"]);
}
if (reader["CurrentPatientCode"] != DBNull.Value)
{
_wardBed.CurrentPatientCode = Convert.ToString(reader["CurrentPatientCode"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_wardBed.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
_wardBed.NewRecord = false;
_wardBedList.Add(_wardBed);
}
reader.Close();
return(_wardBedList);
}
public bool Insert(WardBed wardbed)
{
int autonumber = 0;
WardBedDAC wardbedComponent = new WardBedDAC();
bool endedSuccessfuly = wardbedComponent.InsertNewWardBed(ref autonumber, wardbed.WardRoomId, wardbed.BedNumber, wardbed.BedCode, wardbed.BedStatus, wardbed.BedType, wardbed.BedStatusPercentage, wardbed.CurrentPatientCode, wardbed.SpecialityId);
if (endedSuccessfuly)
{
wardbed.WardBedId = autonumber;
}
return(endedSuccessfuly);
}
public WardBed GetByID(int _wardBedId)
{
WardBedDAC _wardBedComponent = new WardBedDAC();
IDataReader reader = _wardBedComponent.GetByIDWardBed(_wardBedId);
WardBed _wardBed = null;
while (reader.Read())
{
_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"]);
}
if (reader["CurrentPatientCode"] != DBNull.Value)
{
_wardBed.CurrentPatientCode = Convert.ToString(reader["CurrentPatientCode"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_wardBed.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
_wardBed.NewRecord = false;
}
reader.Close();
return(_wardBed);
}
public bool Update(WardBed wardbed, int old_wardBedId)
{
WardBedDAC wardbedComponent = new WardBedDAC();
return(wardbedComponent.UpdateWardBed(wardbed.WardRoomId, wardbed.BedNumber, wardbed.BedCode, wardbed.BedStatus, wardbed.BedType, wardbed.BedStatusPercentage, wardbed.CurrentPatientCode, wardbed.SpecialityId, old_wardBedId));
}
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();
}
