public FileResult PrintInvoice_Read()
{
string _classID = System.Web.HttpContext.Current.Session["InvoiceID"].ToString();
string _PrintDublicate = System.Web.HttpContext.Current.Session["PrintDublicate"].ToString();
bool bit = false;
if (_PrintDublicate == "True")
{
bit = true;
}
if (_classID.Equals("-1"))
{
Session["InvoiceID"] = -1;
return(null);
}
else
{
ReIssued reIssued = new ReIssued();
reIssued.Invoice_ID = Convert.ToInt64(_classID);
reIssued.Re_Issued_By = CurrentUser.NameIdentifierInt64;
reIssued.Re_Issued_Date = DateTime.Now;
reIssued.Organization_ID = CurrentUser.CompanyID;
reIssued.ID = _CustomerBAL.create_InvoiceReIssueBAL(reIssued);
InvoiceHistory invoiceHistory = new InvoiceHistory();
invoiceHistory.History_Name = "Invoice Issued";
invoiceHistory.Type = InvoiceStatus.InvoiceReIssued;
invoiceHistory.Description = "";
invoiceHistory.Invoice_Number = Convert.ToInt64(_classID);
invoiceHistory.User_ID = CurrentUser.NameIdentifierInt64;
invoiceHistory.Organization_ID = CurrentUser.CompanyID;
invoiceHistory.Date_TIME = DateTime.Now;
var x = _CustomerBAL.create_InvoiceHistoryBAL(invoiceHistory);
ReportViewer ReportViewerRSFReports = new ReportViewer();
ReportViewerRSFReports.Height = Unit.Parse("100%");
ReportViewerRSFReports.Width = Unit.Parse("100%");
ReportViewerRSFReports.CssClass = "table";
var rptPath = Server.MapPath(@"../Report/INO_InvoiceRecipt.rdlc");
ReportViewerRSFReports.LocalReport.ReportPath = rptPath;
long cID = Convert.ToInt64(CurrentUser.CompanyID);
DataTable dt = _CustomerBAL.GetInvoiceReportsBAL(Convert.ToInt64(_classID), Convert.ToInt64(CurrentUser.CompanyID), bit);
ReportViewerRSFReports.ProcessingMode = ProcessingMode.Local;
ReportViewerRSFReports.LocalReport.DataSources.Clear();
ReportViewerRSFReports.LocalReport.EnableExternalImages = true;
List <OrganizationModel> logoPath = _PersonBAL.GetOrganizationLogo(CurrentUser.CompanyID);
ReportParameter paramLogo = new ReportParameter();
paramLogo.Name = "Picture";
string imagePath = new Uri(Server.MapPath(@"~/" + logoPath.FirstOrDefault().Logo)).AbsoluteUri;
paramLogo.Values.Add(imagePath);
ReportViewerRSFReports.LocalReport.SetParameters(paramLogo);
ReportViewerRSFReports.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewerRSFReports.LocalReport.Refresh();
byte[] mybytes = ReportViewerRSFReports.LocalReport.Render(format: "PDF", deviceInfo: "");
Session["InvoiceID"] = -1;
Session["PrintDublicate"] = false;
return(File(mybytes, System.Net.Mime.MediaTypeNames.Application.Octet, "Invoice.pdf"));
}
}
private void RenderReportModels(ReportData reportData, string Venue, string classid, string startDate, string endDate)
{
long ClassID = Convert.ToInt64(classid);
long venue = Convert.ToInt64(Venue);
DateTime startdatet = DateTime.ParseExact(startDate, "dd/MM/yyyy",
CultureInfo.InvariantCulture);
DateTime enddatet = DateTime.ParseExact(endDate, "dd/MM/yyyy",
CultureInfo.InvariantCulture);
// Reset report properties.
ReportViewerRSFReports.Height = Unit.Parse("100%");
ReportViewerRSFReports.Width = Unit.Parse("100%");
ReportViewerRSFReports.CssClass = "table";
var rptPath = Server.MapPath(@"../../../Report/" + reportData.ReportName + ".rdlc");
this.ReportViewerRSFReports.LocalReport.ReportPath = rptPath;
DataTable dt = _PersonBAL.GetOccVenueDetailsForReports(Convert.ToInt64(classid),
Convert.ToInt64(Venue), startdatet, enddatet); ReportViewerRSFReports.ProcessingMode = ProcessingMode.Local;
ReportViewerRSFReports.LocalReport.DataSources.Clear();
ReportViewerRSFReports.LocalReport.EnableExternalImages = true;
List <OrganizationModel> logoPath = _PersonBAL.GetOrganizationLogo(Convert.ToInt64(HttpContext.Current.Session["CompanyID"]));
ReportParameter paramLogo = new ReportParameter();
paramLogo.Name = "Path";
string imagePath = new Uri(Server.MapPath(@"~/" + logoPath.FirstOrDefault().Logo)).AbsoluteUri;
paramLogo.Values.Add(imagePath);
ReportViewerRSFReports.LocalReport.SetParameters(paramLogo);
ReportViewerRSFReports.LocalReport.DataSources.Add(new ReportDataSource("OccupancyReport", dt));
ReportViewerRSFReports.LocalReport.Refresh();
}
private void RenderReportModels(ReportData reportData, string classid, string courseid)
{
long ClassID = Convert.ToInt64(classid);
long CourseID = Convert.ToInt64(courseid);
// Reset report properties.
ReportViewerRSFReports.Height = Unit.Parse("100%");
ReportViewerRSFReports.Width = Unit.Parse("100%");
ReportViewerRSFReports.CssClass = "table";
var rptPath = Server.MapPath(@"../../../Report/" + reportData.ReportName + ".rdlc");
this.ReportViewerRSFReports.LocalReport.ReportPath = rptPath;
DataTable dt = _CourseBAL.GetCourseReportData(ClassID, CourseID);
ReportViewerRSFReports.ProcessingMode = ProcessingMode.Local;
ReportViewerRSFReports.LocalReport.DataSources.Clear();
ReportViewerRSFReports.LocalReport.EnableExternalImages = true;
List <OrganizationModel> logoPath = _CourseBAL.GetOrganizationLogo(Convert.ToInt64(HttpContext.Current.Session["CompanyID"]));
ReportParameter paramLogo = new ReportParameter();
paramLogo.Name = "Path";
string imagePath = new Uri(Server.MapPath(@"~/" + logoPath.FirstOrDefault().Logo)).AbsoluteUri;
paramLogo.Values.Add(imagePath);
ReportViewerRSFReports.LocalReport.SetParameters(paramLogo);
ReportViewerRSFReports.LocalReport.DataSources.Add(new ReportDataSource("VewCourseAttendanceReportDataSet", dt));
ReportViewerRSFReports.LocalReport.Refresh();
//ReportViewerRSFReports.RefreshReport();
//// Clear out any previous datasources.
//this.ReportViewerRSFReports.LocalReport.DataSources.Clear();
//// Set report mode for local processing.
//ReportViewerRSFReports.ProcessingMode = ProcessingMode.Remote;
//// Validate report source.
//var rptPath = Server.MapPath(@"../../../Report/" + reportData.ReportName + ".rdlc");
////@"E:\RSFERP_SourceCode\RASolarERP\RASolarERP\Reports\Report\" + reportData.ReportName + ".rdlc";
////Server.MapPath(@"./Report/ClosingInventory.rdlc");
//if (!File.Exists(rptPath))
// return;
//// Set report path.
//this.ReportViewerRSFReports.LocalReport.ReportPath = rptPath;
//// Set report parameters.
//var rpPms = ReportViewerRSFReports.LocalReport.GetParameters();
//foreach (var rpm in rpPms)
//{
// var p = reportData.ReportParameters.SingleOrDefault(o => o.ParameterName.ToLower() == rpm.Name.ToLower());
// if (p != null)
// {
// ReportParameter rp = new ReportParameter(rpm.Name, p.Value);
// ReportViewerRSFReports.LocalReport.SetParameters(rp);
// }
//}
//////Set data paramater for report SP execution
////objClosingInventory = dal.ClosingInventoryReport(this.ReportDataObj.DataParameters[0].Value);
////// Load the dataSource.
//// ReportViewerRSFReports.LocalReport.DataSources.Clear();
////var dsmems = ReportViewerRSFReports.LocalReport.GetDataSourceNames();
//// ReportViewerRSFReports.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", objClosingInventory));
//// ReportViewerRSFReports.RefreshReport();
//// Refresh the ReportViewer.
//DataTable dt = _CourseBAL.GetCourseReportData(ClassID, CourseID);
//ReportViewerRSFReports.ProcessingMode = ProcessingMode.Local;
////ReportViewerRSFReports.LocalReport.ReportPath = Server.MapPath("~/Report/Tran_ViewCourseAttendanceReport.rdlc");
//// DataSet ds = GetTrainerDetailsForReports;
//ReportViewerRSFReports.LocalReport.DataSources.Clear();
////ReportViewerRSFReports.Reset();
//ReportDataSource datasource = new ReportDataSource("VewCourseAttendanceReportDataSet", dt);
//ReportViewerRSFReports.LocalReport.DataSources.Add(datasource);
//this.ReportViewerRSFReports.LocalReport.Refresh();
}