public void LoadByAiportsAndMarginsByAdminClientID(int adminClientId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", adminClientId));
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_AcukwikAirportsAndMarginsByAndAdminClientID", parameters))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
AcukwikAirports margin = new AcukwikAirports();
margin.SetProperties(reader);
margin.Countries = new AcukwikCountries();
margin.Countries.SetProperties(reader);
margin.AirportPriceMargins = new AirportPriceMargins();
margin.AirportPriceMargins.SetProperties(reader);
//margin.FBOPriceMargins = new FBOPriceMargins();
//margin.FBOPriceMargins.SetProperties(reader);
Add(margin);
}
}
}
public void Update()
{
ArrayList propertiesToOmit = new ArrayList();
propertiesToOmit.Add("Contacts");
propertiesToOmit.Add("CustomerNotes");
propertiesToOmit.Add("Users");
propertiesToOmit.Add("Aircrafts");
propertiesToOmit.Add("PriceMargin");
propertiesToOmit.Add("CustomerPriceMargin");
propertiesToOmit.Add("PriceMarginTier");
propertiesToOmit.Add("PrimaryContact");
propertiesToOmit.Add("CustomerPriceMarginID");
propertiesToOmit.Add("MarginSetting");
propertiesToOmit.Add("MarginResult");
propertiesToOmit.Add("FleetSize");
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_CustomerDetail", GetSQLParameters(propertiesToOmit)))
{
if (reader == null)
{
return;
}
if (reader.Read())
{
SetProperties(reader);
}
}
}
public void LoadByCustClientIDForAllVendors(int custClientID, int adminClientID, string icao)
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Load_PricingForAllVendors", GetParametersForPriceLoading(custClientID, adminClientID, icao)))
{
AddPriceMarginsFromReader(reader);
}
}
public void LoadByAdminClientID(int clientId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", clientId));
using (
SqlDataReader reader =
ExecutionHelper.ExecuteReader("up_Select_CustomerDetailsByAndAdminClientID", parameters))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
CustomerDetails detail = new CustomerDetails();
detail.SetProperties(reader);
//detail.Aircrafts = new AircraftsCollection();
//detail.Aircrafts.LoadByCustClientID(detail.CustClientID);
detail.CustomerPriceMargin = new CustomerPriceMargins();
detail.CustomerPriceMargin.SetProperties(reader);
detail.PriceMargin = new PriceMargins();
detail.PriceMargin.SetProperties(reader);
detail.PriceMarginTier = new PriceMarginTiers();
detail.PriceMarginTier.SetProperties(reader);
Add(detail);
}
}
}
public void Update()
{
ArrayList propertiesToOmit = new ArrayList();
propertiesToOmit.Add("FBOPhone");
propertiesToOmit.Add("HasAttachments");
propertiesToOmit.Add("PPG");
propertiesToOmit.Add("DateAdded");
propertiesToOmit.Add("IsFromFuelerLinx");
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_FuelOrder", GetSQLParameters(propertiesToOmit)))
{
if (reader == null)
{
return;
}
if (reader.Read())
{
SetProperties(reader);
}
}
if (!IsFromFuelerLinx)
{
SyncDataWithFuelerLinx();
}
}
public void LoadRemainingByClientID(int adminId, int clientId, string fbo, string icao)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ICAO", icao));
parameters.Add(new SqlParameter("@FBO", fbo));
parameters.Add(new SqlParameter("@AdminClientID", adminId));
parameters.Add(new SqlParameter("@CustClientID", clientId));
using (
SqlDataReader reader =
ExecutionHelper.ExecuteReader("up_Select_Aircrafts_RemainingByCustClientID", parameters))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
Aircrafts aircraft = new Aircrafts();
aircraft.SetProperties(reader);
aircraft.MakeAndModel = new AircraftData(/*aircraft.MakeModelID*/);
aircraft.MakeAndModel.SetProperties(reader);
Add(aircraft);
}
}
}
public void LoadByAdminClientID(int adminClientId, DateTime startDate, DateTime endDate)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", adminClientId));
parameters.Add(new SqlParameter("@StartDate", startDate));
parameters.Add(new SqlParameter("@EndDate", endDate));
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_FuelOrdersByAndAdminClientID", parameters))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
FuelOrders fuelOrder = new FuelOrders();
fuelOrder.SetProperties(reader);
fuelOrder.Aircraft = new Aircrafts();
fuelOrder.Aircraft.SetProperties(reader);
fuelOrder.Client = new Clients();
fuelOrder.Client.SetProperties(reader);
Add(fuelOrder);
}
}
}
//public void Update()
//{
// using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_Login", GetSQLParameters()))
// {
// if (reader == null)
// return;
// if (reader.Read())
// SetProperties(reader);
// }
//}
#endregion
#region Private Methods
private Users AuthenticateUser()
{
Users result = new Users();
List <SqlParameter> Params = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@Username", Username);
Params.Add(Param);
Param = new SqlParameter("@Password", Password);
Params.Add(Param);
Param = new SqlParameter("@Domain", Degatech.Utilities.Data.Utilities.Domain());
Params.Add(Param);
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_LoginByUsernameAndPassword", Params))
{
if (!ConnectionHelper.IsReadingOneRowSuccessful(reader))
{
return(result);
}
result.SetProperties(reader);
}
if (result.Id == 0)
{
return(result);
}
result.Client = Clients.GetClient(result.ClientID);
result.Registration = Registration.GetRegistration(result.RegistrationID);
return(result);
}
public void GetFBODetailsByICAO_FBO_Admin(string icao, string fbo, int clientId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ICAO", icao));
parameters.Add(new SqlParameter("@FBO", fbo));
parameters.Add(new SqlParameter("@AdminClientID", clientId));
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_FBODetailsByAndICAOAndFBOAndAdminClientID", parameters))
{
if (reader == null)
{
return;
}
if (reader.Read())
{
//SetProperties(reader);
//AcukwikFBO = new AcukwikFBOHandlerDetail();
//AcukwikFBO.SetProperties(reader);
//Airports = new AcukwikAirports();
//CustomFields = new FBODetailCustomFieldsCollection();
//CustomFields.GetCustomFields(fbo, icao, clientId);
FBOPriceMargins margin = new FBOPriceMargins();
margin.SetProperties(reader);
margin.AcukwikFBO = new AcukwikFBOHandlerDetail();
margin.AcukwikFBO.SetProperties(reader);
margin.Airports = new AcukwikAirports();
margin.Airports.SetProperties(reader);
margin.CustomFields = new FBODetailCustomFieldsCollection();
margin.CustomFields.GetCustomFields(fbo, icao, clientId);
}
}
}
private static SqlDataReader GetReaderForLoading(int clientID)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ClientID", clientID));
return(ExecutionHelper.ExecuteReader("up_Transactions_FuelOrderFeesClientDefaultGet", parameters));
}
public void Load()
{
List <SqlParameter> parameters = new List <SqlParameter>();
//parameters.Add(new SqlParameter("@Id", Id));
//using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_CustomerDetail", parameters))
parameters.Add(new SqlParameter("@Id", CustClientID));
if (Users.CurrentUser.Client.ClientType == ClientTypes.Admin)
{
parameters.Add(new SqlParameter("@AdminClientId", Users.CurrentUser.ClientID));
}
else
{
parameters.Add(new SqlParameter("@Domain", Degatech.Utilities.Data.Utilities.Domain()));
}
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_CustomerDetail", parameters))
{
if (reader == null)
{
return;
}
if (reader.Read())
{
SetProperties(reader);
}
}
}
public void LoadByICAOAndFBOAndAdminClient(string icao, string fbo, int clientId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ICAO", icao));
parameters.Add(new SqlParameter("@FBO", fbo));
parameters.Add(new SqlParameter("@AdminClientID", clientId));
using (
SqlDataReader reader =
ExecutionHelper.ExecuteReader("up_Select_AircraftExclusionsByAndICAOAndFBOAndAdminClientID", parameters))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
AircraftExclusions exclusion = new AircraftExclusions();
exclusion.SetProperties(reader);
exclusion.Client = new Clients();
exclusion.Client.SetProperties(reader);
exclusion.Aircraft = new Aircrafts();
exclusion.Aircraft.SetProperties(reader);
exclusion.Aircraft.MakeAndModel = new AircraftData();
exclusion.Aircraft.MakeAndModel.SetProperties(reader);
exclusion.aircrafts = new AircraftsCollection();
exclusion.aircrafts.LoadByCustClientID(exclusion.CustClientID);
Add(exclusion);
}
}
}
private SqlDataReader GetReader()
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", _FuelOrder.AdminClientID));
parameters.Add(new SqlParameter("@Purpose", Purpose.FuelReleaseConfirmation));
return(ExecutionHelper.ExecuteReader("up_Load_EmailDispatches", parameters));
}
public void GetQuoteByLocationForAllVendors(int adminClientID, int custClientID, string icao, string tailNumber)
{
using (
SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Load_PricingForAllVendors",
GetParametersForPriceLoading(custClientID, adminClientID, icao, tailNumber)))
{
AddPricingFromReader(reader);
}
}
private void LogAttempt()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_Login", GetSQLParameters()))
{
if (ConnectionHelper.IsReadingOneRowSuccessful(reader))
{
SetProperties(reader);
}
}
}
public void Update()
{
List <SqlParameter> parameters = GetSQLParameters(GetPropertiesToOmitForUpdate());
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_CalendarEvents", parameters))
{
if (ConnectionHelper.IsReadingOneRowSuccessful(reader))
{
SetProperties(reader);
}
}
}
public void Load()
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@OID", OID));
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_CalendarEvents"))
{
if (ConnectionHelper.IsReadingOneRowSuccessful(reader))
{
LoadFromReader(reader);
}
}
}
public void Update()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_ClientFee", GetSQLParameters()))
{
if (reader == null)
{
return;
}
if (reader.Read())
{
SetProperties(reader);
}
}
}
private void GetLogoURL()
{
List <SqlParameter> Params = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@AdminClientID", SqlDbType.Int);
Param.Value = AdminClientID;
Params.Add(Param);
SqlDataReader reader = ExecutionHelper.ExecuteReader("up_DistributionEmails_GetLogoURL", Params);
while (reader.Read())
{
LogoURL = reader["LogoURL"].ToString();
}
}
public void Update()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_AcukwikFBOHandlerDetail", GetSQLParameters()))
{
if (reader == null)
{
return;
}
if (reader.Read())
{
SetProperties(reader);
}
}
}
public void Update()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_InsertUpdate_CustomerDetailAircraftExclusion", GetSQLParameters()))
{
if (reader == null)
{
return;
}
if (reader.Read())
{
SetProperties(reader);
}
}
}
public void SelectDistributionEmails()
{
List <SqlParameter> Params = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@AdminClientID", SqlDbType.Int);
Param.Value = AdminClientID;
Params.Add(Param);
if (CustClientID > 0)
{
Param = new SqlParameter("@CustClientID", SqlDbType.Int);
Param.Value = CustClientID;
Params.Add(Param);
}
PopulateDistributionEmailsSortedList(ExecutionHelper.ExecuteReader("up_DistributionEmails_Get", Params));
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_SuppliersAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
Suppliers supplier = new Suppliers();
supplier.SetProperties(reader);
Add(supplier);
}
}
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_FBODetailCustomFieldsAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
FBODetailCustomFields margin = new FBODetailCustomFields();
margin.SetProperties(reader);
Add(margin);
}
}
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_PriceMarginsAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
PriceMargins margin = new PriceMargins();
margin.SetProperties(reader);
Add(margin);
}
}
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_FuelOrderCustomerPricingsAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
FuelOrderCustomerPricings pricing = new FuelOrderCustomerPricings();
pricing.SetProperties(reader);
Add(pricing);
}
}
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_CustomerNotesAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
CustomerNotes note = new CustomerNotes();
note.SetProperties(reader);
Add(note);
}
}
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_AircraftDatasAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
AircraftData aircraft = new AircraftData();
aircraft.SetProperties(reader);
Add(aircraft);
}
}
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_AcukwikAirportsAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
AcukwikAirports airport = new AcukwikAirports();
airport.SetProperties(reader);
Add(airport);
}
}
}
public void LoadAll()
{
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_CustomerDetailsAll"))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
CustomerDetails detail = new CustomerDetails();
detail.SetProperties(reader);
Add(detail);
}
}
}
