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);
}
