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