BKI_DichVuMatDat.US.US_GD_CONG_TAC.KiemTraNhanVienCoCongTacChua C# (CSharp) Method

KiemTraNhanVienCoCongTacChua() public method

public KiemTraNhanVienCoCongTacChua ( decimal ip_dc_id_nhan_vien, decimal ip_dc_id_don_vi ) : bool
ip_dc_id_nhan_vien decimal
ip_dc_id_don_vi decimal
return bool
        public bool KiemTraNhanVienCoCongTacChua(decimal ip_dc_id_nhan_vien, decimal ip_dc_id_don_vi)
        {
            CStoredProc v_cstore = new CStoredProc("pr_NS_nhan_vien_thuoc_phong_ban_Check");
            v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            v_cstore.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
            SqlParameter v_para = v_cstore.addNVarcharOutputParam("@op_str_yn", "");
            v_cstore.ExecuteCommand(this);

            return v_para.Value.ToString() == "Y" ? true : false;
        }

Usage Example

 private void save_for_chuyen_cong_tac(US_GD_CONG_TAC ip_us_ct_hien_tai)
 {
     try
     {
         if(ip_us_ct_hien_tai.KiemTraNhanVienCoCongTacChua(ip_us_ct_hien_tai.dcID_NHAN_VIEN, ip_us_ct_hien_tai.dcID_DON_VI))
         {
             XtraMessageBox.Show("Nhân viên đang làm việc ở đơn vị này rồi!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
             return;
         }
         ip_us_ct_hien_tai.BeginTransaction();
         ip_us_ct_hien_tai.CapNhatHetHieuLucCongTacChinhThucHoacLamThoi(ip_us_ct_hien_tai.dcID_NHAN_VIEN, ip_us_ct_hien_tai.datNGAY_BAT_DAU.AddDays(-1));
         ip_us_ct_hien_tai.Insert();
         ip_us_ct_hien_tai.CommitTransaction();
         CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_LUU_DU_LIEU_THANH_CONG);
         Close();
     }
     catch(Exception)
     {
         if(ip_us_ct_hien_tai.is_having_transaction())
         {
             ip_us_ct_hien_tai.Rollback();
         }
         throw;
     }
 }