public List <Account> ListarAccounts() { using (var ctx = new TransactionsContext()) { return(baseDalc.Find <Account>().OrderBy(x => x.AccountId).ToList <Account>()); } }
public Transaction BuscarTransacaoPorId(string id) { using (var ctx = new TransactionsContext()) { return(baseDalc.Find <Transaction>().FirstOrDefault(x => x.TransactionId == id)); } }
public List <Transaction> ListarTransacoes() { using (var ctx = new TransactionsContext()) { return(baseDalc.Find <Transaction>().OrderBy(x => x.DataPost).ToList <Transaction>()); } }
/// <summary> /// Method to delete a single item from the database /// </summary> /// <param name="id">id of the item marked for deletion</param> /// <returns></returns> public ActionResult Delete(int id) { var dbContext = new TransactionsContext(); var itemToRemove = dbContext.testts.SingleOrDefault(x => x.Id == id); if (itemToRemove != null) { dbContext.testts.Remove(itemToRemove); dbContext.SaveChanges(); } return(RedirectToAction("ViewDbData")); }
/// <summary> /// Method to retrieve existing data from the database /// </summary> /// <returns></returns> public ActionResult ViewDbData() { var dbContext = new TransactionsContext(); var transactionList = new List <Transaction>(); foreach (var item in dbContext.testts) { transactionList.Add(new Transaction { Account = item.AccountNumber, Description = item.Description, CurrencyCode = item.CCode, Amount = item.Amount, Id = item.Id }); } return(View(transactionList)); }
public void SalvarTransacoes(List <Transaction> trs) { foreach (var item in trs) { using (var ctx = new TransactionsContext()) { using (var ctxTransaction = ctx.Database.BeginTransaction()) { try { ctx.Entry(item.Account).State = EntityState.Modified; ctx.Transactions.Add(item); ctx.SaveChanges(); ctxTransaction.Commit(); } catch (Exception) { ctxTransaction.Rollback(); } } } } }
public static void Main() { var context = new TransactionsContext(); var newsCount = context.News.Count(); }
/// <inheritdoc /> public async Task <Response <List <Transaction> > > RetrievesHistory(TransactionsContext context) => await _client.GetAsync <Response <List <Transaction> > >( "/api/v1/transactions", context);