public bool Insert(string HospitalName, string Phone, string Fax, string Email, string SiteURL, int UserID) { HospitalDAC hospitalComponent = new HospitalDAC(); int EligibilityHospitalID = 0; return(hospitalComponent.InsertNewHospital(ref EligibilityHospitalID, HospitalName, Phone, Fax, Email, SiteURL, UserID)); }
public bool Insert(Hospital hospital) { int autonumber = 0; HospitalDAC hospitalComponent = new HospitalDAC(); bool endedSuccessfuly = hospitalComponent.InsertNewHospital(ref autonumber, hospital.HospitalName, hospital.Phone, hospital.Fax, hospital.Email, hospital.SiteURL, hospital.UserID); if (endedSuccessfuly) { hospital.EligibilityHospitalID = autonumber; } return(endedSuccessfuly); }
public List <Hospital> GetAll() { HospitalDAC _hospitalComponent = new HospitalDAC(); IDataReader reader = _hospitalComponent.GetAllHospital().CreateDataReader(); List <Hospital> _hospitalList = new List <Hospital>(); while (reader.Read()) { if (_hospitalList == null) { _hospitalList = new List <Hospital>(); } Hospital _hospital = new Hospital(); if (reader["EligibilityHospitalID"] != DBNull.Value) { _hospital.EligibilityHospitalID = Convert.ToInt32(reader["EligibilityHospitalID"]); } if (reader["HospitalName"] != DBNull.Value) { _hospital.HospitalName = Convert.ToString(reader["HospitalName"]); } if (reader["Phone"] != DBNull.Value) { _hospital.Phone = Convert.ToString(reader["Phone"]); } if (reader["Fax"] != DBNull.Value) { _hospital.Fax = Convert.ToString(reader["Fax"]); } if (reader["Email"] != DBNull.Value) { _hospital.Email = Convert.ToString(reader["Email"]); } if (reader["SiteURL"] != DBNull.Value) { _hospital.SiteURL = Convert.ToString(reader["SiteURL"]); } if (reader["UserID"] != DBNull.Value) { _hospital.UserID = Convert.ToInt32(reader["UserID"]); } _hospital.NewRecord = false; _hospitalList.Add(_hospital); } reader.Close(); return(_hospitalList); }
public Hospital GetByID(int _eligibilityHospitalID) { HospitalDAC _hospitalComponent = new HospitalDAC(); IDataReader reader = _hospitalComponent.GetByIDHospital(_eligibilityHospitalID); Hospital _hospital = null; while (reader.Read()) { _hospital = new Hospital(); if (reader["EligibilityHospitalID"] != DBNull.Value) { _hospital.EligibilityHospitalID = Convert.ToInt32(reader["EligibilityHospitalID"]); } if (reader["HospitalName"] != DBNull.Value) { _hospital.HospitalName = Convert.ToString(reader["HospitalName"]); } if (reader["Phone"] != DBNull.Value) { _hospital.Phone = Convert.ToString(reader["Phone"]); } if (reader["Fax"] != DBNull.Value) { _hospital.Fax = Convert.ToString(reader["Fax"]); } if (reader["Email"] != DBNull.Value) { _hospital.Email = Convert.ToString(reader["Email"]); } if (reader["SiteURL"] != DBNull.Value) { _hospital.SiteURL = Convert.ToString(reader["SiteURL"]); } if (reader["UserID"] != DBNull.Value) { _hospital.UserID = Convert.ToInt32(reader["UserID"]); } _hospital.NewRecord = false; } reader.Close(); return(_hospital); }
public bool Update(Hospital hospital, int old_eligibilityHospitalID) { HospitalDAC hospitalComponent = new HospitalDAC(); return(hospitalComponent.UpdateHospital(hospital.HospitalName, hospital.Phone, hospital.Fax, hospital.Email, hospital.SiteURL, hospital.UserID, old_eligibilityHospitalID)); }
public int UpdateDataset(System.Data.DataSet dataset) { HospitalDAC hospitalcomponent = new HospitalDAC(); return(hospitalcomponent.UpdateDataset(dataset)); }
public void Delete(int Original_EligibilityHospitalID) { HospitalDAC hospitalComponent = new HospitalDAC(); hospitalComponent.DeleteHospital(Original_EligibilityHospitalID); }
public bool Update(string HospitalName, string Phone, string Fax, string Email, string SiteURL, int UserID, int Original_EligibilityHospitalID) { HospitalDAC hospitalComponent = new HospitalDAC(); return(hospitalComponent.UpdateHospital(HospitalName, Phone, Fax, Email, SiteURL, UserID, Original_EligibilityHospitalID)); }