示例#1
0
        //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();
        }
示例#2
0
        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
            { }
        }