public List <DisplayAccount> GetAllDisplayAccounts()
{
List <DisplayAccount> accounts = new List <DisplayAccount>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GET_ALL_DISPLAY_ACCOUNTS, conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
DisplayAccount account = new DisplayAccount();
account.Username = Convert.ToString(rdr["username"]);
account.AccountId = Convert.ToInt32(rdr["account_id"]);
accounts.Add(account);
}
return(accounts);
}
}
catch (SqlException ex)
{
throw;
}
}
private void ViewAccountExecute()
{
DisplayAccount view = new DisplayAccount();
view.DataContext = new DisplayAccountViewModel(view, SelectItem.Ssn);
view.Owner = mWindow;
bool?result = view.ShowDialog();
if (result == true)
{
}
}
internal static AcctTile CreateTile(Transform container,
DisplayAccount acct, Vector3 iniPos, SubBulletinFinance finance)
{
AcctTile obj = null;
var root = "";
obj = (AcctTile)Resources.Load(Root.acct_Tile, typeof(AcctTile));
obj = (AcctTile)Instantiate(obj, new Vector3(), Quaternion.identity);
var iniScale = obj.transform.localScale;
obj.transform.SetParent(container);
obj.transform.localPosition = iniPos;
obj.transform.localScale = iniScale;
obj.Acct = acct;
obj.Finance = finance;
return(obj);
}
private MenuOptionResult RequestTEBucks()
{
List <DisplayAccount> accounts = accountDAO.GetAllAccounts();
accounts = accounts.Where(a => a.AccountId != UserService.GetUserId()).ToList();
Console.WriteLine("-----------------------------------------");
Console.WriteLine($"Users");
Console.WriteLine($"{"ID",-11}{"Name",-10}");
Console.WriteLine("-----------------------------------------");
foreach (DisplayAccount account in accounts)
{
Console.WriteLine($"{account.AccountId, -10} {account.Username, -10}");
}
bool validId = false;
int fromAccountId = -1;
while (!validId)
{
fromAccountId = GetInteger("Enter ID of user you are requesting from (0 to cancel): ");
if (fromAccountId == 0)
{
return(MenuOptionResult.DoNotWaitAfterMenuSelection);
}
DisplayAccount verifiedAccount = accounts.Find(a => a.AccountId == fromAccountId);
if (verifiedAccount != null)
{
break;
}
else
{
Console.WriteLine("Please provide a valid ID.");
}
}
decimal requestAmount = GetDecimal("Enter Amount");
DisplayAccount accountFrom = accounts.Find(a => a.AccountId == fromAccountId);
Transfer transfer = new Transfer();
transfer.TransferStatus = TransferStatus.Pending;
transfer.TransferType = TransferType.Request;
transfer.AccountFrom = accountFrom.AccountId;
transfer.AccountTo = UserService.GetUserId();
transfer.Amount = requestAmount;
transfer.UserNameTo = UserService.GetUserName();
transfer.UserNameFrom = accountFrom.Username;
bool wasRequested = transferDAO.CreateTransferRequest(transfer);
if (wasRequested)
{
Console.WriteLine("Successfully requested transfer!");
}
else
{
Console.WriteLine("Transfer request failed.");
}
return(MenuOptionResult.WaitAfterMenuSelection);
}
private MenuOptionResult SendTEBucks()
{
List <DisplayAccount> accounts = accountDAO.GetAllAccounts();
accounts = accounts.Where(a => a.AccountId != UserService.GetUserId()).ToList();
Console.WriteLine("-----------------------------------------");
Console.WriteLine($"Users");
Console.WriteLine($"{"ID", -11}{"Name", -10}");
Console.WriteLine("-----------------------------------------");
foreach (DisplayAccount account in accounts)
{
Console.WriteLine($"{account.AccountId, -10} {account.Username, -10}");
}
bool validId = false;
int accountToId = -1;
while (!validId)
{
accountToId = GetInteger("Enter ID of user you are sending to (0 to cancel): ");
if (accountToId == 0)
{
return(MenuOptionResult.DoNotWaitAfterMenuSelection);
}
// verifies selected Id is in list of users
DisplayAccount verifiedAccount = accounts.Find(a => a.AccountId == accountToId);
if (verifiedAccount != null)
{
break;
}
else
{
Console.WriteLine("Please provide a valid ID.");
}
}
decimal transferAmount = GetDecimal("Enter amount: ");
Account userAccount = accountDAO.GetAccountByUserId(UserService.GetUserId());
if (transferAmount > userAccount.Balance)
{
Console.WriteLine("I'm sorry you don't have enough funds for the transfer");
return(MenuOptionResult.WaitAfterMenuSelection);
}
DisplayAccount toAccount = accounts.Find(a => a.AccountId == accountToId);
Transfer transfer = new Transfer();
transfer.TransferStatus = TransferStatus.Approved;
transfer.TransferType = TransferType.Send;
transfer.AccountFrom = userAccount.AccountId;
transfer.AccountTo = accountToId;
transfer.Amount = transferAmount;
transfer.UserNameTo = toAccount.Username;
transfer.UserNameFrom = UserService.GetUserName();
bool wasTransferred = transferDAO.CreateTransfer(transfer);
if (wasTransferred)
{
Console.WriteLine("Successful transfer!");
}
else
{
Console.WriteLine("Transfer failed.");
}
return(MenuOptionResult.WaitAfterMenuSelection);
}
