public static DataTable GetInvetoryPeriodByWarehouse(int warehouseId)
{
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriodByWarehouse(warehouseId);
InventoryPeriod period = new InventoryPeriod();
period.LoadFromRawSql(query);
return period.DataTable;
}
public static bool HasUnCommited(int periodID, int activityID)
{
InventoryPeriod period = new InventoryPeriod();
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasUnCommited(periodID, activityID);
period.LoadFromRawSql(query);
return(period.Getint("Count") > 0);
}
public static DataTable GetInventoryPeriodDatesByWareHouse(int WarehouseID)
{
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInventoryPeriodDatesByWareHouse(WarehouseID);
InventoryPeriod period = new InventoryPeriod();
period.LoadFromRawSql(query);
return(period.DataTable);
}
internal static bool HasInCompleteReceives(int activityID, int physicalStoreID)
{
InventoryPeriod period = new InventoryPeriod();
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasInCompleteReceives(activityID, physicalStoreID, ReceiptConfirmationStatus.Constants.GRV_PRINTED);
period.LoadFromRawSql(query);
return(period.Getint("Count") > 0);
}
public static DataTable GetInvetoryPeriods()
{
string query =
HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriods();
InventoryPeriod period = new InventoryPeriod();
period.LoadFromRawSql(query);
return(period.DataTable);
}
public static DataTable GetInvetoryPeriods(int physicalStoreId, int?Status = null)
{
if (Status == null)
{
string query = HCMIS.Repository.Queries.InventoryPeriod.GetInvetoryPeriods(physicalStoreId);
InventoryPeriod period = new InventoryPeriod();
period.LoadFromRawSql(query);
return(period.DataTable);
}
else
{
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriods(physicalStoreId, Status);
InventoryPeriod period = new InventoryPeriod();
period.LoadFromRawSql(query);
return(period.DataTable);
}
}
public static DataTable GetInvetoryPeriods(int physicalStoreId,int? Status=null)
{
if (Status == null)
{
string query = HCMIS.Repository.Queries.InventoryPeriod.GetInvetoryPeriods(physicalStoreId);
InventoryPeriod period = new InventoryPeriod();
period.LoadFromRawSql(query);
return period.DataTable;
}
else
{
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriods(physicalStoreId, Status);
InventoryPeriod period = new InventoryPeriod();
period.LoadFromRawSql(query);
return period.DataTable;
}
}
public static bool HasUnCommited(int periodID, int activityID)
{
InventoryPeriod period = new InventoryPeriod();
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasUnCommited(periodID, activityID);
period.LoadFromRawSql(query);
return period.Getint("Count") > 0;
}
internal static bool HasInCompleteReceives(int activityID,int physicalStoreID)
{
InventoryPeriod period = new InventoryPeriod();
string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasInCompleteReceives(activityID, physicalStoreID, ReceiptConfirmationStatus.Constants.GRV_PRINTED);
period.LoadFromRawSql(query);
return period.Getint("Count") > 0;
}