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