public void AddVote(int movieId, int rate)
{
_context.Rating.Add(new Rating()
{
Rate = rate,
Date = DateTime.Now,
Films = _context.Films.FirstOrDefault(x => x.Id == movieId)
});
_context.SaveChanges();
}
private void InitializeDB()
{
_context.Database.EnsureCreated();
if (_context.Films.Any())
{
return;
}
var SWApiReader = new SWApiReader();
var filmsList = new List <Films>();
var peopleList = new List <People>();
var starshipsList = new List <Starships>();
var planetsList = new List <Planets>();
var vehiclesList = new List <Vehicles>();
var speciesList = new List <Species>();
var movies = SWApiReader.GetMovies();
foreach (var item in movies)
{
var movie = new Films
{
Id = (int)JObject.Parse(item.ToString())["episode_id"],
Episode_id = (int)JObject.Parse(item.ToString())["episode_id"],
Title = (string)JObject.Parse(item.ToString())["title"],
Opening_crawl = (string)JObject.Parse(item.ToString())["opening_crawl"],
Director = (string)JObject.Parse(item.ToString())["director"],
Producer = (string)JObject.Parse(item.ToString())["producer"],
Url = (string)JObject.Parse(item.ToString())["url"],
Created = (DateTime)JObject.Parse(item.ToString())["created"],
Edited = (DateTime)JObject.Parse(item.ToString())["edited"],
Release_date = (DateTime)JObject.Parse(item.ToString())["release_date"]
};
var peoples = new List <People>();
var starships = new List <Starships>();
var planets = new List <Planets>();
var vehicles = new List <Vehicles>();
var species = new List <Species>();
var peoplesIds = GetArraysOfIds((JArray)JObject.Parse(item.ToString())["characters"]);
foreach (var id in peoplesIds)
{
var character = peopleList.FirstOrDefault(f => f.Id == id);
if (character != null)
{
peoples.Add(character);
}
else
{
var newCharacter = SWApiReader.GetCharacterById(id);
peoples.Add(newCharacter);
peopleList.Add(newCharacter);
}
}
var speciesIds = GetArraysOfIds((JArray)JObject.Parse(item.ToString())["species"]);
foreach (var id in speciesIds)
{
var kind = speciesList.FirstOrDefault(f => f.Id == id);
if (kind != null)
{
species.Add(kind);
}
else
{
var newKind = SWApiReader.GetSpeciesById(id);
species.Add(newKind);
speciesList.Add(newKind);
}
}
var starshipsIds = GetArraysOfIds((JArray)JObject.Parse(item.ToString())["starships"]);
foreach (var id in starshipsIds)
{
var starship = starshipsList.FirstOrDefault(f => f.Id == id);
if (starship != null)
{
starships.Add(starship);
}
else
{
var newStarship = SWApiReader.GetStarshipById(id);
starships.Add(newStarship);
starshipsList.Add(newStarship);
}
}
var vehilcesIds = GetArraysOfIds((JArray)JObject.Parse(item.ToString())["vehicles"]);
foreach (var id in vehilcesIds)
{
var vehilce = vehiclesList.FirstOrDefault(f => f.Id == id);
if (vehilce != null)
{
vehicles.Add(vehilce);
}
else
{
var newVehilce = SWApiReader.GetVehilceById(id);
vehicles.Add(newVehilce);
vehiclesList.Add(newVehilce);
}
}
var planetsIds = GetArraysOfIds((JArray)JObject.Parse(item.ToString())["planets"]);
foreach (var id in planetsIds)
{
var planet = planetsList.FirstOrDefault(f => f.Id == id);
if (planet != null)
{
planets.Add(planet);
}
else
{
var newPlanet = SWApiReader.GetPlanetById(id);
planets.Add(newPlanet);
planetsList.Add(newPlanet);
}
}
movie.People = peoples;
movie.Starships = starships;
movie.Planets = planets;
movie.Vehicles = vehicles;
movie.Species = species;
filmsList.Add(movie);
}
foreach (var item in speciesList)
{
_context.Species.Add(item);
}
_context.SaveChanges();
foreach (var item in vehiclesList)
{
_context.Vehicles.Add(item);
}
_context.SaveChanges();
foreach (var item in planetsList)
{
_context.Planets.Add(item);
}
_context.SaveChanges();
foreach (var item in starshipsList)
{
_context.Starships.Add(item);
}
_context.SaveChanges();
foreach (var item in peopleList)
{
_context.People.Add(item);
}
_context.SaveChanges();
foreach (var item in filmsList)
{
_context.Films.Add(item);
}
_context.SaveChanges();
}
public void Seed()
{
if (db.Department.Any() || db.Seller.Any() || db.SalesRecord.Any())
{
return; //db has been seeded | o banco de dados já foi populado (contém dados)
}
else
{
Department d1 = new Department(1, "Computadores");
Department d2 = new Department(2, "Eletronicos");
Department d3 = new Department(3, "Livros");
Department d4 = new Department(4, "Moda");
Seller s1 = new Seller(1, "Eric", "*****@*****.**", new DateTime(1998, 4, 21), 1000, d1);
Seller s2 = new Seller(2, "Maria", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Alex", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Marta", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller(5, "Pedro", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller(6, "Julia", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
db.Department.AddRange(d1, d2, d3, d4);
db.Seller.AddRange(s1, s2, s3, s4, s5, s6);
db.SalesRecord.AddRange
(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
db.SaveChanges();
}
}
public void UpdatePerson(Person person)
{
SWContext.Users.Update(person);
SWContext.SaveChanges();
}