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)); }