public Section GetSectionByOID(int SOID) { Section section = null; using (OdbcConnection connection = new OdbcConnection(connectionString)) { using (OdbcCommand command = new OdbcCommand()) { command.Connection = connection; command.CommandText = "{CALL Section_BySectionOID(?)}"; command.CommandType = CommandType.StoredProcedure; //Set Parameter Value command.Parameters.AddWithValue("@SOID", SOID); //Open connection connection.Open(); //Read using reader using (OdbcDataReader dataReader = command.ExecuteReader()) { Question q = new Question(); //Section section; if (dataReader.Read()) { section = new Section(); section.SectionOID = Convert.ToInt32(dataReader["SectionOID"]); section.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]); section.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]); section.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]); section.FlagPointTotal = Convert.ToInt32(dataReader["FlagPointTotal"]); section.LastModifiedBy = Convert.ToInt32(dataReader["LastModifiedBy"]); section.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]); section.PassingTotal = Convert.ToInt32(dataReader["PassingTotal"]); section.SectionName = Convert.ToString(dataReader["SectionName"]); section.TotalFlag = Convert.ToInt32(dataReader["TotalFlag"]); section.TotalQuestion = Convert.ToInt32(dataReader["TotalQuestion"]); section.Flag = (dataReader["Flag"]==null)?0:Convert.ToInt32(dataReader["Flag"]); section.Low = (dataReader["Low"] == null) ? 0 : Convert.ToInt32(dataReader["Low"]); section.Medium = (dataReader["Medium"] == null) ? 0 : Convert.ToInt32(dataReader["Medium"]); section.High = (dataReader["High"] == null) ? 0 : Convert.ToInt32(dataReader["High"]); //Get Question By SectionOID section.QuestionList = q.GetQuestionBySectionOID(section.SectionOID); } } } } return section; }