public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { XReadReport rpt = new XReadReport(); rpt.Site = this.Site; return(rpt); }
private void btnXRead_Click(object sender, EventArgs e) { var facade = new Facade(); ArrayList source = new ArrayList(); var register = facade.Restaurant.Areas.SelectMany(a => a.Registers); var people = from p in facade.People select new { Id = p.Id, FirstName = p.FirstName, LastName = p.LastName }; var sales = facade.Restaurant.Areas.SelectMany(a => a.Registers.SelectMany(r => r.Sales)).ToList(); var salesTotal = sales.Sum(s => s.SaleTotal); var gst = sales.Sum(s => s.GSTTotal); var cashPayments = sales.SelectMany(s => s.Payments.Where(p => p.PaymentType.Equals(PaymentType.Cash))).ToList(); var cashTotal = cashPayments.Sum(p => p.Sale.SaleTotal); var eftposPayments = sales.SelectMany(s => s.Payments.Where(p => p.PaymentType.Equals(PaymentType.Eftpos))).ToList(); var eftposTotal = eftposPayments.Sum(p => p.Sale.SaleTotal); foreach (var s in sales) { source.Add(new { RegisterName = register.First().Name, SaleNumber = sales.Count, SaleTotal = salesTotal, GstTotal = gst, CashCount = cashPayments.Count, CashTotal = cashTotal, EftposCount = eftposPayments.Count, EftposTotal = eftposTotal, UserFirstName = s.UserAccount.ToString(), UserSalesTotal = sales.Sum(sum => sales.Where(u => u.UserId.Equals(sum.UserAccount.Id)).FirstOrDefault().SaleTotal) }); } var report = new XReadReport(); report.SetDataSource(source); crystalReportViewer1.ReportSource = report; ConnectReporter(); crystalReportViewer1.RefreshReport(); }
private void btnXRead_Click(object sender, EventArgs e) { var facade = new Facade(); ArrayList source = new ArrayList(); var register = facade.Restaurant.Areas.SelectMany(a => a.Registers); var people = from p in facade.People select new { Id = p.Id, FirstName = p.FirstName, LastName = p.LastName }; var sales = facade.Restaurant.Areas.SelectMany(a => a.Registers.SelectMany(r => r.Sales)).ToList(); var salesTotal = sales.Sum(s => s.SaleTotal); var gst = sales.Sum(s => s.GSTTotal); var cashPayments = sales.SelectMany(s => s.Payments.Where(p => p.PaymentType.Equals(PaymentType.Cash))).ToList(); var cashTotal = cashPayments.Sum(p => p.Sale.SaleTotal); var eftposPayments = sales.SelectMany(s => s.Payments.Where(p => p.PaymentType.Equals(PaymentType.Eftpos))).ToList(); var eftposTotal = eftposPayments.Sum(p => p.Sale.SaleTotal); foreach (var s in sales) { source.Add(new { RegisterName = register.First().Name, SaleNumber = sales.Count, SaleTotal = salesTotal, GstTotal = gst, CashCount = cashPayments.Count, CashTotal = cashTotal, EftposCount = eftposPayments.Count, EftposTotal = eftposTotal, UserFirstName = s.UserAccount.ToString(), UserSalesTotal = sales.Sum(sum => sales.Where(u => u.UserId.Equals(sum.UserAccount.Id)).FirstOrDefault().SaleTotal) }); } var report = new XReadReport(); report.SetDataSource(source); crystalReportViewer1.ReportSource = report; ConnectReporter(); crystalReportViewer1.RefreshReport(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { XReadReport rpt = new XReadReport(); rpt.Site = this.Site; return rpt; }