private static void PrintAllData(HomeCalculatorDbContex dbContex)
{
//Print users table
ListAllUsers(dbContex);
//Print Expencess table with user
ListAllExpencess(dbContex);
}
private static void ListAllExpencess(HomeCalculatorDbContex dbContex)
{
Console.WriteLine("EXPENCESS");
var expencess = dbContex.Expencesses;
foreach (var expence in expencess)
{
Console.WriteLine($"{expence.User.Name} - {expence.FlatTax } {expence.Electricity } {expence.Water } {expence.BlockTax } ");
}
}
private static void ListAllUsers(HomeCalculatorDbContex dbContex)
{
Console.WriteLine("USER NAMES");
var users = dbContex.Users;
foreach (var user in users)
{
Console.WriteLine($"{user.Name}");
}
}
private static void EditALl(HomeCalculatorDbContex dbContex)
{
Console.WriteLine("-------EDIT DATA----");
var users = dbContex.Users;
foreach (var user in users)
{
user.Name = "xxxxx";
}
var expencess = dbContex.Expencesses;
foreach (var expence in expencess)
{
expence.BlockTax = 0;
expence.FlatTax = 0;
expence.Water = 0;
expence.Electricity = 0;
}
dbContex.SaveChanges();
}
static void Main(string[] args)
{
var dbContex = new HomeCalculatorDbContex();
//Print all data in db
PrintAllData(dbContex);
//EditALl(dbContex);
dbContex.Expencesses.Add(new Expencess
{
BlockTax = 10,
FlatTax = 20,
Water = 30,
Electricity = 40,
User = new User
{
Name = "NEW"
}
});
dbContex.SaveChanges();
PrintAllData(dbContex);
}
