private bool sFind(int pRecordPosition, bool pIsGoTo)
{
SqlConnection sqlConnection1 = new SqlConnection(BasicClass.vConectionString);
SqlCommand vSqlCommand = new SqlCommand();
string vRoleID = "";
string vYearID = "";
string vGender = "";
bool vResult = false;
try
{
SqlDataReader vSQLReader;
vSqlCommand.Connection = sqlConnection1;
string vWhereStmt = "";
int vfetchRec = 0;
if (pIsGoTo == false)
{
if (pRecordPosition == 0)
{
vfetchRec = 1;
}
else
{
if (pRecordPosition == -2)
{
vfetchRec = 1;
}
else
{
vfetchRec = pRecordPosition + vFRM_recPos;
if (vfetchRec == 0)
{
vfetchRec = 1;
}
}
}
}
else
{
if (pRecordPosition <= BasicClass.fCount_Rec("From [Book]"))
{
vfetchRec = pRecordPosition;
}
else
{
vfetchRec = BasicClass.fCount_Rec("From [Book]");
}
}
if (vfetchRec == -2)
{
vfetchRec = BasicClass.fCount_Rec("From [Book]");
}
vWhereStmt = " And RecPos='" + vfetchRec + "' ";
vSqlCommand.CommandText = "\n" +
" With MyItems as " + "\n" +
" ( " + "\n" +
"SELECT [ID],[Code],[Title],[Author] "+ "\n" +
" ,[Publisher],[YER_ID],[SubTitle],[Category],[Remarks]" + "\n" +
", ROW_NUMBER() over(Order By [Book].ID) RecPos" + "\n" +
" FROM [StudentExam].[dbo].[Book]" + "\n" +
" )" + "\n" +
" Select * From MyItems " + "\n" +
" WHERE 1=1" + "\n" +
vWhereStmt;
sqlConnection1.Open();
vSQLReader = vSqlCommand.ExecuteReader();
if (vSQLReader.HasRows == true)
{
while (vSQLReader.Read())
{
if (vSQLReader["Code"] != System.DBNull.Value)
{
vBookCode = vSQLReader["Code"].ToString();
TXT_CodeBook.Text = vSQLReader["Code"].ToString();
}
else
{
vBookCode = "";
TXT_CodeBook.Text = "";
}
if (vSQLReader["Title"] != System.DBNull.Value)
{
TXT_Title.Text = vSQLReader["Title"].ToString();
}
else
{
TXT_Title.Text = "";
}
if (vSQLReader["Author"] != System.DBNull.Value)
{
TXT_Author.Text = vSQLReader["Author"].ToString();
}
else
{
TXT_Author.Text = "";
}
if (vSQLReader["Publisher"] != System.DBNull.Value)
{
TXT_Publisher.Text = vSQLReader["Publisher"].ToString();
}
else
{
TXT_Publisher.Text = "";
}
if (vSQLReader["SubTitle"] != System.DBNull.Value)
{
TXT_Subtitle.Text = vSQLReader["SubTitle"].ToString();
}
else
{
TXT_Subtitle.Text = "";
}
if (vSQLReader["Category"] != System.DBNull.Value)
{
TXT_Categ.Text = vSQLReader["Category"].ToString();
}
else
{
TXT_Categ.Text = "";
}
if (vSQLReader["Remarks"] != System.DBNull.Value)
{
TXT_Notes.Text = vSQLReader["Remarks"].ToString();
}
else
{
TXT_Notes.Text = "";
}
if (vSQLReader["ID"] != System.DBNull.Value)
{
TXT_FindByCode.Text = vSQLReader["ID"].ToString();
}
else
{
TXT_FindByCode.Text = "";
}
if (vSQLReader["RecPos"] != System.DBNull.Value)
{
vFRM_recPos = int.Parse(vSQLReader["RecPos"].ToString());
TXT_FindByCode.Text = vFRM_recPos.ToString();
}
else
{
TXT_FindByCode.Text = "0";
vFRM_recPos = 0;
}
}
vSQLReader.Close();
sqlConnection1.Close();
vResult = true;
vFormMode = "N";
}
else
{
sNew();
}
}
catch (Exception ex)
{
vResult = false;
ExceptionHandler.HandleException(ex.Message, "Frm_BOOKS", "TXT_FindByCode_Enter");
}
return(vResult);
}
private bool sFind(int pRecordPosition, bool pIsGoTo)
{
SqlConnection sqlConnection1 = new SqlConnection(BasicClass.vConectionString);
SqlCommand vSqlCommand = new SqlCommand();
string vRoleID = "";
string vYearID = "";
string vGender = "";
bool vResult = false;
try
{
SqlDataReader vSQLReader;
vSqlCommand.Connection = sqlConnection1;
string vWhereStmt = "";
int vfetchRec = 0;
if (pIsGoTo == false)
{
if (pRecordPosition == 0)
{
vfetchRec = 1;
}
else
{
if (pRecordPosition == -2)
{
vfetchRec = 1;
}
else
{
vfetchRec = pRecordPosition + vFRM_recPos;
if (vfetchRec == 0)
{
vfetchRec = 1;
}
}
}
}
else
{
if (pRecordPosition <= BasicClass.fCount_Rec("FROM [Question]"))
{
vfetchRec = pRecordPosition;
}
else
{
vfetchRec = BasicClass.fCount_Rec("FROM [Question]");
}
}
if (vfetchRec == -2)
{
vfetchRec = BasicClass.fCount_Rec("FROM [Question]");
}
vWhereStmt = " And RecPos='" + vfetchRec + "' ";
vSqlCommand.CommandText = "\n" +
" With MyItems as " + "\n" +
" ( " + "\n" +
"SELECT [ID],[Code],[Description],[BOK_ID] "+ "\n" +
" ,[Option1],[Option2],[Option3],[Option4],[CorrectAnswer]" + "\n" +
", ROW_NUMBER() over(Order By [Question].ID) RecPos" + "\n" +
" FROM [dbo].[Question]" + "\n" +
" )" + "\n" +
" Select * From MyItems " + "\n" +
" WHERE 1=1" + "\n" +
vWhereStmt;
sqlConnection1.Open();
vSQLReader = vSqlCommand.ExecuteReader();
if (vSQLReader.HasRows == true)
{
while (vSQLReader.Read())
{
if (vSQLReader["Code"] != System.DBNull.Value)
{
vQuestionCode = vSQLReader["Code"].ToString();
TXT_Code.Text = vSQLReader["Code"].ToString();
}
else
{
vQuestionCode = "";
TXT_Code.Text = "";
}
if (vSQLReader["Description"] != System.DBNull.Value)
{
TXT_Description.Text = vSQLReader["Description"].ToString();
}
else
{
TXT_Description.Text = "";
}
if (vSQLReader["Option1"] != System.DBNull.Value)
{
TXT_Option1.Text = vSQLReader["Option1"].ToString();
}
else
{
TXT_Option1.Text = "";
}
if (vSQLReader["Option2"] != System.DBNull.Value)
{
TXT_Option2.Text = vSQLReader["Option2"].ToString();
}
else
{
TXT_Option2.Text = "";
}
if (vSQLReader["Option3"] != System.DBNull.Value)
{
TXT_Option3.Text = vSQLReader["Option3"].ToString();
}
else
{
TXT_Option3.Text = "";
}
if (vSQLReader["Option4"] != System.DBNull.Value)
{
TXT_Option4.Text = vSQLReader["Option4"].ToString();
}
else
{
TXT_Option4.Text = "";
}
if (vSQLReader["BOK_ID"] != System.DBNull.Value)
{
foreach (var item in TXT_Book.Items)
{
if (item.DataValue.ToString().Trim() == vSQLReader["BOK_ID"].ToString().Trim())
{
TXT_Book.SelectedItem = item;
break;
}
}
}
else
{
TXT_Book.SelectedIndex = -1;
}
if (vSQLReader["CorrectAnswer"] != System.DBNull.Value)
{
TXT_CorrectAnswer.SelectedIndex = int.Parse(vSQLReader["CorrectAnswer"].ToString()) - 1;
}
else
{
TXT_CorrectAnswer.SelectedIndex = -1;
}
if (vSQLReader["ID"] != System.DBNull.Value)
{
TXT_FindByCode.Text = vSQLReader["ID"].ToString();
TXT_Code.Tag = vSQLReader["ID"].ToString();
}
else
{
TXT_FindByCode.Text = "";
TXT_Code.Tag = "";
}
if (vSQLReader["RecPos"] != System.DBNull.Value)
{
vFRM_recPos = int.Parse(vSQLReader["RecPos"].ToString());
TXT_FindByCode.Text = vFRM_recPos.ToString();
}
else
{
TXT_FindByCode.Text = "0";
vFRM_recPos = 0;
}
if (vSQLReader["BOK_ID"] != System.DBNull.Value)
{
foreach (var item in TXT_Book.Items)
{
if (item.DataValue.ToString().Trim() == vSQLReader["BOK_ID"].ToString().Trim())
{
TXT_Book.SelectedItem = item;
break;
}
}
}
else
{
TXT_Book.SelectedIndex = -1;
}
}
vSQLReader.Close();
sqlConnection1.Close();
vResult = true;
vFormMode = "N";
}
else
{
sNew();
}
}
catch (Exception ex)
{
vResult = false;
ExceptionHandler.HandleException(ex.Message, "FRM_Questions", "TXT_FindByCode_Enter");
}
return(vResult);
}
private void sFillQuestionList()
{
SqlConnection sqlConnection1 = new SqlConnection(BasicClass.vConectionString);
SqlCommand vSqlCommand = new SqlCommand();
try
{
// Here i open connection to databse and execute command to get roles to fill dropdown list
SqlDataReader vSQLReader;
vSqlCommand.Connection = sqlConnection1;
int vSTD_ID = BasicClass.vUsrID;
string vStdAnswers = "FROM Student_Answers "+ "\n" +
"WHERE STD_ID = "+ vSTD_ID + " "+ "\n";
int rowsCount = BasicClass.fCount_Rec(vStdAnswers);
if (rowsCount > 0)
{
// HERE I GET REMAINING STUDENT QUESTIONS
vSqlCommand.CommandText = "\n" +
"EXEC [dbo].[GenerateRemainingStudentQuestions] " + vSTD_ID + " ";
}
else
{
// HERE I GET RANDOM 105 STUDENT QUESTIONS
vSqlCommand.CommandText = "\n" +
"EXEC [dbo].[GenerateExamNew] " + vSTD_ID + " ";
}
sqlConnection1.Open();
vSQLReader = vSqlCommand.ExecuteReader();
while (vSQLReader.Read())
{
cQuestion question = new cQuestion();
if (vSQLReader["Row"] != System.DBNull.Value)
{
question.vRow = int.Parse(vSQLReader["Row"].ToString());
}
else
{
question.vRow = 0;
}
if (vSQLReader["ID"] != System.DBNull.Value)
{
question.vID = int.Parse(vSQLReader["ID"].ToString());
}
else
{
question.vID = 0;
}
if (vSQLReader["BOK_ID"] != System.DBNull.Value)
{
question.vBOK_ID = int.Parse(vSQLReader["BOK_ID"].ToString());
}
else
{
question.vBOK_ID = 0;
}
if (vSQLReader["BookTitle"] != System.DBNull.Value)
{
question.vBookTitle = vSQLReader["BookTitle"].ToString();
}
else
{
question.vBookTitle = "";
}
if (vSQLReader["Code"] != System.DBNull.Value)
{
question.vCode = vSQLReader["Code"].ToString();
}
else
{
question.vCode = "";
}
if (vSQLReader["Description"] != System.DBNull.Value)
{
question.vDescription = vSQLReader["Description"].ToString();
}
else
{
question.vDescription = "";
}
if (vSQLReader["Option1"] != System.DBNull.Value)
{
question.vOption1 = vSQLReader["Option1"].ToString();
}
else
{
question.vOption1 = "";
}
if (vSQLReader["Option2"] != System.DBNull.Value)
{
question.vOption2 = vSQLReader["Option2"].ToString();
}
else
{
question.vOption2 = "";
}
if (vSQLReader["Option3"] != System.DBNull.Value)
{
question.vOption3 = vSQLReader["Option3"].ToString();
}
else
{
question.vOption3 = "";
}
if (vSQLReader["Option4"] != System.DBNull.Value)
{
question.vOption4 = vSQLReader["Option4"].ToString();
}
else
{
question.vOption4 = "";
}
if (vSQLReader["CorrectAnswer"] != System.DBNull.Value)
{
question.vCorrectAnswer = int.Parse(vSQLReader["CorrectAnswer"].ToString());
}
else
{
question.vCorrectAnswer = 0;
}
questionsList.Add(question);
}
vSQLReader.Close();
sqlConnection1.Close();
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex.Message, "FRM_Exam", "sFillBooks");
}
finally
{
if (sqlConnection1.State == ConnectionState.Broken || sqlConnection1.State == ConnectionState.Open)
{
sqlConnection1.Close();
}
}
}
