Ejemplo n.º 1
0
        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]);
        }
Ejemplo n.º 2
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());
        }
Ejemplo n.º 3
0
        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());
        }
Ejemplo n.º 4
0
        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());
        }