private void btnAdd_Click(object sender, EventArgs e) { string contents = switchText.Value ? rtxtQuestion.Text : fileName; if (RgEx.isEmpty(contents, "Title question")) { return; } if (!pnOps.getCountOpValid()) { return; } if (cbxNameExams.selectedIndex == -1) { MessBox.Warning("Please Select Exams!!"); return; } /*Insert Question*/ Questions qs = new Questions(contents, DateTime.UtcNow.ToShortDateString(), Examcode[cbxNameExams.selectedIndex].ToString(), FormLogin.username, switchText.Value == true ? "0" : "1", rtxExplain.Text); qs.setOption(pnOps.GetOption()); qs.InsertQuestion(); Clear(); }
public void insertOption(string idQues) { string queryInsertOption = string.Format("insert into Options values(N'{0}',{1},{2},{3})", RgEx.isNullOrEmpty(Contents), RgEx.isNullOrEmpty(idQues), RgEx.isNullOrEmpty(isImages), RgEx.isNullOrEmpty(isCorrect)); ReturnClass.ExcuteNonQuery(queryInsertOption); }
private void btnAddUser_Click(object sender, EventArgs e) { //does the username,password contain special character ??? if (cbxTypeUser.selectedIndex == -1) { MessBox.MessError("Please select type User !!!"); return; } if (!RgEx.isAlphanumericNotSpace(txtUsername.Text, "Username")) { return; } if (!RgEx.isAlphanumericNotSpace(txtPassword.Text, "Password")) { return; } //Compare Retype the password again if (!txtPassword.Text.Equals(txtRqPw.Text)) { MessBox.MessError("Retype the password incorrectly !!"); } // insert into Database int isadmin = 0; if (cbxTypeUser.selectedValue.Equals("Admin")) { isadmin = 1; } string query = String.Format("insert into admin_athu values ('{0}','{1}',{2})", txtUsername.Text, txtPassword.Text, isadmin); ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.insert); }
public void Update() { if (RgEx.isEmpty(exam_name)) { MessBox.MessError("Empty Exams"); return; } string query = string.Format("update exams set exam_name = '{0}' where ex_id = {1}", exam_name, ex_id); ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update); }
private bool CheckContent() { if (RgEx.isEmpty(txtExams.Text, "Tên Môn Học")) { return(false); } if (this.idEx == 0) { MessBox.MessError("Please choose exam!! "); return(false); } return(true); }
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) ); }
public void updateOption() { if (string.IsNullOrEmpty(this.id)) { insertOption(id_Qus); return; } if (RgEx.isEmpty(Contents)) { DeleteOption(); return; } string queryInsertOption = string.Format("update Options set Contents = N'{0}', isImages = {1},isCorrect = {2} where id_Qus = {3} and id ={4}", RgEx.isNullOrEmpty(Contents), RgEx.isNullOrEmpty(isImages), RgEx.isNullOrEmpty(isCorrect), RgEx.isNullOrEmpty(id_Qus), RgEx.isNullOrEmpty(id)); ReturnClass.ExcuteNonQuery(queryInsertOption); }
public void UpdateQuestion() { if (RgEx.isEmpty(q_title)) { MessBox.MessWarning("Chưa nhập câu hỏi !!"); return; } string query = string.Format("update questions set q_title = N'{0}',isImage = {1},explain ='{2}' where q_id = {3}", q_title, isImage, explain, q_id); ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update); //for (int i = 0; i < options.Count; ++i) foreach (var dt in options) { dt.id_Qus = dt.id_Qus ?? this.q_id; dt.updateOption(); } }
private void btnAdd_Click(object sender, EventArgs e) { if (RgEx.isNonCharSpecialAndNonEmpty(txtExams.Text, "Exam name ")) { string query = string.Format("insert into exams values(N'{0}')", txtExams.Text); try { ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.insert); //MessBox.MessInf() RefeshForm(); setDataSource(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
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 { } }