public List <AccountDetailDTO> GetUserAccounts([FromBody] String userId)
{
AccountDetailDTO accountDetail;
List <AccountDetailDTO> accountDetailList = new List <AccountDetailDTO>();
List <BankAccount> accountsList = _accountDBAccess.FindByUser(userId);
foreach (BankAccount account in accountsList)
{
List <Transaction> accountTransactions = _transactionDBAccess.FindByAccount(account.BankAccountId);
decimal balance = _businessService.GetAccountBalance(accountTransactions, account.InitialAmount);
accountDetail = new AccountDetailDTO
{
AccountId = account.BankAccountId,
Name = account.Name,
InitialAmount = account.InitialAmount,
Balance = balance,
LastTransactionDate = accountTransactions.Count != 0 ? DateConverter.DateTimeToLong(accountTransactions.Last().TransactionDate) : 0,
UserId = account.UserId
};
accountDetailList.Add(accountDetail);
}
return(accountDetailList);
}
static void Main(string[] args)
{
Console.WriteLine("Non-Adapted:");
var nonAdaptedPerson = new AccountDTO(CustomerType.Person);
nonAdaptedPerson.Display();
Console.WriteLine("\n\nAdapted:");
var person = new AccountDetailDTO(CustomerType.Person);
person.Display();
var company = new AccountDetailDTO(CustomerType.Company);
company.Display();
var staff = new AccountDetailDTO(CustomerType.Staff);
staff.Display();
}
public static List <AccountDetailDTO> GetEmployeeByMonth(int month, int year, bool salaried = false)
{
List <AccountDetailDTO> List = new List <AccountDetailDTO>();
string query = string.Format("SELECT * FROM EMPLOYEEHISTORY e " +
"RIGHT JOIN ACCOUNT a ON a.ID = e.ACCOUNTID AND e.MONTH = {0} AND e.YEAR = {1} WHERE e.ACCOUNTID IS NULL", month, year);
if (salaried)
{
query = string.Format("SELECT * FROM EMPLOYEEHISTORY e " +
"RIGHT JOIN ACCOUNT a ON a.ID = e.ACCOUNTID AND e.MONTH = {0} AND e.YEAR = {1} WHERE e.ACCOUNTID IS NOT NULL", month, year);
}
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
AccountDetailDTO account = new AccountDetailDTO(item);
List.Add(account);
}
return(List);
}
