private void txtsearch_TextChanged(object sender, EventArgs e)
{
List <tbl_PhiDoanVien> lst = new List <tbl_PhiDoanVien>();
lst = PhiDoanVienService.PhiDoanVien_GetByTop("", "", "");
var v = (from p in lst
where p.Nam.Contains(txtsearch.Text)
select p).ToList();
dtgrvPhiDoan.DataSource = v;
}
private void btndelete_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_PhiDoanVien dt = new tbl_PhiDoanVien();
dt.ID = dtgrvPhiDoan.CurrentRow.Cells["ID"].Value.ToString();
PhiDoanVienService.PhiDoanVien_Delete(dt);
LoadandSetData();
}
}
private void btnthem_Click(object sender, EventArgs e)
{
them = true;
List <Entity.tbl_PhiDoanVien> lst = new List <tbl_PhiDoanVien>();
lst = PhiDoanVienService.PhiDoanVien_GetByTop("", "", "");
if (lst.Count != 0)
{
txtId.Text = (Convert.ToInt32(lst[lst.Count - 1].ID) + 1).ToString();
}
else
{
txtId.Text = "1";
}
btnsua.Enabled = false;
btndelete.Enabled = false;
btnhuy.Enabled = true;
btnluu.Enabled = true;
}
private void LoadandSetData()
{
List <tbl_PhiDoanVien> lst = new List <tbl_PhiDoanVien>();
lst = PhiDoanVienService.PhiDoanVien_GetByTop("", "", "");
txtId.Text = "";
nmrudNam.Value = 2000;
cbbmasv.DisplayMember = "HoTenSV";
cbbmasv.ValueMember = "MaSV";
cbbmasv.DataSource = SinhVienService.SinhVien_GetByTop("", "", "");
nmrudPhidoan.Value = 10000;
btnthem.Enabled = true;
btnsua.Enabled = true;
btnluu.Enabled = false;
btnhuy.Enabled = false;
btndelete.Enabled = true;
txtId.Enabled = false;
dtgrvPhiDoan.DataSource = lst;
}
private void btnluu_Click(object sender, EventArgs e)
{
if (them == true)
{
tbl_PhiDoanVien dt = new tbl_PhiDoanVien();
dt.MaSV = cbbmasv.SelectedValue.ToString();
dt.Nam = nmrudNam.Value.ToString();
dt.PhiDoan = nmrudPhidoan.Value.ToString();
PhiDoanVienService.PhiDoanVien_Insert(dt);
MessageBox.Show("Thêm thành công!!!", "Thông báo");
}
else
{
tbl_PhiDoanVien dt = new tbl_PhiDoanVien();
dt.ID = txtId.Text;
dt.MaSV = cbbmasv.SelectedValue.ToString();
dt.Nam = nmrudNam.Value.ToString();
dt.PhiDoan = nmrudPhidoan.Value.ToString();
PhiDoanVienService.PhiDoanVien_Update(dt);
MessageBox.Show("Sửa thành công!!!", "Thông báo");
}
LoadandSetData();
}