Пример #1
0
        /// <summary>
        /// Insert group
        /// </summary>
        /// <param name="doInsert"></param>
        /// <returns></returns>
        public List <tbm_Group> InsertGroup(doGroup doInsert)
        {
            try
            {
                //set CreateDate, CreateBy, UpdateDate and UpdateBy
                doInsert.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                doInsert.CreateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                doInsert.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                doInsert.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;

                List <tbm_Group> insertList = base.InsertGroup(
                    doInsert.GroupCode
                    , doInsert.GroupNameEN
                    , doInsert.GroupNameLC
                    , doInsert.Memo
                    , doInsert.GroupOfficeCode
                    , doInsert.GroupEmpNo
                    , doInsert.DeleteFlag
                    , doInsert.CreateDate
                    , doInsert.CreateBy
                    , doInsert.UpdateDate
                    , doInsert.UpdateBy);

                //Insert Log
                if (insertList.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Insert;
                    logData.TableName       = TableName.C_TBL_NAME_GROUP;
                    logData.TableData       = CommonUtil.ConvertToXml(insertList);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(insertList);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #2
0
        public List <doSubcontractor> UpdateSubcontractor(doSubcontractor data)
        {
            try
            {
                List <doSubcontractor> curSubcontractor = GetSubcontractor(data.SubContractorCode, null, null, null);
                if (!(curSubcontractor.Count > 0) || DateTime.Compare(curSubcontractor[0].UpdateDate.Value, data.UpdateDate.Value) != 0)
                {
                    throw new Exception(MessageUtil.GetMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0019, null).Message);
                }
                data.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                data.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                List <doSubcontractor> updateList = new List <doSubcontractor>();
                updateList.Add(data);

                string xml = CommonUtil.ConvertToXml_Store(updateList);

                List <doSubcontractor> listUpdated = null;
                using (TransactionScope t = new TransactionScope())
                {
                    listUpdated = base.UpdateSubcontractor(xml);

                    doTransactionLog logData = new doTransactionLog()
                    {
                        TransactionType = doTransactionLog.eTransactionType.Update,
                        TableName       = TableName.C_TBL_NAME_SUBCONTRACTOR,
                        TableData       = CommonUtil.ConvertToXml(listUpdated)
                    };

                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);

                    t.Complete();
                }

                return(listUpdated);
            }
            catch (Exception)
            {
                throw;
            }
        }
        //ICP010
        //Comment by phumipat 4/May/2012 : No need logging for batch process
        //public override List<tbt_Receipt> InsertTbt_Receipt(string xmlTbt_Receipt)
        //{
        //    ILogHandler logHand = ServiceContainer.GetService<ILogHandler>() as ILogHandler;
        //    List<tbt_Receipt> saved = base.InsertTbt_Receipt(xmlTbt_Receipt);
        //    doTransactionLog logData = new doTransactionLog()
        //    {
        //        TransactionType = doTransactionLog.eTransactionType.Insert,
        //        TableName = TableName.C_TBL_NAME_RECEIPT,
        //        TableData = null
        //    };
        //    logData.TableData = CommonUtil.ConvertToXml(saved);
        //    logHand.WriteTransactionLog(logData);
        //    return saved;
        //}

        /// <summary>
        /// Function for insert receipt information to the system.
        /// </summary>
        /// <param name="receipts">receipt information</param>
        /// <returns></returns>
        public List <tbt_Receipt> InsertTbt_Receipt(List <tbt_Receipt> receipts, bool isWriteTransLog = true) //Add (isWriteTransLog) by Jutarat A. on 07062013
        {
            //Modify by Jutarat A. on 30052013
            //return InsertTbt_Receipt(CommonUtil.ConvertToXml_Store<tbt_Receipt>(receipts));
            List <tbt_Receipt> insertList = InsertTbt_Receipt(CommonUtil.ConvertToXml_Store <tbt_Receipt>(receipts));

            if (insertList != null && insertList.Count > 0)
            {
                if (isWriteTransLog) //Add (isWriteTransLog) by Jutarat A. on 07062013
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Insert;
                    logData.TableName       = TableName.C_TBL_NAME_RECEIPT;
                    logData.TableData       = CommonUtil.ConvertToXml(insertList);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }
            }
            return(insertList);
            //End Modify
        }
Пример #4
0
        /// <summary>
        /// Cancel tax invoice by marking cancel flag.
        /// </summary>
        /// <param name="taxtInvoiceNo"></param>
        /// <returns></returns>
        public bool CancelTaxInvoice(string taxtInvoiceNo)
        {
            List <tbt_TaxInvoice> result = base.CancelTaxInvoice(taxtInvoiceNo
                                                                 , CommonUtil.dsTransData.dtUserData.EmpNo
                                                                 , CommonUtil.dsTransData.dtOperationData.ProcessDateTime);

            if (result != null && result.Count > 0)
            {
                ILogHandler      logHand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_TAX_INVOICE,
                    TableData       = null
                };
                logData.TableData = CommonUtil.ConvertToXml(result);
                logHand.WriteTransactionLog(logData);
                return(true);
            }
            return(false);
        }
Пример #5
0
        //ICS020
        /// <summary>
        /// Update auto transfer account last result from auto transfer import file.
        /// </summary>
        /// <param name="invoiceNo"></param>
        /// <param name="lastestResult"></param>
        /// <returns></returns>
        public bool UpdateAutoTransferAccountLastResult(string invoiceNo, string lastestResult)
        {
            List <tbt_AutoTransferBankAccount> result = base.UpdateAutoTransferAccountLastResult(invoiceNo, lastestResult
                                                                                                 , CommonUtil.dsTransData.dtUserData.EmpNo
                                                                                                 , CommonUtil.dsTransData.dtOperationData.ProcessDateTime);

            if (result != null && result.Count > 0)
            {
                ILogHandler      logHand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_AUTO_TRANSFER_ACC,
                    TableData       = null
                };
                logData.TableData = CommonUtil.ConvertToXml(result);
                logHand.WriteTransactionLog(logData);
                return(true);
            }
            return(false);
        }
        /// <summary>
        /// Update receipt status back when the payment is deleted. (sp_IC_UpdateAdvanceReceiptDeletePayment)
        /// </summary>
        /// <param name="receiptNo">receipt no.</param>
        /// <returns></returns>
        public bool UpdateAdvanceReceiptDeletePayment(string receiptNo)
        {
            List <tbt_Receipt> result = base.UpdateAdvanceReceiptDeletePayment(receiptNo, AdvanceReceiptStatus.C_INC_ADVANCE_RECEIPT_STATUS_ISSUED
                                                                               , CommonUtil.dsTransData.dtUserData.EmpNo
                                                                               , CommonUtil.dsTransData.dtOperationData.ProcessDateTime);

            if (result != null && result.Count > 0)
            {
                ILogHandler      logHand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_RECEIPT,
                    TableData       = null
                };
                logData.TableData = CommonUtil.ConvertToXml(result);
                logHand.WriteTransactionLog(logData);
                return(true);
            }
            return(false);
        }
Пример #7
0
        /// <summary>
        /// Insert contract email data
        /// </summary>
        /// <param name="listEmail"></param>
        /// <returns></returns>
        public int InsertTbt_ContractEmail(List <tbt_ContractEmail> listEmail)
        {
            try
            {
                if (listEmail != null)
                {
                    dsTransDataModel dsTrans = CommonUtil.dsTransData;
                    foreach (tbt_ContractEmail relationType in listEmail)
                    {
                        relationType.CreateDate = dsTrans.dtOperationData.ProcessDateTime;
                        relationType.CreateBy   = dsTrans.dtUserData.EmpNo;
                        relationType.UpdateDate = dsTrans.dtOperationData.ProcessDateTime;
                        relationType.UpdateBy   = dsTrans.dtUserData.EmpNo;
                    }
                }

                List <tbt_ContractEmail> res = this.InsertTbt_ContractEmail(
                    CommonUtil.ConvertToXml_Store <tbt_ContractEmail>(listEmail));

                #region Log

                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Insert,
                    TableName       = TableName.C_TBL_NAME_CON_EMAIL,
                    TableData       = CommonUtil.ConvertToXml(res)
                };

                ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                hand.WriteTransactionLog(logData);

                #endregion

                return(res.Count);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #8
0
        /// <summary>
        /// Insert draft sale email
        /// </summary>
        /// <param name="draftLst"></param>
        /// <returns></returns>
        private int InsertTbt_DraftSaleEmail(List <tbt_DraftSaleEmail> draftLst)
        {
            try
            {
                if (draftLst != null)
                {
                    dsTransDataModel dsTrans = CommonUtil.dsTransData;
                    foreach (tbt_DraftSaleEmail draft in draftLst)
                    {
                        draft.CreateDate = dsTrans.dtOperationData.ProcessDateTime;
                        draft.CreateBy   = dsTrans.dtUserData.EmpNo;
                        draft.UpdateDate = dsTrans.dtOperationData.ProcessDateTime;
                        draft.UpdateBy   = dsTrans.dtUserData.EmpNo;
                    }
                }

                List <tbt_DraftSaleEmail> res = this.InsertTbt_DraftSaleEmail(
                    CommonUtil.ConvertToXml_Store <tbt_DraftSaleEmail>(draftLst));

                #region Log

                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Insert,
                    TableName       = TableName.C_TBL_NAME_DRF_SALE_EMAIL,
                    TableData       = CommonUtil.ConvertToXml(res)
                };

                ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                hand.WriteTransactionLog(logData);

                #endregion

                return(res.Count);
            }
            catch (Exception)
            {
                throw;
            }
        }
        // Add By Sommai P., Oct 29, 2013
        /// <summary>
        /// Update Encashed flag of payment transaction of specific payment transaction no. (sp_IC_UpdatePaymentEncashFlag)
        /// </summary>
        /// <param name="paymentTransNo">payment transaction no.</param>
        /// <param name="bankFeeFlag">Eencashed flag</param>
        /// <returns></returns>
        public bool UpdatePaymentEncashFlag(doPaymentEncashParam param)
        {
            List <tbt_Payment> result = base.UpdatePaymentEncashFlag(
                param.PaymentTransNo,
                param.EncashedFlagByte,
                param.ChequeReturnDate,
                param.ChequeReturnReason,
                param.ChequeReturnRemark,
                param.ChequeEncashRemark,
                CommonUtil.dsTransData.dtUserData.EmpNo,
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime
                );

            if (result != null && result.Count > 0)
            {
                //using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Suppress))
                //{
                //    try
                //    {
                ILogHandler      logHand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_PAYMENT,
                    TableData       = null
                };
                logData.TableData = CommonUtil.ConvertToXml(result);
                logHand.WriteTransactionLog(logData);
                //scope.Complete();
                return(true);
                //}
                //catch
                //{
                //    scope.Dispose();
                //    return false;
                //}
                //}
            }
            return(false);
        }
Пример #10
0
        ///<summary>
        ///Purpose:
        ///     Check mandatory filelds.
        ///
        ///Parameters:
        ///     doTransactionLog:
        ///         TransactionType: doTransactionLog.eTransactionType.Insert
        ///         TableName: NULL
        ///         TableData: ""
        ///
        ///Expected:
        ///     MSG0007: "This field was required: TableName."
        ///</summary>
        public string Case2()
        {
            ILogHandler      target = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
            doTransactionLog param  = new doTransactionLog();

            param.TransactionType = doTransactionLog.eTransactionType.Insert;
            param.TableName       = null;
            param.TableData       = "";

            string expected = "MSG0007";
            string actual   = null;

            try {
                target.WriteTransactionLog(param);
            } catch (ApplicationErrorException ex) {
                actual = ex.ErrorResult.Message.Code;
            } catch (Exception ex) {
                actual = ex.StackTrace;
            }

            return(string.Format(RESULT_FORMAT, 2, expected, actual, CompareResult_String(expected, actual)));
        }
Пример #11
0
        //ICS060
        /// <summary>
        /// Update clear receipt no., invoice no of deposit fee transaction.
        /// </summary>
        /// <param name="invoiceNo"></param>
        /// <param name="receiptNo"></param>
        /// <param name="batchId"></param>
        /// <param name="batchDate"></param>
        /// <returns></returns>
        public bool UpdateReceiptNoDepositFeeCancelReceipt(string invoiceNo, string receiptNo, string batchId, DateTime batchDate)
        {
            List <tbt_Depositfee> result = base.UpdateReceiptNoDepositFeeCancelReceipt(invoiceNo, receiptNo
                                                                                       , batchId
                                                                                       , batchDate
                                                                                       , DepositStatus.C_DEPOSIT_STATUS_PAYMENT);

            if (result != null && result.Count > 0)
            {
                ILogHandler      logHand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_DEPOSIT_FEE,
                    TableData       = null
                };
                logData.TableData = CommonUtil.ConvertToXml(result);
                logHand.WriteTransactionLog(logData);
                return(true);
            }
            return(false);
        }
Пример #12
0
        /// <summary>
        /// Update project stockout instrument
        /// </summary>
        /// <param name="doUpdate"></param>
        /// <returns></returns>
        public List <tbt_ProjectStockoutInstrument> UpdateTbt_ProjectStockoutInstrument(tbt_ProjectStockoutInstrument doUpdate)
        {
            try
            {
                //Check whether this record is the most updated data
                List <tbt_ProjectStockoutInstrument> rList = this.GetTbt_ProjectStockoutInstrument(doUpdate.ProjectCode, doUpdate.InstrumentCode);
                //if (rList[0].UpdateDate != doUpdate.UpdateDate)
                if (rList[0].UpdateDate != null && doUpdate.UpdateDate != null && DateTime.Compare(rList[0].UpdateDate.Value, doUpdate.UpdateDate.Value) != 0)
                {
                    throw ApplicationErrorException.ThrowErrorException(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0019);
                }

                //set updateDate and updateBy
                doUpdate.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                doUpdate.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;

                List <tbt_ProjectStockoutInstrument> doUpdateList = new List <tbt_ProjectStockoutInstrument>();
                doUpdateList.Add(doUpdate);
                List <tbt_ProjectStockoutInstrument> updatedList = base.UpdateTbt_ProjectStockoutInstrument(CommonUtil.ConvertToXml_Store <tbt_ProjectStockoutInstrument>(doUpdateList));

                //Insert Log
                if (updatedList.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Update;
                    logData.TableName       = TableName.C_TBL_NAME_PROJ_STOCKOUT_INST;
                    logData.TableData       = CommonUtil.ConvertToXml(updatedList);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(updatedList);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #13
0
        /// <summary>
        /// Update draft sale contract
        /// </summary>
        /// <param name="draft"></param>
        /// <returns></returns>
        public int UpdateTbt_DraftSaleContract(tbt_DraftSaleContract draft)
        {
            try
            {
                List <tbt_DraftSaleContract> draftLst = new List <tbt_DraftSaleContract>();
                if (draft != null)
                {
                    dsTransDataModel dsTrans = CommonUtil.dsTransData;
                    draft.UpdateDate = dsTrans.dtOperationData.ProcessDateTime;
                    draft.UpdateBy   = dsTrans.dtUserData.EmpNo;

                    draftLst.Add(draft);
                }

                List <tbt_DraftSaleContract> res = this.UpdateTbt_DraftSaleContract(
                    CommonUtil.ConvertToXml_Store <tbt_DraftSaleContract>(draftLst));

                #region Log

                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_DRF_RNT_CONTRACT,
                    TableData       = CommonUtil.ConvertToXml(res)
                };

                ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                hand.WriteTransactionLog(logData);

                #endregion

                return(res.Count);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #14
0
        /// <summary>
        /// Insert project stockout branch instrument detail
        /// </summary>
        /// <param name="lst"></param>
        /// <returns></returns>
        public List <tbt_ProjectStockoutBranchIntrumentDetails> InsertTbt_ProjectStockoutBranchIntrumentDetails(List <tbt_ProjectStockoutBranchIntrumentDetails> lst)
        {
            foreach (tbt_ProjectStockoutBranchIntrumentDetails i in lst)
            {
                i.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                i.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                i.CreateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                i.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
            }
            List <tbt_ProjectStockoutBranchIntrumentDetails> Inserted = base.InsertTbt_ProjectStockoutBranchIntrumentDetails(CommonUtil.ConvertToXml_Store <tbt_ProjectStockoutBranchIntrumentDetails>(lst));

            // Transaction log
            if (Inserted.Count > 0)
            {
                ILogHandler      logH = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog log  = new doTransactionLog();
                log.TableName       = TableName.C_TBL_NAME_PRJ_BRA_STOCKOUT;
                log.TransactionType = doTransactionLog.eTransactionType.Insert;
                log.TableData       = CommonUtil.ConvertToXml_Store <tbt_ProjectStockoutBranchIntrumentDetails>(Inserted);
                logH.WriteTransactionLog(log);
            }
            return(Inserted);
        }
Пример #15
0
        /// <summary>
        /// Delete money collection information of specific receipt no. (sp_IC_DeleteTbt_MoneyCollectionInfo)
        /// </summary>
        /// <param name="ReceiptNo">receipt no.</param>
        /// <returns></returns>
        public List <tbt_MoneyCollectionInfo> DeleteTbt_MoneyCollectionInfo(string ReceiptNo)
        {
            try
            {
                List <tbt_MoneyCollectionInfo> result = base.DeleteTbt_MoneyCollectionInfo(ReceiptNo);
                //Insert Log
                if (result.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Delete;
                    logData.TableName       = TableName.C_TBL_NAME_MONEY_COLLECTION_INFO;
                    logData.TableData       = CommonUtil.ConvertToXml(result);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(result);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #16
0
        /// <summary>
        /// For change billing target from CTS130: CP-16 change customer name and address
        /// </summary>
        /// <param name="strContractCode"></param>
        /// <param name="strOldBillingClientCode"></param>
        /// <param name="strOldBillingOfficeCode"></param>
        /// <param name="strOldBillingTargetCode"></param>
        /// <param name="strNewBillingClientCode"></param>
        /// <param name="strNewBillingOfficeCode"></param>
        /// <param name="strNewBillingTargetCode"></param>
        /// <returns></returns>
        public List <tbt_BillingTemp> UpdateBillingTempByBillingTarget(string ContractCode, string strOldBillingClientCode, string strOldBillingOfficeCode, string strOldBillingTargetCode, string strNewBillingClientCode, string strNewBillingOfficeCode, string strNewBillingTargetCode)
        {
            try
            {
                //Validate data input
                //1.1	ContractCode is required.
                doBillingTempData billing = new doBillingTempData();
                billing.ContractCode = ContractCode;
                ApplicationErrorException.CheckMandatoryField(billing);

                //Update data to DB
                List <tbt_BillingTemp> updatedList
                    = base.UpdateTbt_BillingTemp_ByBillingTarget(
                          strNewBillingClientCode, strNewBillingOfficeCode, strNewBillingTargetCode,
                          strOldBillingClientCode, strOldBillingOfficeCode, strOldBillingTargetCode, ContractCode,
                          CommonUtil.dsTransData.dtOperationData.ProcessDateTime,
                          CommonUtil.dsTransData.dtUserData.EmpNo,
                          BillingTemp.C_BILLINGTEMP_FLAG_KEEP);

                //Insert Log
                if (updatedList.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Update;
                    logData.TableName       = TableName.C_TBL_NAME_BILLING_TEMP;
                    logData.TableData       = CommonUtil.ConvertToXml(updatedList);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(updatedList);
            }
            catch (Exception)
            {
                throw;
            }
        }
        public List <tbm_InstrumentExpansion> InsertInstrumentExpansion(tbm_InstrumentExpansion doInsert)
        {
            try
            {
                //set CreateDate, CreateBy, UpdateDate and UpdateBy
                doInsert.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                doInsert.CreateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                doInsert.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                doInsert.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;

                List <tbm_InstrumentExpansion> insertList = base.InsertInstrumentExpansion(
                    doInsert.InstrumentCode
                    , doInsert.ChildInstrumentCode
                    , doInsert.CreateDate
                    , doInsert.CreateBy
                    , doInsert.UpdateDate
                    , doInsert.UpdateBy);

                //Insert Log
                if (insertList.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Insert;
                    logData.TableName       = TableName.C_TBL_NAME_INSTRUMENT_EXPANSION;
                    logData.TableData       = CommonUtil.ConvertToXml(insertList);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(insertList);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #18
0
        //ICS084 : call by screen

        /// <summary>
        /// To update receipt no. to tax invoice table
        /// </summary>
        /// <param name="invoiceNo"></param>
        /// <param name="invoiceOCC"></param>
        /// <param name="receiptNo"></param>
        /// <returns></returns>
        public bool UpdateReceiptNo(string invoiceNo, int invoiceOCC, string receiptNo)
        {
            List <tbt_TaxInvoice> result = base.UpdateReceiptNo(invoiceNo, invoiceOCC, receiptNo
                                                                , CommonUtil.dsTransData.dtUserData.EmpNo
                                                                , CommonUtil.dsTransData.dtOperationData.ProcessDateTime
                                                                );

            if (result != null && result.Count > 0)
            {
                ILogHandler      logHand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_RECEIPT,
                    TableData       = CommonUtil.ConvertToXml(result)
                };
                logHand.WriteTransactionLog(logData);
                //Updated
                return(true);
            }

            //No updated data
            return(false);
        }
Пример #19
0
        /// <summary>
        /// To update invoice correction reason
        /// </summary>
        /// <param name="doInvoice"></param>
        /// <param name="correctionReason"></param>
        /// <returns></returns>
        public bool UpdateInvoiceCorrectionReason(doInvoice doInvoice, string correctionReason)
        {
            List <tbt_Invoice> result = base.UpdateInvoiceCorrectionReason(doInvoice.InvoiceNo, (int?)doInvoice.InvoiceOCC, correctionReason
                                                                           , CommonUtil.dsTransData.dtUserData.EmpNo
                                                                           , CommonUtil.dsTransData.dtOperationData.ProcessDateTime
                                                                           );

            if (result != null && result.Count > 0)
            {
                ILogHandler      logHand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                doTransactionLog logData = new doTransactionLog()
                {
                    TransactionType = doTransactionLog.eTransactionType.Update,
                    TableName       = TableName.C_TBL_NAME_INVOICE,
                    TableData       = CommonUtil.ConvertToXml(result)
                };
                logHand.WriteTransactionLog(logData);
                //Updated
                return(true);
            }

            //No updated data
            return(false);
        }
Пример #20
0
        /// <summary>
        /// Insert billing temp data
        /// </summary>
        /// <param name="billing"></param>
        /// <returns></returns>
        public List <tbt_BillingTemp> InsertBillingTemp(tbt_BillingTemp billing)
        {
            List <tbt_BillingTemp> insertedList = null;

            try
            {
                //Validate data input
                //1.1	ContractCode and OCC are required.
                //1.3   BillingType, BillingAmount, PaymentMethod are required.
                #region validate input
                ApplicationErrorException.CheckMandatoryField <tbt_BillingTemp, doBillingTempData_Insert>(billing);

                //1.2	At least one of (BillingOCC, BillingTargetCode, BillingClientCode and BillingOfficeCode)
                bool          bBillingOCC              = true;
                bool          bBillingTargetCode       = true;
                bool          bBillingClientOfficeCode = true;
                List <String> fieldList = new List <string>();

                //BillingOCC
                if (CommonUtil.IsNullOrEmpty(billing.BillingOCC))
                {
                    bBillingOCC = false;
                    //fieldList.Add("BillingOCC");
                }

                //BillingTargetCode
                if (CommonUtil.IsNullOrEmpty(billing.BillingTargetCode))
                {
                    bBillingTargetCode = false;
                    //fieldList.Add("BillingTargetCode");
                }

                //BillingClientCode and BillingOfficeCode
                try
                {
                    doBillingBasicCheckBillingClientOfficeCode bClientOfficeCode = new doBillingBasicCheckBillingClientOfficeCode();
                    bClientOfficeCode.ContractCode      = billing.ContractCode;
                    bClientOfficeCode.BillingOfficeCode = billing.BillingOfficeCode;
                    bClientOfficeCode.BillingClientCode = billing.BillingClientCode;
                    ApplicationErrorException.CheckMandatoryField(bClientOfficeCode);
                }
                catch (Exception)
                {
                    bBillingClientOfficeCode = false;
                    //fieldList.Add("BillingOfficeCode");
                    //fieldList.Add("BillingClientCode");
                }

                bool bResult = bBillingOCC || bBillingTargetCode || bBillingClientOfficeCode;
                if (!bResult)
                {
                    throw ApplicationErrorException.ThrowErrorException(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0007, "At least one of BillingOCC, BillingTargetCode, BillingClientCode and BillingOfficeCode");
                }
                #endregion

                //Insert billing temp data to DB
                insertedList = base.InsertTbt_BillingTemp(billing.ContractCode
                                                          , billing.OCC
                                                          , billing.BillingOCC
                                                          , billing.BillingTargetRunningNo
                                                          , billing.BillingClientCode
                                                          , billing.BillingTargetCode
                                                          , billing.BillingOfficeCode
                                                          , billing.BillingType
                                                          , billing.CreditTerm
                                                          , billing.BillingTiming
                                                          , billing.BillingAmt
                                                          , billing.PayMethod
                                                          , billing.BillingCycle
                                                          , billing.CalDailyFeeStatus
                                                          , billing.SendFlag
                                                          , CommonUtil.dsTransData.dtOperationData.ProcessDateTime
                                                          , CommonUtil.dsTransData.dtUserData.EmpNo
                                                          , billing.DocLanguage
                                                          , billing.BillingAmtUsd
                                                          , billing.BillingAmtCurrencyType); //Add by Jutarat A. on 18122013

                //Insert Log
                if (insertedList.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Insert;
                    logData.TableName       = TableName.C_TBL_NAME_BILLING_TEMP;
                    logData.TableData       = CommonUtil.ConvertToXml(insertedList);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(insertedList);
        }
Пример #21
0
        /// <summary>
        /// Update billing temp data by key
        /// </summary>
        /// <param name="billing"></param>
        /// <returns></returns>
        public List <tbt_BillingTemp> UpdateBillingTempByKey(tbt_BillingTemp billing)
        {
            try
            {
                //Validate data input
                //1.1	ContractCode, OCC and SequenceNo are required
                //1.3	BillingType, BillingAmount, PaymentMethod are required.
                #region validate input
                ApplicationErrorException.CheckMandatoryField <tbt_BillingTemp, doBillingTempData_Update>(billing);

                //1.2	At least one of (BllingOCC, BillingTargetCode, BillingClientCode)
                List <String> fieldList = new List <string>();

                if (CommonUtil.IsNullOrEmpty(billing.BillingOCC))
                {
                    fieldList.Add("BillingOCC");
                }

                if (CommonUtil.IsNullOrEmpty(billing.BillingTargetCode))
                {
                    fieldList.Add("BillingTargetCode");
                }

                //Modify by Jutarat A. on 13112013

                /*if (CommonUtil.IsNullOrEmpty(billing.BillingClientCode))
                 * {
                 *  //fieldList.Add("BillingClientCode");
                 * }*/
                if (CommonUtil.IsNullOrEmpty(billing.BillingClientCode) && CommonUtil.IsNullOrEmpty(billing.BillingOfficeCode))
                {
                    if (CommonUtil.IsNullOrEmpty(billing.BillingClientCode))
                    {
                        fieldList.Add("BillingClientCode");
                    }

                    if (CommonUtil.IsNullOrEmpty(billing.BillingOfficeCode))
                    {
                        fieldList.Add("BillingOfficeCode");
                    }
                }
                //End Modify

                if (fieldList.Count >= 3) //== 3 //Modify by Jutarat A. on 13112013
                {
                    throw ApplicationErrorException.ThrowErrorException(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0007, fieldList.ToArray <String>());
                }
                #endregion

                //Update data to DB
                List <tbt_BillingTemp> updatedList
                    = base.UpdateTbt_BillingTemp_ByKey(billing.BillingOCC
                                                       , billing.BillingTargetRunningNo
                                                       , billing.BillingClientCode
                                                       , billing.BillingTargetCode
                                                       , billing.BillingOfficeCode
                                                       , billing.BillingType
                                                       , billing.CreditTerm
                                                       , billing.BillingTiming
                                                       , billing.BillingAmt
                                                       , billing.PayMethod
                                                       , billing.BillingCycle
                                                       , billing.CalDailyFeeStatus
                                                       , billing.SendFlag
                                                       , billing.ContractCode
                                                       , billing.OCC
                                                       , billing.SequenceNo
                                                       , CommonUtil.dsTransData.dtOperationData.ProcessDateTime
                                                       , CommonUtil.dsTransData.dtUserData.EmpNo
                                                       , billing.BillingAmtCurrencyType
                                                       , billing.BillingAmtUsd);

                //Insert Log
                if (updatedList.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Update;
                    logData.TableName       = TableName.C_TBL_NAME_BILLING_TEMP;
                    logData.TableData       = CommonUtil.ConvertToXml(updatedList);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(updatedList);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #22
0
        private List <tbm_Employee> SaveEmployee(dsEmployeeBelonging employeeInfo, IEmployeeMasterHandler hand)
        {
            List <tbm_Employee> result = null;

            doTransactionLog.eTransactionType?TransactionType = null;
            MAS070_ScreenParameter            MAS070Param     = GetScreenObject <MAS070_ScreenParameter>();
            PasswordHandler handler = new PasswordHandler();

            using (TransactionScope scope = new TransactionScope())
            {
                if (employeeInfo.employee.ModifyMode.Equals("ADD"))
                {
                    employeeInfo.employee.CreateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                    employeeInfo.employee.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                    employeeInfo.employee.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                    employeeInfo.employee.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                    employeeInfo.employee.Password   = handler.GeneratePasswordHash(employeeInfo.employee.Password);
                    List <tbm_Employee> insertList = new List <tbm_Employee>();
                    insertList.Add(employeeInfo.employee);
                    string xml = CommonUtil.ConvertToXml_Store(insertList);
                    result          = hand.InsertEmployee(xml);
                    TransactionType = doTransactionLog.eTransactionType.Insert;
                }
                else
                {
                    if (employeeInfo.employee.ChangePasswordFlag)
                    {
                        employeeInfo.employee.Password = handler.GeneratePasswordHash(employeeInfo.employee.Password);
                        employeeInfo.employee.PasswordLastUpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                        employeeInfo.employee.PasswordWrongCount     = 0;
                        employeeInfo.employee.Status = null;
                    }
                    result          = hand.UpdateEmployee(employeeInfo.employee);
                    TransactionType = doTransactionLog.eTransactionType.Update;
                }

                if (result.Count == 0)
                {
                    return(null);
                }
                else
                {
                    doTransactionLog logData = new doTransactionLog()
                    {
                        TransactionType = TransactionType,
                        TableName       = TableName.C_TBL_NAME_EMPLOYEE,
                        TableData       = CommonUtil.ConvertToXml(result)
                    };
                    ILogHandler loghand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    loghand.WriteTransactionLog(logData);
                }

                List <tbm_Belonging>      insertBelList      = new List <tbm_Belonging>();
                List <View_tbm_Belonging> checkUpdateBelList = new List <View_tbm_Belonging>();
                List <View_tbm_Belonging> updateBelList      = new List <View_tbm_Belonging>();

                foreach (var item in employeeInfo.belongingList)
                {
                    if (item.ModifyMode.Equals("NONE"))
                    {
                        continue;
                    }

                    if (item.ModifyMode.Equals("ADD"))
                    {
                        item.CreateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                        item.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                        item.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                        item.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                        insertBelList.Add(item);
                    }
                    else if (item.ModifyMode.Equals("EDIT"))
                    {
                        if (MAS070Param.belongingList != null)
                        {
                            var updateDate = from g in MAS070Param.belongingList
                                             where g.BelongingID == item.BelongingID
                                             select g.UpdateDate;

                            foreach (var date in updateDate)
                            {
                                item.UpdateDate = date;
                            }
                        }

                        if (item.UpdateDate != null)
                        {
                            checkUpdateBelList.Add(item);
                            updateBelList.Add(item);
                        }
                        else
                        {
                            item.CreateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                            item.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                            item.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                            item.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                            insertBelList.Add(item);
                        }
                    }
                }


                if (employeeInfo.delBelList != null && employeeInfo.delBelList.Count != 0)
                {
                    foreach (var item in employeeInfo.delBelList)
                    {
                        var updateDate = from g in MAS070Param.belongingList
                                         where g.BelongingID == item.BelongingID
                                         select g.UpdateDate;

                        foreach (var date in updateDate)
                        {
                            item.UpdateDate = date;
                        }
                    }

                    checkUpdateBelList.AddRange(employeeInfo.delBelList);
                }

                if (checkUpdateBelList.Count != 0)
                {
                    hand.checkBelongingUpdateDate(checkUpdateBelList);
                }

                if (insertBelList.Count != 0)
                {
                    string xml = CommonUtil.ConvertToXml_Store(insertBelList);
                    List <tbm_Belonging> insertedList = hand.InsertBelonging(xml);
                    if (insertedList.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Insert,
                            TableName       = TableName.C_TBL_NAME_BELONGING,
                            TableData       = CommonUtil.ConvertToXml(insertedList)
                        };
                        ILogHandler loghand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        loghand.WriteTransactionLog(logData);
                    }
                }

                foreach (var item in updateBelList)
                {
                    List <tbm_Belonging> updateList = new List <tbm_Belonging>();
                    updateList.Add(item);
                    string xml = CommonUtil.ConvertToXml_Store(updateList);
                    List <tbm_Belonging> updatedList = hand.UpdateBelonging(xml, item.BelongingID);
                    if (updatedList.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Update,
                            TableName       = TableName.C_TBL_NAME_BELONGING,
                            TableData       = CommonUtil.ConvertToXml(updatedList)
                        };
                        ILogHandler loghand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        loghand.WriteTransactionLog(logData);
                    }
                }

                if (employeeInfo.delBelList != null && employeeInfo.delBelList.Count != 0)
                {
                    foreach (var item in employeeInfo.delBelList)
                    {
                        List <tbm_Belonging> deletedList = hand.DeleteBelonging(item.BelongingID);
                        if (deletedList.Count == 0)
                        {
                            return(null);
                        }
                        else
                        {
                            doTransactionLog logData = new doTransactionLog()
                            {
                                TransactionType = doTransactionLog.eTransactionType.Delete,
                                TableName       = TableName.C_TBL_NAME_BELONGING,
                                TableData       = CommonUtil.ConvertToXml(deletedList)
                            };
                            ILogHandler loghand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                            loghand.WriteTransactionLog(logData);
                        }
                    }
                }

                scope.Complete();
            }

            return(result);
        }
        public List <tbm_PermissionIndividual> EditPermissionTypeIndividual(doPermission permission)
        {
            List <tbm_PermissionIndividual> result = null;

            using (TransactionScope scope = new TransactionScope()) {
                result = this.updatePermissionIndividual(permission);

                if (result == null || result.Count == 0)
                {
                    return(null);
                }
                else
                {
                    doTransactionLog logData = new doTransactionLog()
                    {
                        TransactionType = doTransactionLog.eTransactionType.Update,
                        TableName       = TableName.C_TBL_NAME_PERMISSION_IND,
                        TableData       = CommonUtil.ConvertToXml(result)
                    };
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                if (permission.DelEmpNo != null)
                {
                    List <tbm_PermissionIndividualDetail> deletedDetail = this.deletePermissionIndividualDetail(permission);
                    if (deletedDetail == null || deletedDetail.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Delete,
                            TableName       = TableName.C_TBL_NAME_PERMISSION_IND_DETAIL,
                            TableData       = CommonUtil.ConvertToXml(deletedDetail)
                        };
                        ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        hand.WriteTransactionLog(logData);
                    }
                }

                if (permission.EmpNo != null)
                {
                    List <tbm_PermissionIndividualDetail> insertDetail = base.InsertPermissionIndividualDetailByEmpNo(
                        permission.PermissionGroupCode,
                        permission.PermissionIndividualCode,
                        permission.EmpNo,
                        CommonUtil.dsTransData.dtOperationData.ProcessDateTime,
                        CommonUtil.dsTransData.dtUserData.EmpNo);

                    if (insertDetail == null || insertDetail.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Insert,
                            TableName       = TableName.C_TBL_NAME_PERMISSION_IND_DETAIL,
                            TableData       = CommonUtil.ConvertToXml(insertDetail)
                        };
                        ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        hand.WriteTransactionLog(logData);
                    }
                }

                List <tbm_PermissionDetail> deleteList = this.deletePermisssionDetail(
                    permission.PermissionGroupCode,
                    permission.PermissionIndividualCode,
                    permission.UpdateDate.Value);

                // Akat K. : Current permission may have no detail
                //if (deleteList == null || deleteList.Count == 0) {
                //    return null;
                //} else {
                if (deleteList != null && deleteList.Count != 0)
                {
                    doTransactionLog logData = new doTransactionLog()
                    {
                        TransactionType = doTransactionLog.eTransactionType.Delete,
                        TableName       = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                        TableData       = CommonUtil.ConvertToXml(deleteList)
                    };
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                // Akat K. 2012-03-14
                // Akat K. 2012-03-06
                //List<tbm_PermissionDetail> copyResult = base.CopyPermissionFromGroupToIndividual(
                //        permission.PermissionGroupCode,
                //        permission.PermissionIndividualCode,
                //        permission.CreateDate,
                //        permission.CreateBy);

                //if (copyResult != null && copyResult.Count != 0) {
                //    doTransactionLog logData = new doTransactionLog() {
                //        TransactionType = doTransactionLog.eTransactionType.Insert,
                //        TableName = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                //        TableData = CommonUtil.ConvertToXml(copyResult)
                //    };
                //    ILogHandler hand = ServiceContainer.GetService<ILogHandler>() as ILogHandler;
                //    hand.WriteTransactionLog(logData);
                //}

                if (permission.ObjectFunction != null && permission.ObjectFunction != "")
                {
                    List <tbm_PermissionDetail> detail = base.InsertPermissionDetailFromSelectedFunction(
                        permission.PermissionGroupCode,
                        permission.ObjectFunction,
                        permission.PermissionIndividualCode,
                        permission.CreateDate,
                        permission.CreateBy);

                    if (detail == null || detail.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Insert,
                            TableName       = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                            TableData       = CommonUtil.ConvertToXml(detail)
                        };
                        ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        hand.WriteTransactionLog(logData);
                    }
                }

                scope.Complete();
            }

            return(result);
        }
        public List <tbm_PermissionGroup> EditPermissionTypeOffice(doPermission permission)
        {
            List <tbm_PermissionGroup> result = null;

            using (TransactionScope scope = new TransactionScope()) {
                result = this.updatePermissionGroup(permission);
                if (result == null || result.Count == 0)
                {
                    return(null);
                }
                else
                {
                    doTransactionLog logData = new doTransactionLog()
                    {
                        TransactionType = doTransactionLog.eTransactionType.Update,
                        TableName       = TableName.C_TBL_NAME_PERMISSION_GROUP,
                        TableData       = CommonUtil.ConvertToXml(result)
                    };
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                List <tbm_PermissionDetail> deleteList = this.deletePermisssionDetail(
                    permission.PermissionGroupCode,
                    permission.PermissionIndividualCode,
                    permission.UpdateDate.Value);

                // Akat K. : Current permission may have no detail
                //if (deleteList == null || deleteList.Count == 0) {
                //    return null;
                //} else {
                if (deleteList != null && deleteList.Count != 0)
                {
                    doTransactionLog logData = new doTransactionLog()
                    {
                        TransactionType = doTransactionLog.eTransactionType.Delete,
                        TableName       = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                        TableData       = CommonUtil.ConvertToXml(deleteList)
                    };
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                permission.UpdateBy   = CommonUtil.dsTransData.dtUserData.EmpNo;
                permission.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
                if (permission.ObjectFunction != null && permission.ObjectFunction != "")
                {
                    List <tbm_PermissionDetail> detail = base.InsertPermissionDetailFromSelectedFunction(
                        permission.PermissionGroupCode,
                        permission.ObjectFunction,
                        permission.PermissionIndividualCode,
                        permission.CreateDate,
                        permission.CreateBy);

                    if (detail == null || detail.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Insert,
                            TableName       = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                            TableData       = CommonUtil.ConvertToXml(detail)
                        };
                        ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        hand.WriteTransactionLog(logData);
                    }
                }

                scope.Complete();
            }

            return(result);
        }
        public List <tbm_PermissionIndividual> AddPermissionTypeIndividual(doPermission permission)
        {
            List <tbm_PermissionIndividual> result = null;

            using (TransactionScope scope = new TransactionScope()) {
                try {
                    List <string> individualCodeList = base.GeneratePermissionIndividualCode();
                    if (individualCodeList.Count != 0 && individualCodeList[0] != null)
                    {
                        permission.PermissionIndividualCode = individualCodeList[0];
                    }
                    else
                    {
                        return(null);
                    }

                    result = base.InsertPermissionIndividual(
                        permission.PermissionGroupCode,
                        permission.PermissionIndividualCode,
                        permission.PermissionIndividualName,
                        permission.CreateDate,
                        permission.CreateBy);

                    if (result == null || result.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        permission.PermissionIndividualCode = result[0].PermissionIndividualCode;

                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Insert,
                            TableName       = TableName.C_TBL_NAME_PERMISSION_IND,
                            TableData       = CommonUtil.ConvertToXml(result)
                        };
                        ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        hand.WriteTransactionLog(logData);
                    }

                    List <tbm_PermissionIndividualDetail> list = base.InsertPermissionIndividualDetailByEmpNo(
                        permission.PermissionGroupCode,
                        permission.PermissionIndividualCode,
                        permission.EmpNo,
                        permission.CreateDate,
                        permission.CreateBy);
                    if (list == null || list.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Insert,
                            TableName       = TableName.C_TBL_NAME_PERMISSION_IND_DETAIL,
                            TableData       = CommonUtil.ConvertToXml(list)
                        };
                        ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        hand.WriteTransactionLog(logData);
                    }

                    // Akat K. 2012-03-14
                    // Akat K. 2012-03-06
                    //List<tbm_PermissionDetail> copyResult = base.CopyPermissionFromGroupToIndividual(
                    //        permission.PermissionGroupCode,
                    //        permission.PermissionIndividualCode,
                    //        permission.CreateDate,
                    //        permission.CreateBy);

                    //if (copyResult != null && copyResult.Count != 0) {
                    //    doTransactionLog logData = new doTransactionLog() {
                    //        TransactionType = doTransactionLog.eTransactionType.Insert,
                    //        TableName = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                    //        TableData = CommonUtil.ConvertToXml(copyResult)
                    //    };
                    //    ILogHandler hand = ServiceContainer.GetService<ILogHandler>() as ILogHandler;
                    //    hand.WriteTransactionLog(logData);
                    //}

                    if (permission.ObjectFunction != null && permission.ObjectFunction != "")
                    {
                        List <tbm_PermissionDetail> detail = base.InsertPermissionDetailFromSelectedFunction(
                            permission.PermissionGroupCode,
                            permission.ObjectFunction,
                            permission.PermissionIndividualCode,
                            permission.CreateDate,
                            permission.CreateBy);

                        if (detail == null || detail.Count == 0)
                        {
                            return(null);
                        }
                        else
                        {
                            doTransactionLog logData = new doTransactionLog()
                            {
                                TransactionType = doTransactionLog.eTransactionType.Insert,
                                TableName       = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                                TableData       = CommonUtil.ConvertToXml(detail)
                            };
                            ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                            hand.WriteTransactionLog(logData);
                        }
                    }
                } catch (Exception e) {
                    throw e;
                }

                scope.Complete();
            }

            return(result);
        }
        public List <tbm_PermissionGroup> AddPermissionTypeOffice(doPermission permission)
        {
            List <tbm_PermissionGroup> result = null;

            using (TransactionScope scope = new TransactionScope()) {
                try {
                    List <string> groupCodeList = base.GeneratePermissionGroupCode();
                    if (groupCodeList.Count != 0 && groupCodeList[0] != null)
                    {
                        permission.PermissionGroupCode = groupCodeList[0];
                    }
                    else
                    {
                        return(null);
                    }

                    result = base.InsertPermissionGroup(
                        permission.PermissionGroupCode,
                        permission.PermissionGroupName,
                        permission.OfficeCode,
                        permission.DepartmentCode,
                        permission.PositionCode, permission.CreateDate, permission.CreateBy);

                    if (result == null || result.Count == 0)
                    {
                        return(null);
                    }
                    else
                    {
                        doTransactionLog logData = new doTransactionLog()
                        {
                            TransactionType = doTransactionLog.eTransactionType.Insert,
                            TableName       = TableName.C_TBL_NAME_PERMISSION_GROUP,
                            TableData       = CommonUtil.ConvertToXml(result)
                        };
                        ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                        hand.WriteTransactionLog(logData);
                    }

                    if (permission.ObjectFunction != null && permission.ObjectFunction != "")
                    {
                        List <tbm_PermissionDetail> detail = base.InsertPermissionDetailFromSelectedFunction(
                            permission.PermissionGroupCode,
                            permission.ObjectFunction,
                            permission.PermissionIndividualCode,
                            permission.CreateDate,
                            permission.CreateBy);

                        if (detail == null || detail.Count == 0)
                        {
                            return(null);
                        }
                        else
                        {
                            doTransactionLog logData = new doTransactionLog()
                            {
                                TransactionType = doTransactionLog.eTransactionType.Insert,
                                TableName       = TableName.C_TBL_NAME_PERMISSION_DETAIL,
                                TableData       = CommonUtil.ConvertToXml(detail)
                            };
                            ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                            hand.WriteTransactionLog(logData);
                        }
                    }
                } catch (Exception e) {
                    throw e;
                }

                scope.Complete();
            }

            return(result);
        }
Пример #27
0
        ///<summary>
        ///Purpose:
        ///     Check mandatory filelds.
        ///
        ///Parameters:
        ///     doTransactionLog:
        ///         refer to "SECOM-AJIS-STC.CMP020-Process of creating log" tab Test Data
        ///
        ///Expected:
        ///     refer to "SECOM-AJIS-STC.CMP020-Process of creating log" tab Test Data
        ///</summary>
        public string Case4()
        {
            ILogHandler      target   = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
            doTransactionLog param    = new doTransactionLog();
            string           expected = null;
            string           actual   = null;

            try
            {
                // 1.
                param.TransactionType = doTransactionLog.eTransactionType.Insert;
                param.TableName       = "Table1";
                param.TableData       = "Datatable object";
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES010";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 1, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000001";
                target.WriteTransactionLog(param);

                // 2.
                param.TransactionType = doTransactionLog.eTransactionType.Update;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES011";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 2, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000002";
                target.WriteTransactionLog(param);

                // 3.
                param.TransactionType = doTransactionLog.eTransactionType.Delete;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES012";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 3, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000003";
                target.WriteTransactionLog(param);

                // 4.
                param.TransactionType = doTransactionLog.eTransactionType.Insert;
                param.TableName       = "Table2";
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES013";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 4, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000004";
                target.WriteTransactionLog(param);

                // 5.
                param.TransactionType = doTransactionLog.eTransactionType.Update;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES014";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 5, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000005";
                target.WriteTransactionLog(param);

                // 6.
                param.TransactionType = doTransactionLog.eTransactionType.Delete;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES015";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 6, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000006";
                target.WriteTransactionLog(param);

                // 7.
                param.TransactionType = doTransactionLog.eTransactionType.Insert;
                param.TableName       = "Table3";
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES016";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 7, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000007";
                target.WriteTransactionLog(param);

                // 8.
                param.TransactionType = doTransactionLog.eTransactionType.Update;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES017";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 1, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000008";
                target.WriteTransactionLog(param);

                // 9.
                param.TransactionType = doTransactionLog.eTransactionType.Delete;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES018";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 2, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000009";
                target.WriteTransactionLog(param);

                // 10.
                param.TransactionType = doTransactionLog.eTransactionType.Insert;
                param.TableName       = "Table4";
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES019";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 3, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000010";
                target.WriteTransactionLog(param);

                // 11.
                param.TransactionType = doTransactionLog.eTransactionType.Update;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES020";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 4, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000011";
                target.WriteTransactionLog(param);

                // 12.
                param.TransactionType = doTransactionLog.eTransactionType.Delete;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES021";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 5, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000012";
                target.WriteTransactionLog(param);

                // 13.
                param.TransactionType = doTransactionLog.eTransactionType.Insert;
                param.TableName       = "Table5";
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES022";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 6, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000013";
                target.WriteTransactionLog(param);

                // 14.
                param.TransactionType = doTransactionLog.eTransactionType.Update;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES023";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 7, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000014";
                target.WriteTransactionLog(param);

                // 15.
                param.TransactionType = doTransactionLog.eTransactionType.Delete;
                CommonUtil.dsTransData.dtTransHeader.ScreenID          = "TES024";
                CommonUtil.dsTransData.dtOperationData.ProcessDateTime = new DateTime(2011, 1, 1);
                CommonUtil.dsTransData.dtUserData.EmpNo = "000015";
                target.WriteTransactionLog(param);
            } catch (ApplicationErrorException ex) {
                actual = ex.ErrorResult.Message.Code;
            } catch (Exception ex) {
                actual = ex.StackTrace;
            }

            return(string.Format(RESULT_FORMAT, 4, expected, actual, CompareResult_String(expected, actual)));
        }
Пример #28
0
        /// <summary>
        /// Insert customer
        /// </summary>
        /// <param name="customer"></param>
        /// <returns></returns>
        public List <tbm_Customer> InsertCustomer(doCustomer customer)
        {
            try
            {
                dsTransDataModel dsTrans = CommonUtil.dsTransData;
                customer.CustStatus    = CustomerStatus.C_CUST_STATUS_NEW;
                customer.ImportantFlag = false;
                customer.DummyIDFlag   = customer.DummyIDFlag == null ? false : customer.DummyIDFlag;
                customer.DeleteFlag    = false;
                customer.CreateDate    = dsTrans.dtOperationData.ProcessDateTime;
                customer.CreateBy      = dsTrans.dtUserData.EmpNo;
                customer.UpdateDate    = dsTrans.dtOperationData.ProcessDateTime;
                customer.UpdateBy      = dsTrans.dtUserData.EmpNo;

                List <tbm_Customer> lst = this.InsertCustomer(customer.CustCode,
                                                              customer.CustStatus,
                                                              customer.ImportantFlag,
                                                              customer.CustNameEN,
                                                              customer.CustNameLC,
                                                              customer.CustFullNameEN,
                                                              customer.CustFullNameLC,
                                                              customer.RepPersonName,
                                                              customer.ContactPersonName,
                                                              customer.SECOMContactPerson,
                                                              customer.CustTypeCode,
                                                              customer.CompanyTypeCode,
                                                              customer.FinancialMarketTypeCode,
                                                              customer.BusinessTypeCode,
                                                              customer.PhoneNo,
                                                              customer.FaxNo,
                                                              customer.IDNo,
                                                              customer.DummyIDFlag,
                                                              customer.RegionCode,
                                                              customer.URL,
                                                              customer.Memo,
                                                              customer.AlleyEN,
                                                              customer.AddressEN,
                                                              customer.RoadEN,
                                                              customer.SubDistrictEN,
                                                              customer.AddressFullEN,
                                                              customer.AddressLC,
                                                              customer.AlleyLC,
                                                              customer.RoadLC,
                                                              customer.SubDistrictLC,
                                                              customer.AddressFullLC,
                                                              customer.DistrictCode,
                                                              customer.ProvinceCode,
                                                              customer.ZipCode,
                                                              customer.DeleteFlag,
                                                              customer.CreateDate,
                                                              customer.CreateBy,
                                                              customer.UpdateDate,
                                                              customer.UpdateBy);
                //Insert Log
                if (lst.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Insert;
                    logData.TableName       = TableName.C_TBL_NAME_CUSTOMER;
                    logData.TableData       = CommonUtil.ConvertToXml(lst);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(lst);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #29
0
        /// <summary>
        /// Update customer
        /// </summary>
        /// <param name="customer"></param>
        /// <returns></returns>
        public List <tbm_Customer> UpdateCustomer(doCustomer customer)
        {
            try
            {
                //Check whether this record is the most updated data
                List <tbm_Customer> sList = this.GetTbm_Customer(customer.CustCode);

                if (sList == null || sList.Count == 0 || sList[0] == null || sList[0].UpdateDate == null ||
                    customer.UpdateDate == null || !customer.UpdateDate.HasValue)
                {
                    throw ApplicationErrorException.ThrowErrorException(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0007, new string[] { "UpdateDate" });
                }

                if (DateTime.Compare(sList[0].UpdateDate.Value, customer.UpdateDate.Value) != 0)
                {
                    throw ApplicationErrorException.ThrowErrorException(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0019);
                }

                dsTransDataModel dsTrans = CommonUtil.dsTransData;
                //customer.UpdateDate = dsTrans.dtOperationData.ProcessDateTime;
                //customer.UpdateBy = dsTrans.dtUserData.EmpNo;

                List <tbm_Customer> lst = this.UpdateCustomer(customer.CustCode,
                                                              customer.CustStatus,
                                                              customer.ImportantFlag,
                                                              customer.CustNameEN,
                                                              customer.CustNameLC,
                                                              customer.CustFullNameEN,
                                                              customer.CustFullNameLC,
                                                              customer.RepPersonName,
                                                              customer.ContactPersonName,
                                                              customer.SECOMContactPerson,
                                                              customer.CustTypeCode,
                                                              customer.CompanyTypeCode,
                                                              customer.FinancialMarketTypeCode,
                                                              customer.BusinessTypeCode,
                                                              customer.PhoneNo,
                                                              customer.FaxNo,
                                                              customer.IDNo,
                                                              customer.DummyIDFlag,
                                                              customer.RegionCode,
                                                              customer.URL,
                                                              customer.Memo,
                                                              customer.AlleyEN,
                                                              customer.AddressEN,
                                                              customer.RoadEN,
                                                              customer.SubDistrictEN,
                                                              customer.AddressFullEN,
                                                              customer.AddressLC,
                                                              customer.AlleyLC,
                                                              customer.RoadLC,
                                                              customer.SubDistrictLC,
                                                              customer.AddressFullLC,
                                                              customer.DistrictCode,
                                                              customer.ProvinceCode,
                                                              customer.ZipCode,
                                                              customer.DeleteFlag,
                                                              dsTrans.dtOperationData.ProcessDateTime,
                                                              dsTrans.dtUserData.EmpNo);

                //Insert Log
                if (lst.Count > 0)
                {
                    doTransactionLog logData = new doTransactionLog();
                    logData.TransactionType = doTransactionLog.eTransactionType.Update;
                    logData.TableName       = TableName.C_TBL_NAME_CUSTOMER;
                    logData.TableData       = CommonUtil.ConvertToXml(lst);
                    ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    hand.WriteTransactionLog(logData);
                }

                return(lst);
            }
            catch (Exception)
            {
                throw;
            }
        }
        public List <tbm_PermissionGroup> DeletePermissionTypeOffice(string permissionGroupCode, DateTime updateDate)
        {
            List <DateTime?> updateDateList = base.GetPermissionGroupUpdateDate(permissionGroupCode);

            if (updateDateList == null || updateDateList.Count == 0 || updateDateList[0] == null ||
                updateDate == null)
            {
                throw ApplicationErrorException.ThrowErrorException(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0007, new string[] { "UpdateDate" });
            }

            if (updateDateList[0].Value.CompareTo(updateDate) != 0)
            {
                throw ApplicationErrorException.ThrowErrorException(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0019, new string[] { permissionGroupCode });
            }

            List <tbm_PermissionGroup> result = null;

            using (TransactionScope scope = new TransactionScope()) {
                try {
                    ILogHandler      hand    = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
                    doTransactionLog logData = new doTransactionLog()
                    {
                        TransactionType = doTransactionLog.eTransactionType.Delete,
                        TableName       = null,
                        TableData       = null
                    };

                    List <tbm_PermissionIndividualDetail> listIndDetail = base.DeletePermissionIndividualDetail(permissionGroupCode, null);
                    if (listIndDetail.Count != 0)
                    {
                        logData.TableData = CommonUtil.ConvertToXml(listIndDetail);
                        logData.TableName = TableName.C_TBL_NAME_PERMISSION_IND_DETAIL;
                        hand.WriteTransactionLog(logData);
                    }

                    List <tbm_PermissionIndividual> listInd = base.DeletePermissionIndividual(permissionGroupCode, null);
                    if (listInd.Count != 0)
                    {
                        logData.TableData = CommonUtil.ConvertToXml(listInd);
                        logData.TableName = TableName.C_TBL_NAME_PERMISSION_IND;
                        hand.WriteTransactionLog(logData);
                    }

                    List <tbm_PermissionDetail> listDetail = base.DeletePermissionDetail(permissionGroupCode, null);
                    if (listDetail.Count != 0)
                    {
                        logData.TableData = CommonUtil.ConvertToXml(listDetail);
                        logData.TableName = TableName.C_TBL_NAME_PERMISSION_DETAIL;
                        hand.WriteTransactionLog(logData);
                    }

                    result = base.DeletePermissionGroup(permissionGroupCode);
                    if (result.Count != 0)
                    {
                        logData.TableData = CommonUtil.ConvertToXml(result);
                        logData.TableName = TableName.C_TBL_NAME_PERMISSION_GROUP;
                        hand.WriteTransactionLog(logData);
                    }
                } catch (Exception ex) {
                    throw ex;
                }

                scope.Complete();
            }
            return(result);
        }