public static MemoryStream GetReportXXXXX() { List <Car> cars = new List <Car>(); cars.Add(new Car() { Name = "01", Price = 500 }); cars.Add(new Car() { Name = "02", Price = 1500 }); cars.Add(new Car() { Name = "03", Price = 2500 }); MemoryStream result = new MemoryStream(); using (CarReport report = new CarReport()) { report.DataSource = cars; // bind object to report report.CreateDocument(); report.ExportToPdf(result); report.Dispose(); } result.Position = 0; return(result); }
public ActionResult Details(int id) { var dir = Server.MapPath("~/App_Data/Images/Vehicles/"); List <CarReport> carReports = new List <CarReport>(); _context = new DbContext(); var result = _context.Reservations.Where(n => n.ReservationVehicleId == id).GroupBy(o => o.ReservationVehicleId) .Select(g => new { VehicleId = g.Key, Total = g.Sum(i => i.ReservationAmount) }); foreach (var group in result) { if (group.VehicleId == id) { var reservationList = _context.Reservations.Where(r => r.ReservationVehicleId == group.VehicleId).ToList(); foreach (var r in reservationList) { var ve = _context.Vehicles.SingleOrDefault(v => v.VehicleId == r.ReservationVehicleId); if (string.IsNullOrEmpty(ve.Photo)) { _image = ""; } else { if (System.IO.File.Exists(dir + ve.Photo)) { _bytes = System.IO.File.ReadAllBytes(dir + ve.Photo); _image = Convert.ToBase64String(_bytes); } else { _image = ""; } } var G = _context.Customers.SingleOrDefault(c => c.UserId == r.ReservedBy); if (G != null) { CarReport carReport = new CarReport() { VehicleId = ve.VehicleId, VehicleName = ve.VehicleName, Photo = _image, ReservedDate = r.ReservationDate, ReservedBy = G.Name, ReservationEarn = r.ReservationAmount, GrandTotal = group.Total }; carReports.Add(carReport); } } } } return(View(carReports)); }