// Tra cuu theo ma giao vien
private void btnTraCuu_Click(object sender, EventArgs e)
{
// Truyen du lieu lay duoc tu co so du lieu vao datatable
DataTable dataTable = khoaHocService.get(AccountHelper.getAccountId(),
AccountHelper.getAccoutPassword(), cbMaKhoaHoc.Text);
// Lay thong tin tu dataTable gan vao dgvTraCuu
dgvTraCuu.DataSource = dataTable;
}
// Them hoac sua cac gia tri trong khoa hoc vao database
private int InsertOrUpdateCurrentValueToDatabase(bool isUpdate = false)
{
// Gan cac gia tri trong phan design vao
string maKhoaHoc = tbMaKhoaHoc.Text;
string tenKhoaHoc = tbTenKhoaHoc.Text;
string taiLieuGiangDay = tbTaiLieuGiangDay.Text;
string moTa = tbMoTa.Text;
// Tong thoi gian tinh bang thang, co gia tri bang thoi gian trong comboBox + 1
int tongThoiGian = cbTongThoiGian.SelectedIndex + 1;
int resultHandle; // tra ve ket qua khi update hoac insert
// Neu ma khoa hoc hoac ten khoa hoc khong hop le
if (maKhoaHoc.Equals("") || tenKhoaHoc.Equals(""))
{
// Thong bao chua dien vao o trong
DialogHelper.ShowMissingField();
// Khong them hoac update
return(1);
}
// --------------------- Neu nguoi dung muon update
if (isUpdate)
{
// Khoi tao row bang row ma nguoi dung chon trong dataGridView
DataGridViewRow row = GetCurrentRow();
// Neu row khong ton tai, tuc dataGridView khong co gia tri
if (row == null)
{
// Hien ra bang thong bao chua chon row
DialogHelper.ShowMissingSelectedRow();
// Update that bai
return(1);
}
// Neu row co ton tai thi kiem tra thay doi trong khoa chinh
// Trong bang nay, khoa chinh la ma khoa hoc co cell o vi tri 0 trong row
string maKhoaHocRowValue = row.Cells["MAKH"].Value.ToString();
// Neu co thay doi trong khoa chinh
if (!maKhoaHoc.Equals(maKhoaHocRowValue))
{
// Hien ra bang thong bao ve viec khong the thay doi khoa chinh
DialogHelper.ShowCannotModifiyPrimaryKey();
// Update that bai
return(1);
}
// Toi day tuc la cac gia tri can update deu thoa yeu cau, nen bat dau update
resultHandle = khoaHocService.update(AccountHelper.getAccountId(), AccountHelper.getAccoutPassword(),
maKhoaHoc, tenKhoaHoc, moTa, taiLieuGiangDay, tongThoiGian);
// Neu viec update that bai
if (resultHandle == 0)
{
// Hien ra bang co loi trong luc update
DialogHelper.ShowErrorOnUpdate();
// That bai trong luc update
return(0);
}
}
// ---------------------- Neu nguoi dung muon them
else
{
// Kiem tra xem ma khoa chinh (maKhoaHoc) da ton tai chua
if (khoaHocService.get(AccountHelper.getAccountId(), AccountHelper.getAccoutPassword(), maKhoaHoc) != null)
{
// Neu maKhoaHoc da ton tai trong database thi khong cho them
// Hien bang thong bao trung khoa chinh
DialogHelper.ShowDuplicatePrimaryKey();
// Them khoa hoc that bai
return(1);
}
// Thoa man dieu kien them khoa hoc, bat dau them
resultHandle = khoaHocService.insert(AccountHelper.getAccountId(), AccountHelper.getAccoutPassword(),
maKhoaHoc, tenKhoaHoc, moTa, taiLieuGiangDay, tongThoiGian);
// Neu viec insert that bai
if (resultHandle == 0)
{
// Hien ra bang co loi trong luc insert
DialogHelper.ShowErrorOnInsert();
// That bai trong luc insert
return(0);
}
}
// Cap nhat lai grid view
PopulateKhoaHocGridView();
// Ket thuc viec them hoac update
return(1);
}
