public void Exercise8()
{
MinionRepository minionRepository = new MinionRepository();
List <Minion> minions = new List <Minion>(minionRepository.GetAll());
foreach (var item in minions)
{
Console.WriteLine(item.Id + " " + item.Name + " " + item.Age);
}
Console.WriteLine("Enter IDs separated by space");
var idList = Console.ReadLine().Split(" ").ToList <string>().Select(int.Parse).ToList();
foreach (var item in idList)
{
Minion m = minionRepository.GetById(item);
m.Age++;
m.Name = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(m.Name);
minionRepository.Update(m);
}
minions = new List <Minion>(minionRepository.GetAll());
foreach (var item in minions)
{
Console.WriteLine(item.Id + " " + item.Name + " " + item.Age);
}
}
public void Exercise6()
{
VillainRepository villainRepository = new VillainRepository();
MinionRepository minionRepository = new MinionRepository();
List <Villain> villains = new List <Villain>(villainRepository.GetAll());
foreach (var item in villains)
{
Console.WriteLine(item.Id + " " + item.Name);
}
Console.WriteLine("Enter id of a villain to delete:");
int id = Convert.ToInt32(Console.ReadLine());
Villain v = villainRepository.GetById(id);
if (v == null)
{
Console.WriteLine("No such villain found");
return;
}
int r = RelationshipsRepository.DeleteMinionsOfVillain(v);
villainRepository.Delete(id);
Console.WriteLine(v.Name + " was deleted.");
Console.WriteLine(r + " minions were released.");
return;
}
public void Exercise4()
{
// Declare repositories
MinionRepository minionRepository = new MinionRepository();
TownRepository townRepository = new TownRepository();
VillainRepository villainRepository = new VillainRepository();
//Promote the towns
foreach (var item in townRepository.GetAll())
{
Console.WriteLine($"Id : {item.Id}\t Name: {item.Name}");
}
//Get the Minion data
Console.WriteLine("Enter Minion Info:Name-Age-TownName");
string line = Console.ReadLine();
var minionLines = line.Split('-');
Town town = townRepository.GetByName(minionLines[2]);
//if town does not exist condition
if (town == null)
{
town = new Town();
town.Name = minionLines[2];
town.CountryId = 1;
townRepository.Insert(town);
town = townRepository.GetByName(town.Name);
Console.WriteLine($"Town {town.Name} was added to the database.");
}
//Read info of its villain
Console.WriteLine("Enter Villain Name");
string villainName = Console.ReadLine();
Villain villain = villainRepository.GetByName(villainName);
//if town does not exist condition
if (villain == null)
{
villain = new Villain();
villain.Name = villainName;
villain.EvilnessFactorId = 3;
villainRepository.Insert(villain);
villain = villainRepository.GetByName(villain.Name);
Console.WriteLine($"Villain {villain.Name} was added to the database.");
}
Minion minion = new Minion();
minion.Name = minionLines[0];
minion.Age = Convert.ToInt32(minionLines[1]);
minion.TownId = town.Id;
minionRepository.Insert(minion);
minion = minionRepository.GetByName(minion.Name);
if (RelationshipsRepository.AddNewMinionToVillain(minion, villain) > 0)
{
Console.WriteLine($"Successfully added {minion.Name} to be minion of {villain.Name}.");
}
Console.ReadKey();
}
public void Exercise7()
{
MinionRepository minionRepository = new MinionRepository();
List <Minion> minions = new List <Minion>(minionRepository.GetAll());
Minion first;
while (minions.Any())
{
first = minions.FirstOrDefault();
Console.WriteLine(first.Name);
minions.Remove(first);
minions.Reverse();
}
}
public void Exercise9()
{
MinionRepository minionRepository = new MinionRepository();
List <Minion> minions = new List <Minion>(minionRepository.GetAll());
foreach (var item in minions)
{
Console.WriteLine(item.Id + " " + item.Name + " " + item.Age);
}
Console.WriteLine("Enter IDs separated by space");
var idList = Console.ReadLine().Split(" ").ToList <string>().Select(int.Parse).ToList();
foreach (var item in idList)
{
minionRepository.GetOlder(item);
}
minions = new List <Minion>(minionRepository.GetAll());
foreach (var item in minions)
{
Console.WriteLine(item.Id + " " + item.Name + " " + item.Age);
}
}
