public List<BusinessPartnerDunninTerm> GetDunninTermList(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);
BusinessPartnerAccess = new BusinessPartnerData(oAppConnData.adoConnString);
List<BusinessPartnerDunninTerm> businessPartners = BusinessPartnerAccess.GetDunninTermList();
//if (socio.CardCode.Length == 0)
// throw new BusinessException(42, "El valor enviado: " + codigoSocio + "no esta registrado como un cliente en SAP Business One");
return businessPartners;
}
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)
{
BizUtilities.ProcessBusinessException(ex);
}
catch (Exception ex)
{
Exception outEx;
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 null;
}
public List<GenericBusinessPartner> GetList(CardType cardType, string slpCode, 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);
BusinessPartnerAccess = new BusinessPartnerData(oAppConnData.adoConnString);
List<GenericBusinessPartner> businessPartners = BusinessPartnerAccess.GetList(cardType, slpCode);
return businessPartners;
}
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)
{
BizUtilities.ProcessBusinessException(ex);
}
catch (Exception ex)
{
Exception outEx;
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 null;
}
public bool Add(BusinessPartner partner, 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);
//DataConnection.Conn = DataConnection.Conn.company;
if (DataConnection.ConnectCompany(oAppConnData.dataBaseName, oAppConnData.sapUser, oAppConnData.sapUserPassword))
{
DataConnection.BeginTran();
BusinessPartnerAccess = new BusinessPartnerData(oAppConnData.adoConnString);
BusinessPartnerAccess.Add(partner, 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 + " Descripción: " + ex.Message);
throw outEx;
}
else
{
throw;
}
//return false;
}
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 + " Descripción: " + ex.Message);
throw outEx;
}
}
else
{
throw ex;
//return 0;
}
return false;
}
#endregion
return false;
}
