public int UploadFileToFolder(int Id) { string pdfname = ""; try { ReportDocument Report = new ReportDocument(); Report.Load(Server.MapPath("~/Reports/LPO-Invoice/LPOInvoice.rpt")); List <IT.Web.Models.CompnayModel> compnayModels = new List <Web.Models.CompnayModel>(); List <IT.Web.Models.LPOInvoiceModel> lPOInvoiceModels = new List <IT.Web.Models.LPOInvoiceModel>(); List <LPOInvoiceDetailsModel> lPOInvoiceDetails = new List <LPOInvoiceDetailsModel>(); List <VenderModel> venderModels = new List <VenderModel>(); int CompanyId = Convert.ToInt32(Session["CompanyId"]); Web.Models.LPOInvoiceModel lPOInvoiceModel = new Web.Models.LPOInvoiceModel(); lPOInvoiceModel.Id = Id; lPOInvoiceModel.detailId = CompanyId; var LPOInvoice = webServices.Post(lPOInvoiceModel, "Quotation/EditReport/" + Id); if (LPOInvoice.Data != "[]") { lPOInvoiceModel = (new JavaScriptSerializer()).Deserialize <IT.Web.Models.LPOInvoiceModel>(LPOInvoice.Data.ToString()); } lPOInvoiceModels.Add(lPOInvoiceModel); venderModels = lPOInvoiceModel.venders; compnayModels = lPOInvoiceModel.compnays; lPOInvoiceDetails = lPOInvoiceModel.lPOInvoiceDetailsList; Report.Database.Tables[0].SetDataSource(compnayModels); Report.Database.Tables[1].SetDataSource(venderModels); Report.Database.Tables[2].SetDataSource(lPOInvoiceModels); Report.Database.Tables[3].SetDataSource(lPOInvoiceDetails); Stream stram = Report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stram.Seek(0, SeekOrigin.Begin); string companyName = Id + "-" + lPOInvoiceModels[0].PONumber; var root = Server.MapPath("/PDF/"); pdfname = String.Format("{0}.pdf", companyName); var path = Path.Combine(root, pdfname); path = Path.GetFullPath(path); Report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path); stram.Close(); return(1); } catch (Exception ex) { throw ex; } }
public ActionResult PrintQuotation(int Id) { string pdfname = ""; try { ReportDocument Report = new ReportDocument(); Report.Load(Server.MapPath("~/Reports/LPO-Invoice/LPOInvoice.rpt")); List <IT.Web.Models.CompnayModel> compnayModels = new List <Web.Models.CompnayModel>(); List <IT.Web.Models.LPOInvoiceModel> lPOInvoiceModels = new List <IT.Web.Models.LPOInvoiceModel>(); List <LPOInvoiceDetailsModel> lPOInvoiceDetails = new List <LPOInvoiceDetailsModel>(); List <VenderModel> venderModels = new List <VenderModel>(); int CompanyId = Convert.ToInt32(Session["CompanyId"]); Web.Models.LPOInvoiceModel lPOInvoiceModel = new Web.Models.LPOInvoiceModel { Id = Id, detailId = CompanyId, }; var LPOInvoice = webServices.Post(lPOInvoiceModel, "Quotation/EditReport/" + Id); if (LPOInvoice.Data != "[]") { lPOInvoiceModel = (new JavaScriptSerializer()).Deserialize <IT.Web.Models.LPOInvoiceModel>(LPOInvoice.Data.ToString()); } lPOInvoiceModels.Add(lPOInvoiceModel); venderModels = lPOInvoiceModel.venders; compnayModels = lPOInvoiceModel.compnays; lPOInvoiceDetails = lPOInvoiceModel.lPOInvoiceDetailsList; venderModels[0].UserName = "******"; Report.Database.Tables[0].SetDataSource(compnayModels); Report.Database.Tables[1].SetDataSource(venderModels); Report.Database.Tables[2].SetDataSource(lPOInvoiceModels); Report.Database.Tables[3].SetDataSource(lPOInvoiceDetails); Report.SetParameterValue("ImageUrl", "http://itmolen-001-site8.htempurl.com/ClientDocument/" + lPOInvoiceModel.compnays[0].LogoUrl); Report.SetParameterValue("Heading", "Quotation"); Stream stram = Report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stram.Seek(0, SeekOrigin.Begin); string companyName = Id + "-" + lPOInvoiceModels[0].PONumber; var root = Server.MapPath("/PDF/"); pdfname = String.Format("{0}.pdf", companyName); var path = Path.Combine(root, pdfname); path = Path.GetFullPath(path); Report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path); //stram.Close(); byte[] fileBytes = System.IO.File.ReadAllBytes(path); string fileName = companyName + ".PDF"; //return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName); //Stream stram = Report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); //stram.Seek(0, SeekOrigin.Begin); return(new FileStreamResult(stram, "application/pdf")); } catch (Exception ex) { throw ex; } }