public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
TransactionsList rpt = new TransactionsList();
rpt.Site = this.Site;
return(rpt);
}
private void buttonTransaction_Click(object sender, EventArgs e)
{
SA46Team09BEntities context = new SA46Team09BEntities();
TransactionsList CR = new TransactionsList();
CR.Database.Tables[0].SetDataSource(context.Transactions);
CR.Database.Tables[1].SetDataSource(context.Members);
crystalReportViewerReport.ReportSource = CR;
((MAIN)MdiParent).UpdateStatusLabel("Report Generated");
}
private void buttonBookingReceipt_Click(object sender, EventArgs e)
{
List <Transaction> Translist = new List <Transaction>();
TransactionsList CR = new TransactionsList();
List <Member> Memlist = new List <Member>();
SA46Team09BEntities context = new SA46Team09BEntities();
int transid = Convert.ToInt32(this.comboBoxTransID.Text);
var Query = from x in context.Transactions where x.TransactionID == transid select x;
Translist = Query.ToList <Transaction>();
string NUSID = Translist[0].NUSID;
var Query2 = from x in context.Members where x.NUSID == NUSID select x;
Memlist = Query2.ToList <Member>();
CR.Database.Tables[0].SetDataSource(Translist);
CR.Database.Tables[1].SetDataSource(Memlist);
crystalReportViewerReport.ReportSource = CR;
((MAIN)MdiParent).UpdateStatusLabel("Report Generated");
}