public DataTable DL_TempIndividualNext(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID),
new SqlParameter("@StudentName", objML_ExamTransaction.StudentName),
new SqlParameter("@QusNo", objML_ExamTransaction.QusNo) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Show_Individual_Sheet_Question_Next", par).Tables[0]);
}
public int DL_DelTempExamStudent(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ExamID", objML_ExamTransaction.ExamName),
new SqlParameter("@StudentID", objML_ExamTransaction.StudentName),
new SqlParameter("@PaperID", objML_ExamTransaction.PaperID) };
return(SqlHelper.ExecuteNonQuery(con, "KSCN_Temp_Delete", par));
}
public int DL_InsValidateQuestion(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ExamName", objML_ExamTransaction.ExamName),
new SqlParameter("@StudentName", objML_ExamTransaction.StudentName),
new SqlParameter("@PaperID", objML_ExamTransaction.PaperID) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Exam_Validation_Insert", par));
}
public int DL_InsSubmitExam(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@OptionA", objML_ExamTransaction.OptionA),
new SqlParameter("@OptionB", objML_ExamTransaction.OptionB),
new SqlParameter("@OptionC", objML_ExamTransaction.OptionC),
new SqlParameter("@OptionD", objML_ExamTransaction.OptionD),
new SqlParameter("@Question", objML_ExamTransaction.Question),
new SqlParameter("@ExamName", objML_ExamTransaction.ExamName),
new SqlParameter("@StudentName", objML_ExamTransaction.StudentName),
new SqlParameter("@PaperID", objML_ExamTransaction.PaperID),
new SqlParameter("@DocType", objML_ExamTransaction.DocType) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Submit_Exam_Insert", par));
}
public DataTable BL_BindSections(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_BindSections(objML_ExamTransaction));
}
public DataTable BL_BindQuestionSheet(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_BindQuestionSheet(objML_ExamTransaction));
}
public DataTable BL_BindTearmsCondition(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_BindTearmsCondition(objML_ExamTransaction));
}
public DataTable DL_ShowIndividualQuestion(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID),
new SqlParameter("@ExamID", objML_ExamTransaction.ExamName) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Show_Individual_Sheet_Question", par).Tables[0]);
}
public int BL_DelTempTableExamStudent(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_DelTempExamStudent(objML_ExamTransaction));
}
public DataTable BL_BindReadingCollection(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_BindReadingCollection(objML_ExamTransaction));
}
public DataTable DL_ShowTempQuestionList(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ExamID", objML_ExamTransaction.ExamName),
new SqlParameter("@StudentID", objML_ExamTransaction.StudentName) };
return(SqlHelper.ExecuteDataset(con, "KSCN_Temp_To_Orignal_Show", par).Tables[0]);
}
public DataTable DL_ShowSpeaking(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID),
new SqlParameter("@ExamID", objML_ExamTransaction.ExamName) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Show_Speaking_Sheet_Video", par).Tables[0]);
}
public int BL_InsValidateQuestion(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_InsValidateQuestion(objML_ExamTransaction));
}
public DataTable DL_BindExamComprehesion(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Exam_Comprehension_Sheet", par).Tables[0]);
}
public DataTable DL_BindReadingCollection(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID),
new SqlParameter("@StudentName", objML_ExamTransaction.StudentName) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Exam_Reading_Serial_Wise_Sheet", par).Tables[0]);
}
public DataTable DL_BindSections(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@SectionID", objML_ExamTransaction.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Bind_Sections", par).Tables[0]);
}
public DataTable DL_BindTearmsCondition(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Select_TearmsConditions", par).Tables[0]);
}
public DataTable DL_GetSectionTime(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID),
new SqlParameter("@ExamID", objML_ExamTransaction.ExamName) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_GetSectionWiseTime", par).Tables[0]);
}
public DataTable BL_BindExamVideo(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_BindExamVideo(objML_ExamTransaction));
}
public DataTable BL_BindIndividualCollection(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_BindIndividualCollection(objML_ExamTransaction));
}
public DataTable BL_BindExamCompreension(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_BindExamComprehesion(objML_ExamTransaction));
}
public DataTable BL_GetSectionTime(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_GetSectionTime(objML_ExamTransaction));
}
public int BL_InsSubmitExam(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_InsSubmitExam(objML_ExamTransaction));
}
public DataTable DL_CurrentDateTime(ML_ExamTransaction objML_ExamTransaction)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_ExamTransaction.ID) };
return(SqlHelper.ExecuteDataset(con, "CurrentDateTime", par).Tables[0]);
}
public DataTable BL_ShowReading(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_ShowReading(objML_ExamTransaction));
}
public int BL_InsTempSaveExam(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_InsTempSaveExam(objML_ExamTransaction));
}
public DataTable BL_ShowIndividualQuestion(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_ShowIndividualQuestion(objML_ExamTransaction));
}
public DataTable BL_TempIndividualNext(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_TempIndividualNext(objML_ExamTransaction));
}
public DataTable BL_CurrentDateTime(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_CurrentDateTime(objML_ExamTransaction));
}
public DataTable BL_ShowTempQuestionList(ML_ExamTransaction objML_ExamTransaction)
{
return(objDL_ExamTransaction.DL_ShowTempQuestionList(objML_ExamTransaction));
}
