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