public tbl_HoSoPV GetOneData(int id)
{
try
{
tbl_HoSoPV data = db.tbl_HoSoPV.Find(id);
return(data);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(null);
}
}
public tbl_HoSoPV AddData(tbl_HoSoPV data)
{
try
{
tbl_HoSoPV d = db.tbl_HoSoPV.Add(data);
db.SaveChanges();
return(d);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(null);
}
}
public int DeleteData(int id)
{
try
{
tbl_HoSoPV tb = db.tbl_HoSoPV.Find(id);
db.tbl_HoSoPV.Remove(tb);
db.SaveChanges();
return(1);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(-1);
}
}
public int UpdateData(tbl_HoSoPV data)
{
try
{
var update = db.tbl_HoSoPV.Find(data.HoSoPVID);
update.copy(data);
db.SaveChanges();
return(1);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(0);
}
}
private void LoadData1(int id)
{
_id = id;
_pv = HoSoPVBUS.Instance.GetOneData(id);
if (_pv.KetQuaPV == null)
{
bsiSTT.Caption = "Chưa phỏng vấn";
}
else if (_pv.KetQuaPV == 1)
{
bsiSTT.Caption = "Được nhận";
}
else if (_pv.KetQuaPV == 2)
{
bsiSTT.Caption = "Bị từ chối";
}
}
private void LoadData(int id)
{
_id = id;
_pv = HoSoPVBUS.Instance.GetOneData(id);
_hoSo = NhanVienBUS.Instance.GetOneData(_pv.NhanVienID ?? default(int));
txtHoTen.Text = _hoSo.HoTen;
dNgaySinh.EditValue = _hoSo.NgaySinh;
txtBacLuong.Text = _hoSo.LuongYeuCau;
txtDanToc.Text = _hoSo.DanToc;
txtDiaChi.Text = _hoSo.DanToc;
txtEmail.Text = _hoSo.Email;
txtMoTa.Text = _hoSo.Mota;
txtSDT.Text = _hoSo.SDT;
radioGroup1.SelectedIndex = _hoSo.GioiTinh ?? default(bool) ? 0 : 1;
for (int i = 0; i < listChuyenMon.Count; ++i)
{
if (listChuyenMon[i].ChuyenMonID == _hoSo.ChuyenMonID)
{
cbbCM.SelectedIndex = i;
}
}
for (int i = 0; i < listPhongBan.Count; ++i)
{
if (listPhongBan[i].PhongBanID == _hoSo.PhongBanID)
{
cbbPhongBan.SelectedIndex = i;
}
}
for (int i = 0; i < listChucVu.Count; ++i)
{
if (listChucVu[i].ChucVuID == _hoSo.ChucVuID)
{
cbbViTri.SelectedIndex = i;
}
}
for (int i = 0; i < listTrinhDoHocVan.Count; ++i)
{
if (listTrinhDoHocVan[i].TrinhDoHocVanID == _hoSo.TDHVID)
{
cbbTDHV.SelectedIndex = i;
}
}
}
public int UpdateData(tbl_HoSoPV data)
{
return(HoSoPVDAO.Instance.UpdateData(data));
}
public tbl_HoSoPV AddData(tbl_HoSoPV data)
{
return(HoSoPVDAO.Instance.AddData(data));
}
private void SaveData()
{
if (cbbCM.Text == "" || cbbPhongBan.Text == "" || cbbTDHV.Text == "" || cbbViTri.Text == "" || txtBacLuong.Text == "" || txtDanToc.Text == "" || txtDiaChi.Text == "" || txtEmail.Text == "" || txtHoTen.Text == "" || txtMoTa.Text == "" || txtSDT.Text == "")
{
XtraMessageBox.Show("Không được bỏ trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (_id == -1)
{
int phongBanID = listPhongBan[cbbPhongBan.SelectedIndex].PhongBanID;
int chucVuID = listChucVu[cbbViTri.SelectedIndex].ChucVuID;
int trinhdoID = listTrinhDoHocVan[cbbTDHV.SelectedIndex].TrinhDoHocVanID;
int chuyenMonID = listChuyenMon[cbbCM.SelectedIndex].ChuyenMonID;
tbl_NhanVien t = new tbl_NhanVien();
t.HoTen = txtHoTen.Text;
t.NgaySinh = Convert.ToDateTime(dNgaySinh.Text);
t.QueQuan = txtDiaChi.Text;
t.GioiTinh = (radioGroup1.SelectedIndex == 0);
t.DanToc = txtDanToc.Text;
t.SDT = txtSDT.Text;
t.Email = txtEmail.Text;
t.PhongBanID = phongBanID;
t.ChucVuID = chucVuID;
t.TDHVID = trinhdoID;
t.LuongYeuCau = txtBacLuong.Text;
t.TrangThai = 1;
t.ChuyenMonID = chuyenMonID;
_hoSo = NhanVienBUS.Instance.AddData(t);
tbl_HoSoPV h = new tbl_HoSoPV();
h.NhanVienID = _hoSo.NhanVienID;
h = HoSoPVBUS.Instance.AddData(h);
_hoSo.HoSoPVID = h.HoSoPVID;
NhanVienBUS.Instance.UpdateData(_hoSo);
}
else
{
int phongBanID = listPhongBan[cbbPhongBan.SelectedIndex].PhongBanID;
int chucVuID = listChucVu[cbbViTri.SelectedIndex].ChucVuID;
int trinhdoID = listTrinhDoHocVan[cbbTDHV.SelectedIndex].TrinhDoHocVanID;
int chuyenMonID = listChuyenMon[cbbCM.SelectedIndex].ChuyenMonID;
tbl_NhanVien t = new tbl_NhanVien();
t.NhanVienID = _hoSo.NhanVienID;
t.HoTen = txtHoTen.Text;
t.NgaySinh = Convert.ToDateTime(dNgaySinh.Text);
t.QueQuan = txtDiaChi.Text;
t.GioiTinh = (radioGroup1.SelectedIndex == 0);
t.DanToc = txtDanToc.Text;
t.SDT = txtSDT.Text;
t.Email = txtEmail.Text;
t.PhongBanID = phongBanID;
t.ChucVuID = chucVuID;
t.TDHVID = trinhdoID;
t.LuongYeuCau = txtBacLuong.Text;
t.TrangThai = 1;
t.ChuyenMonID = chuyenMonID;
t.HoSoPVID = _hoSo.HoSoPVID;
NhanVienBUS.Instance.UpdateData(t);
_hoSo = t;
}
XtraMessageBox.Show("Lưu thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}