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