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