public ActionResult Index() { if (!_context.SystemControls.Any()) { _context.SystemControls.Add(new SystemControl() { Status = 0 }); _context.SaveChanges(); } ViewBag.Status = _context.SystemControls.First().Status; return(View()); }
public void Save(GoCanvasDbContext dbContext) { try { try { dbContext.Database.ExecuteSqlRaw($"INSERT INTO [tblMySubmissions]([FormName],[GoCanSubmissionGUID])VALUES ('{this.Form.Name}', '{this.Submission.SubmissionGuid.ToString()}');"); } catch (Exception exception) { Console.WriteLine(exception); } } catch (Exception e) { dbContext.MySubmissions.Load(); dbContext.MySubmissions.Add(new MySubmissions() { FormName = this.Form.Name, GoCanSubmissionGUID = this.Submission.SubmissionGuid.ToString() }); dbContext.SaveChanges(); } }