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);
}
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);
}
/// <summary>
/// Gets the quaranteen pallet location.
/// </summary>
/// <returns></returns>
public static int GetQuaranteenPalletLocation(int physicalStoreID)
{
int storageType;
int.TryParse(StorageType.Quaranteen, out storageType);
var pl = new PalletLocation();
pl.LoadFromRawSql(HCMIS.Repository.Queries.PalletLocation.SelectGetQuaranteenPalletLocation(physicalStoreID, storageType));
if (pl.RowCount == 0)
{
var physicalStore = new BLL.PhysicalStore();
physicalStore.LoadByPrimaryKey(physicalStoreID);
throw new Exception(String.Format("Please Create a suspended pallet location on store: {0} ",physicalStore.Name));
}
return pl.ID;
}
