public ActionResult DownloadAnex(int RntID)
{
byte[] bytes = null;
//if (returnId == null)
// returnId = "0";
//int catg = Convert.ToInt32(returnId.Substring(0, 1));
//int RntID = Convert.ToInt32(returnId.Substring(1, returnId.Length - 1));
string DocumetNAme = "";
Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
var DBvlu = db.AJ_Stud_Admin_Return_Reg_C(RntID);
rpt.ReportPath = Server.MapPath(@"~/Reports/Regirstion_Reports/Rdlc_Affi_reg_return_Anax_C.rdlc");
rpt.DataSources.Add(new ReportDataSource("Rdlc_Affi_reg_return_Anax_C", DBvlu));
DocumetNAme = "Annex-C" + "." + "PDF";
rpt.GetDefaultPageSettings();
bytes = rpt.Render("PDF");
// bytes = rpt.Render("PDF");
if (bytes.Length > 0)
{
Response.Buffer = true;
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=" + DocumetNAme);
Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
Response.Flush(); // send it to the client to download
Response.End();
// return View();
}
return(RedirectToAction("ReturnStatus", "Registration"));
}
byte[] Laboratory(int Inst_ID)
{
using (UOSEntities db = new UOSEntities())
{
Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_inst_AJ_Rep_Laboratory_INFO.rdlc");
rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Laboratory_INFO", db.AJ_Rep_Laboratory_INFO(Convert.ToInt32(Inst_ID))));
return(rpt.Render("PDF"));
}
}
byte[] Download_Rpt_Insitut_info(int Inst_ID)
{
using (UOSEntities db = new UOSEntities())
{
Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Rpt_Affi_Instu_Info.rdlc");
rpt.DataSources.Add(new ReportDataSource("AJ_Affi_Ins_Pop_Instu_Info", db.AJ_Affi_Ins_Pop_Instu_Info(Convert.ToInt32(Inst_ID))));
return(rpt.Render("PDF"));
}
}
byte[] Download_Rpt_Non_Requir_info(int Inst_ID)
{
using (UOSEntities db = new UOSEntities())
{
Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_ins_Non_Recuring_INFO.rdlc");
rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Non_Recuring_INFO", db.AJ_Rep_Non_Recuring_INFO(Convert.ToInt32(Inst_ID))));
return(rpt.Render("PDF"));
}
}
byte[] Download_Rpt_Staff_info(int Inst_ID, int cag)
{
using (UOSEntities db = new UOSEntities())
{
Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_Inst_Staff_Info.rdlc");
rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Employee_INFO", db.AJ_Rep_Employee_INFO(Convert.ToInt32(Inst_ID), cag)));
return(rpt.Render("PDF"));
}
}
byte[] Download_Rpt_Libaray_info(int Inst_ID)
{
using (UOSEntities db = new UOSEntities())
{
Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_Inst_Library_INFO.rdlc");
rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Library_INFO", db.AJ_Rep_Library_INFO(Convert.ToInt32(Inst_ID))));
rpt.DataSources.Add(new ReportDataSource("Affi_ins_Rep_OtherFacilities_INFO", db.AJ_Affi_ins_Rep_OtherFacilities_INFO(Convert.ToInt32(Inst_ID))));
return(rpt.Render("PDF"));
}
}
public static byte[] GeReportStreamPDF(string reportName, string dataSetName, object dataSet, string reportPath, List <Microsoft.Reporting.WebForms.ReportParameter> parameters = null, Dictionary <string, object> dataSets = null)
{
Microsoft.Reporting.WebForms.LocalReport report = new Microsoft.Reporting.WebForms.LocalReport();
report.EnableExternalImages = true;
report.ReportPath = reportPath + "/" + reportName + ".rdlc";
if (parameters.Count() > 0)
{
report.SetParameters(parameters);
}
ReportDataSource rds = new ReportDataSource();
rds.Name = dataSetName;
rds.Value = dataSet;
report.DataSources.Add(rds);
if (dataSets != null)
{
foreach (KeyValuePair <string, object> kvp in dataSets)
{
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = kvp.Key;
reportDataSource.Value = kvp.Value;
report.DataSources.Add(reportDataSource);
}
}
string deviceInfo = null; // http://msdn2.microsoft.com/en-us/library/ms155397.aspx
string mimeType;
string encoding;
string fileNameExtension;
string[] streams;
Microsoft.Reporting.WebForms.Warning[] warnings;
byte[] renderedBytes = report.Render(
"PDF",
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
return(renderedBytes);
}
public ActionResult DownloadForm(string appId)
{
obj = GetData();
Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Rep_Affi_Ins_Visting_Member.rdlc");
rpt.DataSources.Add(new ReportDataSource("AJ_Aff_Ins_Vist_Rep_Commety", db.AJ_Aff_Ins_Vist_Rep_Commety(Convert.ToInt32(appId))));
rpt.DataSources.Add(new ReportDataSource("AJ_Aff_Ins_Vist_Rep_MEmBEr_Commety", db.AJ_Aff_Ins_Vist_Rep_MEmBEr_Commety(Convert.ToInt32(obj.Institute_Id))));
byte[] bytes = rpt.Render("PDF");
Response.Buffer = true;
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename= Application" + "." + "PDF");
Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
Response.Flush(); // send it to the client to download
Response.End();
//return View();
//return Json("Secuss", JsonRequestBehavior.AllowGet);
return(View());
}
protected void generate_report_ServerClick(object sender, EventArgs e)
{
int briefId = 1;
ReportGenerator rg = new ReportGenerator(Server.MapPath("~/download/") + Session.SessionID + ".rdlc");
rg.ChartImagePath = Server.MapPath("~/chart-images/");
string reportPath = rg.Generate(briefId);
string fileName = "File_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".docx";
string fullFilePath = Server.MapPath("~/download/") + fileName;
string extension = string.Empty;
string encoding = string.Empty;
string mimeType = string.Empty;
string[] streams;
MRW.Warning[] warnings;
MRW.LocalReport report = new MRW.LocalReport();
report.ReportPath = reportPath;
report.SetParameters(GetReportParameters(briefId));
Byte[] mybytes = report.Render("WORDOPENXML", null,
out mimeType, out encoding,
out extension, out streams, out warnings);
using (FileStream fs = File.Create(fullFilePath))
{
fs.Write(mybytes, 0, mybytes.Length);
}
Response.ClearHeaders();
Response.ClearContent();
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.WriteFile(fullFilePath);
Response.Flush();
Response.Close();
Response.End();
}
public static HttpResponseMessage Report(DataTable ds, string dsName, string rdlc)
{
var report = new Microsoft.Reporting.WebForms.LocalReport();
report.ReportPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Bin/Report/" + rdlc);
report.DataSources.Add(new ReportDataSource(dsName, ds));
report.Refresh();
string mimeType = "";
string encoding = "";
string filenameExtension = "";
string[] streams = null;
Microsoft.Reporting.WebForms.Warning[] warnings = null;
byte[] bytes = report.Render("PDF", null, out mimeType, out encoding, out filenameExtension, out streams, out warnings);
HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
result.Content = new ByteArrayContent(bytes);
result.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue(mimeType);
return(result);
}
// metodos para imprimir o BE
private static void ExportarEtiq(Microsoft.Reporting.WebForms.LocalReport etiqueta)
{
Microsoft.Reporting.WebForms.Warning[] warnings;
LimparStreams();
etiqueta.Render("image", CriarDeviceInfoEtique(etiqueta), CreateStreamCallback, out warnings);
}
// metodos para imprimir o BE
private static void Exportar(Microsoft.Reporting.WebForms.LocalReport relatorio)
{
Microsoft.Reporting.WebForms.Warning[] warnings;
LimparStreams();
relatorio.Render("image", CriarDeviceInfo(relatorio), CreateStreamCallback, out warnings);
}
public ActionResult DetailsReport()
{
LocalReport lr = new Microsoft.Reporting.WebForms.LocalReport();
string deviceInfo = "<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>1in</MarginLeft>" +
" <MarginRight>1in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
lr.ReportPath = Server.MapPath("~/Rapor/Birim.rdlc");
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["matbaaConnectionString"].ConnectionString);
conn.Open();
SqlDataAdapter adap = new SqlDataAdapter("select * from Birim", conn);
DataSet ds = new DataSet();
adap.Fill(ds);
conn.Close();
lr.DataSources.Clear();
lr.DataSources.Add(
new ReportDataSource("DataSetBirim", ds.Tables[0]));
Warning[] warnings; string mimeType; string encoding; string[] streamids; string fne;
byte[] bytes = lr.Render("PDF", deviceInfo, out mimeType, out encoding, out fne, out streamids, out warnings);
return File(bytes, mimeType);
}
