Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }