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);
}
public void PersistExamTemplate(DataSet ds)
{
DAExamTemplate daET = new DAExamTemplate();
DACultureResources daCR = new DACultureResources();
using (DbTransaction transaction = daET.CreateTransaction())
{
try
{
DataTable dtCR = ds.Tables[Entities.CultureResources.TABLE_NAME];
DataTable dtET = ds.Tables[Entities.TestTemplate.TABLE_NAME];
DataTable dtSWQ = ds.Tables[Entities.TestTemplateSectionWiseQuestions.TABLE_NAME];
daCR.PersistCultureResource(dtCR, transaction);
dtET.Rows[0][Entities.TestTemplate.CULTURE_NAME] = (Int64)dtCR.Rows[0][Entities.CultureResources.ID];
daET.PersistExamTemplates(dtET, dtSWQ, transaction);
daET.CommitTransaction(transaction);
}
catch (Exception e)
{
daET.RollbackTransaction(transaction);
throw e;
}
}
}
// Added by avanza\MUHAMMADUZAIR on 06/09/2017 17:48:48
public void UpdateExamStatus(string customerServiceExamId, string result)
{
DAExamTemplate daExTm = new DAExamTemplate();
daExTm.UpdateExamStatus(customerServiceExamId, result);
}
// jawwad.ahmed
public DataSet CancelCustomerExam(string customerServiceExamId, string userId)
{
DAExamTemplate daExTm = new DAExamTemplate();
return(daExTm.CancelCustomerExam(customerServiceExamId, userId));
}
// amjad
public DataSet GetCustomerExamDetails(string customerId, string customerServContrId)
{
DAExamTemplate daExTm = new DAExamTemplate();
return(daExTm.GetCustomerExamDetails(customerId, customerServContrId));
}
// amjad
public DataSet GetCustomerExamBookingDetails(string CSEID)
{
DAExamTemplate daExTm = new DAExamTemplate();
return(daExTm.GetCustomerExamBookingDetails(CSEID));
}
// Added by MUHAMMADUZAIR\avanza on 20/09/2017 17:50:02
public string GetExamNameFromCustomerExamId(string customerServiceExamId)
{
DAExamTemplate daExTm = new DAExamTemplate();
return(daExTm.GetExamNameFromCustomerExamId(customerServiceExamId));
}
