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