public static int TotalExpiredPicklists()
{
var query = HCMIS.Repository.Queries.PickList.SelectTotalExpiredPicklists(BLL.Settings.NoOfDaysPicklistStaysAfterPrinting);
var pickList = new BLL.PickList();
pickList.LoadFromRawSql(query);
return(pickList.RowCount);
}
public static void CancelExpiredPicklists()
{
var query = HCMIS.Repository.Queries.PickList.SelectCancelExpiredPicklists(BLL.Settings.NoOfDaysPicklistStaysAfterPrinting);
var pickList = new BLL.PickList();
pickList.LoadFromRawSql(query);
while (!pickList.EOF)
{
ReleaseReservation(pickList.OrderID, true);
pickList.MoveNext();
}
}
public static void CancelExpiredPicklists()
{
var query = HCMIS.Repository.Queries.PickList.SelectCancelExpiredPicklists(BLL.Settings.NoOfDaysPicklistStaysAfterPrinting);
var pickList = new BLL.PickList();
pickList.LoadFromRawSql(query);
while (!pickList.EOF)
{
ReleaseReservation(pickList.OrderID, true);
pickList.MoveNext();
}
}
public void CreateDetailTransactionsForErrorCorrection(Order order, BLL.PickList picklist,
Issue stvLog, int receiptPalletId, int receiptID, User user, DateTime convertedEthDate
, int newItemId, int newUnitId, int newManufacturerId, decimal pickedPack
, decimal Convertedpack, int confirmationStatusId, bool changeExpiryDate
, DateTime?ExpiryDate, bool changeBatchNo, string batchNo)
{
//Load the ReceivePallet First From that we Get the Information that We need
ReceivePallet receivePalletOriginal = new ReceivePallet();
receivePalletOriginal.LoadByPrimaryKey(receiptPalletId);
ReceiveDoc receiveDocOriginal = new ReceiveDoc();
receiveDocOriginal.LoadByPrimaryKey(receivePalletOriginal.ReceiveID);
//Load ItemUnit Detail for For ItemUnit Change;
ItemUnit newItemUnit = new ItemUnit();
newItemUnit.LoadByPrimaryKey(newUnitId);
// Generate PicklistDetail With OrderDetail information
PickListService pickListService = new PickListService();
PickListDetail pickListDetail = pickListService.CreatePicklistDetailWithOrder(receiveDocOriginal, receivePalletOriginal, order, picklist,
pickedPack);
// Generate IssueDoc from picklistDetail and substract the quantity from receiveDoc
IssueService issueService = new IssueService();
issueService.CreateIssueFromPicklist(pickListDetail, order, convertedEthDate, stvLog, user);
if (Convertedpack > 0)
{
//duplicate The ReceiveDoc and ReceiptPallet
ReceiveService receiveService = new ReceiveService();
receiveService.CloneReceiveForErrorCorrection(confirmationStatusId, receivePalletOriginal, receiveDocOriginal
, Convertedpack, user, newItemId
, receiveDocOriginal.StoreID, receiptID
, newManufacturerId, newItemUnit, convertedEthDate, changeExpiryDate, ExpiryDate, changeBatchNo, batchNo);
}
}
public static int TotalExpiredPicklists()
{
var query = HCMIS.Repository.Queries.PickList.SelectTotalExpiredPicklists(BLL.Settings.NoOfDaysPicklistStaysAfterPrinting);
var pickList = new BLL.PickList();
pickList.LoadFromRawSql(query);
return pickList.RowCount;
}