public ActionResult Index()
{
_logger.LogInfo("Hey - I called the Home Page!!!!");
ViewBag.Message = "Welcome to ASP.NET MVC!";
var db = new LearnMVC3DBContext();
var productions = db.Productions;
var orders = db.Orders;
var production = CreateNewProduction();
var order = CreateNewOrder();
productions.Add(production);
orders.Add(order);
try
{
int success = db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
_logger.LogInfo(string.Format(" > Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage));
}
}
}
catch (Exception ex)
{
_logger.LogInfo(string.Format("Error DB: {0}", ex.Message));
}
//_logger.LogInfo(string.Format("Datatabase: {0}", ((IObjectContextAdapter)db).ObjectContext.Connection.ConnectionString));
return View();
}
public DBFiller(LearnMVC3DBContext dbContext)
{
db = dbContext;
productions = db.Productions;
orders = db.Orders;
}
private void ClearFullTable(string table, LearnMVC3DBContext dbContext)
{
dbContext.Database.ExecuteSqlCommand(String.Format("delete from {0}", table));
}