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