public Boolean GenerarComprobanteReserva(EntComprobantepagoreserva fact) { SqlCommand cmd = null; Boolean generar; try { SqlConnection cn = Conexion.Instancia.Conectar(); cmd = new SqlCommand("SP_GenerarCompReserva", cn) { CommandType = System.Data.CommandType.StoredProcedure, }; cmd.Parameters.AddWithValue("@prmintReservaID", fact.Reserva.ReservaID); cmd.Parameters.AddWithValue("@prmdoubleMonto", fact.Monto); cmd.Parameters.AddWithValue("@prmintserie", fact.NumeroSerie); cn.Open(); int result = cmd.ExecuteNonQuery(); generar = result > 0 ? true : false; } catch (SqlException err) { throw err; } finally { cmd.Connection.Close(); } return(generar); }
public Boolean GenerarComprobanteReserva(EntComprobantepagoreserva fact) { try { return(DatComprobanteDePagoReserva.Instancia.GenerarComprobanteReserva(fact)); } catch (Exception e) { throw e; } }
public List <EntComprobantepagoreserva> IngresosReserva() { SqlCommand cmd = null; List <EntComprobantepagoreserva> lista = new List <EntComprobantepagoreserva>(); try { SqlConnection cn = Conexion.Instancia.Conectar(); cmd = new SqlCommand("SP_IngresosReserva", cn) { CommandType = System.Data.CommandType.StoredProcedure }; cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { EntComprobantepagoreserva cr = new EntComprobantepagoreserva { Fechadeemision = Convert.ToString(dr["Fechadeemision"]), Monto = Convert.ToDouble(dr["Cantidad"]) }; lista.Add(cr); } } catch (SqlException e) { throw e; } finally { cmd.Connection.Close(); } return(lista); }
public ActionResult Capture(string authorizationId) { verificarSesion(); var viewData = new ConfirmedViewData(); try { var accessToken = new OAuthTokenCredential(ConfigManager.Instance.GetProperties()["clientId"], ConfigManager.Instance.GetProperties()["clientSecret"]).GetAccessToken(); var apiContext = new APIContext(accessToken); var authorization = Authorization.Get(apiContext, authorizationId); if (authorization != null) { var total = Convert.ToDouble(authorization.amount.total); //Sacando informacion de la reseva var reservaID = ((EntCuenta)Session["cuenta"]).ReservaID; var monto = ((EntCuenta)Session["cuenta"]).Monto; var capture = authorization.Capture(apiContext, new Capture { is_final_capture = true, amount = new Amount { currency = "USD", total = total.ToString("f2") }, }); viewData.JsonResponse = JObject.Parse(capture.ConvertToJson()).ToString(Formatting.Indented); //Generando comprobante de pago Random rdn = new Random(); EntReserva reserva = new EntReserva { ReservaID = reservaID }; EntComprobantepagoreserva fact = new EntComprobantepagoreserva { Monto = monto, NumeroSerie = rdn.Next(10001, int.MaxValue), Reserva = reserva }; Boolean generarCPReserva = LogComprobanteReserva.Instancia.GenerarComprobanteReserva(fact); //Limpiamos la información de la reserva ((EntCuenta)Session["cuenta"]).ReservaID = 0; ((EntCuenta)Session["cuenta"]).Monto = 0; viewData.ReservaID = fact.Reserva.ReservaID; viewData.Monto = fact.Monto; viewData.Serie = fact.NumeroSerie; return(View("Success", viewData)); } viewData.ErrorMessage = "Could not find previous authorization."; return(View("Error", viewData)); } catch (PayPalException ex) { viewData.ErrorMessage = ex.Message; return(View("Error", viewData)); } }