private void GetVillains()
{
Villains.Add(new Character()
{
personName = "Jöhann Schmidt",
name = "Caveira Vermelha",
universe = "Terra 999",
image = "red_skull_background"
});
Villains.Add(new Character()
{
personName = "Victor Von Doom",
name = "Doutor Destino",
universe = "Terra 999",
image = "dr_doom_background"
});
Villains.Add(new Character()
{
personName = "Norman Osborn",
name = "Duende Verde",
universe = "Terra 999",
image = "green_goblin_background"
});
}
public async Task <ActionResult <Villains> > PostVillains(Villains villains)
{
_context.Villains.Add(villains);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetVillains", new { id = villains.VillainId }, villains));
}
public async Task <IActionResult> PutVillains(int id, Villains villains)
{
if (id != villains.VillainId)
{
return(BadRequest());
}
_context.Entry(villains).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VillainsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
void AddMinion()
{
Minions minions = new Minions();
Console.Write("Enter minions name =");
minions.Name = Console.ReadLine();
Console.Write("Enter minions age =");
minions.Age = Convert.ToInt32(Console.ReadLine());
Towns towns = new Towns();
Console.Write("Enter minions town =");
towns.Name = Console.ReadLine();
Villains villains = new Villains();
Console.Write("Enter villains name =");
villains.Name = Console.ReadLine();
var checkVillainsName = from v in villainsRepository.GetAll()
where v.Name.ToLower() == villains.Name.ToLower()
select v.Name;
int countVillains = checkVillainsName.Count();
if (countVillains == 0)
{
villains.EvilnessFactorId = 4;
villainsRepository.Insert(villains);
Console.WriteLine($"Villain {villains.Name} was added to the database.");
}
var checkTownsName = from t in townsRepository.GetAll()
where t.Name.ToLower() == towns.Name.ToLower()
select t.Name;
int countTowns = checkTownsName.Count();
if (countTowns == 0)
{
towns.CountryCode = 4;
townsRepository.Insert(towns);
Console.WriteLine($"Town {towns.Name} was added to the database.");
}
foreach (var item in townsRepository.GetAll())
{
if (item.Name.ToLower() == towns.Name.ToLower())
{
minions.TownId = item.Id;
}
}
minionsRepositroy.Insert(minions);
Console.WriteLine($"Successfully added {minions.Name} to be minion of {villains.Name}.");
}
void AddVillains()
{
Villains v = new Villains();
Console.Write("Enter ID: ");
v.Id = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter Name: ");
v.Name = Console.ReadLine();
Console.Write("Enter EvilnessFactor(good, bad, evil...): ");
v.EvilnessFactor = Console.ReadLine();
if (villainsRepository.Insert(v) > 0)
{
Console.WriteLine("Villain added");
}
else
{
Console.WriteLine("Some error has occurred");
}
}
static void Main()
{
var connection = new SqlConnection("");
connection.Open();
using (connection)
{
var allVillains = new List<Villains>();
var command = new SqlCommand(@"SELECT V.Name, COUNT(VillainId) as Count FROM MinionsVillains AS MV
INNER JOIN Villains AS V ON V.Id = MV.VillainId
GROUP BY V.Name", connection);
var reader = command.ExecuteReader();
while (reader.Read())
{
var name = (string)reader["Name"];
var minionsCount =(int)reader["Count"];
Villains villain = new Villains()
{
Name = name,
MinionsCount = minionsCount
};
allVillains.Add(villain);
}
var resultVillains = allVillains
.Where(v => v.MinionsCount >= 2)
.OrderByDescending(m => m.MinionsCount)
.ToList();
foreach (var villain in resultVillains)
{
Console.WriteLine(villain);
}
}
}
