protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L3BA_CTBAfT_1519 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Bool(); #region Tax account counter for fiscal year - until better solution comes var taxAccountCounter = CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount.Query.Search(Connection, Transaction, new CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount.Query { FiscalYear_RefID = Parameter.FiscalYearID, Tenant_RefID = securityTicket.TenantID }).Count(); #endregion #region Find out if there is already made account for this tax in this fiscalyear var param = new CL3_BookingAccounts.Atomic.Retrieval.P_L3BA_GAfTaFY_1647 { FiscalYearID = Parameter.FiscalYearID, TaxID = Parameter.TaxIDs, IsTaxAccount = true, IsRevenueAccount = false }; var alreadyExists = CL3_BookingAccounts.Atomic.Retrieval.cls_Get_Assignment_for_TaxID_List_and_FiscalYearID.Invoke(Connection, Transaction, param, securityTicket).Result; var taxesNotAssignedAccount = Parameter.TaxIDs.Except(alreadyExists.Select(x => x.ACC_TAX_Tax_RefID)); #endregion foreach (var taxID in taxesNotAssignedAccount) { #region Load Tax var taxQuery = new CL1_ACC_TAX.ORM_ACC_TAX_Tax.Query { IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var tax = new CL1_ACC_TAX.ORM_ACC_TAX_Tax(); tax.Load(Connection, Transaction, taxID); #endregion #region Create booking account var bookingAccountParam = new P_L3BA_CBA_1305 { FiscalYearID = Parameter.FiscalYearID, BookingAccountName = String.Format("VAT {0}%", tax.TaxRate), BookingAccountNumber = String.Format("{0:000000000000}", taxAccountCounter + 1) }; Guid bookingAccountID = cls_Create_Booking_Account.Invoke(Connection, Transaction, bookingAccountParam, securityTicket).Result; #endregion #region Booking account 2 tax Guid tenantBPID = CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query { IfTenant_Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single().CMN_BPT_BusinessParticipantID; var bookingAccountTypeParam = new P_L3BA_SBAT_1310 { BookingAccountID = bookingAccountID, BusinessParticipantID = tenantBPID, FiscalYearID = Parameter.FiscalYearID, IsVATAccount = true, TaxRate = tax.TaxRate }; cls_Set_Booking_Account_Type.Invoke(Connection, Transaction, bookingAccountTypeParam, securityTicket); #endregion } returnValue.Result = true; return(returnValue); #endregion UserCode }
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L3BA_SBAT_1310 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Bool(); var tenantBP = CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query { IsTenant = true, IfTenant_Tenant_RefID = securityTicket.TenantID, Tenant_RefID = securityTicket.TenantID }).Single().CMN_BPT_BusinessParticipantID; CL1_ACC_BOK.ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment assignment = null; var foundAssignments = CL1_ACC_BOK.ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment.Query.Search(Connection, Transaction, new CL1_ACC_BOK.ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment.Query { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, BusinessParticipant_RefID = tenantBP, BookingAccount_RefID = Parameter.BookingAccountID }); if (Parameter.IsRevenueAccount || Parameter.IsVATAccount) { if (Parameter.IsRevenueAccount) { if (foundAssignments.Count == 0) { assignment = CL3_BookingAccounts.Utils.BookingAccountUtils.GetEmptyRevenueAccount(); } else { assignment = foundAssignments.Single(); } } else // it has to be VAT account { if (foundAssignments.Count == 0) { assignment = CL3_BookingAccounts.Utils.BookingAccountUtils.GetEmptyVATAccount(); } else { assignment = foundAssignments.Single(); } } #region Get correct Tax by tax rate var taxes = CL1_ACC_TAX.ORM_ACC_TAX_Tax.Query.Search(Connection, Transaction, new CL1_ACC_TAX.ORM_ACC_TAX_Tax.Query { IsDeleted = false, Tenant_RefID = securityTicket.TenantID }); var tax = taxes.Where(x => Double.Equals(x.TaxRate, Parameter.TaxRate)).SingleOrDefault(); if (tax == null) { returnValue.Status = FR_Status.Error_Internal; returnValue.Result = false; return(returnValue); } #endregion #region Assign tax to booking account CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount_2_Tax foundBooking2Tax = null; if (Parameter.IsRevenueAccount && tax.TaxRate != 0 && foundAssignments != null) { foundBooking2Tax = CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount_2_Tax.Query.Search(Connection, Transaction, new CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount_2_Tax.Query { IsDeleted = false, IsDefaultAccountForRevenueBookings = true, ACC_TAX_Tax_RefID = tax.ACC_TAX_TaxeID }).FirstOrDefault(); } else { foundBooking2Tax = CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount_2_Tax.Query.Search(Connection, Transaction, new CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount_2_Tax.Query { ACC_BOK_BookingAccount_RefID = Parameter.BookingAccountID, ACC_TAX_Tax_RefID = tax.ACC_TAX_TaxeID }).SingleOrDefault(); } CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount_2_Tax bookingAcc2Tax = null; Guid bookingAccount2Tax_assignmentId; if (foundBooking2Tax != null) { bookingAccount2Tax_assignmentId = foundBooking2Tax.AssignmentID; bookingAcc2Tax = foundBooking2Tax; } else { bookingAcc2Tax = new CL1_ACC_BOK.ORM_ACC_BOK_BookingAccount_2_Tax(); bookingAccount2Tax_assignmentId = Guid.NewGuid(); } bookingAcc2Tax.AssignmentID = bookingAccount2Tax_assignmentId; bookingAcc2Tax.ACC_BOK_BookingAccount_RefID = Parameter.BookingAccountID; bookingAcc2Tax.ACC_TAX_Tax_RefID = tax.ACC_TAX_TaxeID; bookingAcc2Tax.IsDefaultAccountForRevenueBookings = Parameter.IsRevenueAccount; bookingAcc2Tax.IsDefaultAccountForTaxBookings = Parameter.IsVATAccount; bookingAcc2Tax.Tenant_RefID = securityTicket.TenantID; bookingAcc2Tax.Save(Connection, Transaction); #endregion } else if (Parameter.IsCustomerAccount) { assignment = CL3_BookingAccounts.Utils.BookingAccountUtils.GetEmptyCustomerAccount(); } else if (Parameter.IsBankAccount) { var foundAssignments_for_Bank = CL1_ACC_BOK.ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment.Query.Search(Connection, Transaction, new CL1_ACC_BOK.ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment.Query { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, BusinessParticipant_RefID = tenantBP, Is_L3_BankAccount = true }); if (foundAssignments_for_Bank.Count == 0) { assignment = CL3_BookingAccounts.Utils.BookingAccountUtils.GetEmptyBankAccount(); assignment.Is_L3_BankAccount = true; assignment.If_L3_AssetAccount_BankAccount_RefID = Parameter.BankAccountID; //assignment.BookingAccount_RefID = Guid.NewGuid(); } else { assignment = foundAssignments.Single(); } } if (assignment != null) { if (assignment.ACC_BOK_BookingAccounts_Purpose_BP_AssignmentID == Guid.Empty) { assignment.ACC_BOK_BookingAccounts_Purpose_BP_AssignmentID = Guid.NewGuid(); } assignment.BookingAccount_RefID = Parameter.BookingAccountID; assignment.BusinessParticipant_RefID = Parameter.BusinessParticipantID; assignment.Tenant_RefID = securityTicket.TenantID; assignment.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_Bool Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L3BA_SBAT_1310 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_Bool functionReturn = new FR_Bool(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, Parameter, securityTicket); #region Cleanup Connection/Transaction //Commit the transaction if (cleanupTransaction == true) { Transaction.Commit(); } //Close the connection if (cleanupConnection == true) { Connection.Close(); } #endregion } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw new Exception("Exception occured in method cls_Set_Booking_Account_Type", ex); } return(functionReturn); }
///<summary> /// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured ///<summary> public static FR_Bool Invoke(DbConnection Connection, DbTransaction Transaction, P_L3BA_SBAT_1310 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, Transaction, null, Parameter, securityTicket)); }
///<summary> /// Opens the connection/transaction for the given connectionString, and closes them when complete ///<summary> public static FR_Bool Invoke(string ConnectionString, P_L3BA_SBAT_1310 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(null, null, ConnectionString, Parameter, securityTicket)); }
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L3BA_CRAfT_0903 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Bool(); #region Tenant's Business Participant var tenantBP = CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query { IsTenant = true, IfTenant_Tenant_RefID = securityTicket.TenantID, Tenant_RefID = securityTicket.TenantID }).Single(); #endregion #region Retrieve all valid taxes var taxQuery = new CL1_ACC_TAX.ORM_ACC_TAX_Tax.Query { IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var taxes = CL1_ACC_TAX.ORM_ACC_TAX_Tax.Query.Search(Connection, Transaction, taxQuery); #endregion int counter = 0; foreach (var tax in taxes) { #region Booking Account var bookingAccountParam = new P_L3BA_CBA_1305 { FiscalYearID = Parameter.FiscalYearID, BookingAccountName = tenantBP.DisplayName, BookingAccountNumber = String.Format("{0:000000000000}", counter + 1) }; Guid bookingAccountID = cls_Create_Booking_Account.Invoke(Connection, Transaction, bookingAccountParam, securityTicket).Result; #endregion #region Create Account assignment to booking account as "Revenue Account" var bookingAccountTypeParam = new P_L3BA_SBAT_1310 { BookingAccountID = bookingAccountID, BusinessParticipantID = tenantBP.CMN_BPT_BusinessParticipantID, FiscalYearID = Parameter.FiscalYearID, IsRevenueAccount = true, TaxRate = tax.TaxRate }; cls_Set_Booking_Account_Type.Invoke(Connection, Transaction, bookingAccountTypeParam, securityTicket); #endregion } returnValue.Result = true; return(returnValue); #endregion UserCode }