private void InitRandomChoice()
{
////Random Choice
for (int i = 0; i < IdQuestions.Count; ++i)
{
string query = string.Format("select count(id) from Options where id_Qus ={0}", IdQuestions[i]);
optionMix.Add(new List <int>());
check.Add(new List <bool>());
FillOption(int.Parse(ReturnClass.scalarReturn(query)), optionMix[i], check[i]);
}
}
public void InsertQuestion()
{
string query = string.Format("insert into questions values (N'{0}','{1}',{2},'{3}',{4},'{5}')",
RgEx.isNullOrEmpty(q_title), RgEx.isNullOrEmpty(q_addeddate), RgEx.isNullOrEmpty(q_fk_ex),
RgEx.isNullOrEmpty(ad_add), RgEx.isNullOrEmpty(isImage), this.explain);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.insert);
query = string.Format("select top 1 q_id from questions order by q_id desc");
string id_Ques = ReturnClass.scalarReturn(query);
options.ForEach
(
x => x.insertOption(id_Ques)
);
}
private void WaitAdminForm_Load(object sender, EventArgs e)
{
eclipse.ApplyElipse(pictureBox1, 90);
string query = string.Format("select Images from admin_athu where ad_user = '******'", FormLogin.username);
string result = ReturnClass.scalarReturn(query);
if (!string.IsNullOrEmpty(result))
{
pictureBox1.Image = Image.FromFile(result);
}
txtName.Text = FormLogin.username + " Login";
this.Opacity = 0.9;
timer2.Start();
timer1.Start();
}
public static void Delete(int exId)
{
string query = string.Format("select count(q_id) from questions where q_fk_ex ={0}", exId);
if (!MessBox.MessWarning(" Confirm deleted " + ReturnClass.scalarReturn(query) + " questions"))
{
return;
}
//Process Delete Exams
query = string.Format("select q_id from questions where q_fk_ex ={0}", exId);
using (SqlDataReader reader = ReturnClass.readerReturn(query))
{
while (reader.Read())
{
Questions.DeleteQuestion(reader.GetInt32(0));
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string user = txtUsername.Text;
string pass = txtPassword.Text;
if (user.Equals("Username") || pass.Equals("Password"))
{
MessBox.MessError("Username or Password is Empty !!"); return;
}
if (!RgEx.isAlphanumericNotSpace(user, "Username"))
{
return;
}
if (!RgEx.isAlphanumericNotSpace(pass, "Password"))
{
return;
}
//MessBox.MessInf(isAd);
string query = string.Format("select isAd from admin_athu where ad_user='******' and ad_password='******'", user, pass);
string isAd = ReturnClass.scalarReturn(query);
//Check invalid User or password
if (isAd.Equals(""))
{
MessBox.MessError("Invalid Input User or Password"); return;
}
//Hide old form login and show form Admin or Students
try
{
this.Hide();
if (isAd.Equals("True"))
{
username = user;
formAdmin.ShowDialog();
}
else
{
formStudents.ShowDialog();
}
this.Show();
}catch
{
}
}
public bool setQuestions(int numQues, int exId, int timePer)
{
string query = string.Format("select count(q_id) from questions where q_fk_ex ={0}", exId);
string IdQuestions = ReturnClass.scalarReturn(query);
if (string.IsNullOrEmpty(IdQuestions) || int.Parse(IdQuestions) < numQues)
{
MessBox.Warning("Num Question or Name Exams invalid "); return(false);
}
this.numQues = numQues;
this.exId = exId;
this.timePer = timePer;
optionMix.Clear();
check.Clear();
RandomNumberQs();
InitRandomChoice();
currentIndex = -1;
return(true);
}
public static bool CheckTextQs(int qs)
{
string query = string.Format("select isImage from questions where q_id = {0}", qs);
return(ReturnClass.scalarReturn(query).Equals("True") ? false : true);
}
