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;
}