/// <summary>
/// Generate revenue no. and save revenue information to DB.
/// </summary>
/// <param name="_dotbt_Revenue"></param>
/// <returns></returns>
public tbt_Revenue RegisterRevenue(tbt_Revenue _dotbt_Revenue)
{
try
{
IBillingHandler iBillingHandler = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler;
_dotbt_Revenue.RevenueNo = iBillingHandler.GetNextRunningNoByTypeMonthYear(RunningType.C_RUNNING_TYPE_REVENUE);
//set CreateDate, CreateBy, UpdateDate and UpdateBy
_dotbt_Revenue.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
_dotbt_Revenue.CreateBy = CommonUtil.dsTransData.dtUserData.EmpNo;
_dotbt_Revenue.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
_dotbt_Revenue.UpdateBy = CommonUtil.dsTransData.dtUserData.EmpNo;
if (InsertTbt_Revenue(_dotbt_Revenue) == 0)
{
return(null);
}
else
{
return(_dotbt_Revenue);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Function for insert revenue information to DB. (sp_IC_InsertTbt_Revenue)
/// </summary>
/// <param name="doTbt_Revenue">revenue information</param>
/// <returns></returns>
public int InsertTbt_Revenue(tbt_Revenue doTbt_Revenue)
{
try
{
//set CreateDate, CreateBy, UpdateDate and UpdateBy
doTbt_Revenue.CreateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
doTbt_Revenue.CreateBy = CommonUtil.dsTransData.dtUserData.EmpNo;
doTbt_Revenue.UpdateDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime;
doTbt_Revenue.UpdateBy = CommonUtil.dsTransData.dtUserData.EmpNo;
List <tbt_Revenue> doInsertList = new List <tbt_Revenue>();
doInsertList.Add(doTbt_Revenue);
List <tbt_Revenue> insertList = base.InsertTbt_Revenue
(CommonUtil.ConvertToXml_Store <tbt_Revenue>(doInsertList));
//Insert Log
if (insertList.Count > 0)
{
doTransactionLog logData = new doTransactionLog();
logData.TransactionType = doTransactionLog.eTransactionType.Insert;
logData.TableName = TableName.C_TBL_NAME_REVENUE;
logData.TableData = CommonUtil.ConvertToXml(insertList);
ILogHandler hand = ServiceContainer.GetService <ILogHandler>() as ILogHandler;
hand.WriteTransactionLog(logData);
}
return(insertList.Count);
}
catch (Exception Ex)
{
throw;
}
}
