protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L3BA_CBA_1141 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
#region Bank account
var bankAccount = new CL1_ACC_BNK.ORM_ACC_BNK_BankAccount
{
ACC_BNK_BankAccountID = Guid.NewGuid(),
Bank_RefID = Parameter.BankID,
BankAccountType_RefID = Parameter.BankAccountTypeID,
Currency_RefID = Parameter.CurrencyID,
IBAN = Parameter.IBAN,
IsValid = true,
AccountOpenedAtDate = Parameter.OpenedAtDate,
Tenant_RefID = securityTicket.TenantID
};
bankAccount.Save(Connection, Transaction);
#endregion
#region Booking account
var bookingAccountParam = new P_L3BA_CBA_1305
{
FiscalYearID = Parameter.FiscalYearID,
BookingAccountName = Parameter.BookingAccountName,
BookingAccountNumber = Parameter.BookingAccountName
};
Guid bookingAccountID = cls_Create_Booking_Account.Invoke(Connection, Transaction, bookingAccountParam, securityTicket).Result;
#endregion
#region Create Account assignment to booking account as "Bank Account"
var accountAssignment = CL3_BookingAccounts.Utils.BookingAccountUtils.GetEmptyBankAccount();
accountAssignment.ACC_BOK_BookingAccounts_Purpose_BP_AssignmentID = Guid.NewGuid();
accountAssignment.BookingAccount_RefID = bookingAccountID;
accountAssignment.BusinessParticipant_RefID = Parameter.BusinessParticipantID;
accountAssignment.If_L3_AssetAccount_BankAccount_RefID = bankAccount.ACC_BNK_BankAccountID;
accountAssignment.Tenant_RefID = securityTicket.TenantID;
accountAssignment.Save(Connection, Transaction);
#endregion
returnValue.Result = true;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2B_SBA_0944 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
var returnValue = new FR_Guid();
var item = new CL1_ACC_BNK.ORM_ACC_BNK_BankAccount();
if (Parameter.ACC_BNK_BankAccountID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.ACC_BNK_BankAccountID);
if (result.Status != FR_Status.Success || item.ACC_BNK_BankAccountID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_BNK_BankAccountID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.ACC_BNK_BankAccountID == Guid.Empty)
{
item.Tenant_RefID = securityTicket.TenantID;
}
item.Bank_RefID = Parameter.Bank_RefID;
item.Currency_RefID = Parameter.Currency_RefID;
item.IBAN = Parameter.IBAN;
item.AccountNumber = Parameter.AccountNumber;
item.BankAccountType_RefID = Parameter.BankAccountType_RefID;
item.OwnerText = Parameter.OwnerText;
item.AccountOpenedAtDate = Parameter.AccountOpenedAtDate;
item.AccountClosedAtDate = Parameter.AccountClosedAtDate;
item.IsValid = Parameter.IsValid;
item.R_AccountBalance = Parameter.R_AccountBalance;
return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_BNK_BankAccountID));
}