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