/// <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; } }
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 }
/// <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); }
//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); }
/// <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; } }
/// <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); }
///<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))); }
//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); }
/// <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; } }
/// <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; } }
/// <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); }
/// <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; } }
/// <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; } }
//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); }
/// <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); }
/// <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); }
/// <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; } }
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); }
///<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))); }
/// <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; } }
/// <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); }