//public static Data.HrChiTietDaoTao IsExisted(string MaChucVu, string TenChucVu) //{ // BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities(); // var query = from c in ctx.HrChiTietDaoTao // where c.MaChucVu == MaChucVu && c.TenChucVu == TenChucVu // select c; // if (query.Count() > 0) // { // ctx.Dispose(); // return query.First(); // } // else // return null; //} public static void Delete(string QuaTrinhDaoTaoID) { BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities(); var obj = new Data.HrChiTietDaoTao { QuaTrinhDaoTaoID = new Guid(QuaTrinhDaoTaoID) }; ctx.HrChiTietDaoTao.Attach(obj); ctx.HrChiTietDaoTao.Remove(obj); ctx.SaveChanges(); ctx.Dispose(); }
public static BHXH.Data.HrChiTietDaoTao New(string MaNhanVien, int STT, string MaCMDaoTao, string TenTruong, string NganhHoc, string ThoiGian, string MaLHDaoTao, string MaBangCap, string XepLoai) { //if (MaCMDaoTao == "" || TenCMDaoTao == "" || LoaiCMDaoTao == "") // return null; //if (IsExisted(MaCMDaoTao, TenCMDaoTao, LoaiCMDaoTao) != null) // return IsExisted(MaCMDaoTao, TenCMDaoTao, LoaiCMDaoTao); BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities(); BHXH.Data.HrChiTietDaoTao n = new Data.HrChiTietDaoTao(); n.MaNhanVien = new Guid(MaNhanVien); n.STT = STT; n.MaCMDaoTao = MaCMDaoTao; n.TenTruong = TenTruong; n.NganhHoc = NganhHoc; n.ThoiGian = ThoiGian; n.MaLHDaoTao = MaLHDaoTao; n.MaBangCap = MaBangCap; n.XepLoai = XepLoai; n.QuaTrinhDaoTaoID = Guid.NewGuid(); ctx.HrChiTietDaoTao.Add(n); try { ctx.SaveChanges(); ctx.Dispose(); return(n); } catch (Exception) { return(null); } finally { } }