///<summary> ///Functions Saves the Result ///</summary> ///<param name="_Answer"></param> ///<return></return> public int UpdateResult(int ResDetId, int StudId, string fileName, bool IsModuleTest = false) { int success; Database db = ConnectDatabase.Conn(); string str = "Proc_UpdateExamResult"; DbCommand ResDetCommand = db.GetStoredProcCommand(str); db.AddInParameter(ResDetCommand, "ResDetId", DbType.Int32, ResDetId); db.AddInParameter(ResDetCommand, "StudentId", DbType.Int32, StudId); db.AddInParameter(ResDetCommand, "FileName", DbType.String, fileName); db.AddInParameter(ResDetCommand, "IsModuleTest", DbType.Boolean, IsModuleTest); using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { success = Convert.ToInt32(db.ExecuteScalar(ResDetCommand, trans)); trans.Commit(); } catch (Exception) { trans.Rollback(); success = 1; } finally { conn.Close(); } } return(success); }
///<summary> ///Functions Saves the Answers to QnStudExamResult ///</summary> ///<param name="_Answer"></param> ///<return></return> public int SaveAnswer(int ExamDetId, string SeqNo, int TypeId) { int success; Database db = ConnectDatabase.Conn(); string str = "Proc_SaveAnswer"; DbCommand ExResCommand = db.GetStoredProcCommand(str); db.AddInParameter(ExResCommand, "ExamDetId", DbType.Int32, ExamDetId); db.AddInParameter(ExResCommand, "SeqNo", DbType.String, SeqNo); db.AddInParameter(ExResCommand, "QnTypeID", DbType.Int32, TypeId); using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { success = Convert.ToInt32(db.ExecuteScalar(ExResCommand, trans)); trans.Commit(); } catch (Exception) { trans.Rollback(); success = 1; } finally { conn.Close(); } } return(success); }
/// <summary> /// Function returns a list of Questions allocated based on studentId and ResdetId /// </summary> /// <returns></returns> public List <QnStudentExamDet> GetQuestionaires(int ExamDetId, string saveAns, int TypeId, int StudId, int ResDetId, int SeqNo = 0, int Fin = 0, bool isModExam = false) { DataSet dsQues = new DataSet(); DataTable dtQues = new DataTable(); List <QnStudentExamDet> _lstQues = new List <QnStudentExamDet>(); Database dbQues = ConnectDatabase.Conn(); String str = "Proc_GetQuestionnaire"; DbCommand QuesCommand = dbQues.GetStoredProcCommand(str); dbQues.AddInParameter(QuesCommand, "ExamDetId", DbType.Int32, ExamDetId); dbQues.AddInParameter(QuesCommand, "SeqNo", DbType.String, saveAns); dbQues.AddInParameter(QuesCommand, "QnTypeID", DbType.Int32, TypeId); dbQues.AddInParameter(QuesCommand, "StudId", DbType.Int32, StudId); dbQues.AddInParameter(QuesCommand, "ResDetId", DbType.Int32, ResDetId); if (SeqNo != 0) { dbQues.AddInParameter(QuesCommand, "QnSeqId", DbType.Int32, SeqNo); } if (Fin != 0) { dbQues.AddInParameter(QuesCommand, "Fin", DbType.Int32, Fin); } dbQues.AddInParameter(QuesCommand, "IsModExam", DbType.Boolean, isModExam); dsQues = dbQues.ExecuteDataSet(QuesCommand); if (Fin != 1) { dtQues = dsQues.Tables[0]; _lstQues = MapQuestions(ref dtQues); } return(_lstQues); }
//get Company infor as Dataset for result print in Nov-2020 public DataSet GetCompInfo() { DataSet dsCompInfo = new DataSet(); Database dbCompInfo = ConnectDatabase.Conn(); String sqlDetails = "Proc_RptCompInfo"; DbCommand cmdCompInfo = dbCompInfo.GetStoredProcCommand(sqlDetails); //dbCompInfo.AddInParameter(CompInfo, "QuestId", DbType.Int32, QuestId); dsCompInfo = dbCompInfo.ExecuteDataSet(cmdCompInfo); return(dsCompInfo); }
//get result output as Dataset for result print added in Nov-2020 public DataSet GetExamResultPrint(int ResDetId, int StudId, int table, bool IsModuleTest = false) { DataSet dsResPrint = new DataSet(); Database dbCompInfo = ConnectDatabase.Conn(); String sqlDetails = "Proc_RptExamResultPrint"; DbCommand cmdResPrint = dbCompInfo.GetStoredProcCommand(sqlDetails); dbCompInfo.AddInParameter(cmdResPrint, "StudentId", DbType.Int32, StudId); dbCompInfo.AddInParameter(cmdResPrint, "ResDetId", DbType.Int32, ResDetId); dbCompInfo.AddInParameter(cmdResPrint, "table", DbType.Int32, table); dbCompInfo.AddInParameter(cmdResPrint, "isModExam", DbType.Boolean, IsModuleTest); dsResPrint = dbCompInfo.ExecuteDataSet(cmdResPrint); return(dsResPrint); }
/// <summary> /// Function returns a list of Question Details /// </summary> /// <returns>List</returns> public void ViewQuestion(int QuestId, ref QuestionMaster _QueslateDetails, ref List <QuestionOptions> lstQuesDetails) { DataSet dsViewquesDetails = new DataSet(); Database dbViewquesDetails = ConnectDatabase.Conn(); String sqlDetails = "Proc_ViewQuestion"; DbCommand quesDetailsCmd = dbViewquesDetails.GetStoredProcCommand(sqlDetails); dbViewquesDetails.AddInParameter(quesDetailsCmd, "QuestId", DbType.Int32, QuestId); dsViewquesDetails = dbViewquesDetails.ExecuteDataSet(quesDetailsCmd); if (dsViewquesDetails.Tables.Count > 0) { _QueslateDetails = Mapqueslate(dsViewquesDetails.Tables[0]); lstQuesDetails = MapquesDetails(dsViewquesDetails.Tables[1]); } }
/// <summary> /// Function Saves the new Generate Questions /// </summary> /// <param name="_ques"></param> /// <returns></returns> public int GenerateQuestions(int studId, int courseId, int SchId, int ResDetId, int SemId = 0, bool isModExam = false) { int success; Database db = ConnectDatabase.Conn(); //string QuesXml = Utilities.Serialize(_Ques.LstQuestionOptions); string str = "Proc_GenerateQuestions"; DbCommand QuesCommand = db.GetStoredProcCommand(str); db.AddInParameter(QuesCommand, "StudId", DbType.Int32, studId); db.AddInParameter(QuesCommand, "CourseId", DbType.Int32, courseId); if (SemId != 0) { db.AddInParameter(QuesCommand, "SemID", DbType.Int32, SemId); } db.AddInParameter(QuesCommand, "ScheduleId", DbType.Int32, SchId); db.AddInParameter(QuesCommand, "ResDetId", DbType.Int32, ResDetId); db.AddInParameter(QuesCommand, "IsModExam", DbType.Boolean, isModExam); using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { success = Convert.ToInt32(db.ExecuteScalar(QuesCommand, trans)); trans.Commit(); //if (dbPO.GetParameterValue(pOCommand, "PONo") != DBNull.Value) // _purchaseOrder.PONumber = Convert.ToString(dbPO.GetParameterValue(pOCommand, "PONo")); } catch (Exception) { trans.Rollback(); success = 1; } finally { conn.Close(); } } return(success); }
public Student StudExmUserLogin(String username, String password, bool isModExam) { Student student = new Student(); DataSet dsUsers = new DataSet(); Database db = ConnectDatabase.Conn(); String strsql = "Proc_AuthenticateStudExam"; DbCommand userCmd = db.GetStoredProcCommand(strsql); db.AddInParameter(userCmd, "StudLoginId", DbType.String, username); // db.AddInParameter(userCmd, "Password", DbType.String, CryptoGraphy.Encrypt(password)); db.AddInParameter(userCmd, "Password", DbType.String, password); db.AddInParameter(userCmd, "IsModuleTest", DbType.Boolean, isModExam); dsUsers = db.ExecuteDataSet(userCmd); if (dsUsers.Tables[0].Rows.Count > 0) { student = MapUser(dsUsers.Tables[0], isModExam); } else { student = null; } return(student); }