BKI_DichVuMatDat.F152_DANH_SACH_NHAN_VIEN_EXCEL.gan_du_lieu_cho_us_dm_nhan_vien C# (CSharp) Method

        private US_DM_NHAN_VIEN gan_du_lieu_cho_us_dm_nhan_vien(DataRow dataRow)
        {
            US_DM_NHAN_VIEN v_us = new US_DM_NHAN_VIEN();
            if(m_e_form_mode == DataEntryFormMode.UpdateDataState) v_us = new US_DM_NHAN_VIEN(ExecuteFuntion.LayNhanVienID(dataRow["MA_NV"].ToString()));
            
            if (dataRow["NGAY_CAP"] != DBNull.Value || !string.IsNullOrEmpty(dataRow["NGAY_CAP"].ToString()))
                v_us.datNGAY_CAP = WinFormControls.FormatPostingDate(dataRow["NGAY_CAP"].ToString());

            if (dataRow["NGAY_CAP_THE"] != DBNull.Value || !string.IsNullOrEmpty(dataRow["NGAY_CAP_THE"].ToString()))
                v_us.datNGAY_CAP_THE = WinFormControls.FormatPostingDate(dataRow["NGAY_CAP_THE"].ToString());

            if (dataRow["NGAY_CHINH_THUC_TIEP_NHAN"] != DBNull.Value || !string.IsNullOrEmpty(dataRow["NGAY_CHINH_THUC_TIEP_NHAN"].ToString()))
                v_us.datNGAY_CHINH_THUC_TIEP_NHAN = WinFormControls.FormatPostingDate(dataRow["NGAY_CHINH_THUC_TIEP_NHAN"].ToString());

            if (dataRow["NGAY_HET_HAN_THE"] != DBNull.Value || !string.IsNullOrEmpty(dataRow["NGAY_HET_HAN_THE"].ToString()))
                v_us.datNGAY_HET_HAN_THE = WinFormControls.FormatPostingDate(dataRow["NGAY_HET_HAN_THE"].ToString());

            if (dataRow["NGAY_SINH"] != DBNull.Value || !string.IsNullOrEmpty(dataRow["NGAY_SINH"].ToString()))
                v_us.datNGAY_SINH = WinFormControls.FormatPostingDate(dataRow["NGAY_SINH"].ToString());

            if (dataRow["NGAY_TIEP_NHAN_VAO_TCT"] != DBNull.Value || !string.IsNullOrEmpty(dataRow["NGAY_TIEP_NHAN_VAO_TCT"].ToString()))
                v_us.datNGAY_TIEP_NHAN_VAO_TCT = WinFormControls.FormatPostingDate(dataRow["NGAY_TIEP_NHAN_VAO_TCT"].ToString());

            if (dataRow["NGAY_VAO_HANG_KHONG"] != DBNull.Value || !string.IsNullOrEmpty(dataRow["NGAY_VAO_HANG_KHONG"].ToString()))
                v_us.datNGAY_VAO_HANG_KHONG = Convert.ToDateTime(dataRow["NGAY_VAO_HANG_KHONG"]);

            v_us.strCHUYEN_MON = dataRow["CHUYEN_MON"].ToString();
            v_us.strDAN_TOC = dataRow["DAN_TOC"].ToString();
            v_us.strDIA_CHI_LIEN_LAC = dataRow["DIA_CHI_LIEN_LAC"].ToString();
            v_us.strDIA_CHI_TAM_TRU = dataRow["DIA_CHI_TAM_TRU"].ToString();
            v_us.strDIA_CHI_THUONG_TRU = dataRow["DIA_CHI_THUONG_TRU"].ToString();
            v_us.strEMAIL = dataRow["EMAIL"].ToString();
            //v_us.strGIOI_TINH = dataRow["GIOI_TINH"].ToString();
            if (dataRow["GIOI_TINH"].ToString().Trim().ToUpper() == "NAM")
                v_us.strGIOI_TINH = "Y";
            else v_us.strGIOI_TINH = "N";
            v_us.strHO_DEM = dataRow["HO_DEM"].ToString();
            v_us.strHON_NHAN = dataRow["HON_NHAN"].ToString();
            v_us.strMA_NV = dataRow["MA_NV"].ToString();
            v_us.strMA_SO_THUE_CA_NHAN = dataRow["MA_SO_THUE_CA_NHAN"].ToString();
            v_us.strNAM_TOT_NGHIEP = dataRow["NAM_TOT_NGHIEP"].ToString();
            v_us.strNGAN_HANG = dataRow["NGAN_HANG"].ToString();
            v_us.strNOI_CAP = dataRow["NOI_CAP"].ToString();
            v_us.strNOI_SINH = dataRow["NOI_SINH"].ToString();
            v_us.strQUE_QUAN = dataRow["QUE_QUAN"].ToString();
            v_us.strQUOC_TICH = dataRow["QUOC_TICH"].ToString();
            v_us.strSDT = dataRow["SDT"].ToString();
            v_us.strSO_CMT = dataRow["SO_CMT"].ToString();
            v_us.strSO_TAI_KHOAN = dataRow["SO_TAI_KHOAN"].ToString();
            v_us.strTEN = dataRow["TEN"].ToString();
            v_us.strTON_GIAO = dataRow["TON_GIAO"].ToString();
            v_us.strTOT_NGHIEP_TAI = dataRow["TOT_NGHIEP_TAI"].ToString();
            v_us.strTRINH_DO_VAN_HOA = find_id_cm_dm_tu_dien_by_trinh_do_van_hoa(dataRow["TRINH_DO_VAN_HOA"].ToString().Trim());
            v_us.strNGUOI_BAO_LANH = dataRow["NGUOI_BAO_LANH"].ToString();
            
            return v_us;
        }