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