private VFMClasses.DataSets.FuelOrders.TotalByStatusDataTable GetTotalCustFuelOrdersByStatusDataTable(int custClientId, string startDate, string endDate) { TotalByStatusTableAdapter adapter = new TotalByStatusTableAdapter(); adapter.Connection = new SqlConnection(Degatech.Utilities.SQL.ConnectionHelper.GetConnectionString("SQLFLString")); VFMClasses.DataSets.FuelOrders.TotalByStatusDataTable table = adapter.GetCustData(DateTime.Parse(startDate), DateTime.Parse(endDate), custClientId, Degatech.Utilities.Data.Utilities.Domain()); return(table); }
private VFMClasses.DataSets.FuelOrders.TotalByStatusDataTable GetTransactionHistory(int adminClientId, string startDate, string endDate) { TotalByStatusTableAdapter adapter = new TotalByStatusTableAdapter(); adapter.Connection = new SqlConnection(Degatech.Utilities.SQL.ConnectionHelper.GetConnectionString("SQLFLString")); VFMClasses.DataSets.FuelOrders.TotalByStatusDataTable table = adapter.GetAnalysis(DateTime.Parse(startDate), DateTime.Parse(endDate), adminClientId); return(table); }