private void btnluu_Click(object sender, EventArgs e)
{
if (them == true)
{
tbl_XepLoaiSV obj = new tbl_XepLoaiSV();
obj.MaSV = Masv;
obj.Nam = nmrudNam.Value.ToString();
obj.XepLoai = cbbxeploai.SelectedItem.ToString();
if (XepLoaiSVService.XepLoai_Insert(obj) == true)
{
MessageBox.Show("Thêm thành công!!");
}
}
else
{
tbl_XepLoaiSV obj = new tbl_XepLoaiSV();
obj.MaSV = Masv;
obj.Nam = nmrudNam.Value.ToString();
obj.XepLoai = cbbxeploai.SelectedItem.ToString();
obj.Id = Id_XeploaiSV;
if (XepLoaiSVService.XepLoai_Update(obj) == true)
{
MessageBox.Show("Sửa thành công!!");
}
}
LamMoiXepLoaiDV();
}
private void UC_XepLoaiDV_Load(object sender, EventArgs e)
{
dtgrvDV.DataSource = SinhVienService.SinhVien_GetByTop("", "", "").Select(a => new { a.MaSV, a.HoTenSV, a.NgaySinh, a.DienThoai, a.TinhTrang }).ToList();
dtgrvXeploaiDV.DataSource = XepLoaiSVService.XepLoai_GetByTop("", "", "").Select(a => new { a.Id, a.XepLoai, a.Nam }).ToList();
cbbxeploai.Items.Add("Xuất sắc");
cbbxeploai.Items.Add("Tốt");
cbbxeploai.Items.Add("Khá");
cbbxeploai.Items.Add("Trung Bình");
cbbxeploai.Items.Add("Yếu");
}
private void btnxoa_Click(object sender, EventArgs e)
{
DialogResult h = MessageBox.Show("Bạn có chắc muốn xoá không? ", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (h == DialogResult.Yes)
{
tbl_XepLoaiSV dt = new tbl_XepLoaiSV();
dt.Id = dtgrvXeploaiDV.CurrentRow.Cells["Id"].Value.ToString();
XepLoaiSVService.XepLoai_Delete(dt);
LamMoiXepLoaiDV();
}
}
void LamMoiXepLoaiDV()
{
nmrudNam.Value = 2000;
cbbxeploai.ResetText();
if (Masv == null)
{
dtgrvXeploaiDV.DataSource = XepLoaiSVService.XepLoai_GetByTop("", "", "");
}
else
{
dtgrvXeploaiDV.DataSource = XepLoaiSVService.XepLoai_GetByTop("", " MaSV=" + Masv + "", "");
}
btnluu.Enabled = true;
btnthem.Enabled = true;
btnsua.Enabled = true;
btnxoa.Enabled = true;
}
private void dtgrvDV_CellClick(object sender, DataGridViewCellEventArgs e)
{
Masv = dtgrvDV.CurrentRow.Cells["masinhvien"].Value.ToString();
dtgrvXeploaiDV.DataSource = XepLoaiSVService.XepLoai_GetByTop("", " MaSV=" + Masv + "", "");
}
