User-544325736 posted
Hello All,
I currently get a list of data selected by checkboxes.
I'm turning the records into a byte[] and inserting it into a .rdlc report.
I currently have it so my program creates a seperate PDF for each record this is done.
When I am in debug mode and I watch it, it creates each file it takes the correct byte[] for each record and inserts it into the rdlc document.
When I open the file though each file has the same content, each file should have its own records content.
Each should have its own content because it takes the correct byte[] but they are all the same.
Here is what I have
JavaScript and Ajax [Gets selected checkboxes and sents them to the controller]
$('#btnGetChecksz').on('click', function () {
var arrChkBoxes = [];
var arrSelectedQIDs = [];
// Turn all selected checkbox T/F values into QuoteIDs
$("input:checked").each(function (index, value) {
arrChkBoxes.push($(value).val());
});
// Push all QuoteIDs into new array
$.each(arrChkBoxes, function (key, value) {
if (IsPositiveInteger(value)) {
arrSelectedQIDs.push(value);
}
});
$.ajax({
type: "GET",
url: "/Service/ExportReport/",
contentType: "application/json; charset=utf-8",
traditional: true,
data: { "quoteIDs": arrSelectedQIDs },
success: function (data) {
//alert("success");
window.location = '/Service/DownloadReportPDF?mimeType=' + data;
},
error: function (request, status, error) {
alert("error " + request.responseText);
}
});
});
C# MVC Controller
(Turns the IDs into a list of records and turns the list into each byte[] for rdlc report)
public ActionResult ExportReport(int[] quoteIDs)
{
List<byte[]> lstBytes = new List<byte[]>();
List<string> lstFileNames = new List<string>();
List<ServiceQuote> lstQuotes = new List<ServiceQuote>();
//var tstparam = '';
// servicequote same fields as 'Service_Fields'
//for(int i=0; i<quoteIDs.Length-1; i++)
//{ var quote = context.ServiceQuotes.Where(x => x.QuoteID == quoteIDs[i]).fi }
if (quoteIDs != null)
{
string command = "PDF";
string reportType = command;
string mimeType = "", encoding = "", fileNameExtension = "";
foreach (var qid in quoteIDs)
{
var quote = context.ServiceQuotes.Where(x => x.QuoteID == qid).FirstOrDefault();
lstQuotes.Add(quote);
LocalReport localReport = new LocalReport()
{
ReportPath = Server.MapPath("~/ReportForms/VirtualService3.rdlc")
};
ReportDataSource reportDataSource = new ReportDataSource("Service_Fields", lstQuotes);
localReport.DataSources.Add(reportDataSource);
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>" + reportType + "</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0in</MarginTop>" +
" <MarginLeft>0in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes = localReport.Render(reportType, deviceInfo, out mimeType, out encoding,
out fileNameExtension, out streams, out warnings);
lstBytes.Add(renderedBytes);
lstFileNames.Add(qid.ToString());
//lstFileNames.Add(qid.ToString() + "." + fileNameExtension);
//TempData["localR"] = localReport;
}
TempData["Data"] = lstBytes;
TempData["File"] = lstFileNames;
//TempData["localR"] = LocalReport
//return new JsonResult() { Data = new { MimeType = mimeType } };
return Json(mimeType, JsonRequestBehavior.AllowGet);
//return new JsonResult(JsonRequestBehavior.AllowGet) { Data = new { MimeType = mimeType } };
//return File(renderedBytes, mimeType);
}
return RedirectToAction("VirtualService");
}
[HttpGet]
public virtual ActionResult DownloadReportPDF(string mimeType)
{
if (TempData["Data"] != null)
{
List<byte[]> lstBytesArray = TempData["Data"] as List<byte[]>;
List<string> lstNamesArray = TempData["File"] as List<string>;
//LocalReport localReport = TempData["localR"] as LocalReport;
int i = 0;
foreach(byte[] bytes in lstBytesArray)
{
var tempPath = Path.GetTempPath();
using (FileStream stream = new FileStream(String.Format(tempPath + lstNamesArray[i] + "_{0}.pdf", DateTime.Now.ToString("yyyy-MM-dd-HHmmss")), FileMode.Create))
{
stream.Write(bytes, 0, bytes.Length);
}
i++;
}
return RedirectToAction("VirtualService");
}
else
{
return new EmptyResult();
}
}
