public async Task <List <SavingAccounts> > ReadSaving(string email)
{
try
{
List <SavingAccounts> checkingAccounts = null;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_GetSavingAccount_ByEmail", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@Email", email);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
checkingAccounts = new List <SavingAccounts>();
while (await sdr.ReadAsync())
{
SavingAccounts obj = new SavingAccounts();
obj.AccountId = int.Parse(sdr["ID"].ToString());
obj.Account = new Accounts();
obj.Account.Id = int.Parse(sdr["ID"].ToString());
obj.Account.AccountNumber = sdr["AccountNumber"].ToString();
obj.Account.CardNumber = sdr["CardNumber"].ToString();
checkingAccounts.Add(obj);
}
}
return(checkingAccounts);
}
}
catch (Exception)
{
return(null);
}
}
static void Main(string[] args)
{
Account acc1 = new Account(1001, "Alex", 500);
Account acc2 = new SavingAccounts(1002, "Anna", 500, 0.01);
acc1.Withdraw(10);
acc2.Withdraw(10);
Console.WriteLine(acc1.Balance);
Console.WriteLine(acc2.Balance);
}
public async Task <SavingAccounts> SavingAccountsDetails(string id)
{
Accounts acc = await _context.Accounts.FirstOrDefaultAsync(acc => acc.AccountNumber == id);
EntityLayer.Persons.Persons person = await _context.Persons.FirstOrDefaultAsync(pr => pr.Id == acc.ClientId);
SavingAccounts checking = await _context.SavingAccounts.FirstOrDefaultAsync(ch => ch.Account.AccountNumber == id);
acc.Client = person;
checking.Account = acc;
return(checking);
}
public async Task <ActionResult <SavingAccounts> > Insert(SavingAccounts obj)
{
try
{
await _context.SavingAccounts.AddAsync(obj);
if (await _context.SaveChangesAsync() > 0)
{
return(obj);
}
return(null);
}
catch (Exception)
{
return(null);
}
}
public async Task <IActionResult> InsertSavingAccount(SavingAccounts obj)
{
if (ModelState.IsValid)
{
obj.Account.StartDate = DateTime.Now;
if (await _accountRepository.Insert(obj) != null)
{
return(RedirectToAction("AccountsList"));
}
ViewBag.ErrorTitle = $"Error";
ViewBag.ErrorMessage = $"Not Register";
return(View("Error"));
}
ViewBag.Clients = await _personRepository.GetPersons();
return(View(obj));
}
public async Task <IActionResult> OnGetAsync()
{
var userName = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.Name).Value;
cacct = await _context.CheckingAccounts.FirstOrDefaultAsync(c => c.Username == userName);
sacct = await _context.SavingAccounts.FirstOrDefaultAsync(s => s.Username == userName);
if (cacct != null)
{
checkingBalance = cacct.Balance;
}
if (sacct != null)
{
savingBalance = sacct.Balance;
}
return(Page());
}
public async Task <ActionResult <SavingAccounts> > Update(SavingAccounts obj)
{
try
{
var account = _context.Accounts.Attach(obj.Account);
account.State = EntityState.Modified;
var savingaccount = _context.SavingAccounts.Attach(obj);
savingaccount.State = EntityState.Modified;
if (await _context.SaveChangesAsync() > 0)
{
return(obj);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
static void Main(string[] args)
{
Account acc = new Account(1001, "Alex", 0);
BusinessAccount bacc = new BusinessAccount(1002, "Maria", 0, 500);
//UPCASTING = Conversão da subclasse para a Superclasse
Account acc1 = bacc; //conversão é permitida, pois o BusinessAccount é um acount (por causa da herança)
Account acc2 = new BusinessAccount(1003, "Bob", 0, 200);
Account acc3 = new SavingAccounts(1004, "Anna", 0, 0.01);
//DOWNCASTING = Da superclasee para a subclasse
//BusinessAccount acc4 = acc2; para o compilador acc2 é do tipo account, precisa especificar que vai ter um objeto do tipo BusinessAccount, para isso precisamos fazer um casting
BusinessAccount acc4 = (BusinessAccount)acc2;
acc4.Loan(100);
//Account acc5 = (BusinessAccount)acc3; Deste jeito apresentará um erro apenas em tempo de exucação, pois SavingAccounts é diferente de BusinessAccount, para mostrar isso antes usa-se "is"
//Este if irá falhar pois acc3 não é uma instancia de BusinessAccount
if (acc3 is BusinessAccount)
{
//BusinessAccount acc5 = (BusinessAccount)acc3;
BusinessAccount acc5 = acc3 as BusinessAccount; //Sintaxe alternativa para fazer o casting
acc5.Loan(200);
Console.WriteLine("Loan!");
}
if (acc3 is SavingAccounts)
{
SavingAccounts acc5 = (SavingAccounts)acc3;
acc5.UpdateBalance();
Console.WriteLine("Update!");
}
}
public async Task <ActionResult <SavingAccounts> > DeleteSavingAccount(int id)
{
try
{
Accounts accounts = await _context.Accounts.FirstOrDefaultAsync(acc => acc.Id == id);
SavingAccounts savingAccounts = await _context.SavingAccounts.FirstOrDefaultAsync(acc => acc.Account.Id == id);
_context.Accounts.Remove(accounts);
_context.SavingAccounts.Remove(savingAccounts);
if (await _context.SaveChangesAsync() > 0)
{
return(savingAccounts);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public async Task <IActionResult> SavingAccountDetails(string id)
{
SavingAccounts obj = await _accountRepository.SavingAccountsDetails(id);
return(View(obj));
}
