public DataTable GetDistributePricing()
{
List <SqlParameter> Params = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@AdminClientID", AdminClientID);
Params.Add(Param);
if (CustClientID > 0)
{
Param = new SqlParameter("@CustClientID", CustClientID);
Params.Add(Param);
}
if (ContactID > 0)
{
Param = new SqlParameter("@ContactID", ContactID);
Params.Add(Param);
}
if (PriceMargin > 0)
{
Param = new SqlParameter("@PriceMargin", PriceMargin);
Params.Add(Param);
}
Param = new SqlParameter("@Mode", "distribute");
Params.Add(Param);
DataSet ds = ExecutionHelper.ExecuteDataset("up_Load_Pricing", Params);
return(ds.Tables[0]);
}
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());
}
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 static DataTable GetCustomersByAdminClientID(int clientId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", clientId));
DataSet resultSet = ExecutionHelper.ExecuteDataset("up_Select_CustomerDetailsByAndAdminClientID", parameters);
if (resultSet.Tables.Count > 0)
{
return(resultSet.Tables[0]);
}
return(null);
}
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());
}