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