/// <summary>
/// Function for update credit note information to DB. (sp_IC_UpdateTbt_CreditNote)
/// </summary>
/// <param name="doTbt_CreditNote">credit note information</param>
/// <returns></returns>
public int UpdateTbt_CreditNote(tbt_CreditNote doTbt_CreditNote)
{
try
{
//set updateDate and updateBy
doTbt_CreditNote.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
doTbt_CreditNote.UpdateBy = CommonUtil.dsTransData.dtUserData.EmpNo;
List <tbt_CreditNote> doUpdateList = new List <tbt_CreditNote>();
doUpdateList.Add(doTbt_CreditNote);
List <tbt_CreditNote> updatedList = base.UpdateTbt_CreditNote(CommonUtil.ConvertToXml_Store <tbt_CreditNote>(doUpdateList));
//Insert Log
if (updatedList.Count > 0)
{
doTransactionLog logData = new doTransactionLog();
logData.TransactionType = doTransactionLog.eTransactionType.Update;
logData.TableName = TableName.C_TBL_NAME_CREDIT_NOTE;
logData.TableData = CommonUtil.ConvertToXml(updatedList);
ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
hand.WriteTransactionLog(logData);
}
return(updatedList.Count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Function for generate credit note no. and save credit note information to DB.
/// </summary>
/// <param name="_dotbt_CreditNote">credit note information</param>
/// <returns></returns>
public tbt_CreditNote RegisterCreditNote(tbt_CreditNote _dotbt_CreditNote)
{
try
{
IBillingHandler iBillingHandler = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler;
_dotbt_CreditNote.CreditNoteNo = iBillingHandler.GetNextRunningNoByTypeMonthYear(RunningType.C_RUNNING_TYPE_CREDIT_NOTE, CommonUtil.dsTransData.dtUserData.EmpNo, _dotbt_CreditNote.CreditNoteDate == null ? CommonUtil.dsTransData.dtOperationData.ProcessDateTime : _dotbt_CreditNote.CreditNoteDate.Value);
//set CreateDate, CreateBy, UpdateDate and UpdateBy
_dotbt_CreditNote.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
_dotbt_CreditNote.CreateBy = CommonUtil.dsTransData.dtUserData.EmpNo;
_dotbt_CreditNote.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
_dotbt_CreditNote.UpdateBy = CommonUtil.dsTransData.dtUserData.EmpNo;
_dotbt_CreditNote.CancelFlag = false;
if (InsertTbt_CreditNote(_dotbt_CreditNote) == 0)
{
return(null);
}
else
{
return(_dotbt_CreditNote);
}
}
catch (Exception)
{
throw;
}
}