public Speciality GetByID(int _specialityId) { SpecialityDAC _specialityComponent = new SpecialityDAC(); IDataReader reader = _specialityComponent.GetByIDSpeciality(_specialityId); Speciality _speciality = null; while (reader.Read()) { _speciality = new Speciality(); if (reader["SpecialityId"] != DBNull.Value) { _speciality.SpecialityId = Convert.ToInt32(reader["SpecialityId"]); } if (reader["SpecialityCode"] != DBNull.Value) { _speciality.SpecialityCode = Convert.ToString(reader["SpecialityCode"]); } if (reader["SpecialityName"] != DBNull.Value) { _speciality.SpecialityName = Convert.ToString(reader["SpecialityName"]); } if (reader["SpecialityAbbreviation"] != DBNull.Value) { _speciality.SpecialityAbbreviation = Convert.ToString(reader["SpecialityAbbreviation"]); } _speciality.NewRecord = false; } reader.Close(); return(_speciality); }
public bool Insert(string SpecialityCode, string SpecialityName, string SpecialityAbbreviation) { SpecialityDAC specialityComponent = new SpecialityDAC(); int SpecialityId = 0; return(specialityComponent.InsertNewSpeciality(ref SpecialityId, SpecialityCode, SpecialityName, SpecialityAbbreviation)); }
public List <Speciality> GetAll() { SpecialityDAC _specialityComponent = new SpecialityDAC(); IDataReader reader = _specialityComponent.GetAllSpeciality().CreateDataReader(); List <Speciality> _specialityList = new List <Speciality>(); while (reader.Read()) { if (_specialityList == null) { _specialityList = new List <Speciality>(); } Speciality _speciality = new Speciality(); if (reader["SpecialityId"] != DBNull.Value) { _speciality.SpecialityId = Convert.ToInt32(reader["SpecialityId"]); } if (reader["SpecialityCode"] != DBNull.Value) { _speciality.SpecialityCode = Convert.ToString(reader["SpecialityCode"]); } if (reader["SpecialityName"] != DBNull.Value) { _speciality.SpecialityName = Convert.ToString(reader["SpecialityName"]); } if (reader["SpecialityAbbreviation"] != DBNull.Value) { _speciality.SpecialityAbbreviation = Convert.ToString(reader["SpecialityAbbreviation"]); } _speciality.NewRecord = false; _specialityList.Add(_speciality); } reader.Close(); return(_specialityList); }
public bool Insert(string SpecialityCode, string SpecialityName, string BedDisplayCode) { SpecialityDAC specialityComponent = new SpecialityDAC(); int SpecialityId = 0; return(specialityComponent.InsertNewSpeciality(ref SpecialityId, SpecialityCode, SpecialityName, BedDisplayCode)); }
public bool Insert(Speciality speciality) { int autonumber = 0; SpecialityDAC specialityComponent = new SpecialityDAC(); bool endedSuccessfuly = specialityComponent.InsertNewSpeciality(ref autonumber, speciality.SpecialityCode, speciality.SpecialityName, speciality.SpecialityAbbreviation); if (endedSuccessfuly) { speciality.SpecialityId = autonumber; } return(endedSuccessfuly); }
public bool Update(string SpecialityCode, string SpecialityName, string SpecialityAbbreviation, int Original_SpecialityId) { SpecialityDAC specialityComponent = new SpecialityDAC(); return(specialityComponent.UpdateSpeciality(SpecialityCode, SpecialityName, SpecialityAbbreviation, Original_SpecialityId)); }
public bool Update(Speciality speciality, int old_specialityId) { SpecialityDAC specialityComponent = new SpecialityDAC(); return(specialityComponent.UpdateSpeciality(speciality.SpecialityCode, speciality.SpecialityName, speciality.SpecialityAbbreviation, old_specialityId)); }
public int UpdateDataset(System.Data.DataSet dataset) { SpecialityDAC specialitycomponent = new SpecialityDAC(); return(specialitycomponent.UpdateDataset(dataset)); }
public void Delete(int Original_SpecialityId) { SpecialityDAC specialityComponent = new SpecialityDAC(); specialityComponent.DeleteSpeciality(Original_SpecialityId); }
public bool Update(string SpecialityCode, string SpecialityName, string BedDisplayCode, int Original_SpecialityId) { SpecialityDAC specialityComponent = new SpecialityDAC(); return(specialityComponent.UpdateSpeciality(SpecialityCode, SpecialityName, BedDisplayCode, Original_SpecialityId)); }
public bool Update(Speciality speciality, int old_specialityId) { SpecialityDAC specialityComponent = new SpecialityDAC(); return(specialityComponent.UpdateSpeciality(speciality.SpecialityCode, speciality.SpecialityName, speciality.BedDisplayCode, old_specialityId)); }