public PersonDTO GetPersonByPersonCode(int personCode) { var _context = new InteractiveDBContext(); var personDTO = new PersonDTO(); var person = _context.Persons.Where(x => x.Code == personCode).FirstOrDefault(); var param = new SqlParameter("@personCode", personCode); var accounts = _context.Set <DataLayer.Models.Account>().FromSqlRaw("dbo.GetByAccountsByPersonCode @personCode", param).ToList(); var config = new MapperConfiguration(cfg => { cfg.CreateMap <DataLayer.Models.Account, DTO.Account> (); cfg.CreateMap <DataLayer.Models.Transaction, DTO.TransactionDTO> (); }); IMapper iMapper = config.CreateMapper(); var accountsDTO = new List <DTO.Account>(); foreach (var item in accounts) { var destination = iMapper.Map <DataLayer.Models.Account, DTO.Account>(item); accountsDTO.Add(destination); } personDTO.Code = person.Code; personDTO.IdNumber = person.IdNumber; personDTO.Name = person.Name; personDTO.Surname = person.Surname; personDTO.Accounts = accountsDTO; return(personDTO); }
public DTO.Account GetAccountByCode(int accountCode) { var _context = new InteractiveDBContext(); var accountDTO = new DTO.Account(); var account = _context.Accounts.Where(x => x.Code == accountCode).FirstOrDefault(); var param = new SqlParameter("@accountCode", accountCode); var transactions = _context.Set <DataLayer.Models.Transaction>().FromSqlRaw("dbo.GetByTransactionByAccountCode @accountCode", param).ToList(); var config = new MapperConfiguration(cfg => { cfg.CreateMap <DataLayer.Models.Account, DTO.Account>(); cfg.CreateMap <DataLayer.Models.Transaction, DTO.TransactionDTO> (); }); IMapper iMapper = config.CreateMapper(); var transactionsDTO = new List <DTO.TransactionDTO>(); foreach (var item in transactions) { var destination = iMapper.Map <DataLayer.Models.Transaction, TransactionDTO>(item); transactionsDTO.Add(destination); } accountDTO.Code = account.Code; accountDTO.AccountNumber = account.AccountNumber; accountDTO.OutstandingBalance = account.OutstandingBalance; accountDTO.PersonCode = account.PersonCode; accountDTO.PersonCodeNavigation = account.PersonCodeNavigation; accountDTO.Transactions = transactionsDTO; return(accountDTO); }
public List <DTO.Account> GetAccounts(int personCode) { var _context = new InteractiveDBContext(); var accountList = new List <DTO.Account>(); using (_context) { object[] sqlParams = { new SqlParameter("@personCode", personCode), }; var accounts = _context.Set <Person>().FromSqlRaw("dbo.GetByAccountsByPersonCode", sqlParams); } return(accountList); }
public List <TransactionDTO> GetTransactions(int accountCode) { var _context = new InteractiveDBContext(); var transactionList = new List <TransactionDTO>(); using (_context) { object[] sqlParams = { new SqlParameter("@personCode", accountCode), }; var accounts = _context.Set <TransactionDTO>().FromSqlRaw("dbo.GetByAccountsByPersonCode", sqlParams); } return(transactionList); }
public PersonDTO GetPersonByAccount(string account) { var _context = new InteractiveDBContext(); var personDTO = new PersonDTO(); using (_context) { object[] sqlParams = { new SqlParameter("@personCode", account), }; var person = _context.Set <Person>().FromSqlRaw("dbo.GetPersonByAccount", sqlParams); } return(personDTO); }