public bool Insert(ResearchChairs researchchairs) { int autonumber = 0; ResearchChairsDAC researchchairsComponent = new ResearchChairsDAC(); bool endedSuccessfuly = researchchairsComponent.InsertNewResearchChairs(ref autonumber, researchchairs.Name, researchchairs.Description, researchchairs.Phone1, researchchairs.Phone2, researchchairs.Fax1, researchchairs.Fax2); if (endedSuccessfuly) { researchchairs.ResearchChairId = autonumber; } return(endedSuccessfuly); }
public List <ResearchChairs> GetAll() { ResearchChairsDAC _researchChairsComponent = new ResearchChairsDAC(); IDataReader reader = _researchChairsComponent.GetAllResearchChairs().CreateDataReader(); List <ResearchChairs> _researchChairsList = new List <ResearchChairs>(); while (reader.Read()) { if (_researchChairsList == null) { _researchChairsList = new List <ResearchChairs>(); } ResearchChairs _researchChairs = new ResearchChairs(); if (reader["ResearchChairId"] != DBNull.Value) { _researchChairs.ResearchChairId = Convert.ToInt32(reader["ResearchChairId"]); } if (reader["Name"] != DBNull.Value) { _researchChairs.Name = Convert.ToString(reader["Name"]); } if (reader["Description"] != DBNull.Value) { _researchChairs.Description = Convert.ToString(reader["Description"]); } if (reader["Phone1"] != DBNull.Value) { _researchChairs.Phone1 = Convert.ToString(reader["Phone1"]); } if (reader["Phone2"] != DBNull.Value) { _researchChairs.Phone2 = Convert.ToString(reader["Phone2"]); } if (reader["Fax1"] != DBNull.Value) { _researchChairs.Fax1 = Convert.ToString(reader["Fax1"]); } if (reader["Fax2"] != DBNull.Value) { _researchChairs.Fax2 = Convert.ToString(reader["Fax2"]); } _researchChairs.NewRecord = false; _researchChairsList.Add(_researchChairs); } reader.Close(); return(_researchChairsList); }
public ResearchChairs GetByID(int _researchChairId) { ResearchChairsDAC _researchChairsComponent = new ResearchChairsDAC(); IDataReader reader = _researchChairsComponent.GetByIDResearchChairs(_researchChairId); ResearchChairs _researchChairs = null; while (reader.Read()) { _researchChairs = new ResearchChairs(); if (reader["ResearchChairId"] != DBNull.Value) { _researchChairs.ResearchChairId = Convert.ToInt32(reader["ResearchChairId"]); } if (reader["Name"] != DBNull.Value) { _researchChairs.Name = Convert.ToString(reader["Name"]); } if (reader["Description"] != DBNull.Value) { _researchChairs.Description = Convert.ToString(reader["Description"]); } if (reader["Phone1"] != DBNull.Value) { _researchChairs.Phone1 = Convert.ToString(reader["Phone1"]); } if (reader["Phone2"] != DBNull.Value) { _researchChairs.Phone2 = Convert.ToString(reader["Phone2"]); } if (reader["Fax1"] != DBNull.Value) { _researchChairs.Fax1 = Convert.ToString(reader["Fax1"]); } if (reader["Fax2"] != DBNull.Value) { _researchChairs.Fax2 = Convert.ToString(reader["Fax2"]); } _researchChairs.NewRecord = false; } reader.Close(); return(_researchChairs); }
public bool Update(ResearchChairs researchchairs, int old_researchChairId) { ResearchChairsDAC researchchairsComponent = new ResearchChairsDAC(); return(researchchairsComponent.UpdateResearchChairs(researchchairs.Name, researchchairs.Description, researchchairs.Phone1, researchchairs.Phone2, researchchairs.Fax1, researchchairs.Fax2, old_researchChairId)); }