download PDF from web service using json

download PDF from web service using json

Hi, I have a WCF service that creates a report in PDF, it works, since I have a C# app that use it, however I need to use the same method to obtain the same document in my jquery mobile application. This is the method that generates the document:

  2.         public void exportToPDF()
  3.         {
  4.             SqlConnection conn = DbManagement.getConnection();
  5.             conn.Open();
  6.             SqlCommand objCmd = null;
  7.             String sql = "";
  8.             String fileName = "";

  10.             DataSet ds1 = new DataSet();
  11.             SqlDataAdapter da;
  12.             DataSet1 ds = new DataSet1();
  13.             CrystalReport1 cr1 = new CrystalReport1();

  15.             sql = "SELECT productId " +
  16.                     "FROM isProductReport " +
  17.                    "WHERE userId = 'dev1'";
  18.             objCmd = new SqlCommand(sql, conn);
  19.             objCmd.ExecuteNonQuery();

  21.             da = new SqlDataAdapter(objCmd);

  23.             ds1.EnforceConstraints = false;
  24.             da.Fill(ds1, "isProductReport");

  26.             cr1.SetDataSource(ds1);

  28.             fileName = "reporte de inventario " + DateTime.Now.ToString("dd/MM/yyyy hmmtt");
  29.             cr1.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, true, fileName);
  30.         }

And this is the code that I normally use to consume web services:

  2. function exportToPDF()
  3. {
  4. var userIdValue = $("#username").val();
  6. $.ajax({
  7. type: "POST",
  8. contentType: "application/json",
  9. url: "http://localhost/Service1.svc/exportToPDF",
  10. data: JSON.stringify({ userId: userIdValue }),
  11. dataType: "json",
  12. success: function (data){
  13. },
  14. error: function(result){
  15. alert(result.status + ' ' + result.StatusText);
  16. }
  17. });
  18. }

The method does not return anything since it's void, I'm sure that for this kind of operation, what I'm doing is not correct, but I don't know how to solve this issue, I'm able to read and retrieve any value from the database, but this is completely different. I would appreciate your help, thanks!