public IActionResult Explicit()
{
St_type type = db.Types.FirstOrDefault();
db.Stagings.Where(p => p.St_typeId == type.Id).Load();
return(View(db.Stagings.ToList()));
}
public HomeController(ApplicationContext context)
{
this.db = context;
//context.Database.EnsureDeleted();
if (!db.Types.Any())
{
St_type balet = new St_type {
Type = "Balet"
};
St_type theater = new St_type {
Type = "Theater"
};
St_type opera = new St_type {
Type = "Opera"
};
Staging staging1 = new Staging {
Name = "Three masks of the king", St_type = opera, Tickets = 100, Price = 1700
};
Staging staging2 = new Staging {
Name = "Prince Vladimir", St_type = balet, Tickets = 100, Price = 1900
};
Staging staging3 = new Staging {
Name = "The Wedding of Figaro", St_type = opera, Tickets = 100, Price = 1500
};
Staging staging4 = new Staging {
Name = "Aida", St_type = theater, Tickets = 100, Price = 1700
};
Staging staging5 = new Staging {
Name = "Anna Karenina", St_type = theater, Tickets = 100, Price = 2000
};
Staging staging6 = new Staging {
Name = "Swan Lake", St_type = balet, Tickets = 100, Price = 2000
};
db.Types.AddRange(balet, theater, opera);
db.Stagings.AddRange(staging1, staging2, staging3,
staging4, staging5, staging6);
db.SaveChanges();
}
}
public HomeController(DataContext context)
{
this.db = context;
if (db.Types.Count() == 0)
{
St_type balet = new St_type {
Type = "Balet"
};
St_type theater = new St_type {
Type = "Theater"
};
St_type opera = new St_type {
Type = "Opera"
};
Staging staging1 = new Staging {
Name = "Three masks of the king", Tickets = 100, Price = 1700, St_type = opera, CreationDate = DateTime.Now
};
Staging staging2 = new Staging {
Name = "Prince Vladimir", Tickets = 100, Price = 1900, St_type = balet, CreationDate = DateTime.Now
};
Staging staging3 = new Staging {
Name = "The Wedding of Figaro", Tickets = 100, Price = 1500, St_type = opera, CreationDate = DateTime.Now
};
Staging staging4 = new Staging {
Name = "Aida", Tickets = 100, Price = 1700, St_type = theater, CreationDate = DateTime.Now
};
Staging staging5 = new Staging {
Name = "Anna Karenina", Tickets = 100, Price = 2000, St_type = theater, CreationDate = DateTime.Now
};
Staging staging6 = new Staging {
Name = "Swan Lake", Tickets = 100, Price = 2000, St_type = balet, CreationDate = DateTime.Now
};
db.Types.AddRange(balet, theater, opera);
db.Stagings.AddRange(staging1, staging2, staging3, staging4, staging5, staging6);
db.SaveChanges();
}
}
public IActionResult AddNew(string name, string type, int tickets, int price)
{
var type1 = new St_type
{
Type = type
};
var staging = new Staging()
{
Name = name,
St_type = type1,
Tickets = tickets,
Price = price,
CreationDate = DateTime.Now
};
if (staging.Name == null && staging.Tickets < 0 && staging.Price < 0)
{
return(BadRequest());
}
db.Stagings.Add(staging);
db.SaveChanges();
return(RedirectToAction("Index"));
}
