private VFMClasses.DataSets.FuelOrders.TransactionsDataTable ExportFuelOrders(int adminClientId, string fuelOrderIDs,
string startDate, string endDate)
{
TransactionsTableAdapter adapter = new TransactionsTableAdapter();
adapter.Connection =
new SqlConnection(Degatech.Utilities.SQL.ConnectionHelper.GetConnectionString("SQLFLString"));
VFMClasses.DataSets.FuelOrders.TransactionsDataTable table = adapter.ExportDataByAdminID(adminClientId, fuelOrderIDs,
DateTime.Parse(startDate), DateTime.Parse(endDate));
return(table);
}
private VFMClasses.DataSets.FuelOrders.TransactionsDataTable GetTransactionsByCust(int custClientId,
string startDate, string endDate)
{
TransactionsTableAdapter adapter = new TransactionsTableAdapter();
adapter.Connection =
new SqlConnection(Degatech.Utilities.SQL.ConnectionHelper.GetConnectionString("SQLFLString"));
VFMClasses.DataSets.FuelOrders.TransactionsDataTable table = adapter.GetDataByCust(custClientId, DateTime.Parse(startDate),
DateTime.Parse(endDate));
return(table);
}
private void IssueTransactionReportForm_Load(object sender, EventArgs e)
{
DataSetTransReport ds = new DataSetTransReport();
TransactionsTableAdapter td = new TransactionsTableAdapter();
td.Fill(ds.Transactions);
TransactionReport cr = new TransactionReport();
cr.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr;
}
private void BtnGenerarReporte_Click(object sender, EventArgs e)
{
//var transactionsD = _transactionRepository.GetAll().Where(t => t.TransactionType == TransactionTypeEnum.Deposit).ToList();
//var transactionsR = _transactionRepository.GetAll().Where(t => t.TransactionType == TransactionTypeEnum.Retirement).ToList();
reportViewer1.LocalReport.ReportPath = @"C:\Cash\ProyectoFinalProg3\CashBox\CashBox\GeneralReport.rdlc";
TransactionsTableAdapter adapter = new TransactionsTableAdapter();
int TransactionType = int.Parse(txtTipoTransaccion.Text);
ReportDataSource reportDataSource = new ReportDataSource("DataSetTransactionType", (DataTable)adapter.GetDataByTransactionType(TransactionType));
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.RefreshReport();
}
