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));
}
}
