public DataTable GetAirportDataSource()
{
AirportAutoCompletionDataTableAdapter adapter = new AirportAutoCompletionDataTableAdapter();
adapter.Connection = new SqlConnection(ExecutionHelper.GetConnectionString());
return(adapter.GetData());
}
private void UploadDatabaseRecords(DataTable convertedTable)
{
//Delete all old records for that supplier/admin
AcukwikFBOHandlerDetailTableAdapter adapter = new AcukwikFBOHandlerDetailTableAdapter();
adapter.Connection = new SqlConnection(ExecutionHelper.GetConnectionString());
adapter.DeleteData();
//Bulk insert the new records
using (SqlBulkCopy s = new SqlBulkCopy(ExecutionHelper.GetConnectionString()))
{
s.DestinationTableName = "AcukwikFBOHandlerDetail";
s.BatchSize = 5000;
s.ColumnMappings.Add("Airport_ID", "Airport_ID");
s.ColumnMappings.Add("Handler_ID", "Handler_ID");
s.ColumnMappings.Add("HandlerLongName", "HandlerLongName");
s.ColumnMappings.Add("HandlerType", "HandlerType");
s.ColumnMappings.Add("HandlerTelephone", "HandlerTelephone");
s.ColumnMappings.Add("HandlerFax", "HandlerFax");
s.ColumnMappings.Add("HandlerTollFree", "HandlerTollFree");
s.ColumnMappings.Add("HandlerFreq", "HandlerFreq");
s.ColumnMappings.Add("HandlerFuelBrand", "HandlerFuelBrand");
s.ColumnMappings.Add("HandlerFuelBrand2", "HandlerFuelBrand2");
s.ColumnMappings.Add("HandlerFuelSupply", "HandlerFuelSupply");
s.ColumnMappings.Add("HandlerLocationOnField", "HandlerLocationOnField");
s.ColumnMappings.Add("MultiService", "MultiService");
s.ColumnMappings.Add("Avcard", "Avcard");
s.ColumnMappings.Add("Acukwik_ID", "Acukwik_ID");
s.WriteToServer(convertedTable);
s.Close();
}
}
private void UploadDatabaseRecords(DataTable convertedTable)
{
//Delete all old records for that supplier/admin
AcukwikCountriesTableAdapter adapter = new AcukwikCountriesTableAdapter();
adapter.Connection = new SqlConnection(ExecutionHelper.GetConnectionString());
adapter.DeleteData();
//Bulk insert the new records
using (SqlBulkCopy s = new SqlBulkCopy(ExecutionHelper.GetConnectionString()))
{
s.DestinationTableName = "AcukwikCountries";
s.BatchSize = 5000;
s.ColumnMappings.Add("COUNTRY_ID", "COUNTRY_ID");
s.ColumnMappings.Add("Country", "Country");
s.ColumnMappings.Add("FullCountryName", "FullCountryName");
s.ColumnMappings.Add("ISOCountryID", "ISOCountryID");
s.ColumnMappings.Add("ISO_Name", "ISO_Name");
s.ColumnMappings.Add("ISOCode2", "ISOCode2");
s.ColumnMappings.Add("ISOCode3", "ISOCode3");
s.ColumnMappings.Add("Region", "Region");
s.WriteToServer(convertedTable);
s.Close();
}
}
public void UploadDatabaseRecords(DataTable convertedTable)
{
//Delete all old records for that supplier/admin
SupplierFuelsPricesTableAdapter adapter = new SupplierFuelsPricesTableAdapter();
adapter.Connection = new SqlConnection(ExecutionHelper.GetConnectionString());
adapter.DeleteAll(_AdminClientId, _SupplierId);
//Bulk insert the new records
using (SqlBulkCopy s = new SqlBulkCopy(ExecutionHelper.GetConnectionString()))
{
s.DestinationTableName = "SupplierFuelsPrices";
s.BatchSize = 5000;
s.ColumnMappings.Add("Vendor", "Vendor");
s.ColumnMappings.Add("IATA", "IATA");
s.ColumnMappings.Add("ICAO", "ICAO");
s.ColumnMappings.Add("FBOName", "FBOName");
s.ColumnMappings.Add("Min", "Min");
s.ColumnMappings.Add("Max", "Max");
s.ColumnMappings.Add("TotalWithTax", "TotalWithTax");
s.ColumnMappings.Add("Expires", "Expires");
s.ColumnMappings.Add("Product", "Product");
s.ColumnMappings.Add("Notes", "Notes");
s.ColumnMappings.Add("AdminClientId", "AdminClientID");
s.ColumnMappings.Add("SupplierId", "SupplierID");
s.ColumnMappings.Add("EffectiveDate", "EffectiveDate");
s.ColumnMappings.Add("VendorEmail", "VendorEmail");
s.WriteToServer(convertedTable);
s.Close();
}
adapter.UpdateSupplierFuelsPricesMax(_AdminClientId, _SupplierId);
}
public void UploadDatabaseRecords(DataTable convertedTable)
{
//Delete all old records for that supplier/admin
SchedulingImportsTableAdapter adapter = new SchedulingImportsTableAdapter();
adapter.Connection = new SqlConnection(ExecutionHelper.GetConnectionString());
//adapter.DeleteAll(_SchedulingId, _AdminClientId, _CustClientId);
//Bulk insert the new records
using (SqlBulkCopy s = new SqlBulkCopy(ExecutionHelper.GetConnectionString()))
{
s.DestinationTableName = "SchedulingImports";
s.BatchSize = 5000;
s.ColumnMappings.Add("SchedulingPlatform", "SchedulingPlatform");
s.ColumnMappings.Add("AdminClientID", "AdminClientID");
s.ColumnMappings.Add("CustClientID", "CustClientID");
s.ColumnMappings.Add("TripNumber", "TripNumber");
s.ColumnMappings.Add("TailNumber", "TailNumber");
s.ColumnMappings.Add("ICAO", "ICAO");
s.ColumnMappings.Add("FBO", "FBO");
s.ColumnMappings.Add("Arrival", "Arrival");
s.ColumnMappings.Add("ImportDate", "ImportDate");
s.WriteToServer(convertedTable);
s.Close();
}
}
public void UpdateAll(int FuelOrderID)
{
FuelOrderTaxes.DeleteAll(FuelOrderID);
foreach (FuelOrderTaxes tax in this)
{
tax.FuelOrderID = FuelOrderID;
}
ExecutionHelper.BulkInsert(this.GetAllWithPricingData().AsDataTable(),
"dbo.FuelOrderTaxes", ExecutionHelper.GetConnectionString());
}
private void UploadDatabaseRecords(DataTable convertedTable)
{
//Delete all old records for that supplier/admin
AcukwikAirportsTableAdapter adapter = new AcukwikAirportsTableAdapter();
adapter.Connection = new SqlConnection(ExecutionHelper.GetConnectionString());
adapter.DeleteData();
//Bulk insert the new records
using (SqlBulkCopy s = new SqlBulkCopy(ExecutionHelper.GetConnectionString()))
{
s.DestinationTableName = "AcukwikAirports";
s.BatchSize = 5000;
s.ColumnMappings.Add("Airport_ID", "Airport_ID");
s.ColumnMappings.Add("ICAO", "ICAO");
s.ColumnMappings.Add("IATA", "IATA");
s.ColumnMappings.Add("FAA", "FAA");
s.ColumnMappings.Add("FullAirportName", "FullAirportName");
s.ColumnMappings.Add("AirportCity", "AirportCity");
s.ColumnMappings.Add("State/Subdivision", "State/Subdivision");
s.ColumnMappings.Add("Country", "Country");
s.ColumnMappings.Add("AirportType", "AirportType");
s.ColumnMappings.Add("Distance_From_City", "Distance_From_City");
s.ColumnMappings.Add("Latitude", "Latitude");
s.ColumnMappings.Add("Longitude", "Longitude");
s.ColumnMappings.Add("Elevation", "Elevation");
s.ColumnMappings.Add("Variation", "Variation");
s.ColumnMappings.Add("IntlTimeZone", "IntlTimeZone");
s.ColumnMappings.Add("DaylightSavingsYN", "DaylightSavingsYN");
s.ColumnMappings.Add("FuelType", "FuelType");
s.ColumnMappings.Add("AirportOfEntry", "AirportOfEntry");
s.ColumnMappings.Add("Customs", "Customs");
s.ColumnMappings.Add("HandlingMandatory", "HandlingMandatory");
s.ColumnMappings.Add("SlotsRequired", "SlotsRequired");
s.ColumnMappings.Add("Open24Hours", "Open24Hours");
s.ColumnMappings.Add("ControlTowerHours", "ControlTowerHours");
s.ColumnMappings.Add("ApproachList", "ApproachList");
s.ColumnMappings.Add("PrimaryRunwayID", "PrimaryRunwayID");
s.ColumnMappings.Add("RunwayLength", "RunwayLength");
s.ColumnMappings.Add("RunwayWidth", "RunwayWidth");
s.ColumnMappings.Add("Lighting", "Lighting");
s.ColumnMappings.Add("AirportNameShort", "AirportNameShort");
s.WriteToServer(convertedTable);
s.Close();
}
}
private void UploadDatabaseRecords(DataTable convertedTable)
{
//Delete all old records for that supplier/admin
AcukwikSubdivisionStatesTableAdapter adapter = new AcukwikSubdivisionStatesTableAdapter();
adapter.Connection = new SqlConnection(ExecutionHelper.GetConnectionString());
adapter.DeleteData();
//Bulk insert the new records
using (SqlBulkCopy s = new SqlBulkCopy(ExecutionHelper.GetConnectionString()))
{
s.DestinationTableName = "AcukwikSubdivisionStates";
s.BatchSize = 5000;
s.ColumnMappings.Add("StateSubdivision_ID", "StateSubdivision_ID");
s.ColumnMappings.Add("StateSubdivisionName", "StateSubdivisionName");
s.ColumnMappings.Add("StateSubdivisionAbbr", "StateSubdivisionAbbr");
s.ColumnMappings.Add("Country", "Country");
s.WriteToServer(convertedTable);
s.Close();
}
}
public void UpdateAll(int fuelOrderID)
{
FuelOrderFees.DeleteAll(fuelOrderID);
foreach (FuelOrderFees fee in this)
{
fee.FuelOrderID = fuelOrderID;
}
ExecutionHelper.BulkInsert(this.GetAllWithPricingData().AsDataTable(), "dbo.FuelOrderFees", ExecutionHelper.GetConnectionString());
}
public DataTable GetAirportDataSourceByAdminClinetID(int adminClientId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", adminClientId));
DataSet dataSet = ExecutionHelper.ExecuteDataset("up_Select_AcukwikAirportsAndMarginsByAndAdminClientID", parameters, ExecutionHelper.GetConnectionString());
if (dataSet != null && dataSet.Tables.Count > 0)
{
return(dataSet.Tables[0]);
}
return(new DataTable());
}
public DataTable GetSupplierFuelsPricesByAdminClinetID(int adminClientId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", adminClientId));
DataSet dataSet = ExecutionHelper.ExecuteDataset("up_Select_SupplierFuelsPricesByAndAdminClientID", parameters, ExecutionHelper.GetConnectionString());
if (dataSet != null && dataSet.Tables.Count > 0)
{
return(dataSet.Tables[0]);
}
return(new DataTable());
}
public DataTable GetAircraftData()
{
List <SqlParameter> parameters = new List <SqlParameter>();
DataSet dataSet = ExecutionHelper.ExecuteDataset("up_Select_AircraftDatasAll", parameters, ExecutionHelper.GetConnectionString());
if (dataSet != null && dataSet.Tables.Count > 0)
{
return(dataSet.Tables[0]);
}
return(new DataTable());
}
