public IActionResult Index(WelcomeModel model) { WelcomeModel user = null; using (var db = new WelcomeContext()) //использование контекста { user = db.welcomers.Where(x => x.name == model.name && x.profession == model.profession) .FirstOrDefault(); } if (user == null) { ViewBag.Message = "Добро пожаловать! Вы автоматически зарегистрированы! Пожалуйста, перед тем, как выйти из здания подойдите к соответствующему окну!"; using (var db = new WelcomeContext()) { db.Add(new WelcomeModel { isinbuilding = true, lastin = DateTime.Now, profession = model.profession, name = model.name }); db.SaveChanges(); } return(View()); } ViewBag.Message = "Добро пожаловать!"; return(View()); }
public IActionResult About(WelcomeModel model) { WelcomeModel user = null; using (var db = new WelcomeContext()) { user = db.welcomers.Where(x => x.name == model.name && x.profession == model.profession).FirstOrDefault(); user.lastout = DateTime.Now; } AddDataInVisit(user); using (var db = new VisitContext()) { db.Update(user); } return(View()); }
public string WriteToDatabase([FromBody] Message m) { WelcomeContext wc = null; string response = string.Empty; try { DbContextOptionsBuilder <WelcomeContext> builder = new DbContextOptionsBuilder <WelcomeContext>(); builder.UseInMemoryDatabase("Welcome"); DbContextOptions <WelcomeContext> options = builder.Options; wc = new WelcomeContext(options); wc.WelcomeMessages.Add( new Welcome { WelcomeMessage = m.Content, DateReceived = DateTime.Now } ); wc.SaveChanges(); response = wc.WelcomeMessages.OrderByDescending(i => i.Id) .Select(f => f.WelcomeMessage) .First().ToString(); } catch (Exception ex) { response = ex.Message; } finally { wc.Dispose(); } return(response); }
public AgentsController(IStringLocalizer <AgentsController> localizer, WelcomeContext context, UserAccessInfo UserInfo) { _localizer = localizer; _context = context; _userinfo = UserInfo; }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, WelcomeContext context) { loggerFactory.AddConsole(Configuration.GetSection("Logging")); loggerFactory.AddDebug(); var locOptions = app.ApplicationServices.GetService <IOptions <RequestLocalizationOptions> >(); app.UseRequestLocalization(locOptions.Value); app.UseSession(); app.UseApplicationInsightsRequestTelemetry(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseDatabaseErrorPage(); app.UseBrowserLink(); } else { app.UseExceptionHandler("/Home/Error"); } app.UseApplicationInsightsExceptionTelemetry(); app.UseStaticFiles(); app.UseIdentity(); // Add external authentication middleware below. To configure them please see http://go.microsoft.com/fwlink/?LinkID=532715 app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); DbInitializer.Initialize(context); }
public HotelReservationsController(IStringLocalizer <HotelReservationsController> localizer, WelcomeContext context, UserAccessInfo UserInfo) { _localizer = localizer; _context = context; _userinfo = UserInfo; }