public Assessment GetAssessmentByOID_QuestionSheet(int OID) { //Assessment ass = null; using (OdbcConnection connection = new OdbcConnection(connectionString)) { using (OdbcCommand command = new OdbcCommand()) { command.Connection = connection; command.CommandText = "{CALL Assessment_BYOID(?)}"; command.CommandType = CommandType.StoredProcedure; //Parameter Setting command.Parameters.AddWithValue("@AOID", OID); connection.Open(); using (OdbcDataReader dataReader = command.ExecuteReader()) { Section sect = new Section(); if (dataReader.Read()) { //this = new Assessment(); this.AssessmentName = Convert.ToString(dataReader["AssessmentName"]); this.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]); this.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]); this.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]); this.LastModifiedBy = Convert.ToInt32(dataReader["LastModifiedBy"]); this.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]); this.RefMenuID = Convert.ToInt32(dataReader["RefMenuID"]); this.TotalFlag = Convert.ToInt32(dataReader["TotalFlag"]); this.TotalFlagPoint = Convert.ToInt32(dataReader["TotalFlagPoint"]); this.TotalQuestion = Convert.ToInt32(dataReader["TotalQuestion"]); this.TotalSection = Convert.ToInt32(dataReader["TotalSection"]); this.SectionList = sect.GetSectionByAssessmentOID(this.AssessmentOID); } } } } return this; }