private void btnInsert_Click(object sender, EventArgs e) { Program.insertLevel = txtLevel.Text; Program.insertSubjectID = txtSubject.Text; Program.insertTeacherID = txtTeacherID.Text; Program.insertClassID = txtClass.Text; frmInsertQuestion frm = new frmInsertQuestion(); frm.ShowDialog(); }
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { String sqlStr = ""; if (method == Program.NEW_METHOD) { Program.connect.Open(); sqlStr = "sp_KiemTraGVDK"; Program.cmd = Program.connect.CreateCommand(); Program.cmd.CommandType = CommandType.StoredProcedure; Program.cmd.CommandText = sqlStr; Program.cmd.Parameters.Add("@MALOP", SqlDbType.NChar).Value = getClassIDSelected(); Program.cmd.Parameters.Add("@MAMH", SqlDbType.NChar).Value = getSubjectIDSelected(); Program.cmd.Parameters.Add("@LAN", SqlDbType.Int).Value = Int32.Parse(txtTime.Text.ToString()); Program.cmd.Parameters.Add("@TRINHDO", SqlDbType.NChar).Value = txtLevel.Text.ToString(); Program.cmd.Parameters.Add("@SOCAUTHI", SqlDbType.Int).Value = txtQuestNum.Text.ToString(); Program.cmd.Parameters.Add("@NGAYTHI", SqlDbType.DateTime).Value = pickerDate.Value.ToString(); Program.cmd.Parameters.Add("@THOIGIAN", SqlDbType.Int).Value = txtCountdown.Text.ToString(); Program.cmd.Parameters.Add("@ReturnValue", SqlDbType.VarChar).Direction = ParameterDirection.ReturnValue; Program.cmd.ExecuteNonQuery(); Program.connect.Close(); String result = Program.cmd.Parameters["@ReturnValue"].Value.ToString(); if (result == "-1") { MessageBox.Show("The registration for this class has already exists!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); Program.myReader.Close(); return; } else { if (txtQuestNum.Text.Length == 0 || txtTime.Text.Length == 0 || txtLevel.Text.Length == 0 || txtCountdown.Text.Length == 0) { MessageBox.Show("Can not empty!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); Program.myReader.Close(); return; } else if (result == "2") { if (MessageBox.Show("University have not enough exam code. \nUpdate new exam code?", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Program.insertLevel = txtLevel.Text; Program.insertSubjectID = getSubjectIDSelected(); Program.insertTeacherID = txtTeacherID.Text; Program.insertClassID = txtClass.Text; frmInsertQuestion frm = new frmInsertQuestion(); frm.ShowDialog(); Program.myReader.Close(); } else { return; } } else if (result == "3") { MessageBox.Show("This class have not tested yet", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); Program.myReader.Close(); return; } else if (result == "4") { MessageBox.Show("Date must be after first test's date", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); Program.myReader.Close(); return; } else if (result == "0" || result == "1") { try { this.Validate(); bdsRegistrationFromDep.EndEdit(); bdsRegistrationFromDep.ResetCurrentItem(); this.sp_DanhSachGVDKTheoCosoTableAdapter.Insert(txtTeacherID.Text, getClassIDSelected(), getSubjectIDSelected(), txtLevel.Text, pickerDate.Value.Date, Int32.Parse(txtTime.Text), Int32.Parse(txtQuestNum.Text), Int32.Parse(txtCountdown.Text)); getDataClassFromDep(); } catch (Exception ex) { MessageBox.Show("Create registration failed! \n" + ex.Message, "Error", MessageBoxButtons.OK); Program.myReader.Close(); return; } } Program.myReader.Close(); } } else if (method == Program.UPDATE_METHOD) { Program.connect.Open(); sqlStr = "sp_KiemTraGVDK"; Program.cmd = Program.connect.CreateCommand(); Program.cmd.CommandType = CommandType.StoredProcedure; Program.cmd.CommandText = sqlStr; Program.cmd.Parameters.Add("@MALOP", SqlDbType.NChar).Value = txtClass.Text; Program.cmd.Parameters.Add("@MAMH", SqlDbType.NChar).Value = txtSubject.Text; Program.cmd.Parameters.Add("@LAN", SqlDbType.Int).Value = Int32.Parse(txtTime.Text.ToString()); Program.cmd.Parameters.Add("@TRINHDO", SqlDbType.NChar).Value = txtLevel.Text.ToString(); Program.cmd.Parameters.Add("@SOCAUTHI", SqlDbType.Int).Value = txtQuestNum.Text.ToString(); Program.cmd.Parameters.Add("@NGAYTHI", SqlDbType.DateTime).Value = pickerDate.Value.ToString(); Program.cmd.Parameters.Add("@THOIGIAN", SqlDbType.Int).Value = txtCountdown.Text.ToString(); Program.cmd.Parameters.Add("@ReturnValue", SqlDbType.VarChar).Direction = ParameterDirection.ReturnValue; Program.cmd.ExecuteNonQuery(); Program.connect.Close(); String result = Program.cmd.Parameters["@ReturnValue"].Value.ToString(); if (txtQuestNum.Text.Length == 0 || txtTime.Text.Length == 0 || txtCountdown.Text.Length == 0) { MessageBox.Show("Can not empty!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (result == "2") { if (MessageBox.Show("University have not enough exam code. \nUpdate new exam code?", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Program.insertLevel = txtLevel.Text; Program.insertSubjectID = txtSubject.Text; Program.insertTeacherID = txtTeacherID.Text; Program.insertClassID = txtClass.Text; frmInsertQuestion frm = new frmInsertQuestion(); frm.ShowDialog(); Program.myReader.Close(); } else { return; } } else if (result == "3") { MessageBox.Show("This class have not tested yet", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); Program.myReader.Close(); return; } else if (result == "4") { MessageBox.Show("Date must be after first test's date", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); Program.myReader.Close(); return; } else if (result == "0" || result == "1") { try { this.Validate(); bdsRegistrationFromDep.EndEdit(); bdsRegistrationFromDep.ResetCurrentItem(); this.sp_DanhSachGVDKTheoCosoTableAdapter.Update(txtSubject.Text, txtClass.Text, Int32.Parse(txtTime.Text), txtLevel.Text, pickerDate.Value.Date, Int32.Parse(txtQuestNum.Text), Int32.Parse(txtCountdown.Text)); getDataClassFromDep(); } catch (Exception ex) { MessageBox.Show("Update registration failed! \n" + ex.Message, "Error", MessageBoxButtons.OK); Program.myReader.Close(); return; } } Program.myReader.Close(); } groupBox1.Enabled = true; cbbClass.Enabled = false; cbbSubject.Enabled = false; groupBox2.Enabled = true; txtLevel.Enabled = pickerDate.Enabled = txtTime.Enabled = txtCountdown.Enabled = txtQuestNum.Enabled = false; btnNew.Enabled = btnEdit.Enabled = btnDel.Enabled = btnRefresh.Enabled = true; txtSubject.Visible = txtClass.Visible = true; cbbClass.Visible = cbbSubject.Visible = false; btnSave.Enabled = btnCancel.Enabled = false; }