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 bool Delete(int code)
{
var _context = new InteractiveDBContext();
using (_context)
{
var person = _context.Persons.Where(x => x.Code == code).FirstOrDefault();
_context.Persons.Remove(person);
return(true);
}
}
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);
}
public bool AddPerson(PersonDTO personDTO)
{
var _context = new InteractiveDBContext();
var person = new Person();
using (_context)
{
// person.Code = personDTO.Code;
person.IdNumber = personDTO.IdNumber;
person.Name = personDTO.Name;
person.Surname = personDTO.Surname;
person.Accounts = (ICollection <DataLayer.Models.Account>)personDTO.Accounts;
_context.Persons.Add(person);
_context.SaveChanges();
}
return(true);
}
public PersonDTO GetPersonByIdNumber(string idNumber)
{
var _context = new InteractiveDBContext();
var personDTO = new PersonDTO();
using (_context)
{
var person = _context.Persons.Where(x => x.IdNumber == idNumber).FirstOrDefault();
personDTO.Code = person.Code;
personDTO.IdNumber = person.IdNumber;
personDTO.Name = person.Name;
personDTO.Surname = person.Surname;
personDTO.Accounts = (ICollection <DTO.Account>)person.Accounts;
}
return(personDTO);
}
public bool EditPerson(PersonDTO personDTO)
{
var _context = new InteractiveDBContext();
var person = new Person();
using (_context)
{
person.Code = personDTO.Code;
person.IdNumber = personDTO.IdNumber;
person.Name = personDTO.Name;
person.Surname = personDTO.Surname;
person.Accounts = (ICollection <DataLayer.Models.Account>)personDTO.Accounts;
_context.Persons.Attach(person);
_context.Entry(person).State = EntityState.Modified;
_context.SaveChanges();
}
return(true);
}
public TransactionDTO GetTransaction(int id)
{
var _context = new InteractiveDBContext();
var transactionDTO = new TransactionDTO();
using (_context)
{
var config = new MapperConfiguration(cfg => {
cfg.CreateMap <DataLayer.Models.Account, DTO.Account>();
cfg.CreateMap <DataLayer.Models.Transaction, DTO.TransactionDTO>();
});
var transaction = _context.Transactions.Where(x => x.Code == id).FirstOrDefault();
IMapper iMapper = config.CreateMapper();
var destination = iMapper.Map <DataLayer.Models.Transaction, TransactionDTO>(transaction);
transactionDTO = destination;
}
return(transactionDTO);
}
public int AddTranstion(TransactionDTO transactionDTO)
{
var _context = new InteractiveDBContext();
var transaction = new Transaction();
using (_context)
{
transaction.Code = transactionDTO.Code;
transaction.AccountCode = transactionDTO.AccountCode;
transaction.Amount = transactionDTO.Amount;
transaction.CaptureDate = transactionDTO.CaptureDate;
transaction.Description = transactionDTO.Description;
_context.Transactions.Add(transaction);
_context.SaveChanges();
}
return(transaction.AccountCode);
}
public bool EditTranstion(TransactionDTO transactionDTO)
{
var _context = new InteractiveDBContext();
var transaction = new Transaction();
using (_context)
{
transaction.Code = transactionDTO.Code;
transaction.AccountCode = transactionDTO.AccountCode;
transaction.Amount = transactionDTO.Amount;
transaction.CaptureDate = transactionDTO.CaptureDate;
transaction.Description = transactionDTO.Description;
_context.Transactions.Attach(transaction);
_context.Entry(transaction).State = EntityState.Modified;
_context.SaveChanges();
}
return(true);
}
public bool Addacount(DTO.Account accountDTO)
{
var _context = new InteractiveDBContext();
var account = new DataLayer.Models.Account();
using (_context)
{
account.AccountNumber = accountDTO.AccountNumber;
account.Code = accountDTO.Code;
account.OutstandingBalance = accountDTO.OutstandingBalance;
account.PersonCode = accountDTO.PersonCode;
account.PersonCodeNavigation = accountDTO.PersonCodeNavigation;
account.Transactions = (ICollection <Transaction>)accountDTO.Transactions;
_context.Accounts.Add(account);
_context.SaveChanges();
}
return(true);
}
public List <PersonDTO> GetPeople()
{
var _context = new InteractiveDBContext();
var peopleList = new List <PersonDTO>();
using (_context)
{
var people = _context.Persons;
foreach (var item in people)
{
var person = new PersonDTO();
person.Code = item.Code;
person.IdNumber = item.IdNumber;
person.Name = item.Name;
person.Surname = item.Surname;
person.Accounts = item.Accounts as ICollection <DTO.Account>;
peopleList.Add(person);
}
}
return(peopleList);
}
public List <PersonDTO> GetPersonBySurname(string surname)
{
var _context = new InteractiveDBContext();
var peopleList = new List <PersonDTO>();
using (_context)
{
var people = _context.Persons.Where(x => x.Surname == surname);
foreach (var item in people)
{
var person = new PersonDTO();
person.Code = item.Code;
person.IdNumber = item.IdNumber;
person.Name = item.Name;
person.Surname = item.Surname;
person.Accounts = (ICollection <DTO.Account>)item.Accounts;
peopleList.Add(person);
}
}
return(peopleList);
}
