BKI_DichVuMatDat.US.US_GD_HOP_DONG.SetID_LUONG_CHE_DONull C# (CSharp) Method

        public void SetID_LUONG_CHE_DONull()
        {
            pm_objDR["ID_LUONG_CHE_DO"] = System.Convert.DBNull;
        }

        private void grid_to_us_gd_hop_dong(US_GD_HOP_DONG v_us_gd_hd, DataRow data)
        {
            v_us_gd_hd.dcID_NHAN_VIEN = find_id_nv_by_ma_nv(data[ExcelHopDong.MA_NHAN_VIEN].ToString());
            v_us_gd_hd.dcID_LOAI_HOP_DONG = find_id_loai_hop_dong_by_ma(data[ExcelHopDong.MA_LOAI_HOP_DONG].ToString());
            v_us_gd_hd.dcID_CHUC_VU = find_id_chuc_vu(data[ExcelHopDong.MA_CHUC_VU].ToString());
            v_us_gd_hd.dcID_DON_VI = find_id_don_vi(data[ExcelHopDong.MA_DON_VI].ToString());
            if(!is_not_null(data[ExcelHopDong.MA_CHUC_DANH_LCD]) || !is_not_null(data[ExcelHopDong.MA_MUC_LCD]))
            {
                v_us_gd_hd.SetID_LUONG_CHE_DONull();
                v_us_gd_hd.dcSO_TIEN_LCD = 0;
            }
            else
            {
                v_us_gd_hd.dcID_LUONG_CHE_DO = find_id_lcd_by_ma_lcd(data[ExcelHopDong.MA_CHUC_DANH_LCD].ToString(), data[ExcelHopDong.MA_MUC_LCD].ToString());
                v_us_gd_hd.dcSO_TIEN_LCD = find_so_tien_lcd(find_id_lcd_by_ma_lcd(data[ExcelHopDong.MA_CHUC_DANH_LCD].ToString(), data[ExcelHopDong.MA_MUC_LCD].ToString()));
            }

            v_us_gd_hd.dcID_LOAI_LAO_DONG = find_id_tu_dien_by_ma_tu_dien(data[ExcelHopDong.MA_LOAI_LAO_DONG].ToString());

            //v_us_gd_hd.strMA_HOP_DONG = data[ExcelHopDong.MA_HOP_DONG].ToString();
            v_us_gd_hd.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
            v_us_gd_hd.datNGAY_BAT_DAU = WinFormControls.FormatPostingDate(data[ExcelHopDong.NGAY_BAT_DAU].ToString());
            if(String.IsNullOrEmpty(data[ExcelHopDong.NGAY_KET_THUC].ToString()))
            {
                v_us_gd_hd.SetNGAY_KET_THUCNull();
            }
            else
            {
                v_us_gd_hd.datNGAY_KET_THUC = WinFormControls.FormatPostingDate(data[ExcelHopDong.NGAY_KET_THUC].ToString());
            }
            if(String.IsNullOrEmpty(data[ExcelHopDong.NGAY_KI_HOP_DONG].ToString()))
            {
                v_us_gd_hd.SetNGAY_KY_HOP_DONGNull();
            }
            else
            {
                v_us_gd_hd.datNGAY_KY_HOP_DONG = WinFormControls.FormatPostingDate(data[ExcelHopDong.NGAY_KI_HOP_DONG].ToString());
            }

            v_us_gd_hd.datNGAY_LAP = DateTime.Now.Date;
        }