public IHttpActionResult GetCode(string accessCode) { using (var db = new SegregContext()) { var code = db.Codes.FirstOrDefault(c => c.AccessCode.Equals(accessCode, StringComparison.OrdinalIgnoreCase)); if (code == null) { return NotFound(); } return Ok(code); } }
// Ctor with connection string public PersistedRepository(string connString) { db = new SegregContext(connString); rng = new Random(); apiController = new ApiController(this); cellController = new CellController(db, this); codeController = new CodeController(this); engineController = new EngineController(this); gameController = new GameController(db, this); gridController = new GridController(db, this); logController = new LogController(db, this); playerController = new PlayerController(this); psController = new PowerShellController(this); viewController = new ViewController(this); }
protected void Page_Load(object sender, EventArgs e) { // RegisterJs("~/bundles/admin"); RegisterScript("~/scripts/segregplayerview.js"); // Process variables in query string var accessCode = Page.RouteData.Values["accessCode"] as string; // Get Player details using(var db = new SegregContext()) { var player = db.Players.FirstOrDefault(p => p.AccessCode.StartsWith(accessCode)); if (player != null) { DetailsView1.DataSource = new object[] { player }; DetailsView1.DataBind(); } } // Logging PageLog(AccessCode, "playerview", 0); }
//Ctor public LogController(SegregContext context, PersistedRepository repo) { ctx = context; db = repo; }
//Ctor public CellController(SegregContext context, PersistedRepository db) { _ctx = context; _db = db; }
//Ctor public GridController(SegregContext ctx, PersistedRepository repo) { _ctx = ctx; db = repo; }