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