//Populate method used to populate developer object from DB public void Populate(int intID) { SqlDataReader dr; DataSet ds; DataRow[] aDr; //Get developer record dr = m_DL.GetDeveloper(intID); if (!dr.IsClosed) { if (dr.HasRows) { //Only one record should have been returned dr.Read(); m_intID = (int)dr[DataLayer.FldID]; m_strName = (string)dr[DataLayer.FldDeveloperName]; m_dblSalary = (double)dr[DataLayer.FldDeveloperSalary]; m_blnIsNew = false; } dr.Close(); } //Close open connection made for retrieving data reader m_DL.CloseDBConnection(); //At this point if no developer record was retrieved, there's no need to continue if (!m_blnIsNew) { //Get department records ds = new DataSet(); ds = m_DL.GetDeveloperDepartments(m_intID); if (ds.Tables.Count > 0) { if (ds.Tables[DataLayer.TblDeveloperDepartments].Rows.Count > 0) { aDr = ds.Tables[DataLayer.TblDeveloperDepartments].Select(); //Add each department record to Departments collection foreach (DataRow d in aDr) { AddDepartment((int)d[DataLayer.FldDevDeptsDepartmentID]); } } } } }
//Populates this department object from DB public void Populate(int intID) { SqlDataReader dr; //Get department record dr = m_DL.GetDepartment(intID); if (!dr.IsClosed) { if (dr.HasRows) { //Only one record should have been returned dr.Read(); m_intID = (int)dr[DataLayer.FldID]; m_strName = (string)dr[DataLayer.FldDepartmentName]; m_blnIsNew = false; } dr.Close(); } //Close open connection made for retrieving data reader m_DL.CloseDBConnection(); }