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(); }