public string RemoveGeneralAccount(Guid id) { try { GeneralAccountRepository repository = new GeneralAccountRepository(); GeneralAccount generalAccount = repository.ActiveContext.GeneralAccounts.Include("IndexAccounts") .Where(ga => ga.Id == id) .FirstOrDefault(); if (generalAccount == null) { return("no record was found by this id"); } if (generalAccount.ContainIndexAccounts) { return("this record has index account record and can not be deleted"); } repository.Remove(generalAccount); return("has successfully removed"); } catch (Exception exception) { return(exception.Message); } }
public void create_generalAccount() { GeneralAccount generalAccount = CreateGeneralAccount(); GeneralAccountRepository repository = new GeneralAccountRepository(); repository.Add(generalAccount); }
public ActionResult GetDynamicGeneralAccountCode(int GeneralAccountID) { FM_Bank model = new FM_Bank(); GeneralAccount tblSector = (from e in TOSSDB.GeneralAccounts where e.GeneralAccountID == GeneralAccountID select e).FirstOrDefault(); model.BankAccountGeneralAccountCodeID = tblSector.SubMajorAccountGroup.MajorAccountGroup.AccountGroup.AccountGroupCode + "- " + tblSector.SubMajorAccountGroup.MajorAccountGroup.MajorAccountGroupCode + "- " + tblSector.SubMajorAccountGroup.SubMajorAccountGroupCode + "- " + tblSector.GeneralAccountCode; return(PartialView("BankAccount/_DynamicDDGeneralCode", model)); }
public static GeneralAccount CreateGeneralAccount() { var generalAccount = new GeneralAccount { Id = Guid.NewGuid(), Description = "sandogh", Category = 1, Code = 1 }; return(generalAccount); }
public GeneralAccountDto GetGeneralAccount(int code) { GeneralAccountRepository repository = new GeneralAccountRepository(); GeneralAccount general = repository.ActiveContext.GeneralAccounts .Where(ga => ga != null && ga.Code == code) .FirstOrDefault(); return(general != null ? (GeneralAccountDto) new GeneralAccountDto().InjectFrom <UnflatLoopValueInjection>(general) : null); }
public void Create_Complex_Account() { var context = new ValiasrContext("Valiasr"); Person person = PersonTest.CreatePerson(); Customer customer = PersonTest.CreateCustomer(person); Lawyer lawyer = PersonTest.CreateLawyer(person); IndexAccount indexAccount = CreateIndexAccount(); GeneralAccount generalAccount = CreateGeneralAccount(); Account account = CreateAccount(); account.Lawyers = new Collection <Lawyer>(); account.Lawyers.Add(lawyer); account.Customers = new Collection <Customer>(); account.Customers.Add(customer); LoanRequest loanRequest = new LoanRequest(); Loan loan = new Loan(); // loan.Account = account; loan.LoanRequest = loanRequest; LoanRequestOkyAssistant loanRequestOkyAssistant = new LoanRequestOkyAssistant(); loanRequest.LoanRequestOkyAsistant = loanRequestOkyAssistant; loanRequest.Account = account; account.LoanRequests = new Collection <LoanRequest>(); account.LoanRequests.Add(loanRequest); indexAccount.BankAccounts = new Collection <BankAccount>(); indexAccount.BankAccounts.Add(account); indexAccount.BankAccounts.Add(loan); generalAccount.IndexAccounts = new Collection <IndexAccount>(); generalAccount.IndexAccounts.Add(indexAccount); context.GeneralAccounts.Add(generalAccount); //context.IndexAccounts.Add(indexAccount); context.SaveChanges(); /* GeneralAccount generalAccount = CreateGeneralAccount(); * * * * account.Lawyers.Add(lawyer); * indexAccount.Accounts.Add(account); * generalAccount.IndexAccounts.Add(indexAccount); * * context.GeneralAccounts.Add(generalAccount); * account.Customers.Add(customer); * context.SaveChanges();*/ }
/// <summary> /// Method to create a new account. /// </summary> /// <param name="accountNumber">The account number.</param> /// <param name="customerId">The customer identifier.</param> /// <param name="currencyCode">The currency code.</param> /// <param name="initialBalance">The initial balance.</param> /// <param name="mimimumBalance">The mimimum balance.</param> public void CreateGeneralAccount(string accountNumber, string customerId, string currencyCode, decimal?initialBalance, decimal?mimimumBalance) { try { if (Repository.GeneralAccountRepository.Any(a => string.Equals(a.AccountNumber, accountNumber, StringComparison.CurrentCultureIgnoreCase))) { throw new DataException($"Unable to create account as account number {accountNumber} already exist !!"); } if (initialBalance == null) { throw new DataException("Unable to create account as provided initial balance is unknown !!"); } if (mimimumBalance == null) { throw new DataException("Unable to create account as provided minimum balance is unknown !!"); } ICustomer accountHolder = Repository.CustomerRepository.FirstOrDefault(c => string.Equals(c.CustomerId, customerId, StringComparison.CurrentCultureIgnoreCase)); if (accountHolder == null) { throw new DataException($"Unable to create account for customer id {customerId} as customer not found !!"); } Currency defaultCurrency = Repository.CurrencyRepository.FirstOrDefault(c => string.Equals(c.Code, currencyCode, StringComparison.CurrentCultureIgnoreCase)); if (defaultCurrency == null) { throw new DataException($"Unable to create account for customer as provided currency code {currencyCode} doesn't exist !!"); } IGeneralAccount account = new GeneralAccount(accountNumber, accountHolder, defaultCurrency, initialBalance.Value, mimimumBalance.Value); Repository.GeneralAccountRepository.Add(account); } catch (DataException dataException) { Console.WriteLine($"ERROR - {dataException.Message}"); } catch (Exception ex) { Console.WriteLine($"An error occured while creating account !! {ex.Message}"); } }
/// <summary> /// accout region /// </summary> /// <param name="generalAccountDto"></param> public string AddGeneralAccount(GeneralAccountDto generalAccountDto) { try { int code = generalAccountDto.Code; GeneralAccountRepository repository = new GeneralAccountRepository(); if ((repository.ActiveContext.GeneralAccounts.Count(ga => ga.Code == code)) == 0) { GeneralAccount generalAccount = new GeneralAccount(); generalAccountDto.Id = Guid.NewGuid(); generalAccount.InjectFrom <UnflatLoopValueInjection>(generalAccountDto); repository.Add(generalAccount); return("has successfully created"); } return("this record with this code is there"); } catch (Exception exception) { return(exception.Message); } }
/// <summary> /// accout region /// </summary> /// <param name="generalAccountDto"></param> public string AddGeneralAccount(GeneralAccountDto generalAccountDto) { try { int code = generalAccountDto.Code; GeneralAccountRepository repository = new GeneralAccountRepository(); if ((repository.ActiveContext.GeneralAccounts.Count(ga => ga.Code == code)) == 0) { GeneralAccount generalAccount = new GeneralAccount(); generalAccountDto.Id = Guid.NewGuid(); generalAccount.InjectFrom<UnflatLoopValueInjection>(generalAccountDto); repository.Add(generalAccount); return "has successfully created"; } return "this record with this code is there"; } catch (Exception exception) { return exception.Message; } }
public void Create_Complex_Account1() { GeneralAccountRepository context = new GeneralAccountRepository(); Person person = PersonTest.CreatePerson(); // Customer customer = PersonTest.CreateCustomer(person); Lawyer lawyer = PersonTest.CreateLawyer(person); GeneralAccount generalAccount = CreateGeneralAccount(); IndexAccount indexAccount = CreateIndexAccount(); Account account = CreateAccount(); // account.Customers.Add(customer); account.Lawyers.Add(lawyer); indexAccount.BankAccounts.Add(account); generalAccount.IndexAccounts.Add(indexAccount); context.Add(generalAccount); //context.AddIndexAccount(indexAccount); //context.GeneralAccounts.Add(generalAccount); // context.SaveChanges(); }
public static void ComputerFinanicalStatemments(DataStore dataStore) { var input = dataStore.GetPackage(WorkFlowViewModel.InputParametersPackageDefinition); var journalStatements = dataStore.GetPackage(WorkFlowViewModel.InputJournalStatementsPackageDefintion); var previousBalanceSheetStatements = dataStore.GetPackage(WorkFlowViewModel.PreviousBalanceSheetStatementsPackageDefinition); var accountDefinitionStatement = dataStore.GetPackage(WorkFlowViewModel.InputAccountDefinitionPackageDefinition); var accountPrintableNamesLookup = dataStore.GetPackage(WorkFlowViewModel.DisplayableAccountNamesDictionaryPackageDefinition); GeneralAccount generalAccount = new GeneralAccount(input.AccountingPeriodStartDate, input.AccountingPeriodEndDate, previousBalanceSheetStatements, journalStatements, accountDefinitionStatement, accountPrintableNamesLookup); dataStore.PutPackage(generalAccount.GetAllAccounts(), WorkFlowViewModel.AccountsPackageDefinition); dataStore.PutPackage(generalAccount.GetTrialBalanceStatements(), WorkFlowViewModel.TrialBalanceStatementsPackageDefinition); dataStore.PutPackage(generalAccount.GetBalanceSheetStatements(), WorkFlowViewModel.BalanceSheetStatementsPackageDefinition); }
public string AddIndexAccount(IndexAccountDto indexAccountDto) { try { IndexAccountRepository repository = new IndexAccountRepository(); GeneralAccount generalAccount = repository.ActiveContext.GeneralAccounts.Include("IndexAccounts") .FirstOrDefault(ga => ga.Id == indexAccountDto.GeneralAccountId); if (!generalAccount.ContainIndexAccount(code: indexAccountDto.Code)) { IndexAccount indexAccount = new IndexAccount(); indexAccountDto.Id = Guid.NewGuid(); indexAccount.InjectFrom <UnflatLoopValueInjection>(indexAccountDto); indexAccount.GeneralAccount = generalAccount; repository.Add(indexAccount); return("has successfully created"); } return("this record with this code was there in database"); } catch (Exception exception) { return(exception.Message); } }
public static GeneralAccount CreateGeneralAccount() { var generalAccount = new GeneralAccount { Id = Guid.NewGuid(),Description = "sandogh", Category = 1,Code = 1}; return generalAccount; }
public FM_ChartOfAccounts_GeneralAccount() { getGeneralAccount = new List <GeneralAccount>(); getGeneralAccountcolumns = new GeneralAccount(); getGeneralAccountList = new List <GeneralAccountList>(); }