/// <summary>
        /// Register checking returned instrument.<br />
        /// - Check system suspending.<br />
        /// - Check quantity.<br />
        /// - Register transfer instrument.<br />
        /// - Update account transfer new/second hand/sample instrument.<br />
        /// - Generate report.
        /// </summary>
        /// <returns></returns>
        public ActionResult IVS140_Confirm()
        {
            string slipNo                = string.Empty;
            string slipNoReportPath      = string.Empty;
            IVS140_ScreenParameter param = GetScreenObject <IVS140_ScreenParameter>();
            IVS140_RegisterData    data  = new IVS140_RegisterData();

            if (param != null)
            {
                data = param.RegisterData;
            }

            ObjectResultData res = new ObjectResultData();

            res.MessageType = MessageModel.MESSAGE_TYPE.WARNING;

            try
            {
                IInventoryHandler handlerInventory = ServiceContainer.GetService <IInventoryHandler>() as IInventoryHandler;
                ICommonHandler    handlerCommon    = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler;

                // Is suspend ?
                if (handlerCommon.IsSystemSuspending())
                {
                    res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION;
                    res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0049);
                    return(Json(res));
                }

                //Business validate
                //int countBusinessWaringing = 0;
                foreach (var item in data.Detail)
                {
                    doCheckTransferQty doCheck = new doCheckTransferQty()
                    {
                        OfficeCode     = param.HeaderOffice[0].OfficeCode,
                        LocationCode   = InstrumentLocation.C_INV_LOC_RETURNED,
                        AreaCode       = item.AreaCode,
                        ShelfNo        = item.ShelfNo,
                        InstrumentCode = item.Instrumentcode,
                        TransferQty    = item.FixedReturnQty.HasValue ? item.FixedReturnQty.Value : 0
                    };


                    doCheckTransferQtyResult result = handlerInventory.CheckTransferQty(doCheck);

                    item.InstrumentQty = result.CurrentyQty;

                    if (result.OverQtyFlag == null)
                    {
                        res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION;
                        res.AddErrorMessage(MessageUtil.MODULE_INVENTORY, MessageUtil.MessageList.MSG4009
                                            , new string[] { item.Instrumentcode }
                                            , new string[] { item.txtFixedReturnQtyID });
                        res.ResultData = new
                        {
                            IsSuccess = false,
                            Data      = data
                        };
                        return(Json(res));
                        //countBusinessWaringing++;
                    }
                    else if (result.OverQtyFlag == true)
                    {
                        res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION;
                        res.AddErrorMessage(MessageUtil.MODULE_INVENTORY, MessageUtil.MessageList.MSG4008
                                            , new string[] { item.Instrumentcode }
                                            , new string[] { item.txtFixedReturnQtyID });
                        res.ResultData = new
                        {
                            IsSuccess = false,
                            Data      = data
                        };
                        return(Json(res));
                        //countBusinessWaringing++;
                    }
                }
                //if (countBusinessWaringing > 0)
                //{
                //    return Json(res);
                //}


                // Prepare data for Register
                doRegisterTransferInstrumentData dsRegisterData = new doRegisterTransferInstrumentData();

                dsRegisterData.SlipId        = SlipID.C_INV_SLIPID_CHECKING_RETURNED;
                dsRegisterData.InventorySlip = new tbt_InventorySlip()
                {
                    SlipStatus              = InventorySlipStatus.C_INV_SLIP_STATUS_COMPLETE,
                    TransferTypeCode        = TransferType.C_INV_TRANSFERTYPE_CHECKING_RETURNED,
                    SlipIssueDate           = DateTime.Now,
                    StockInDate             = DateTime.Now,
                    StockOutDate            = DateTime.Now,
                    SourceLocationCode      = InstrumentLocation.C_INV_LOC_RETURNED,
                    DestinationLocationCode = InstrumentLocation.C_INV_LOC_INSTOCK,
                    SourceOfficeCode        = param.HeaderOffice[0].OfficeCode,
                    DestinationOfficeCode   = param.HeaderOffice[0].OfficeCode,
                    ApproveNo  = data.Header.ApproveNo,
                    Memo       = data.Header.Memo,
                    ShelfType  = ShelfType.C_INV_SHELF_TYPE_NORMAL,
                    CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime,
                    CreateBy   = CommonUtil.dsTransData.dtUserData.EmpNo,
                    UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime,
                    UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo
                };

                dsRegisterData.lstTbt_InventorySlipDetail = new List <tbt_InventorySlipDetail>();
                tbt_InventorySlipDetail detail;
                for (int i = 0; i < data.Detail.Count; i++)
                {
                    detail = new tbt_InventorySlipDetail()
                    {
                        RunningNo           = (i + 1),
                        InstrumentCode      = data.Detail[i].Instrumentcode,
                        SourceAreaCode      = data.Detail[i].AreaCode,
                        DestinationAreaCode = data.Detail[i].AreaCode,
                        SourceShelfNo       = data.Detail[i].ShelfNo,
                        DestinationShelfNo  = ShelfNo.C_INV_SHELF_NO_NOT_MOVE_SHELF,
                        TransferQty         = data.Detail[i].FixedReturnQty
                    };

                    dsRegisterData.lstTbt_InventorySlipDetail.Add(detail);
                }

                // TODO: (Narupon) Uncomment for use TransactionScope

                // Save data to database..
                using (TransactionScope scope = new TransactionScope())
                {
                    try
                    {
                        // Register Inventory Tranfer data
                        string slipNo_result = handlerInventory.RegisterTransferInstrument(dsRegisterData);
                        slipNo       = slipNo_result;
                        param.SlipNo = slipNo_result;

                        // Check New instrument -- 8.5
                        int bCheckingNewInstrument = handlerInventory.CheckNewInstrument(slipNo_result);
                        if (bCheckingNewInstrument == 1)
                        {
                            List <doGroupNewInstrument> dtGroupNewInstrument = handlerInventory.GetGroupNewInstrument(slipNo_result);
                            foreach (var item in dtGroupNewInstrument)
                            {
                                #region Monthly Price @ 2015
                                //decimal decMovingAveragePrice = handlerInventory.CalculateMovingAveragePrice(item);
                                decimal decMovingAveragePrice = handlerInventory.GetMonthlyAveragePrice(item.Instrumentcode, dsRegisterData.InventorySlip.SlipIssueDate, InventoryAccountCode.C_INV_ACCOUNT_CODE_INSTOCK, SECOM_AJIS.Common.Util.ConstantValue.CurrencyUtil.C_CURRENCY_LOCAL, SECOM_AJIS.Common.Util.ConstantValue.CurrencyUtil.C_CURRENCY_US);
                                #endregion
                                handlerInventory.UpdateAccountTransferNewInstrument(item, decMovingAveragePrice);
                            }
                        }

                        // Check secondhand instrument -- 8.6
                        int bCheckSeconhandInstrument = handlerInventory.CheckSecondhandInstrument(slipNo_result);
                        if (bCheckSeconhandInstrument == 1)
                        {
                            List <doGroupSecondhandInstrument> dtGroupSecondhandInstrument = handlerInventory.GetGroupSecondhandInstrument(slipNo_result);
                            foreach (var item in dtGroupSecondhandInstrument)
                            {
                                handlerInventory.UpdateAccountTransferSecondhandInstrument(item);
                            }
                        }


                        // Check sample instrument -- 8.6
                        int bCheckSampleInstrument = handlerInventory.CheckSampleInstrument(slipNo_result);
                        if (bCheckSampleInstrument == 1)
                        {
                            List <doGroupSampleInstrument> dtGroupSampleInstrument = handlerInventory.GetGroupSampleInstrument(slipNo_result);
                            foreach (var item in dtGroupSampleInstrument)
                            {
                                handlerInventory.UpdateAccountTransferSampleInstrument(item, null);
                            }
                        }

                        // Generate inventory slip report  // ReportID.C_INV_REPORT_ID_CHECKING_RETURNED = IVR090
                        IInventoryDocumentHandler handlerInventoryDocument = ServiceContainer.GetService <IInventoryDocumentHandler>() as IInventoryDocumentHandler;
                        slipNoReportPath = handlerInventoryDocument.GenerateIVR090FilePath(slipNo_result, param.HeaderOffice[0].OfficeCode, CommonUtil.dsTransData.dtUserData.EmpNo, CommonUtil.dsTransData.dtOperationData.ProcessDateTime);


                        scope.Complete(); // Commit transtion.
                    }
                    catch (Exception ex)
                    {
                        scope.Dispose();
                        throw ex;
                    }
                }
                // TODO: (Narupon) Uncomment for use TransactionScope

                param.SlipNoReportPath = slipNoReportPath;

                res.ResultData = new
                {
                    IsSuccess = true,
                    Data      = data,
                    SlipNo    = slipNo
                };
            }
            catch (Exception ex)
            {
                res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION;
                res.AddErrorMessage(ex);
            }

            return(Json(res));
        }