public List <CostModel> GetCosts()
{
List <CostModel> costs = null;
Context.AppContext dbContext = new Context.AppContext();
try
{
costs = dbContext.Costs.ToList();
}
catch (SqliteException ex)
{
dbContext.Database.ExecuteSqlCommand("alter table Costs add BalanceId text null;");
dbContext.Database.ExecuteSqlCommand("alter table Balance add Name text null;");
dbContext.Database.ExecuteSqlCommand("update Balance set Name = 'My first account'");
var firstBalance = dbContext.Balance.First();
dbContext.Database.ExecuteSqlCommand($"update Costs set BalanceId={firstBalance.Id};");
costs = dbContext.Costs.ToList();
}
finally
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
costs.Reverse();
return(costs);
}
public IEnumerable <Category> Get()
{
var categories = db.Categories.ToList();
db.Dispose();
return(categories);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
public IActionResult GetAllProducts()
{
string path = Directory.GetCurrentDirectory() + @"\Resources\Images";
if (Directory.Exists(path))
{
try
{
var pr = db.Products.ToList();
db.Dispose();
return(Json(pr));
}
catch
{
return
(StatusCode(500,
$"500. Internal server error")); //if cannot read from database throw InternalServer error status code
}
}
return(StatusCode(404, $"404.Not found"));
;
}
public List <BalanceModel> GetBalances()
{
List <BalanceModel> balances = null;
Context.AppContext dbContext = new Context.AppContext();
try
{
balances = dbContext.Balance.ToList();
}
catch (SqliteException ex)
{
dbContext.Database.ExecuteSqlCommand("alter table Balance add Name text null;");
dbContext.Database.ExecuteSqlCommand("update Balance set Name = 'My first account'");
}
finally
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
return(balances);
}
public BalanceModel GetFirstBalance()
{
BalanceModel balance = null;
Context.AppContext dbContext = new Context.AppContext();
try
{
balance = dbContext.Balance.FirstOrDefault();
}
catch (SqliteException ex)
{
dbContext.Database.ExecuteSqlCommand("alter table Balance add Name text null;");
balance = dbContext.Balance.FirstOrDefault();
}
finally
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
return(balance);
}
protected override void DisposeCore()
{
_dbContext?.Dispose();
}
