BKI_DichVuMatDat.US.US_GD_THU_NHAP_KHAC.KiemTraXemDaInsertThuong2014Chua C# (CSharp) Method

        public bool KiemTraXemDaInsertThuong2014Chua(decimal ip_id_quy_tien, decimal ip_dc_id_nhan_vien)
        {
            CStoredProc v_sp = new CStoredProc("pr_check_before_insert_thuong_2k14");
            v_sp.addDecimalInputParam("@ip_dc_id_quy_tien", ip_id_quy_tien);
            v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            SqlParameter v_yn = v_sp.addNVarcharOutputParam("@op_yn_insert", "");
            v_sp.ExecuteCommand(this);

            return v_yn.Value.ToString() == "Y" ? false : true;//Y la chua co
        }

        private void save_data()
        {
            try
            {
                var rowCount = m_grv_main.RowCount;
                US_GD_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC();
                splashScreenManager1.ShowWaitForm();

                for(int i = 0; i < rowCount; i++)
                {
                    var dr = m_grv_main.GetDataRow(i);
                    var is_exist = v_us_gd_thu_nhap_khac.KiemTraXemDaInsertThuong2014Chua(Convert.ToDecimal(m_sle_quy_tien_thuong.EditValue), Convert.ToDecimal(dr["ID"]));
                    if(is_exist)
                    {
                        continue;
                    }
                    if(dr["HS_THUONG"].ToString() == "")
                    {
                        continue;
                    }
                    data_row_2_us(dr, ref v_us_gd_thu_nhap_khac);
                    v_us_gd_thu_nhap_khac.Insert();
                }
                //
            }
            catch(Exception)
            {
                throw;
            }
            finally
            {
                splashScreenManager1.CloseWaitForm();
            }
        }