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 GetDataUser() { /*Query Filter username in Login form into this Form*/ string query = string.Format("select * from admin_athu where ad_user ='******'", FormLogin.username); using (SqlDataReader reader = ReturnClass.readerReturn(query)) if (reader.Read()) { /*Username*/ setContentPanel(DataReader.GetDataReader(reader, 0) as string, pnUsername, lblUsername); /*Full Name*/ setContentPanel(DataReader.GetDataReader(reader, 3) as string, pnFullName, lblFullName); ////Get object int then compare with null if true then parameter is Empty else string in obj //object obj = DataReader.GetDataReader(reader, 4); //setContentPanel(obj.Equals(null)?"":obj.ToString(), pnAge, lblAge); /*Live*/ setContentPanel(DataReader.GetDataReader(reader, 4) as string, pnLive, lblLive); //Get object Date then compare with null if true then parameter is Empty else cast object into DateTime and // Pass parameter is ToShotDateString method object obj = DataReader.GetDataReader(reader, 5); setContentPanel(obj.Equals(null) ? "" : ((DateTime)obj).ToShortDateString(), pnDateOfBirth, lblDateOfBirth); /*Phone number*/ setContentPanel(DataReader.GetDataReader(reader, 6) as string, pnPhoneNum, lblPhoneNum); obj = DataReader.GetDataReader(reader, 7); pictureBox1.Image = ((obj is System.DBNull || string.IsNullOrEmpty((string)obj))) ? Properties.Resources.businesswoman : Image.FromFile((string)obj); } }
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 setDataTable() { string query = "select q_id,ex_id,isImage,q_title,exam_name,ad_add,q_addeddate,explain from questions join exams on questions.q_fk_ex = exams.ex_id"; DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); GridView.DataSource = dt; SetHeader(); }
private void btnSaved_Click(object sender, EventArgs e) { if (!CheckContent()) { return; } string query = string.Format("update exams set exam_name = '{0}' where ex_id = {1}", txtExams.Text, this.idEx); ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update); }
private void setDataGridview(string exName) { string query = string.Format("select * from questions join exams on ex_id= q_fk_ex " + exName); using (DataTable table = new DataTable()) { ReturnClass.FillAdapter(query, table); GridView.DataSource = table; } }
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 void setDataSource() { string query = "select exam_name from exams"; DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); GridView.DataSource = dt; GridView.Columns[0].Width = GridView.Width; GridView.Columns[0].HeaderText = "Tên Môn Học"; }
private void guna2ImageButton1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(oldUsername)) { return; } string query = string.Format("update admin_athu set ad_user = '******',ad_password='******',FullName=N'{2}',Live =N'{3}',DateOfBirth = '{4}',PhoneNumber ='{5}',Images='{6}' where ad_user = '******'", txtUsername.Text, txtPassword.Text, txtFullName.Text, txtLive.Text, txtDate.Value.ToShortDateString(), txtPhoneNum.Text, img, oldUsername); ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update); }
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 static DataTable GetDataSource(string query) { try { DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); return(dt); }catch { return(null); } }
private void AddUsers_Load(object sender, EventArgs e) { Clear(); string query = string.Format("select * from admin_athu where isAd = 0 or ad_user ='******' order by isAd asc", FormLogin.username); using (DataTable dt = new DataTable()) { ReturnClass.FillAdapter(query, dt); viewUser.DataSource = dt; } SetDataTable(); }
private void setDataSource() { string query = "select * from exams"; DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); viewExams.DataSource = dt; viewExams.Columns["ex_id"].Visible = false; viewExams.Columns["exam_name"].Width = viewExams.Width; viewExams.Columns["exam_name"].HeaderText = "Tên Môn Học"; }
private void setDataCbxNameExams() { string query = string.Format("select exam_name from exams"); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { string content = reader.GetString(0); //MessageBox.Show(content); comboBox1.Items.Add(content); } } //comboBox1.Items }
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 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(); }
private void setItemCbbExams() { string query = string.Format("select * from exams"); List <string> nameExams = new List <string>(); using (SqlDataReader data = ReturnClass.readerReturn(query)) { while (data.Read()) { Examcode.Add(data.GetInt32(0)); nameExams.Add(data.GetString(1)); } } cbxNameExams.Items = nameExams.ToArray(); }
private void btnDel_Click(object sender, EventArgs e) { if (!CheckContent()) { return; } List <int> q_id = new List <int>(); string query = string.Format("select q_id from questions where q_fk_ex =2"); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { q_id.Add(reader.GetInt32(0)); } } }
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); } } }
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); }
private void AddQuestions_Load(object sender, EventArgs e) { SetZoomImage(); pnOps = new PnContentQs(pnOptions, animation, zoomImg); string query = string.Format("select * from exams"); List <string> nameExams = new List <string>(); using (SqlDataReader data = ReturnClass.readerReturn(query)) { while (data.Read()) { Examcode.Add(data.GetInt32(0)); nameExams.Add(data.GetString(1)); } } cbxNameExams.Items = nameExams.ToArray(); switchText_Click(null, null); pnOptions.Controls.SetChildIndex(pnExplain, 0); }
public void RandomNumberQs() { List <int> idQuestions; string query = string.Format("select q_id from questions"); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { idQuestions = (from IDataRecord r in reader select(int) r["q_id"]).ToList <int>(); } List <string> IdQuestions = new List <string>(); for (int index = 0; index < this.numQues; ++index) { int value = random.Next(idQuestions.Count); IdQuestions.Add(idQuestions[value].ToString()); idQuestions.RemoveAt(value); } //MessageBox.Show(string.Join("\n", IdQuestions)); this.IdQuestions = IdQuestions; }
public static Questions GetQuestions(string idQues) { Questions question = new Questions(); try { string query = string.Format("select q_title,isImage from questions where q_id = {0}", idQues); using (SqlDataReader reader = ReturnClass.readerReturn(query)) if (reader.Read()) { question.q_id = idQues; question.q_title = DataReader.GetDataReader(reader, 0) as string; question.isImage = DataReader.getStringBitDb((bool)DataReader.GetDataReader(reader, 1)); } //question.getOption(); return(question); }catch { return(null); } }
public List <Options> getOption() { string query = string.Format("select * from Options where id_Qus ={0}", q_id); List <Options> options = new List <Options>(); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { string id_Op = reader.GetInt32(0).ToString(); string Contents = reader.GetString(1); string id_ques = reader.GetInt32(2).ToString(); string isImage = DataReader.getStringBitDb(reader.GetBoolean(3)); string isCorrect = DataReader.getStringBitDb(reader.GetBoolean(4)); Options op = new Options(id_Op, Contents, isImage, isCorrect); op.id_Qus = id_ques; options.Add(op); } } setOption(options); return(options); }
public static List <string> getContentOption(string qs, List <string> Contents, List <bool> check) { string msg = "Contents"; if (check != null) { msg += ",isCorrect"; } string query = string.Format("select {0} from Options where id_Qus ={1}", msg, qs); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { Contents.Add(reader.GetString(0)); if (check != null) { check.Add(reader.GetBoolean(1)); } } } return(Contents); }
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); }