/// <summary> /// Obtiene la información de un giro dado a partir de su ExternalId (ID Multipay 472) /// </summary> /// <param name="sessionId">Session ID que será escrito en los logs</param> /// <param name="id">ID Multipay 472 del giro</param> /// <param name="returnCode">Codigo de error en caso de que algo falle (-1 = OK, >-1 = Error)</param> /// <param name="connection">Objeto de conexión a base de datos</param> /// <returns>Un objeto <c>DwhModel.Giro</c> que contiene la información del giro</returns> private DwhModel.GiroUltimaTransaccion GetInfoGiroPorExternalId( string sessionId, long id, string pin, out ErrorMessagesMnemonics returnCode, SqlConnection connection = null) { string methodName = string.Format("{0}", System.Reflection.MethodBase.GetCurrentMethod().Name); returnCode = ErrorMessagesMnemonics.None; DwhModel.GiroUltimaTransaccion ret = null; try { this.ProviderLogger.InfoLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Ejecutando query ...")); Dictionary <string, object> queryParams = new Dictionary <string, object>() { { "@IdGiro", id.ToString() } }; if (connection == null) { using (connection = Movilway.API.Utils.Database.GetCash472DbConnection()) { connection.Open(); ret = Movilway.API.Utils.Dwh <DwhModel.GiroUltimaTransaccion> .ExecuteSingle( connection, Queries.Cash.GetInfoGiroPorExternalId, queryParams, null); } } else { ret = Movilway.API.Utils.Dwh <DwhModel.GiroUltimaTransaccion> .ExecuteSingle( connection, Queries.Cash.GetInfoGiroPorExternalId, queryParams, null); } this.ProviderLogger.InfoLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Query ejecutado")); } catch (Exception ex) { this.ProviderLogger.ExceptionLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Error ejecutando query") .Exception(ex)); returnCode = ErrorMessagesMnemonics.InternalDatabaseError; ret = new DwhModel.GiroUltimaTransaccion(); } return(ret); }
/// <summary> /// Emite un nuevo giro a partir de llamados directos a los WS de Movilway - Kinacu /// </summary> /// <param name="request">Objeto que contiene todos los datos de autenticacion del usuario e información del giro</param> /// <returns>Respuesta de la cotización</returns> public EmitirResponse Emitir(EmitirRequest request) { string methodName = string.Format("{0}", System.Reflection.MethodBase.GetCurrentMethod().Name); this.LogRequest(request); EmitirResponse response = new EmitirResponse(); string sessionId = this.GetSessionId(request, response, out this.errorMessage); if (this.errorMessage != ErrorMessagesMnemonics.None) { this.LogResponse(response); return(response); } if (!request.IsValidRequest()) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.InvalidRequiredFields); this.LogResponse(response); return(response); } DwhModel.Cliente infoEmisor = this.GetInfoCliente(sessionId, request.Emisor.TipoIdentificacion, request.Emisor.NumeroIdentificacion, out this.errorMessage); DwhModel.Cliente infoReceptor = this.GetInfoCliente(sessionId, request.Receptor.TipoIdentificacion, request.Receptor.NumeroIdentificacion, out this.errorMessage); DwhModel.Agencia agencia = this.GetInfoAgencia(sessionId, request.AuthenticationData.Username); if (agencia == null) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.UnableToFindAgentInLocalDatabase); this.LogResponse(response); return(response); } if (infoEmisor == null || infoReceptor == null) { if (infoEmisor == null && infoReceptor == null) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.UnableToFindIssuingAndReceiverUserInLocalDatabase); } else if (infoEmisor == null) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.UnableToFindIssuingUserInLocalDatabase); } else { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.UnableToFindReceiverUserInLocalDatabase); } this.LogResponse(response); return(response); } if (infoEmisor.Id == infoReceptor.Id) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.IssuingUserAndReceiverUserAreTheSame); this.LogResponse(response); return(response); } request.CiudadPdv = agencia.Ciudad; int id = this.InsertGiro(sessionId, request, infoEmisor, infoReceptor, agencia, out this.errorMessage); if (this.errorMessage != ErrorMessagesMnemonics.None || id == 0) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.InternalDatabaseErrorInsertingOrder); this.LogResponse(response); return(response); } Exception ex = null; DataContract.TopUpResponseBody topup = null; if (this.errorMessage == ErrorMessagesMnemonics.None) { topup = this.EmitirPaso2(request, id, sessionId, out ex); } int topupResponseCode = topup != null && topup.ResponseCode.HasValue ? topup.ResponseCode.Value : -1; if (this.errorMessage == ErrorMessagesMnemonics.None && topupResponseCode == 0) { response.ResponseCode = 0; DwhModel.GiroUltimaTransaccion infoGiro = this.GetInfoGiro(sessionId, id, out this.errorMessage); response.Pin = Multipay472TripleDes.Decrypt(this.multipayTripleDesKey, infoGiro.Pin); response.CodigoTransaccion = infoGiro.CodigoTransaccion ?? " "; response.NumeroFactura = infoGiro.NumeroFactura; response.CodigoAutorizacion = infoGiro.CodigoAutorizacion472; response.Fecha = infoGiro.Fecha.DateTime; response.ResponseMessage = topup.ResponseMessage; response.Id = infoGiro.Id; response.ExternalId = infoGiro.ExternalId; if (this.smssEnabled) { // Envios SMSs string message = string.Format( "Se emitio un giro por {0} con PIN: {1}. Servicio prestado por Movilway S.A.S", this.FormatMoney(request.ValorAEntregar), response.Pin); SmsApi.SmsApiSoapClient smsapi = new SmsApi.SmsApiSoapClient(); string phonePayer = string.Concat("57", infoEmisor.Telefono.ToString()); string phonePayee = string.Concat("57", infoReceptor.Telefono.ToString()); try { smsapi.SendSms(new SmsApi.SendSmsRequest() { To = phonePayer, Message = message }); if (phonePayer != phonePayee) { smsapi.SendSms(new SmsApi.SendSmsRequest() { To = phonePayee, Message = message }); } } catch (Exception exs) { this.ProviderLogger.ExceptionLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Error envíando SMSs") .Exception(exs)); } } } else { string error = string.Empty; //if (transfer != null && transferResponseCode != 0) //{ // error = "Error en llamado a Transfer"; // response.ResponseCode = transfer.ResponseCode; // response.ResponseMessage = transfer.ResponseMessage; //} //else if (topup != null && topupResponseCode != 0) { error = "Error en llamado a TopUp"; response.ResponseCode = topup.ResponseCode; response.ResponseMessage = topup.ResponseMessage; } else { error = "Error API/Otros"; response.ResponseCode = (int)this.errorMessage; response.ResponseMessage = string.Concat(this.errorMessage.ToDescription(), ex != null ? string.Concat(" => ", ex.Message) : string.Empty); } this.AnularGiro(sessionId, id, error, response.ResponseMessage, out this.errorMessage); this.LogResponse(response); return(response); } this.LogResponse(response); return(response); }
/// <summary> /// Inserta en base de datos la información de un pago /// </summary> /// <param name="sessionId">Session ID que será escrito en los logs</param> /// <param name="request">Petición original</param> /// <param name="giro">Giro original</param> /// <param name="cliente">Información del cliente</param> /// <param name="returnCode">Codigo de error en caso de que algo falle (-1 = OK, >-1 = Error)</param> /// <param name="connection">Objeto de conexión a base de datos</param> /// <returns>Un <c>int</c> que contiene el ID del pago creado, cero en caso de falla</returns> private int InsertPago( string sessionId, PagoRequest request, DwhModel.GiroUltimaTransaccion giro, DwhModel.Cliente cliente, out ErrorMessagesMnemonics returnCode, SqlConnection connection = null) { string methodName = string.Format("{0}", System.Reflection.MethodBase.GetCurrentMethod().Name); returnCode = ErrorMessagesMnemonics.None; int ret = 0; try { this.ProviderLogger.InfoLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Ejecutando query ...")); bool exists = giro.Id != 0; Dictionary <string, object> queryParams = new Dictionary <string, object>() { { "@GiroId", giro.Id > 0 ? (object)giro.Id : DBNull.Value }, { "@ExternalId", request.Id }, { "@EmisorId", giro.EmisorId > 0 ? (object)giro.EmisorId : DBNull.Value }, { "@ReceptorId", cliente.Id }, { "@Pdv", request.Pdv }, { "@CiudadPdv", request.CiudadPdv }, { "@TotalRecibido", request.ValorRecibidoTotal }, { "@TotalAEntregar", request.Valor }, { "@Flete", request.ValorFlete }, { "@IncluyeFlete", request.IncluyeFlete }, { "@ValorPago", request.Valor } }; if (connection == null) { using (connection = Movilway.API.Utils.Database.GetCash472DbConnection()) { connection.Open(); ret = (int)Movilway.API.Utils.Dwh <int> .ExecuteScalar( connection, Queries.Cash.InsertPago, queryParams, null); } } else { ret = (int)Movilway.API.Utils.Dwh <int> .ExecuteScalar( connection, Queries.Cash.InsertPago, queryParams, null); } this.ProviderLogger.InfoLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Query ejecutado")); } catch (Exception ex) { this.ProviderLogger.ExceptionLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Error ejecutando query") .Exception(ex)); returnCode = ErrorMessagesMnemonics.InternalDatabaseError; ret = 0; } return(ret); }
/// <summary> /// Realiza el proceso de pago de un giro /// </summary> /// <param name="request">Objeto que contiene todos los datos de autenticacion del usuario e información del pago</param> /// <returns>Respuesta del pago</returns> public PagoResponse Pago(PagoRequest request) { string methodName = string.Format("{0}", System.Reflection.MethodBase.GetCurrentMethod().Name); this.LogRequest(request); PagoResponse response = new PagoResponse(); string sessionId = this.GetSessionId(request, response, out this.errorMessage); if (this.errorMessage != ErrorMessagesMnemonics.None) { this.LogResponse(response); return(response); } if (!request.IsValidRequest()) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.InvalidRequiredFields); this.LogResponse(response); return(response); } DwhModel.Cliente infoCliente = this.GetInfoCliente(sessionId, request.TipoIdentificacion, request.NumeroIdentificacion, out this.errorMessage); if (this.errorMessage != ErrorMessagesMnemonics.None) { this.SetResponseErrorCode(response, this.errorMessage); this.LogResponse(response); return(response); } DwhModel.Agencia agencia = this.GetInfoAgencia(sessionId, request.AuthenticationData.Username); if (agencia == null) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.UnableToFindAgentInLocalDatabase); this.LogResponse(response); return(response); } request.CiudadPdv = Convert.ToInt64(agencia.Ciudad); DwhModel.GiroUltimaTransaccion infoGiro = this.GetInfoGiroPorExternalId(sessionId, request.Id, request.Pin, out this.errorMessage); int id = this.InsertPago(sessionId, request, infoGiro, infoCliente, out this.errorMessage); if (this.errorMessage != ErrorMessagesMnemonics.None || id == 0) { this.SetResponseErrorCode(response, ErrorMessagesMnemonics.InternalDatabaseErrorInsertingPayment); this.LogResponse(response); return(response); } Exception ex = null; string error = string.Empty; // Quitar el valor de la Agencia que va a efectuar el pago con valor facial -1 DataContract.TopUpResponseBody topup = this.PagoPaso1(request, id, sessionId, out ex); int topupResponseCode = topup != null && topup.ResponseCode.HasValue ? topup.ResponseCode.Value : -1; if (this.errorMessage == ErrorMessagesMnemonics.None && topupResponseCode == 0) { response.ResponseCode = 0; DwhModel.Pago infoPago = this.GetInfoPago(sessionId, id, out this.errorMessage); response.NumeroFactura = infoPago.NumeroFactura; response.CodigoTransaccion = !string.IsNullOrEmpty(infoPago.CodigoTransaccion) ? infoPago.CodigoTransaccion : string.Empty; response.CodigoAutorizacion = infoPago.CodigoAutorizacion; response.NumeroComprobantePago = infoPago.NumeroComprobantePago; response.NumeroReferencia = infoPago.NumeroReferencia; response.Valor = infoPago.ValorPagoRespuesta; response.Fecha = infoPago.FechaPago != null && infoPago.FechaPago.HasValue ? infoPago.FechaPago.Value : DateTime.MinValue; if (this.smssEnabled) { // Envios SMSs string message = string.Format( "Se pago un giro por {0} correspondiente al PIN: {1}. Servicio prestado por Movilway S.A.S", this.FormatMoney(request.Valor), request.Pin); SmsApi.SmsApiSoapClient smsapi = new SmsApi.SmsApiSoapClient(); try { smsapi.SendSms(new SmsApi.SendSmsRequest() { To = string.Concat("57", infoCliente.Telefono.ToString()), Message = message }); } catch (Exception exs) { this.ProviderLogger.ExceptionLow(() => TagValue.New() .MethodName(methodName) .Message("[" + sessionId + "] " + "Error envíando SMSs") .Exception(exs)); } } } else { if (topup != null && topupResponseCode != 0) { error = "Error en llamado a TopUp"; response.ResponseCode = topup.ResponseCode; response.ResponseMessage = topup.ResponseMessage; } else { error = "Error en llamado a TopUp"; response.ResponseCode = (int)this.errorMessage; response.ResponseMessage = string.Concat(this.errorMessage.ToDescription(), ex != null ? string.Concat(" => ", ex.Message) : string.Empty); } } this.LogResponse(response); return(response); }