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