예제 #1
0
        public DataSet GetExamTemplateById(String id)
        {
            DataSet dsET = objExamTemplate.GetExamTemplatesById(id);


            DataSet dsReturn = GetExamTemplateDataSet();;

            DataTable dtCR = new DataTable();

            dtCR = dsReturn.Tables[Entities.CultureResources.TABLE_NAME];
            DataTable dtET = new DataTable();

            dtET = dsReturn.Tables[Entities.TestTemplate.TABLE_NAME];
            //DataTable dtSWQ = Entities.TestTemplateSectionWiseQuestions.GetDataTable();
            DataRow element = dsET.Tables[0].Rows[0];
            DataRow rowET   = dtET.NewRow();

            rowET[Entities.TestTemplate.ID]                     = element[Entities.TestTemplate.ID];
            rowET[Entities.TestTemplate.DURATION]               = element[Entities.TestTemplate.DURATION];
            rowET[Entities.TestTemplate.APPROVED_BY]            = element[Entities.TestTemplate.APPROVED_BY];
            rowET[Entities.TestTemplate.APPROVED_ON]            = element[Entities.TestTemplate.APPROVED_ON];
            rowET[Entities.TestTemplate.CREATED_BY]             = element[Entities.TestTemplate.CREATED_BY];
            rowET[Entities.TestTemplate.CREATED_ON]             = element[Entities.TestTemplate.CREATED_ON];
            rowET[Entities.TestTemplate.CULTURE_NAME]           = element[Entities.TestTemplate.CULTURE_NAME];
            rowET[Entities.TestTemplate.IS_ACTIVE]              = element[Entities.TestTemplate.IS_ACTIVE];
            rowET[Entities.TestTemplate.IS_PERCENTAGE]          = element[Entities.TestTemplate.IS_PERCENTAGE];
            rowET[Entities.TestTemplate.NO_OF_QUESTIONS]        = element[Entities.TestTemplate.NO_OF_QUESTIONS];
            rowET[Entities.TestTemplate.PASSING_CHANGE_REASON]  = element[Entities.TestTemplate.PASSING_CHANGE_REASON];
            rowET[Entities.TestTemplate.PASSING_SCORE]          = element[Entities.TestTemplate.PASSING_SCORE];
            rowET[Entities.TestTemplate.GENERAL_INSTRUCTIONS]   = element[Entities.TestTemplate.GENERAL_INSTRUCTIONS];
            rowET[Entities.TestTemplate.EXAM_INFO]              = element[Entities.TestTemplate.EXAM_INFO];
            rowET[Entities.TestTemplate.EXAM_INFO_PLACE_HOLDER] = element[Entities.TestTemplate.EXAM_INFO_PLACE_HOLDER];
            dtET.Rows.Add(rowET);
            DataRow rowCR = dtCR.NewRow();

            rowCR[Entities.CultureResources.ID]     = element[Entities.TestTemplate.CULTURE_NAME];
            rowCR[Entities.CultureResources.RES_EN] = element[Entities.CultureResources.RES_EN];
            rowCR[Entities.CultureResources.RES_AR] = element[Entities.CultureResources.RES_AR];
            rowCR[Entities.CultureResources.RES_UR] = element[Entities.CultureResources.RES_UR];
            dtCR.Rows.Add(rowCR);

            DataSet dsSWQ = objExamTemplate.GetSectionWiseQuestionByExamTemplatesById(id);

            dsReturn.Tables.Add(dsSWQ.Tables[0].Copy());

            return(dsReturn);
        }
예제 #2
0
        public DataSet GetExamSchedulesById(Int64 id)
        {
            DataSet ds = objDATest.GetExamSchedulesById(id);

            ds.Tables[0].TableName = Entities.Test.TABLE_NAME;

            DAExamTemplate oDAET = new DAExamTemplate();
            DataSet        dsET  = oDAET.GetExamTemplatesById(ds.Tables[0].Rows[0][Entities.Test.TEST_TEMP_ID].ToString());

            dsET.Tables[0].TableName = Entities.TestTemplate.TABLE_NAME;
            ds.Tables.Add(dsET.Tables[Entities.TestTemplate.TABLE_NAME].Copy());

            DATestTakers oDATT = new DATestTakers();
            DataSet      dstt  = oDATT.GetTestTakersByTestId(ds.Tables[0].Rows[0][Entities.Test.ID].ToString());

            dstt.Tables[0].TableName = Entities.TestTakers.TABLE_NAME;
            ds.Tables.Add(dstt.Tables[Entities.TestTakers.TABLE_NAME].Copy());

            return(ds);
        }