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