// GET: api/Book
public IEnumerable <Books> Get()
{
List <Books> output = new List <Books>();
LibDataSetTableAdapters.BooksTableAdapter ta = new LibDataSetTableAdapters.BooksTableAdapter();
var dt = ta.GetData();
try
{
var numRows = dt.Rows.Count;
DataRow dr;
for (int i = 0; i < numRows; i++)
{
dr = dt.Rows[i];
output.Add(new Books(Int32.Parse(dr["ISBN"].ToString()),
dr["Title"].ToString()));
}
}
catch (Exception e)
{
throw e;
}
return(output);
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
LibDataSet context = new LibDataSet();
LibDataSetTableAdapters.BooksTableAdapter b = new LibDataSetTableAdapters.BooksTableAdapter();
b.Fill(context.Books);
ListofBooks2 cr = new ListofBooks2();
cr.SetDataSource(context);
crystalReportViewer1.ReportSource = cr;
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
LibDataSet context = new LibDataSet();
LibDataSetTableAdapters.BooksTableAdapter b = new LibDataSetTableAdapters.BooksTableAdapter();
LibDataSetTableAdapters.BorrowTableAdapter c = new LibDataSetTableAdapters.BorrowTableAdapter();
b.Fill(context.Books);
c.Fill(context.Borrow);
BorrowReport cr1 = new BorrowReport();
cr1.SetDataSource(context);
crystalReportViewer1.ReportSource = cr1;
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
LibDataSet context = new LibDataSet();
LibDataSetTableAdapters.BooksTableAdapter b = new LibDataSetTableAdapters.BooksTableAdapter();
LibDataSetTableAdapters.BorrowTableAdapter c = new LibDataSetTableAdapters.BorrowTableAdapter();
LibDataSetTableAdapters.MemberTableAdapter d = new LibDataSetTableAdapters.MemberTableAdapter();
b.Fill(context.Books);
c.Fill(context.Borrow);
d.Fill(context.Member);
receiptCrystalReport cr1 = new receiptCrystalReport();
cr1.SetDataSource(context);
crystalReportViewer1.ReportSource = cr1;
///
/// select a transcation shown on the receipt
///
crystalReportViewer1.SelectionFormula = "{Borrow.TransactionID} = " + TranID;
}
