public static string TestSAP(string I_FECHA)
{
string json = "";
try
{
//wsSapSaldo.ZVISTA_PA_WS KK = new wsSapSaldo.ZVISTA_PA_WS();
wsSapSaldo.ZVISTA_PA_WSClient mySAP = new wsSapSaldo.ZVISTA_PA_WSClient();
//ICredentials credenciales = new NetworkCredential("prg1", "fase10");
//mySAP.Credentials = credenciales;
mySAP.ClientCredentials.UserName.UserName = "******";
mySAP.ClientCredentials.UserName.Password = "******";
wsSapSaldo.ZIB_WSRFC_PA_CREAR_TAB oParamIn = new wsSapSaldo.ZIB_WSRFC_PA_CREAR_TAB();
oParamIn.I_FECHA = I_FECHA;
wsSapSaldo.ZIB_WSRFC_PA_CREAR_TABResponse oResponse = mySAP.ZIB_WSRFC_PA_CREAR_TAB(oParamIn);
}
catch (Exception e)
{
json = e.InnerException + e.Message;
}
return(json);
}
public static string TestSAP2(string I_FECHA)
{
string json = "ok";
wsSapSaldo.ZVISTA_PA_WSClient mySAP = null;
try
{
//Manually reconfigure the binding for SAP-BasicAuth
BasicHttpBinding basicAuthBinding = new BasicHttpBinding(BasicHttpSecurityMode.TransportCredentialOnly);
basicAuthBinding.MaxReceivedMessageSize = 2147483647;
basicAuthBinding.Security.Transport.ClientCredentialType = HttpClientCredentialType.Basic;
//EndpointAddress basicAuthEndpoint = new EndpointAddress("http://vmsapibd.intranet.ibermatica:8000/sap/bc/srt/wsdl/flv_10002A111AD1/bndg_url/sap/bc/srt/rfc/sap/zvista_pa_ws/111/zvista_pa_ws/zb_vista_pa_ws?sap-client=111");
//EndpointAddress basicAuthEndpoint = new EndpointAddress("http://vmsapibd.intranet.ibermatica:8000/sap/bc/srt/wsdl/flv_10002A111AD1/bndg_url/sap/bc/srt/rfc/sap/zvista_pa_ws/111/zvista_pa_ws/zb_vista_pa_ws");
EndpointAddress basicAuthEndpoint = new EndpointAddress("http://VMSAPIBD.intranet.ibermatica:8000/sap/bc/srt/rfc/sap/zvista_pa_ws/111/zvista_pa_ws/zb_vista_pa_ws");
mySAP = new wsSapSaldo.ZVISTA_PA_WSClient(basicAuthBinding, basicAuthEndpoint);
mySAP.ClientCredentials.UserName.UserName = "******";
mySAP.ClientCredentials.UserName.Password = "******";
wsSapSaldo.ZIB_WSRFC_PA_CREAR_TAB oParamIn = new wsSapSaldo.ZIB_WSRFC_PA_CREAR_TAB();
wsSapSaldo.ZIB_WSRFC_PA_CREAR_TABResponse oResponse = new wsSapSaldo.ZIB_WSRFC_PA_CREAR_TABResponse();
oParamIn.I_FECHA = I_FECHA;
wsSapSaldo.ZVISTA_PA_SUPER oCobro = new wsSapSaldo.ZVISTA_PA_SUPER();
//wsSapSaldo.ZVISTA_PA_SUPER[] TI_ZVISTA_PA = { };
wsSapSaldo.ZVISTA_PA_SUPER[] TI_ZVISTA_PA = { oCobro };
oParamIn.TI_ZVISTA_PA = TI_ZVISTA_PA;
oResponse = mySAP.ZIB_WSRFC_PA_CREAR_TAB(oParamIn);
TI_ZVISTA_PA = oResponse.TI_ZVISTA_PA;
//object oResponse = mySAP.ZIB_WSRFC_PA_CREAR_TAB(oParamIn);
}
catch (Exception e)
{
json = e.InnerException + e.Message;
}
finally
{
mySAP.Close();
}
return(json);
}
public static void cargaSaldos(string fecha)
{
string sError = "";
BLL.SALDOSSAP bSaldo = new BLL.SALDOSSAP();
wsSapSaldo.ZVISTA_PA_WSClient mySAP = null;
wsSapSaldo.ZVISTA_PA_SUPER oCobro = new wsSapSaldo.ZVISTA_PA_SUPER();
wsSapSaldo.ZVISTA_PA_SUPER[] TI_ZVISTA_PA = { oCobro };
try
{
#region SERVICIO WEB
//Convierto la fecha a formato AAAA-MM-DD
string sFecha = fecha.Substring(6, 4) + "-" + fecha.Substring(3, 2) + "-" + fecha.Substring(0, 2);
//sFecha = "2005-12-31";
BasicHttpBinding basicAuthBinding = new BasicHttpBinding(BasicHttpSecurityMode.TransportCredentialOnly);
basicAuthBinding.OpenTimeout = new TimeSpan(0, 3, 0);
basicAuthBinding.CloseTimeout = new TimeSpan(0, 3, 0);
basicAuthBinding.ReceiveTimeout = new TimeSpan(0, 3, 0);
basicAuthBinding.SendTimeout = new TimeSpan(0, 3, 0);
basicAuthBinding.MaxReceivedMessageSize = 2147483647;
basicAuthBinding.Security.Transport.ClientCredentialType = HttpClientCredentialType.Basic;
EndpointAddress basicAuthEndpoint = new EndpointAddress(System.Configuration.ConfigurationManager.AppSettings["wsSapSaldo"]);
mySAP = new wsSapSaldo.ZVISTA_PA_WSClient(basicAuthBinding, basicAuthEndpoint);
/* mySAP.ClientCredentials.UserName.UserName = "******";
* mySAP.ClientCredentials.UserName.Password = "******";*/
mySAP.ClientCredentials.UserName.UserName = "******";
mySAP.ClientCredentials.UserName.Password = "******";
wsSapSaldo.ZIB_WSRFC_PA_CREAR_TAB oParamIn = new wsSapSaldo.ZIB_WSRFC_PA_CREAR_TAB();
wsSapSaldo.ZIB_WSRFC_PA_CREAR_TABResponse oResponse = new wsSapSaldo.ZIB_WSRFC_PA_CREAR_TABResponse();
oParamIn.I_FECHA = sFecha;
oParamIn.TI_ZVISTA_PA = TI_ZVISTA_PA;
try
{
oResponse = mySAP.ZIB_WSRFC_PA_CREAR_TAB(oParamIn);
TI_ZVISTA_PA = oResponse.TI_ZVISTA_PA;
}
catch (Exception e)
{
sError = e.Message + " " + e.InnerException.ToString();
}
finally
{
mySAP.Close();
}
#endregion
if (sError == "")
{
#region Inserto los elementos del catálogo en la tabla T297_SALDOSAP
foreach (wsSapSaldo.ZVISTA_PA_SUPER elem in TI_ZVISTA_PA)
{
Models.SALDOSSAP mSaldo = new Models.SALDOSSAP();
mSaldo.AUGBL = elem.AUGBL;
mSaldo.AUGDT = elem.AUGDT.Replace("-", "");
mSaldo.AUGGJ = elem.AUGGJ;
mSaldo.BELNR = elem.BELNR;
mSaldo.BUDAT = elem.BUDAT.Replace("-", "");;
mSaldo.BUKRS = elem.BUKRS;
mSaldo.BUSAB = elem.BUSAB;
mSaldo.BUZEI = elem.BUZEI;
mSaldo.DMBT1 = elem.DMBT1;
mSaldo.DMBT2 = elem.DMBT2;
mSaldo.DMBT3 = elem.DMBT3;
mSaldo.DMBTR = elem.DMBTR;
mSaldo.FKDAT = elem.FKDAT.Replace("-", "");
mSaldo.GJAHR = elem.GJAHR;
mSaldo.HKONT = elem.HKONT;
mSaldo.KUNNR = elem.KUNNR;
mSaldo.LIFNR = elem.LIFNR;
mSaldo.MANDT = elem.MANDT;
mSaldo.MANSP = elem.MANSP;
mSaldo.MWSK1 = elem.MWSK1;
mSaldo.MWSK2 = elem.MWSK2;
mSaldo.MWSK3 = elem.MWSK3;
mSaldo.MWSKZ = elem.MWSKZ;
mSaldo.PARVW = elem.PARVW;
mSaldo.POSNR = elem.POSNR;
mSaldo.REBZG = elem.REBZG;
mSaldo.SGTXT = elem.SGTXT;
mSaldo.SHKZG = elem.SHKZG;
mSaldo.UMSKS = elem.UMSKS;
mSaldo.UMSKZ = elem.UMSKZ;
mSaldo.VBELN = elem.VBELN;
mSaldo.XBLNR = elem.XBLNR;
mSaldo.ZBD1T = elem.ZBD1T;
mSaldo.ZBD2T = elem.ZBD2T;
mSaldo.ZBD3T = elem.ZBD3T;
mSaldo.ZFBDT = elem.ZFBDT.Replace("-", "");
mSaldo.ZLSCH = elem.ZLSCH;
mSaldo.ZTERM = elem.ZTERM;
mSaldo.ZUONR = elem.ZUONR;
mSaldo.ZVENC = elem.ZVENC.Replace("-", "");
bSaldo.Insert(mSaldo);
}
#endregion
}
else
{
throw new Exception("Error en la llamada al servicio SAP: " + sError);
}
}
catch (Exception ex)
{
if (bSaldo != null)
{
bSaldo.Dispose();
}
throw ex;
}
finally
{
bSaldo.Dispose();
}
}
