public void Delete(int _congtacID) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.QuanHeCongTac quanhect = db.QuanHeCongTacs.FirstOrDefault(x => x.QHCTID == _congtacID); db.QuanHeCongTacs.Remove(quanhect); db.SaveChanges(); }
public void Delete(int _qtdtID) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.QuaTrinhDaoTao qtdt = db.QuaTrinhDaoTaos.FirstOrDefault(x => x.QTDTID == _qtdtID); db.QuaTrinhDaoTaos.Remove(qtdt); db.SaveChanges(); db.Dispose(); }
public void Delete(int _hesoluongID) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.HeSoLuong hesoluong = db.HeSoLuongs.FirstOrDefault(x => x.HSLID == _hesoluongID); db.HeSoLuongs.Remove(hesoluong); db.SaveChanges(); db.Dispose(); }
public void Update(int _hesoluongID, int _bacluongID, int _ngachID, decimal _heso) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.HeSoLuong hesoluong = db.HeSoLuongs.FirstOrDefault(x => x.HSLID == _hesoluongID); hesoluong.NGID = _ngachID; hesoluong.BLID = _bacluongID; hesoluong.HSLHeSo = _heso; db.SaveChanges(); db.Dispose(); }
// LOAD DATASOURCE public void Load_AllLoaiQuanHe_ToRadComboBox(RadComboBox _cbb) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); IEnumerable <Models.LoaiQuanHe> lqhs = db.LoaiQuanHes.OrderBy(x => x.LQHTen); _cbb.DataSource = lqhs.ToList(); _cbb.DataTextField = "LQHTen"; _cbb.DataValueField = "LQHID"; _cbb.DataBind(); }
public void Insert(int _bacluongID, int _ngachID, decimal _heso) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.HeSoLuong hesoluong = new Models.HeSoLuong(); hesoluong.NGID = _ngachID; hesoluong.BLID = _bacluongID; hesoluong.HSLHeSo = _heso; db.HeSoLuongs.Add(hesoluong); db.SaveChanges(); db.Dispose(); }
public void Delete(int _nhanvienID) { Helper.FileHelper fileHelper = new Helper.FileHelper(); Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.NhanVien nhanvien = db.NhanViens.FirstOrDefault(x => x.NVID == _nhanvienID); if ((nhanvien.NVHinh != null) && (!nhanvien.NVHinh.Equals("DefaultUser.png"))) { fileHelper.DeleteFile("Images\\NhanVien\\" + nhanvien.NVHinh); } db.NhanViens.Remove(nhanvien); db.SaveChanges(); db.Dispose(); }
public void Update(int _qtdtID, string _truong, string _chuyennganh, DateTime _tungay, DateTime _denngay, string _hinhthuc, string _vanbang) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.QuaTrinhDaoTao qtdt = db.QuaTrinhDaoTaos.FirstOrDefault(x => x.QTDTID == _qtdtID); qtdt.QTDTTruong = _truong; qtdt.QTDTChuyenNganh = _chuyennganh; qtdt.QTDTTuNgay = _tungay; qtdt.QTDTDenNgay = _denngay; qtdt.QTDTHinhThuc = _hinhthuc; qtdt.QTDTVanBang = _vanbang; db.SaveChanges(); db.Dispose(); }
public void Update(int _congtacID, string _donvi, string _chucvu, string _nghenghiep, string _ghichu, DateTime _tungay, DateTime _denngay) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.QuanHeCongTac quanhect = db.QuanHeCongTacs.FirstOrDefault(x => x.QHCTID == _congtacID); quanhect.QHCTDonVi = _donvi; quanhect.QHCTChucVu = _chucvu; quanhect.QHCTNgheNghiep = _nghenghiep; quanhect.QHCTNoiDung = _ghichu; quanhect.QHCTTuNgay = _tungay; quanhect.QHCTDenNgay = _denngay; db.SaveChanges(); db.Dispose(); }
public void Insert(int _nhanvienID, string _truong, string _chuyennganh, DateTime _tungay, DateTime _denngay, string _hinhthuc, string _vanbang) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.QuaTrinhDaoTao qtdt = new Models.QuaTrinhDaoTao(); qtdt.QTDTTruong = _truong; qtdt.NVID = _nhanvienID; qtdt.QTDTChuyenNganh = _chuyennganh; qtdt.QTDTTuNgay = _tungay; qtdt.QTDTDenNgay = _denngay; qtdt.QTDTHinhThuc = _hinhthuc; qtdt.QTDTVanBang = _vanbang; db.QuaTrinhDaoTaos.Add(qtdt); db.SaveChanges(); db.Dispose(); }
// LOAD DATASOURCE public void Load_DataSource_RadGrid(RadGrid _radgrid, int _nhanvienID) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); IEnumerable <object> qhs = db.QuanHes.Where(x => x.NVID == _nhanvienID).AsEnumerable().Select(x => new { QHID = x.QHID, QHTen = x.QHTen, QHNgaySinh = x.QHNgaySinh, LQHTen = x.LoaiQuanHe.LQHTen, QHBenVo = x.QHBenVo, QHGioiTinh = this.ConvertGioiTinh(x), QHHoKhau = x.QHHoKhau, QHNoiO = x.QHNoiO }); _radgrid.DataSource = qhs.ToList(); }
public void Insert(int _quanheID, string _donvi, string _chucvu, string _nghenghiep, string _ghichu, DateTime _tungay, DateTime _denngay) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.QuanHeCongTac quanhect = new Models.QuanHeCongTac(); quanhect.QHID = _quanheID; quanhect.QHCTDonVi = _donvi; quanhect.QHCTChucVu = _chucvu; quanhect.QHCTNgheNghiep = _nghenghiep; quanhect.QHCTNoiDung = _ghichu; quanhect.QHCTTuNgay = _tungay; if (_denngay != DateTime.MinValue) { quanhect.QHCTDenNgay = _denngay; } db.QuanHeCongTacs.Add(quanhect); db.SaveChanges(); db.Dispose(); }
protected void RadFilterNhanVien_ExpressionItemCreated(object sender, RadFilterExpressionItemCreatedEventArgs e) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); IEnumerable <Models.ChucVu> chuvus = db.ChucVus; IEnumerable <Models.ChinhTriXaHois> ctxhs = db.ChinhTriXaHois; RadFilterSingleExpressionItem singleItem = e.Item as RadFilterSingleExpressionItem; if (singleItem != null && singleItem.FieldName == "NVLamViecChucVu" && singleItem.IsSingleValue) { RadDropDownList dropDownList = singleItem.InputControl as RadDropDownList; dropDownList.DataSource = chuvus.ToList(); dropDownList.DataBind(); } if (singleItem != null && singleItem.FieldName == "NVTGCTXH" && singleItem.IsSingleValue) { RadDropDownList dropDownList = singleItem.InputControl as RadDropDownList; dropDownList.DataSource = ctxhs.ToList(); dropDownList.DataBind(); } }
public void Update(int _nhanvienID, string _ten, string _tenkhac, DateTime _ngaysinh, bool _gioitinh, int _dantocID, int _tongiaoID, string _hokhau, string _noio, int _gdptID, int _chuyenmonID, int _llctID, int _qlnnID, string _ttsk, decimal _chieucao, decimal _cannang, int _nhommauID, string _cmnd, DateTime _cmndNgay, string _noisinh, string _quequan, string _nganh, FileUpload _fileuploadImage, bool _useDefaultImage, string _bhxh) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.NhanVien nhanvien = db.NhanViens.FirstOrDefault(x => x.NVID == _nhanvienID); nhanvien.NVTen = _ten; nhanvien.NVTenKhac = _tenkhac; nhanvien.NVNgaySinh = _ngaysinh; nhanvien.NVGioiTinh = _gioitinh; nhanvien.DTID = _dantocID; nhanvien.TGID = _tongiaoID; nhanvien.NVHoKhau = _hokhau; nhanvien.NVNoiO = _noio; nhanvien.NVBHXH = _bhxh; nhanvien.GDPTID = _gdptID; nhanvien.CMID = _chuyenmonID; nhanvien.LLCTID = _llctID; nhanvien.QLNNID = _qlnnID; nhanvien.NVTinhTrangSucKhoe = _ttsk; if (_chieucao > 0) { nhanvien.NVChieuCao = _chieucao; } else { nhanvien.NVChieuCao = null; } if (_cannang > 0) { nhanvien.NVCanNang = _cannang; } else { nhanvien.NVCanNang = null; } nhanvien.NMID = _nhommauID; nhanvien.NVCMND = _cmnd; if (_cmndNgay != null && _cmndNgay != DateTime.MinValue) { nhanvien.NVNgayCapCMND = _cmndNgay; } else { nhanvien.NVNgayCapCMND = null; } nhanvien.NVQueQuan = _quequan; nhanvien.NVNganh = _nganh; if (_useDefaultImage) { Helper.FileHelper fileHelper = new Helper.FileHelper(); if ((nhanvien.NVHinh != null) && (!nhanvien.NVHinh.Equals("DefaultUser.png"))) { fileHelper.DeleteFile("Images\\NhanVien\\" + nhanvien.NVHinh); } nhanvien.NVHinh = null; } else if (_fileuploadImage.HasFile) { Helper.FileHelper fileHelper = new Helper.FileHelper(); if ((nhanvien.NVHinh != null) && (!nhanvien.NVHinh.Equals("DefaultUser.png"))) { fileHelper.DeleteFile("Images\\NhanVien\\" + nhanvien.NVHinh); } Helper.FileHelper _fileHelper = new Helper.FileHelper(); string extension = System.IO.Path.GetExtension(_fileuploadImage.PostedFile.FileName); string imageName = _fileHelper.SetFileUploadedName(extension); nhanvien.NVHinh = imageName; _fileHelper.SaveFile(_fileuploadImage, "Images\\NhanVien\\", imageName); } db.SaveChanges(); db.Dispose(); }
public Models.DonVi Find_DonVi(int _donviID) { Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities(); Models.DonVi donvi = db.DonVis.FirstOrDefault(x => x.DVID == _donviID); return(donvi); }