public Core.Business.StudentRoom GetStudentRoomByStudentCode(string studentCode) { SqlServerUtility sqlhelper = new SqlServerUtility(); sqlhelper.AddParameter("@StudentCode", SqlDbType.NVarChar, studentCode); SqlDataReader reader = sqlhelper.ExecuteSqlReader(SqlGetStudentRoomByStudentCode); Core.Business.StudentRoom studentRoom = null; if (reader != null) { while (reader.Read()) { studentRoom = new StudentRoom(); if (!reader.IsDBNull(0)) studentRoom.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) studentRoom.StudentCode = reader.GetString(1); if (!reader.IsDBNull(2)) studentRoom.RoomCode = reader.GetString(2); if (!reader.IsDBNull(3)) studentRoom.StayStartDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) studentRoom.StayEndDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) studentRoom.IsState = reader.GetBoolean(5); studentRoom.MarkOld(); } reader.Close(); } return studentRoom; }