public WardRoomSpeciality GetByID(int _roomSpecialityId)
{
WardRoomSpecialityDAC _wardRoomSpecialityComponent = new WardRoomSpecialityDAC();
IDataReader reader = _wardRoomSpecialityComponent.GetByIDWardRoomSpeciality(_roomSpecialityId);
WardRoomSpeciality _wardRoomSpeciality = null;
while (reader.Read())
{
_wardRoomSpeciality = new WardRoomSpeciality();
if (reader["RoomSpecialityId"] != DBNull.Value)
{
_wardRoomSpeciality.RoomSpecialityId = Convert.ToInt32(reader["RoomSpecialityId"]);
}
if (reader["WardRoomId"] != DBNull.Value)
{
_wardRoomSpeciality.WardRoomId = Convert.ToInt32(reader["WardRoomId"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_wardRoomSpeciality.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
if (reader["IsMainSpeciality"] != DBNull.Value)
{
_wardRoomSpeciality.IsMainSpeciality = Convert.ToBoolean(reader["IsMainSpeciality"]);
}
if (reader["SpecialityOrder"] != DBNull.Value)
{
_wardRoomSpeciality.SpecialityOrder = Convert.ToInt32(reader["SpecialityOrder"]);
}
_wardRoomSpeciality.NewRecord = false;
}
reader.Close();
return(_wardRoomSpeciality);
}
public bool Insert(WardRoomSpeciality wardroomspeciality)
{
int autonumber = 0;
WardRoomSpecialityDAC wardroomspecialityComponent = new WardRoomSpecialityDAC();
bool endedSuccessfuly = wardroomspecialityComponent.InsertNewWardRoomSpeciality(ref autonumber, wardroomspeciality.WardRoomId, wardroomspeciality.SpecialityId, wardroomspeciality.IsMainSpeciality, wardroomspeciality.SpecialityOrder);
if (endedSuccessfuly)
{
wardroomspeciality.RoomSpecialityId = autonumber;
}
return(endedSuccessfuly);
}
public List <WardRoomSpeciality> GetAll()
{
WardRoomSpecialityDAC _wardRoomSpecialityComponent = new WardRoomSpecialityDAC();
IDataReader reader = _wardRoomSpecialityComponent.GetAllWardRoomSpeciality().CreateDataReader();
List <WardRoomSpeciality> _wardRoomSpecialityList = new List <WardRoomSpeciality>();
while (reader.Read())
{
if (_wardRoomSpecialityList == null)
{
_wardRoomSpecialityList = new List <WardRoomSpeciality>();
}
WardRoomSpeciality _wardRoomSpeciality = new WardRoomSpeciality();
if (reader["RoomSpecialityId"] != DBNull.Value)
{
_wardRoomSpeciality.RoomSpecialityId = Convert.ToInt32(reader["RoomSpecialityId"]);
}
if (reader["WardRoomId"] != DBNull.Value)
{
_wardRoomSpeciality.WardRoomId = Convert.ToInt32(reader["WardRoomId"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_wardRoomSpeciality.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
if (reader["IsMainSpeciality"] != DBNull.Value)
{
_wardRoomSpeciality.IsMainSpeciality = Convert.ToBoolean(reader["IsMainSpeciality"]);
}
if (reader["SpecialityOrder"] != DBNull.Value)
{
_wardRoomSpeciality.SpecialityOrder = Convert.ToInt32(reader["SpecialityOrder"]);
}
_wardRoomSpeciality.NewRecord = false;
_wardRoomSpecialityList.Add(_wardRoomSpeciality);
}
reader.Close();
return(_wardRoomSpecialityList);
}
public bool Update(WardRoomSpeciality wardroomspeciality, int old_roomSpecialityId)
{
WardRoomSpecialityDAC wardroomspecialityComponent = new WardRoomSpecialityDAC();
return(wardroomspecialityComponent.UpdateWardRoomSpeciality(wardroomspeciality.WardRoomId, wardroomspeciality.SpecialityId, wardroomspeciality.IsMainSpeciality, wardroomspeciality.SpecialityOrder, old_roomSpecialityId));
}
