public DataTable DL_Result(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID),
//new SqlParameter("@ExamName",objML_StudentProfile.ExamName)
};
return(SqlHelper.ExecuteDataset(con, "FBNPC_Results", par).Tables[0]);
}
public DataTable DL_SerachQuestionInfo(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID),
new SqlParameter("@StudentName", objML_StudentProfile.StudentName),
new SqlParameter("@ExamName", objML_StudentProfile.ExamName),
new SqlParameter("@DocType", objML_StudentProfile.doctype) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Student_Search_Questions", par).Tables[0]);
}
public int DL_UpdStudentInfo(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID),
new SqlParameter("@EmailID", objML_StudentProfile.EmailID),
new SqlParameter("@PhoneNo", objML_StudentProfile.PhoneNo),
new SqlParameter("@ModifyBy", objML_StudentProfile.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_User_Update", par));
}
public int DL_InsReloaderExamValidationHistory(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@hist_By", objML_StudentProfile.Hist_By),
new SqlParameter("@Hist_Version", objML_StudentProfile.HIst_Version),
new SqlParameter("@ExamName", objML_StudentProfile.ExamName),
new SqlParameter("@StudentName", objML_StudentProfile.StudentName),
new SqlParameter("@PaperID", objML_StudentProfile.PaperID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Exam_Validation_History_Insert", par));
}
public int DL_InsReloaderStudentSubmitHistory(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@hist_By", objML_StudentProfile.Hist_By),
new SqlParameter("@Hist_Version", objML_StudentProfile.HIst_Version),
new SqlParameter("@OptionA", objML_StudentProfile.OPtionA),
new SqlParameter("@OptionB", objML_StudentProfile.OPtionB),
new SqlParameter("@OptionC", objML_StudentProfile.OPtionC),
new SqlParameter("@OptionD", objML_StudentProfile.OPtionD),
new SqlParameter("@QuestionID", objML_StudentProfile.QuestionID),
new SqlParameter("@ExamName", objML_StudentProfile.ExamName),
new SqlParameter("@StudentName", objML_StudentProfile.StudentName),
new SqlParameter("@PaperID", objML_StudentProfile.PaperID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Submit_Exam_History_Insert", par));
}
public static List <Data> GetData()
{
BL_StudentProfile objBL_StudentProfile = new BL_StudentProfile();
ML_StudentProfile objML_StudentProfile = new ML_StudentProfile();
DataTable dt = new DataTable();
objML_StudentProfile.ID = HttpContext.Current.Session["User_Code"].ToString();
dt = objBL_StudentProfile.BL_BindStudentScoreBoard(objML_StudentProfile);
List <Data> dataList = new List <Data>();
string cat = "";
int val = 0;
foreach (DataRow dr in dt.Rows)
{
cat = dr[0].ToString();
val = Convert.ToInt32(dr[1]);
dataList.Add(new Data(cat, val));
}
return(dataList);
}
public DataTable BL_Re_loaderCountExam_StudentAttempted(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_Re_loaderCountExam_StudentAttempted(objML_StudentProfile));
}
public DataTable BL_SerachQuestionInfo(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_SerachQuestionInfo(objML_StudentProfile));
}
public DataTable BL_Re_loaderCountExam_StudentTotal(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_Re_loaderCountExam_StudentTotal(objML_StudentProfile));
}
public DataTable BL_BindExamList(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_BindExamList(objML_StudentProfile));
}
public DataTable DL_BindStudentExamListIndividual(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Exam_Student_Mapping_Select_Individual", par).Tables[0]);
}
public int BL_InsReloaderStudentSubmitHistory(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_InsReloaderStudentSubmitHistory(objML_StudentProfile));
}
public int BL_InsReloaderExamValidationDelete(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_InsReloaderExamValidationDelete(objML_StudentProfile));
}
public DataTable BL_Result(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_Result(objML_StudentProfile));
}
public DataTable BL_BindStudentInfo(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_BindStudentInfo(objML_StudentProfile));
}
public DataTable DL_ReloaderStudentValidationSelect(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.StudentName),
new SqlParameter("@ExamName", objML_StudentProfile.ExamName), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Re_loader_Validation_Select", par).Tables[0]);
}
public DataTable DL_BindExamList(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID),
new SqlParameter("@doctype", objML_StudentProfile.doctype), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Exam_Bind_For_Result", par).Tables[0]);
}
public DataTable DL_Re_loaderCountExam_StudentAttempted(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID),
new SqlParameter("@ExamName", objML_StudentProfile.ExamName), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Re_loader_CountExam_Student_Attempted", par).Tables[0]);
}
public DataTable DL_BindStudentInfo(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_UserMaster_Edit", par).Tables[0]);
}
public DataTable DL_BindStudentScoreBoard(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Student_DashboardScore_Board", par).Tables[0]);
}
public DataTable BL_ReloaderStudentSubmitSelect(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_ReloaderStudentSubmitSelect(objML_StudentProfile));
}
public DataTable DL_BindStudentUpdates(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Students_Updates_Bind", par).Tables[0]);
}
public DataTable BL_ReloaderStudentValidationSelect(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_ReloaderStudentValidationSelect(objML_StudentProfile));
}
public DataTable BL_BindStudentExam(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_BindStudentCount(objML_StudentProfile));
}
public int BL_InsReloaderStudentSubmitDelete(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_InsReloaderStudentSubmitDelete(objML_StudentProfile));
}
public DataTable BL_BindStudentExamListIndividual(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_BindStudentExamListIndividual(objML_StudentProfile));
}
public DataTable BL_BindStudentUpdates(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_BindStudentUpdates(objML_StudentProfile));
}
public DataTable BL_BindStudentScoreBoard(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_BindStudentScoreBoard(objML_StudentProfile));
}
public int BL_UpdStudentInfo(ML_StudentProfile objML_StudentProfile)
{
return(objDL_StudentProfile.DL_UpdStudentInfo(objML_StudentProfile));
}
public DataTable DL_BindStudentCount(ML_StudentProfile objML_StudentProfile)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_StudentProfile.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Exam_Student_Mapping_Count", par).Tables[0]);
}
