private void edit_cv(LyLichXinViec _newllxv)
{
using (var db1 = new TroGiupViecLamEntities())
{
// string mavc = dgrDSLL.Rows[0].Cells[0].Value.ToString();
LyLichXinViec _llxinviec = db1.LyLichXinViecs;
// db1.SaveChanges();
//LyLichXinViec _llxinviec = db1.LyLichXinViecs.FirstOrDefault(c => c.maCV == _newllxv.maCV);
// _llxinviec.maCV = _newllxv.maCV;
_llxinviec.tenNV = _newllxv.tenNV;
_llxinviec.queQuan = _newllxv.queQuan;
_llxinviec.dcThuongTru = _newllxv.dcThuongTru;
_llxinviec.dcTamTru = _newllxv.dcTamTru;
_llxinviec.soDT = _newllxv.soDT;
_llxinviec.cmND = _newllxv.cmND;
_llxinviec.sucKhoe = _newllxv.sucKhoe;
_llxinviec.eMail = _newllxv.eMail;
_llxinviec.maDN = _newllxv.maDN;
// return true;
// db1.Entry(_newllxv).State = System.Data.Entity.EntityState.Modified;
// db1.LyLichXinViecs.Attach()
capnhatcv(_llxinviec);
LoadCv();
// db1.SaveChanges();
}
}
private void chinhsuadn(LyLichXinViec _l1xivc)
{
using (var db1 = new TroGiupViecLamEntities())
{
db1.Entry(_l1xivc).State = System.Data.Entity.EntityState.Modified;
db1.SaveChanges();
}
}
private void add_CV(LyLichXinViec _llxinvien)
{
using (var db1 = new TroGiupViecLamEntities())
{
//db1.Entry(_llxinvien).State = System.Data.Entity.EntityState.Modified;
db1.LyLichXinViecs.Add(_llxinvien);
db1.SaveChanges();
}
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
try
{
using (var db1 = new TroGiupViecLamEntities())
{
string mavc = dgrDSLL.SelectedRows[0].Cells[0].Value.ToString();
LyLichXinViec lll = db1.LyLichXinViecs.Find(mavc);
// MessageBox.Show(mavc);
//LyLichXinViec ll1 = new LyLichXinViec();
//ll1.maCV = txtMaCV.Text;
lll.tenNV = txtHoTen.Text;
lll.queQuan = txtQueQuan.Text;
lll.cmND = txtCMND.Text;
lll.dcThuongTru = txtDCTHT.Text;
lll.dcTamTru = txtDCTT.Text;
lll.soDT = txtSDT.Text;
lll.sucKhoe = txtSucKhoe.Text;
// ll1.maDN = cbxMaDN.SelectedItem.ToString();
lll.eMail = txtMail.Text;
lll.maDN = cbxMaDN.Text;
// edit_cv(ll1);
// chinhsuadn(lll);
capnhatcv(lll);
LoadCv();
}
}
catch (Exception ex)
{
MessageBox.Show("Cập nhật thất bại.\n" + ex.Message);
}
//using (var db1 = new TroGiupViecLamEntities())
//{
// LyLichXinViec _l = new LyLichXinViec();
// // _l.maCV = txtMaCV.Text;
// _l.tenNV = txtHoTen.Text;
// _l.queQuan = txtQueQuan.Text;
// _l.cmND = txtCMND.Text;
// _l.dcThuongTru = txtDCTHT.Text;
// _l.dcTamTru = txtDCTT.Text;
// _l.soDT = txtSDT.Text;
// _l.sucKhoe = txtSucKhoe.Text;
// // ll1.maDN = cbxMaDN.SelectedItem.ToString();
// _l.eMail = txtMail.Text;
// _l.maDN = cbxMaDN.Text;
// capnhatcv(_l);
// db1.LyLichXinViecs.Attach(_l);
// LoadCv();
//}
}
private bool capnhatcv(LyLichXinViec _ll23xv)
{
try
{
using (var db1 = new TroGiupViecLamEntities())
{
// db1.Entry(_ll23xv).State =EntityState.Modified;
string mavc = dgrDSLL.SelectedRows[0].Cells[0].Value.ToString();
// db1.LyLichXinViecs.Attach();
db1.Entry(_ll23xv).State = _ll23xv.maCV == mavc ? EntityState.Added : EntityState.Modified;
db1.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
using (var db1 = new TroGiupViecLamEntities())
{
if (KtTrung(txtMaCV.Text) == true)
{
LyLichXinViec ll1 = new LyLichXinViec();
ll1.maCV = txtMaCV.Text;
ll1.tenNV = txtHoTen.Text;
ll1.queQuan = txtQueQuan.Text;
ll1.cmND = txtCMND.Text;
ll1.dcThuongTru = txtDCTHT.Text;
ll1.dcTamTru = txtDCTT.Text;
ll1.soDT = txtSDT.Text;
ll1.sucKhoe = txtSucKhoe.Text;
// ll1.maDN = cbxMaDN.SelectedItem.ToString();
ll1.eMail = txtMail.Text;
ll1.maDN = cbxMaDN.Text;
add_CV(ll1);
MessageBox.Show("Thêm thành công");
LoadCv();
}
else
{
MessageBox.Show("Thêm thất bại");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Thêm thất bại\n" + ex.Message);
}
}