public void UpdatePhysicalStoreStatusbyCluster(int cluster, bool IsActive)
        {
            var    physicalStore = new BLL.PhysicalStore();
            string query         =
                HCMIS.Repository.Queries.PhysicalStore.UpdateUpdatePhysicalStoreStatusbyCluster(cluster, IsActive);

            physicalStore.LoadFromRawSql(query);
        }
        public void UpdatePhysicalStoreStatusbyWarehouse(int warehouseID, bool IsActive)
        {
            var    physicalStore = new BLL.PhysicalStore();
            string query         =
                HCMIS.Repository.Queries.PhysicalStore.UpdateUpdatePhysicalStoreStatusbyWarehouse(warehouseID, IsActive);

            physicalStore.LoadFromRawSql(query);
        }
        public static DataTable GetPhysicalStoreStatus()
        {
            var    physicalStore = new BLL.PhysicalStore();
            string query         =
                HCMIS.Repository.Queries.PhysicalStore.SelectGetPhysicalStoreStatus();

            physicalStore.LoadFromRawSql(query);
            return(physicalStore.DataTable);
        }
        public static DataTable GetPhysicalStoreStatus()
        {
            var physicalStore = new BLL.PhysicalStore();
            string query =
                HCMIS.Repository.Queries.PhysicalStore.SelectGetPhysicalStoreStatus();

            physicalStore.LoadFromRawSql(query);
            return physicalStore.DataTable;
        }
        public void UpdatePhysicalStoreStatusbyWarehouse(int warehouseID,bool IsActive)
        {
            var physicalStore = new BLL.PhysicalStore();
            string query =
                HCMIS.Repository.Queries.PhysicalStore.UpdateUpdatePhysicalStoreStatusbyWarehouse(warehouseID, IsActive);

            physicalStore.LoadFromRawSql(query);
        }
        public void UpdatePhysicalStoreStatusbyCluster(int cluster, bool IsActive)
        {
            var physicalStore = new BLL.PhysicalStore();
            string query =
                HCMIS.Repository.Queries.PhysicalStore.UpdateUpdatePhysicalStoreStatusbyCluster(cluster, IsActive);

            physicalStore.LoadFromRawSql(query);
        }