protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); BundleMobileConfig.RegisterBundles(BundleTable.Bundles); Database.SetInitializer <LocalDbContext>(new LocalDbInitializer()); LocalDbContext context = new LocalDbContext(); context.Database.Initialize(true); DisplayModeProvider.Instance.Modes.Insert(0, new DefaultDisplayMode("iPhone") { ContextCondition = (ctx => ctx.GetOverriddenUserAgent().IndexOf("iPhone", StringComparison.OrdinalIgnoreCase) >= 0) }); DisplayModeProvider.Instance.Modes.Insert(1, new DefaultDisplayMode("iPad") { ContextCondition = (ctx => ctx.GetOverriddenUserAgent().IndexOf("iPad", StringComparison.OrdinalIgnoreCase) >= 0) }); ModelBinders.Binders.Add(typeof(CustomModelBinderModel), new CustomModelBinderModelCustomBinder()); }
private static async Task <List <RssItem> > SyncCoreAsync(LocalDbContext ctx, ISyncSource syncSource, SyncSourceInfo syncInfo, CancellationToken cancellationToken) { if (syncInfo is null) { syncInfo = new SyncSourceInfo { SyncSourceId = syncSource.SyncSourceId }; ctx.Add(syncInfo); } var page = await syncSource.TryGetItemsAsync(syncInfo.LastSyncId, cancellationToken) .ConfigureAwait(false); if (page.LastId is int lastId) { syncInfo.LastSyncId = lastId; } var newItems = page.GetItems().Select(z => { var r = new RssItem(); r.UpdateFrom(z); return(r); }).ToList(); return(ctx.AddOrIgnoreRange(newItems)); }
public IRun GetRun(Guid runId) { using (var db = new LocalDbContext()) { return(db.Runs.FirstOrDefault(x => x.Id == runId)); } }
public void AddTwoEntities_GetAll() { sqlConnection = new SqlConnection("Server=(localdb)\\mssqllocaldb;Database=ProductsTest"); context = new LocalDbContext(sqlConnection); anotherContext = new LocalDbContext(sqlConnection); if (!context.Database.Exists()) { context.Database.Create(); } var products = context.Set <Product>(); products.Add(new Product { Name = "Product #1", Price = 1.23m, Count = 8 }); products.Add(new Product { Name = "Product #2", Price = 4.56m, Count = 3 }); context.SaveChanges(); var allProducts = anotherContext.Set <Product>().ToArray(); Assert.IsNotNull(allProducts); Assert.AreEqual(2, allProducts.Length); Assert.AreEqual("Product #1", allProducts[0].Name); Assert.AreEqual(1.23m, allProducts[0].Price); Assert.AreEqual(8, allProducts[0].Count); Assert.AreEqual("Product #2", allProducts[1].Name); Assert.AreEqual(4.56m, allProducts[1].Price); Assert.AreEqual(3, allProducts[1].Count); }
//readonly ObservableCollection<Order> orders; public JournalViewModel(LocalDbContext context) { Title = "ORDERS JOURNAL"; _context = context; Orders = new ObservableCollection <Order>(context.Orders); }
///<inheritdoc/> public IExperiment GetExperiment(string experimentName) { using (var db = new LocalDbContext()) { return(db.Experiments.Single(x => x.ExperimentName == experimentName)); } }
private static Task <string> GetToken() { using (var db = new LocalDbContext()) { return(Task.FromResult(db.Usuario.SingleOrDefault()?.Token)); } }
public ProductsStatViewModel(LocalDbContext context) { Title = "PRODUCTS"; //get data for all queries context.Categories.Load(); categories = context.Categories.ToList <Category>(); context.Products.Load(); products = context.Products.ToList <Product>(); //query for ProductByCategoryGroups var ProductsAndCountries = products.Join(categories, pro => pro.CategoryID, cat => cat.CategoryID, (pro, cat) => new { pro.ProductID, cat.CategoryName }); //projection on ProductByCategoryObject this.ProductByCategoryGroups = new List <ProductByCategoryObject>(ProductsAndCountries.GroupBy(c => c.CategoryName). Select(g => new ProductByCategoryObject { CategoryName = g.Key, ProductCount = g.Count() })); }
public TableLessonViewPageModel( TableLessonViewToken token, LocalDbContext db, IExportLocatorScope scope, TabPageHost host ) { _db = db; _scope = scope; _host = host; this.Items = new CollectionViewSource { Source = _items }; this.Columns.Add(BuildMissedLessonsColumn()); this.WhenActivated(c => { this.WhenAnyValue(model => model.FilterText) .Throttle(TimeSpan.FromMilliseconds(300)) .ObserveOnDispatcher(DispatcherPriority.Background) .Subscribe(_ => { if (string.IsNullOrWhiteSpace(this.FilterText)) { this.Items.View.Filter = null; return; } this.Items.View.Filter = o => o is StudentLessonViewModel item && item.FullName.ToUpper().Contains(this.FilterText.ToUpper()); }).DisposeWith(c); }); Init(token.Lesson); }
// Clean up the db here private void CleanUp() { try { using (var context = new LocalDbContext()) { var tempUser = context.Users.Where(x => x.UserName == "tempUsername").FirstOrDefault(); var dummyUser = context.Users.Where(x => x.UserName == "dummy").FirstOrDefault(); if (tempUser != null) { context.Users.Remove(tempUser); } if (dummyUser == null) { var dummy = new User { FullName = "Dummy User", UserName = "******", Password = AppSecurity.HashPassword("test1234!").HashedPassword, Role = "Tester" }; context.Users.Add(dummy); } context.SaveChanges(); } } catch (Exception ex) { } }
///<inheritdoc/> public List <IRun> GetRuns(Guid experimentId) { using (var db = new LocalDbContext()) { return(db.Runs.Where(x => x.ExperimentId == experimentId).ToList <IRun>()); } }
///<inheritdoc/> public List <IMetric> GetMetrics(Guid runId) { using (var db = new LocalDbContext()) { return(db.Metrics.Where(x => x.RunId == runId).ToList <IMetric>()); } }
public EmployeeStatsViewModel(LocalDbContext context) { Title = "Employees"; _context = context; //get data for all queries _context.Orders.Load(); orders = _context.Orders.Local.ToList <Order>(); _context.Order_Details.Load(); orderDetails = _context.Order_Details.ToList <Order_Details>(); _context.Employees.Load(); employees = _context.Employees.Local.ToList <Employee>(); //query for SalesByEmployeeGroups var EmployeesAndOrders = employees.Join(orders, emp => emp.EmployeeID, ord => ord.EmployeeID, (emp, ord) => new { LastName = emp.LastName, OrderId = ord.OrderID }). Join(orderDetails, emp => emp.OrderId, det => det.OrderID, (emp, det) => new { name = emp.LastName, sale = det.UnitPrice * det.Quantity }); //projection on SalesByEmployeeObject this.SalesByEmployeeGroups = new List <SalesByEmployeeObject>(EmployeesAndOrders.GroupBy(c => c.name). Select(g => new SalesByEmployeeObject { LastName = g.Key, SumOfSale = g.Sum(c => c.sale) }).OrderBy(g => g.SumOfSale)); }
private async Task TrySetAudioDiscriminator(LocalDbContext context) { var alarms = await context.Alarms.ToListAsync(); foreach (var alarmEntity in alarms) { var sound = alarmEntity.Sound; if (sound == null || sound.Length == 0 || !string.IsNullOrWhiteSpace(alarmEntity.Discriminator)) { continue; } var metadataStart = new byte[20]; Array.Copy(sound, metadataStart, 20); var metadataAsString = Encoding.ASCII.GetString(metadataStart); if (metadataAsString.StartsWith(MpegStartMetadata)) { alarmEntity.Discriminator = ".mp3"; } if (metadataAsString.StartsWith(WavStartMetadata)) { alarmEntity.Discriminator = ".wav"; } } await context.SaveChangesAsync(); }
///<inheritdoc/> public IEnumerable <IExperiment> GetExperiments() { using (var db = new LocalDbContext()) { return(db.Experiments); } }
//private void WithDisabledConstraints(Action action) //{ // _db.Database.Connection.Open(); // _db.Database.ExecuteSqlCommand("PRAGMA foreign_keys=OFF;"); // _db.Database.ExecuteSqlCommand("PRAGMA ignore_check_constraints=true;"); // action(); // _db.Database.ExecuteSqlCommand("PRAGMA foreign_keys=ON;"); // _db.Database.ExecuteSqlCommand("PRAGMA ignore_check_constraints=false;"); // _db.Database.Connection.Close(); //} //private void SaveChangesWithDisabledConstraints() //{ // WithDisabledConstraints(() => _db.SaveChanges()); //} public List <DbLocalizedString> GetLocalizedStrings(Lang language) { var strLang = $"{language.EnumToString().Take(3).ToUpper()}_"; var db = new LocalDbContext(); return(db.LocalizedStrings.Where(ls => ls.Key.StartsWith(strLang)).ToList()); }
public JournalViewModel(LocalDbContext context, IEventAggregator eventAggregator) { Title = "ORDERS JOURNAL"; _context = context; _eventAggregator = eventAggregator; cachedOrders = context.Orders; Orders = new ReadOnlyCollection <Order>(cachedOrders.ToList()); var propertyChangedObservable = Observable.FromEventPattern <PropertyChangedEventHandler, PropertyChangedEventArgs> (handler => this.PropertyChanged += handler, handler => this.PropertyChanged -= handler); var searchTermObservable = propertyChangedObservable .Where(p => p.EventArgs.PropertyName == nameof(SearchTerm)) .Select(_ => _searchTerm).Throttle(TimeSpan.FromMilliseconds(250)).Subscribe (s => { if (string.IsNullOrEmpty(s)) { this.Orders = new ReadOnlyCollection <Order>(cachedOrders.ToList()); } else { this.Orders = new ReadOnlyCollection <Order>(cachedOrders .Where(o => o.CustomerID.SafeSubstring(0, s.Length).ToLower() == s.ToLower()).OrderBy(o => o.CustomerID) .ToList()); } }); ClearSearchCommand = new DelegateCommand(() => SearchTerm = ""); }
public BaseApplication( IEmailSender _emailSender, LocalDbContext _ldbc, EntityDbContext _edbc, ExamsDbContext _xdbc, IModuleRepo _moduleRepo, IAppDetails _app, IModuleMarkRepo _moduleMarkRepo, IModuleMarkChangeLogRepo _moduleMarkChangeLogRepo, ICMPMarksImportRepo _cmpMarksImportRepo, TestDbContext _tdbc, IStudentRepo _studentRepo ) { emailSender = _emailSender; ldbc = _ldbc; edbc = _edbc; tdbc = _tdbc; xdbc = _xdbc; moduleRepo = _moduleRepo; moduleMarkRepo = _moduleMarkRepo; moduleMarkChangeLogRepo = _moduleMarkChangeLogRepo; app = _app; cmpMarksImportRepo = _cmpMarksImportRepo; //Test cases studentRepo = _studentRepo; }
public void SaveOrder(Order order, bool isFraud) { using var db = new LocalDbContext(); var dbOrder = new DbOrder(order, isFraud); db.Orders.Add(dbOrder); db.SaveChanges(); }
private static void AtualizaInscricao(Inscricao inscricao) { using (var db = new LocalDbContext()) { db.UpdateInscricao(inscricao); db.SaveChanges(); } }
public SettingsPageModel(AudioService service, LocalDbContext context) { this.RefreshSubject.AsObservable().Subscribe(_ => { this.Alarms.Clear(); this.Alarms.AddRange(context.Alarms .Select(alarm => new AlarmSettingsViewModel(alarm, service, context)).ToList()); }); }
public async Task <Settings> Get() { using (var db = new LocalDbContext()) { Settings.SetCurrent(await db.Settings.FirstOrDefaultAsync()); return(Settings.Current); } }
public HomeController(IRepository <User> userRepository, IRepository <FileReference> fileRepository, ILogger <HomeController> logger, IWebHostEnvironment webHostingEnvironment, LocalDbContext context) { _userRepository = userRepository; _fileRepository = fileRepository; _logger = logger; this.webHostingEnvironment = webHostingEnvironment; }
public void Get_Id1OnEmptyDb_ReturnsNull() { var mock = GetMockDependency <Product>(); var obj = new LocalDbContext <Product>(mock); var actual = obj.Get(1); Assert.Null(actual); }
public void Delete_Id1EmptyDb_ReturnsFalse() { var mock = GetMockDependency <Product>(); var obj = new LocalDbContext <Product>(mock); var actual = obj.Delete(1); Assert.False(actual); }
public void GetAll_EmptyDb_ReturnsEmptyCollection() { var mock = GetMockDependency <Product>(); var obj = new LocalDbContext <Product>(mock); var actual = obj.GetAll(); Assert.Empty(actual); }
public static string GetClaimUsernameById(int userId) { using (var context = new LocalDbContext()) { var user = context.Users.Where(x => x.Id == userId).SingleOrDefault(); return((user == null || String.IsNullOrEmpty(user.UserName)) ? "" : user.UserName); } }
public BaseRepository(LocalDbContext dbContext) { if (dbContext == null) { throw new Exception("Data context can not be null!"); } _dbContext = dbContext; }
public CreateViewModel(LocalDbContext context, IEventAggregator eventAggregator) { _context = context; _eventAggregator = eventAggregator; SelectCommand = new DelegateCommand(Select, CanSelect); UnselectCommand = new DelegateCommand(Unselect, CanUnselect); CreateOrderCommand = new DelegateCommand(CreateOrder, CanCreateOrder); }
private static void AtualizaConfirmacao(Confirmacao confirmacao) { using (var db = new LocalDbContext()) { confirmacao.IdRemoto = confirmacao.Id; db.UpdateConfirmacao(confirmacao); db.SaveChanges(); } }