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