public bool AddBusinessPartnerWithholdingTax(BusinessPartnerWithholdingTax withholdingTax, AppConnData oAppConnData) { return bizBusinessPartner.AddBusinessPartnerWithholdingTax(withholdingTax, oAppConnData); }
public List<BusinessPartnerWithholdingTax> GetBusinessPartnerWithholdingTaxList(string cardCode) { StringBuilder oSQL = new StringBuilder(); oSQL.Append("SELECT wtCode "); oSQL.Append("FROM CRD4 T0 "); oSQL.Append(string.Format("WHERE cardCode = '{0}'", cardCode)); DbCommand myCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); List<BusinessPartnerWithholdingTax> withholdingTaxes = new List<BusinessPartnerWithholdingTax>(); using (this.reader = this.dataBase.ExecuteReader(myCommand)) { while (this.reader.Read()) { BusinessPartnerWithholdingTax withholdingTax = new BusinessPartnerWithholdingTax(); withholdingTax.wtCode = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); withholdingTax.cardCode = cardCode; withholdingTaxes.Add(withholdingTax); } } return withholdingTaxes; }
public void AddBusinessPartnerWithholdingTax(BusinessPartnerWithholdingTax withholdingTax, AppConnData oAppConnData) { try { facade = new BizFacade(BusinessClass.BizBusinessPartner); facade.AddBusinessPartnerWithholdingTax(withholdingTax, oAppConnData); } catch (Exception ex) { DataAccessFault detalleError = new DataAccessFault(); foreach (string valores in ex.Data.Keys) { switch (valores) { case "1": detalleError.ErrorID = ex.Data[valores].ToString(); break; case "2": detalleError.ErrorSAP = ex.Data[valores].ToString(); break; case "3": detalleError.Description = ex.Data[valores].ToString(); break; default: detalleError.ErrorID = ex.Data[valores].ToString(); break; } } throw new FaultException<DataAccessFault>(detalleError, "Error al Procesar la solicitud"); } }
public void AddBusinessPartnerWithholdingTax(BusinessPartnerWithholdingTax withholdingTax, SAPConnection sapConn) { List<BusinessPartnerWithholdingTax> bpWithholdingTaxes = GetBusinessPartnerWithholdingTaxList(withholdingTax.cardCode); BusinessPartners bp; //= new BusinessPartners(); bp = (BusinessPartners)sapConn.company.GetBusinessObject(BoObjectTypes.oBusinessPartners); bp.GetByKey(withholdingTax.cardCode); int wtQty = bpWithholdingTaxes.Count(); bp.BPWithholdingTax.Add(); bp.BPWithholdingTax.SetCurrentLine(wtQty); bp.BPWithholdingTax.WTCode = withholdingTax.wtCode; bp.Update(); }
public bool AddBusinessPartnerWithholdingTax(BusinessPartnerWithholdingTax withholdingTax, AppConnData oAppConnData) { try { if (!BizUtilities.ValidateServiceConnection(oAppConnData)) throw new BusinessException(15, "Nombre de Usuario o Contraseña incorrecta para el Servicio"); oAppConnData = BizUtilities.GetDataConnection(oAppConnData); string licenseServer = Cryptography.Decrypt(HexSerialization.HexToString(ConfigurationManager.AppSettings["licenseServer"])); string dbServer = Cryptography.Decrypt(HexSerialization.HexToString(ConfigurationManager.AppSettings["dbServer"])); string dbUser = Cryptography.Decrypt(HexSerialization.HexToString(ConfigurationManager.AppSettings["dbUser"])); string dbUserPassword = Cryptography.Decrypt(HexSerialization.HexToString(ConfigurationManager.AppSettings["dbUserPassword"])); string serverType = ConfigurationManager.AppSettings["serverType"]; DataConnection = new SAPConnectionData(oAppConnData.dataBaseName, licenseServer, dbServer, oAppConnData.sapUser, oAppConnData.sapUserPassword, dbUser, dbUserPassword, serverType); if (DataConnection.ConnectCompany(oAppConnData.dataBaseName, oAppConnData.sapUser, oAppConnData.sapUserPassword)) { DataConnection.BeginTran(); BusinessPartnerAccess = new BusinessPartnerData(oAppConnData.adoConnString); BusinessPartnerAccess.AddBusinessPartnerWithholdingTax(withholdingTax, DataConnection.Conn); DataConnection.EndTranAndRelease(BoWfTransOpt.wf_Commit); return true; } } #region Catch catch (SAPException ex) { DataConnection.EndTranAndRelease(SAPbobsCOM.BoWfTransOpt.wf_RollBack); BizUtilities.ProcessSapException(ex, "Gestión de Pagos"); return false; } catch (COMException ex) { DataConnection.EndTranAndRelease(SAPbobsCOM.BoWfTransOpt.wf_RollBack); Exception outEx; if (ExceptionPolicy.HandleException(ex, "Politica_Excepcion_Com", out outEx)) { outEx.Data.Add("1", "3"); outEx.Data.Add("2", "NA"); outEx.Data.Add("3", outEx.Message); throw outEx; } else { throw; } } catch (DbException ex) { Exception outEx; if (ExceptionPolicy.HandleException(ex, "Politica_SQLServer", out outEx)) { outEx.Data.Add("1", "14"); outEx.Data.Add("2", "NA"); //outEx.Data.Add("3", outEx.Message); outEx.Data.Add("3", outEx.Message + " Descripción: " + ex.Message); throw outEx; } else { throw ex; } } catch (BusinessException ex) { ex.Data.Add("1", ex.ErrorId); ex.Data.Add("2", "NA"); ex.Data.Add("3", ex.Message); throw ex; } catch (Exception ex) { DataConnection.EndTranAndRelease(SAPbobsCOM.BoWfTransOpt.wf_RollBack); Exception outEx; if (ex.Data["1"] == null) { if (ExceptionPolicy.HandleException(ex, "Politica_ExcepcionGenerica", out outEx)) { outEx.Data.Add("1", "3"); outEx.Data.Add("2", "NA"); outEx.Data.Add("3", outEx.Message); throw outEx; } } else { throw ex; //return 0; } return false; } #endregion return false; }