private void btnApply_Click(object sender, EventArgs e) { if (isValid()) { lblInvalid.Visible = false; bool result = false; if (isNew) { try { result = KhoaData.AddNewKhoa(txtSpecialityCode.Text.Trim(), txtSpecialityName.Text.Trim(), int.Parse(txtSpecialtityFoundedYear.Text.Trim()), true); } catch (Exception exception) { if (exception.Message.Contains("duplicate")) { this.errSpeciality.SetError(txtSpecialityCode, "Mã Khoa đã tồn tại"); } } } else { result = KhoaData.UpdateKhoa(txtSpecialityCode.Text.Trim(), txtSpecialityName.Text.Trim(), int.Parse(txtSpecialtityFoundedYear.Text.Trim())); } if (result) { MessageBox.Show("Thành công"); maintainForm.GetAll(); this.Close(); } } else { lblInvalid.Visible = true; } }
private void btnPhysicalDelete_Click(object sender, EventArgs e) { DataGridViewSelectedRowCollection rows = dgvSpeciality.SelectedRows; foreach (DataGridViewRow row in rows) { KhoaData.PhysicalDeleteKhoa(row.Cells[0].Value.ToString()); } GetAll("Khoa ngung dao tao"); }
public void GetAll(string type = null) { if (type == null) { dsKhoa = KhoaData.FindAll(); } else { dsKhoa = KhoaData.FindNotStudentEnroll(); } if (dsKhoa != null) { dgvSpeciality.DataSource = dsKhoa; dgvSpeciality.Columns["NamThanhLap"].Visible = false; dgvSpeciality.Columns["TuyenSinh"].Visible = false; lblNumber.Text = "Có " + dsKhoa.Count + " khoa"; cbSpeciality.DataSource = null; cbSpeciality.DataBindings.Clear(); txtSpecialistName.DataBindings.Clear(); cbSpeciality.DataBindings.Add("text", dsKhoa, "MaKhoa"); txtSpecialistName.DataBindings.Add("text", dsKhoa, "TenKhoa"); cbSpeciality.DataSource = dsKhoa; cbSpeciality.ValueMember = "MaKhoa"; cbSpeciality.DisplayMember = "MaKhoa"; dgvSpeciality.Visible = true; lblSpeciality.Visible = false; int count; lblNumberStudent.Text = (count = SVienData.CountNumberStudent(cbSpeciality.Text.ToString())) != 0 ? "Khoa " + txtSpecialistName.Text + " có " + count + " sinh viên" : "Chưa có sinh viên"; } else { dgvSpeciality.Visible = false; lblSpeciality.Visible = true; lblSpeciality.Text = "Chưa có khoa"; cbSpeciality.DataBindings.Clear(); txtSpecialistName.DataBindings.Clear(); cbSpeciality.Text = string.Empty; cbSpeciality.DataSource = null; txtSpecialistName.Text = string.Empty; lblNumber.Text = "Chưa có khoa"; lblNumberStudent.Text = "Chưa có sinh viên"; } }
private void btnDelete_Click(object sender, EventArgs e) { if (lblMaKhoa.Text.ToString() != string.Empty) { DialogResult option = MessageBox.Show("Bạn có muốn xóa Khoa " + lblMaKhoa.Text.ToString() + "?", "Xác nhận xóa", MessageBoxButtons.YesNo); if (option == DialogResult.Yes) { bool r = KhoaData.DeleteKhoa(lblMaKhoa.Text.ToString()); if (r) { MessageBox.Show("Thành công"); GetAll(); } else { MessageBox.Show("Xảy ra lỗi khi thực hiện"); } } } }