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