public BedSpeciality GetByID(int _bedSpecialityId)
{
BedSpecialityDAC _bedSpecialityComponent = new BedSpecialityDAC();
IDataReader reader = _bedSpecialityComponent.GetByIDBedSpeciality(_bedSpecialityId);
BedSpeciality _bedSpeciality = null;
while (reader.Read())
{
_bedSpeciality = new BedSpeciality();
if (reader["BedSpecialityId"] != DBNull.Value)
{
_bedSpeciality.BedSpecialityId = Convert.ToInt32(reader["BedSpecialityId"]);
}
if (reader["WardRoomBedId"] != DBNull.Value)
{
_bedSpeciality.WardRoomBedId = Convert.ToInt32(reader["WardRoomBedId"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_bedSpeciality.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
if (reader["IsMainSpeciality"] != DBNull.Value)
{
_bedSpeciality.IsMainSpeciality = Convert.ToBoolean(reader["IsMainSpeciality"]);
}
if (reader["SpecialityOrder"] != DBNull.Value)
{
_bedSpeciality.SpecialityOrder = Convert.ToInt32(reader["SpecialityOrder"]);
}
_bedSpeciality.NewRecord = false;
}
reader.Close();
return(_bedSpeciality);
}
public bool Insert(BedSpeciality bedspeciality)
{
int autonumber = 0;
BedSpecialityDAC bedspecialityComponent = new BedSpecialityDAC();
bool endedSuccessfuly = bedspecialityComponent.InsertNewBedSpeciality(ref autonumber, bedspeciality.WardRoomBedId, bedspeciality.SpecialityId, bedspeciality.IsMainSpeciality, bedspeciality.SpecialityOrder);
if (endedSuccessfuly)
{
bedspeciality.BedSpecialityId = autonumber;
}
return(endedSuccessfuly);
}
public List <BedSpeciality> GetAll()
{
BedSpecialityDAC _bedSpecialityComponent = new BedSpecialityDAC();
IDataReader reader = _bedSpecialityComponent.GetAllBedSpeciality().CreateDataReader();
List <BedSpeciality> _bedSpecialityList = new List <BedSpeciality>();
while (reader.Read())
{
if (_bedSpecialityList == null)
{
_bedSpecialityList = new List <BedSpeciality>();
}
BedSpeciality _bedSpeciality = new BedSpeciality();
if (reader["BedSpecialityId"] != DBNull.Value)
{
_bedSpeciality.BedSpecialityId = Convert.ToInt32(reader["BedSpecialityId"]);
}
if (reader["WardRoomBedId"] != DBNull.Value)
{
_bedSpeciality.WardRoomBedId = Convert.ToInt32(reader["WardRoomBedId"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_bedSpeciality.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
if (reader["IsMainSpeciality"] != DBNull.Value)
{
_bedSpeciality.IsMainSpeciality = Convert.ToBoolean(reader["IsMainSpeciality"]);
}
if (reader["SpecialityOrder"] != DBNull.Value)
{
_bedSpeciality.SpecialityOrder = Convert.ToInt32(reader["SpecialityOrder"]);
}
_bedSpeciality.NewRecord = false;
_bedSpecialityList.Add(_bedSpeciality);
}
reader.Close();
return(_bedSpecialityList);
}
public bool Update(BedSpeciality bedspeciality, int old_bedSpecialityId)
{
BedSpecialityDAC bedspecialityComponent = new BedSpecialityDAC();
return(bedspecialityComponent.UpdateBedSpeciality(bedspeciality.WardRoomBedId, bedspeciality.SpecialityId, bedspeciality.IsMainSpeciality, bedspeciality.SpecialityOrder, old_bedSpecialityId));
}
