public async Task <ActionResult <BaseResponse> > Get()
{
List <BookReport> list = new List <BookReport>();
var books = await _context.BOOKS.ToListAsync();
for (int i = 1; i < books.Count; i++)
{
int totalAmount = 0;
var input = await _context.INPUTS.Where(x => x.bookId == books[i].id).ToListAsync();
for (int j = 0; j < input.Count; j++)
{
totalAmount += input[j].amount;
}
BookReport report = new BookReport();
report.name = books[i].name;
report.nowStock = books[i].stock;
report.oldStock = books[i].stock - totalAmount;
report.additionalStock = totalAmount;
list.Add(report);
}
return(new BaseResponse
{
ErrorCode = Roles.Success,
Message = "Completed create report!",
Data = list
});
}
public BookReportViewerForm()
{
InitializeComponent();
filterSortSlidePanel.IsOpen = false;
SQLSelectCommandModel command = new SQLSelectCommandModel();
command.Table = "Book";
command.Columns = "*";
DataSet dataSet = new DataSet();
DataTable table = SQLCommandController.SelectFrom(command, "Book");
dataSet.Tables.Add(table);
BookReport report = new BookReport();
report.SetDataSource(dataSet);
crystalReportViewer.ReportSource = report;
}