public void Seed()
{
if (_context.Pedido.Any() || _context.Cliente.Any() || _context.Jogo.Any() || _context.Console.Any())
{
return;
}
Jogo J0 = new Jogo(1, "---", "---", 0);
Jogo J1 = new Jogo(2, "CSGO", "PC", 5.50);
Jogo J2 = new Jogo(10, "CSGO", "XBOX 360", 6.50);
Jogo J3 = new Jogo(20, "CSGO", "PS3", 6.50);
Jogo J4 = new Jogo(30, "COD MW2", "PS4", 7.00);
Jogo J5 = new Jogo(40, "COD MW3", "XBOX ONE", 7.0);
Jogo J6 = new Jogo(3, "BF3", "PC", 5.50);
Jogo J7 = new Jogo(11, "SKYRIM", "XBOX 360", 6.50);
Jogo J8 = new Jogo(21, "Insurgency", "PS3", 6.50);
Jogo J9 = new Jogo(31, "Apex", "PS4", 7.00);
Jogo J10 = new Jogo(41, "Fortnite", "XBOX ONE", 7.0);
Models.Console Cc0 = new Models.Console(1, "---", 0);
Models.Console Cc1 = new Models.Console(2, "PC", 80.50);
Models.Console Cc2 = new Models.Console(3, "XBOX ONE", 85.00);
Models.Console Cc3 = new Models.Console(4, "PS4", 85.00);
Cliente C1 = new Cliente(1, "Allann Hoffmann", 84579856485, 5426853, "*****@*****.**", 985464526);
Cliente C2 = new Cliente(2, "Artur Rodrigues", 32568854232, 3254824, "*****@*****.**", 996542365);
Cliente C3 = new Cliente(3, "Amanda Silva", 12563145845, 4564213, "*****@*****.**", 965423253);
Cliente C4 = new Cliente(4, "Matheus Cruvinel", 84569741413, 1256478, "*****@*****.**", 984563123);
Pedido P1 = new Pedido(1, C1, new DateTime(2019, 6, 25), new DateTime(2019, 6, 27));
Pedido P2 = new Pedido(2, C2, new DateTime(2019, 6, 28), new DateTime(2019, 7, 12));
Pedido P3 = new Pedido(3, C3, new DateTime(2019, 7, 26), new DateTime(2019, 7, 5));
Pedido P4 = new Pedido(4, C4, new DateTime(2019, 7, 29), new DateTime(2019, 8, 14));
P1.AddJogo(J1);
P1.AddJogo(J2);
P2.AddJogo(J3);
P2.AddJogo(J4);
P3.AddJogo(J5);
P3.AddJogo(J6);
P4.AddJogo(J7);
P1.AddConsole(Cc1);
P2.AddConsole(Cc2);
P3.AddConsole(Cc3);
_context.Jogo.AddRange(J0, J1, J2, J3, J4, J5, J6, J7, J8, J9, J10);
_context.Console.AddRange(Cc0, Cc1, Cc2, Cc3);
_context.Cliente.AddRange(C1, C2, C3, C4);
_context.Pedido.AddRange(P1, P2, P3, P4);
_context.SaveChanges();
}
public void RegisterConsole(Models.Console console)
{
string query1 = "insert into Online_Store.dbo.tblConsole values( '" + console.ConsoleModel + "' , '" + console.ConsoleState + "', '" + console.ConsoleDetail + "')";
using (var db = new SqlConnection(connectionString))
{
var SentenciaAEjecutar = new SqlCommand(query1, db);
// abrimos connection
db.Open();
var ex = SentenciaAEjecutar.ExecuteNonQuery();
db.Close();
}
}
public ViewResult ConsoleForm()
{
var console = new Models.Console();
return(View(console));
}
// GET: CreateDB
public ActionResult Index()
{
var console = new Models.Console
{
Name = "Playstation 4"
};
using (var ctx = new Models.DAL.testModel())
{
ctx.Console.Add(console);
var games = new List <string>()
{
"NHL 17", "FIFA 16", "No man's sky", "Assassins Creed",
"Attack on titan", "Party Hard", "Destiny", "Curse of monkey island",
"The walking dead", "Race the sun", "Gran turismo", "Rock band 3", "Journey"
};
var gamesList = new Collection <Game>();
foreach (var g in games)
{
var game = new Game
{
Name = g,
Console = console
};
ctx.Game.Add(game);
gamesList.Add(game);
}
var names = new List <string>()
{
"rbnbghl",
"rockaz87",
"rehnmaise",
"ludde_lada83",
"sku77z0n3",
"RadX"
};
var user = new User
{
Email = "*****@*****.**",
FirstName = "Fredrik",
LastName = "Olsson",
Username = "******",
Password = "******"
};
var users = new List <User>();
users.Add(user);
var gc = new GameCollection
{
Games = gamesList
};
user.Collection = gc;
ctx.User.Add(user);
ctx.SaveChanges();
//ctx.GameCollection.Add(gc);
//ctx.SaveChanges();
//var listOfUsers = ctx.User.ToList();
//foreach(var u in listOfUsers)
//{
// u.Games = ctx.GameCollection.FirstOrDefault(x => x.User.UserID == u.UserID);
//}
//ctx.SaveChanges();
}
return(View());
}
public Console()
{
Model = new Models.Console();
ChatHandler = new Extensions.Chat.Chat();
SetCommands();
}
// GET: CreateDB
public ActionResult Index()
{
var console = new Models.Console
{
Name = "Playstation 4"
};
using (var ctx = new Models.DAL.testModel())
{
ctx.Console.Add(console);
var games = new List<string>(){ "NHL 17", "FIFA 16", "No man's sky", "Assassins Creed",
"Attack on titan", "Party Hard", "Destiny", "Curse of monkey island",
"The walking dead", "Race the sun", "Gran turismo", "Rock band 3", "Journey"};
var gamesList = new Collection<Game>();
foreach (var g in games)
{
var game = new Game
{
Name = g,
Console = console
};
ctx.Game.Add(game);
gamesList.Add(game);
}
var names = new List<string>() {
"rbnbghl",
"rockaz87",
"rehnmaise",
"ludde_lada83",
"sku77z0n3",
"RadX"
};
var user = new User
{
Email = "*****@*****.**",
FirstName = "Fredrik",
LastName = "Olsson",
Username = "******",
Password = "******"
};
var users = new List<User>();
users.Add(user);
var gc = new GameCollection
{
Games = gamesList
};
user.Collection = gc;
ctx.User.Add(user);
ctx.SaveChanges();
//ctx.GameCollection.Add(gc);
//ctx.SaveChanges();
//var listOfUsers = ctx.User.ToList();
//foreach(var u in listOfUsers)
//{
// u.Games = ctx.GameCollection.FirstOrDefault(x => x.User.UserID == u.UserID);
//}
//ctx.SaveChanges();
}
return View();
}
