コード例 #1
0
 public void Inititalize()
 {
     warehouseEngine = new WarehouseEngine(warehouse_username, warehouse_password, warehouse_host, warehouse_port, warehouse_database);
 }
コード例 #2
0
        static void DoWork()
        {
            switch (applicationConfig.Action.ToLower())
            {
                case "makewarehousesales":
                    log.Info("Calling makewarehousesales");

                    Init();

                    BiotrackEngine reporting = new BiotrackEngine(programConfig.username, programConfig.password, programConfig.host, programConfig.port, programConfig.database);
                    WarehouseEngine warehouse = new WarehouseEngine(programConfig.warehouse_username, programConfig.warehouse_password, programConfig.warehouse_host, programConfig.warehouse_port);
                    warehouse = WarehouseEngine.GetWarehouse(warehouse, true);

                    SyncFoundation();

                    var inputStartTime = applicationConfig.Options[0].Split('=')[1];                    
                    var inputEndTime = applicationConfig.Options[1].Split('=')[1];

                    log.Info(string.Format("starttime => {0}, endtime => {1}", inputStartTime, inputEndTime));
                    var data = reporting.MakeSalesWarehouse(inputStartTime, inputEndTime);
                    var syncedrows = warehouse.InsertSalesWarehouseData((List<SalesWarehouseRow>)data);

                    var syncrow = new SyncRow { Success = true, Tablename = "saleswarehouse", Timestamp = DateTime.UtcNow, RowsSynced = syncedrows };
                    warehouse.InsertSyncRow(syncrow);

                    break;
                case "makewarehouseinventory":
                    log.Info("Calling makewarehouseinventory");

                    Init();
                    reporting = new BiotrackEngine(programConfig.username, programConfig.password, programConfig.host, programConfig.port, programConfig.database);
                    warehouse = new WarehouseEngine(programConfig.warehouse_username, programConfig.warehouse_password, programConfig.warehouse_host, programConfig.warehouse_port);

                    break;
                case "deletedatabase":
                    log.Info("Calling deletedatabase");

                    Init();
                    warehouse = new WarehouseEngine(programConfig.warehouse_username, programConfig.warehouse_password, programConfig.warehouse_host, programConfig.warehouse_port);
                    warehouse.DropWarehouseDatabase();

                    break;
                case "applyconfig":
                    log.Info("Calling config");
                    ApplyConfiguration(applicationConfig);
                    break;
                default:
                    ShowHelp();
                    break;
            }
        }
コード例 #3
0
 public void TestInitialize()
 {
     biotrackEngine = new BiotrackEngine(username, password, host, port, database);
     warehouseEngine = new WarehouseEngine(warehouse_username, warehouse_password, warehouse_host, warehouse_port, warehouse_database);
 }
コード例 #4
0
        private static void SyncFoundation()
        {
            var warehouse = new WarehouseEngine(programConfig.warehouse_username, programConfig.warehouse_password, programConfig.warehouse_host, programConfig.warehouse_port);
            var database = new DatabaseEngine(programConfig.username, programConfig.password, programConfig.host, programConfig.port, programConfig.database);

            using (var wh_session = warehouse.GetSession())
            {
                // products            
                var products = database.GetProducts();
                foreach (var product in products)
                {
                    var wh_product = (wh_products)product;
                    wh_session.Replicate(wh_product, replicationMode: NHibernate.ReplicationMode.Overwrite);
                }
                wh_session.Flush();

                // product categories
                var productCategories = database.GetProductCategories();
                foreach (var category in productCategories)
                {
                    var wh_productcategory = (wh_productcategory)category;
                    wh_session.Replicate(wh_productcategory, replicationMode: NHibernate.ReplicationMode.Overwrite);
                }
                wh_session.Flush();

                // locations
                var locations = database.GetLocations();
                foreach (var location in locations)
                {
                    var wh_location = (wh_location)location;
                    wh_session.Replicate(wh_location, replicationMode: NHibernate.ReplicationMode.Overwrite);
                }

                wh_session.Flush();

                // vendors
                var vendors = database.GetVendors();
                foreach (var vendor in vendors)
                {
                    var wh_vendor = (wh_Vendors)vendor;
                    wh_session.Replicate(wh_vendor, replicationMode: NHibernate.ReplicationMode.Overwrite);
                }

                wh_session.Flush();

                // customers
                var customers = database.GetCustomers();
                foreach (var customer in customers)
                {
                    var wh_customer = (wh_customers)customer;
                    wh_session.Replicate(wh_customer, replicationMode: NHibernate.ReplicationMode.Overwrite);
                }

                wh_session.Flush();
            }
        }