public void GittMatch_IngenPosterErFramITid_SkalIkkeKræsje() { var match = _gitt.EnMatchMedTreLagOgTrePoster(); using (var context = _dataContextFactory.Create()) { context.PosterIMatch .Include(x => x.Post) .Include(x => x.Match) .ForEach(x => { x.SynligFraTid = TimeService.Now.Subtract(new TimeSpan(0, 60, 0)); x.SynligTilTid = TimeService.Now.Subtract(new TimeSpan(0, 30, 0)); }); context.SaveChanges(); } var lag1 = match.DeltakendeLag.First(); var gamestateservice = _container.Resolve <GameStateService>(); var lag1State = gamestateservice.Get(lag1.Lag.LagId); Assert.AreEqual(0, lag1State.Score, "Skal ikke ha noen poeng"); Assert.AreEqual(false, lag1State.Poster.Any(x => x.HarRegistrert), "Skal ikke ha noen registreringer"); }
public async Task Create_SqliteDatabaseWithoutMigrationErrors() { var connectionString = $"Data Source={_databaseFilePath}"; ILoggerFactory loggerFactory = new NullLoggerFactory(); var dataContextFactory = new DataContextFactory(loggerFactory.CreateLogger <DataContextFactory>(), connectionString); using (var dataContext = dataContextFactory.Create()) { //Assert.IsTrue(await dataContext.Database.EnsureCreatedAsync(), "Database hos not been created"); Assert.IsTrue(dataContext.Database.IsSqlite(), "Is it not Sqlite database"); } // Simple request using (var dataContext = dataContextFactory.Create()) { Assert.AreEqual(await dataContext.Clients.CountAsync(), 0); } var clientName = Guid.NewGuid().ToString(); Guid clientId; // Create entity request using (var dataContext = dataContextFactory.Create()) { var clientEntity = new ClientEntity { Name = clientName }; await dataContext.AddAsync(clientEntity); await dataContext.SaveChangesAsync(); clientId = clientEntity.Id; } // Simple request using (var dataContext = dataContextFactory.Create()) { Assert.AreEqual(await dataContext.Clients.CountAsync(), 1); var client = await dataContext.Clients.SingleOrDefaultAsync(x => x.Id == clientId); Assert.IsNotNull(client); Assert.AreEqual(client.Id, clientId); Assert.AreEqual(client.Name, clientName); } }
public List <Lag> ToLagMedToDeltakere() { using (var context = _dataContextFactory.Create()) { var lag1 = LagFactory.SettOppEtLagMedDeltakere(1, 2); var lag2 = LagFactory.SettOppEtLagMedDeltakere(2, 2); context.Lag.Add(lag1); context.Lag.Add(lag2); context.SaveChanges(); return(new List <Lag> { lag1, lag2 }); } }
private void PersistLogs(Log log, List <Log> logs) { try { using (var dc = DataContextFactory.Create()) { if (log != null) { dc.ApplicationLogs.Add(log.InternalLog); } else { if (logs != null) { logs.ForEach(x => dc.ApplicationLogs.Add(x.InternalLog)); } } dc.SaveChanges(); } } catch (Exception ex) { WriteFileLog("ApplicaitonLogger.LoggingError " + GetNowString(), ex.Message); Fallback(log, logs); } }
public byte[] ToByteArray(Guid matchId) { using (var context = _dataContextFactory.Create()) { var match = context.Matcher.SingleOrDefault(x => x.MatchId == matchId); //var l1 = context.Lag.Include(x => x.Deltakere).ToList(); //var lag = (from l in context.Lag.Include(x => x.Deltakere) // join lim in context.LagIMatch on l.LagId equals lim.Lag.LagId // where lim.Match.MatchId == matchId // select l).ToList(); var lag = context.LagIMatch.Include(x => x.Lag.Deltakere) .Where(x => x.Match.MatchId == matchId) .ToList() // strange - needed to have deltakere included .Select(x => x.Lag) .ToList(); var posterIMatch = context.PosterIMatch.Include(x => x.Post).Where(x => x.Match.MatchId == matchId).ToList(); var excelMatch = MatchImport.ExcelMatch.FromMatch(match); var excelPoster = posterIMatch.Select(PostImport.ExcelPost.Create).ToList(); _excelWriter.SkrivTilExcel(excelMatch, lag, excelPoster); } return(_excelWriter.GetAsByteArray()); }
private void frmCadastroCliente_Load(object sender, EventArgs e) { _dataContext = DataContextFactory.Create(); _cliente = new Cliente(); _enderecoSelecionado = new Endereco(); dtgEmderecos.DataSource = _cliente.Endereco; }
private void btnFiltrar_Click(object sender, EventArgs e) { using (ClienteDataContext clienteDataContext = DataContextFactory.Create()) { var clientes = string.IsNullOrEmpty(txtNomeCliente.Text) ? clienteDataContext.Clientes : clienteDataContext.Clientes.Where(t => t.Nome.StartsWith(txtNomeCliente.Text)); dtgClientes.DataSource = clientes.ToList(); } }
public void NårEnMeldingPostes_SkalDenLagresIDatabasen() { var gittLag = _gitt.ToLagMedToDeltakere(); var lag1 = gittLag[0]; var deltaker1 = lag1.Deltakere[0]; var meldingsService = _container.Resolve <MeldingService>(); meldingsService.PostMelding(deltaker1.DeltakerId, lag1.LagId, "Testmelding"); using (var context = _dataContextFactory.Create()) { var melding = context.Meldinger.Single(); Assert.AreEqual(deltaker1.DeltakerId, melding.DeltakerId, "DeltakerId"); Assert.AreEqual(lag1.LagId, melding.LagId, "LagId"); Assert.AreEqual("Testmelding", melding.Tekst, "Tekst"); } }
private void btnFiltrar_Click(object sender, EventArgs e) { using (ClienteDataContext clienteDataContext = DataContextFactory.Create()) { var clientes = string.IsNullOrEmpty(txtNomeCliente.Text) ? Program.unityOfWork.clienteRepository.Clientes() : Program.unityOfWork.clienteRepository.BuscarClientesPorNome(txtNomeCliente.Text); dtgClientes.DataSource = clientes; } }
public void Given() { _container = RestApiApplication.CreateContainer(); _gitt = new Gitt(_container); _dataContextFactory = _container.Resolve <DataContextFactory>(); TimeService.ResetToRealTime(); // Slett alle meldinger (blir rullet tilbake i transaksjon uansett) using (var context = _dataContextFactory.Create()) { context.Meldinger.Clear(); context.SaveChanges(); } }
private void DisablePostIMatch(PostIMatch førstePost) { using (var context = _dataContextFactory.Create()) { var postIMatch = context.PosterIMatch .Include(x => x.Post) .Include(x => x.Match) .Single(x => x.Id == førstePost.Id); postIMatch.SynligFraTid = new DateTime(2001, 01, 01); postIMatch.SynligTilTid = new DateTime(2001, 01, 02); context.SaveChanges(); } }
public void Given() { _container = RestApiApplication.CreateContainer(); _appSettings = new OverridableSettings(); _container.Register(Component.For <OverridableSettings>().Instance(_appSettings).IsDefault().Named(Guid.NewGuid().ToString())); _gitt = new Gitt(_container); _dataContextFactory = _container.Resolve <DataContextFactory>(); TimeService.ResetToRealTime(); // Slett alle posisjoner (blir rullet tilbake i transaksjon uansett) using (var context = _dataContextFactory.Create()) { context.DeltakerPosisjoner.Clear(); context.SaveChanges(); } }
public void Les(ExcelWorksheet excelWorksheet, MatchImport.ExcelMatch excelMatch) { var matchId = excelMatch.MatchId; var lagListe = LesFra(excelWorksheet); using (var context = _dataContextFactory.Create()) { var match = (from m in context.Matcher.Include(x => x.DeltakendeLag.Select(y => y.Lag)) where m.MatchId == matchId select m).FirstOrDefault(); var våpen = context.Våpen.ToList(); foreach (var lag in lagListe) { AddOrUpdate(lag, match, context, excelMatch, våpen); } context.SaveChanges(); } }
protected override async Task OnStarted() { using (var db = DataContextFactory.Create()) { var accounts = db.Accounts .Where(a => a.LatestConnectedService == Info.Name) .Select(a => a.ID.ToString()); if (accounts.Any()) { await AccountStatusCache.RemoveAllAsync(db.Accounts .Where(a => a.LatestConnectedService == Info.Name) .Select(a => a.ID.ToString())); Logger.Info( $"Forcibly reset account states of {"account".ToQuantity(accounts.Count())} previously connected to {Info.Name}" ); } } await base.OnStarted(); }
public void NårEnDeltakerPosterEnPosisjon_SkalPosisjonenLagresIDatabasen() { var givenLag = _gitt.ToLagMedToDeltakere(); var posisjonsSevice = _container.Resolve <PosisjonsService>(); var deltaker11 = givenLag[0].Deltakere[0]; var latitude = 59.6785526164; var longitude = 10.6039274298; posisjonsSevice.RegistrerPosisjon(deltaker11.Lag.LagId, deltaker11.DeltakerId, latitude, longitude); using (var context = _dataContextFactory.Create()) { Assert.AreEqual(1, context.DeltakerPosisjoner.Count(), "Skulle vært 1 posisjon"); } }
public PayConfigurationRepository() : base(DataContextFactory.Create <DataContext>()) { }
public IncreasingNumberRepository() : base(DataContextFactory.Create <PosDataContext>()) { }
public string GetKml() { var matchId = _currentMatchProvider.GetMatchId(); SharpKml.Dom.Kml kml = new SharpKml.Dom.Kml(); var document = new Document(); kml.Feature = document; var c = System.Drawing.ColorTranslator.FromHtml("#33FF33"); var postStyle = new Style(); postStyle.Id = "post_vanlig"; postStyle.Icon = new IconStyle { Color = new Color32(c.A, c.R, c.G, c.B), Icon = new IconStyle.IconLink(new Uri("http://maps.google.com/mapfiles/kml/paddle/wht-blank.png")), Scale = 0.5 }; document.AddStyle(postStyle); var lagFolder = new Folder { Name = "Lag" }; var postFolder = new Folder { Name = "Poster" }; document.AddFeature(lagFolder); document.AddFeature(postFolder); using (var context = _dataContextFactory.Create()) { var match = context.Matcher.Single(x => x.MatchId == matchId); var maxLat = match.GeoboxNWLatitude.GetValueOrDefault(); var minLat = match.GeoboxSELatitude.GetValueOrDefault(); var minLon = match.GeoboxNWLongitude.GetValueOrDefault(); var maxLon = match.GeoboxSELongitude.GetValueOrDefault(); var poster = (from pim in context.PosterIMatch where pim.Match.MatchId == matchId select new { pim.SynligFraTid, pim.SynligTilTid, pim.Post.Navn, pim.Post.Latitude, pim.Post.Longitude }).ToList(); foreach (var p in poster) { var placemark = new Placemark(); placemark.StyleUrl = new Uri("#post_vanlig", UriKind.Relative); placemark.Time = new TimeSpan { Begin = p.SynligFraTid, End = p.SynligTilTid }; placemark.Name = p.Navn; placemark.Geometry = new Point { Coordinate = new Vector(p.Latitude, p.Longitude) }; postFolder.AddFeature(placemark); } var lag = context.Lag.ToList(); var lagDictionary = new Dictionary <string, Folder>(); foreach (var lag1 in lag) { var color = System.Drawing.ColorTranslator.FromHtml("#" + lag1.Farge); var style = new Style(); style.Id = LagStyleKey(lag1.LagId); style.Icon = new IconStyle { Color = new Color32(color.A, color.R, color.G, color.B), Icon = new IconStyle.IconLink(new Uri("http://maps.google.com/mapfiles/kml/paddle/wht-blank-lv.png")), Scale = 0.3 }; document.AddStyle(style); var folder = new Folder { Name = lag1.Navn }; lagDictionary.Add(lag1.LagId, folder); lagFolder.AddFeature(folder); } var deltakerPosisjoner = (from p in context.DeltakerPosisjoner join d in context.Deltakere on p.DeltakerId equals d.DeltakerId where match.StartTid < p.Tidspunkt && p.Tidspunkt < match.SluttTid select new { p.Latitude, p.Longitude, p.DeltakerId, d.Navn, d.Lag.Farge, d.Lag.LagId, p.Tidspunkt }).GroupBy(x => x.DeltakerId).ToDictionary(x => x.Key, y => y); foreach (var deltaker in deltakerPosisjoner) { //if (deltaker.Key != "MS_3-2") // continue; var førstePosisjon = deltaker.Value.FirstOrDefault(); var placemark = new Placemark(); placemark.StyleUrl = new Uri("#" + LagStyleKey(førstePosisjon.LagId), UriKind.Relative); placemark.Name = førstePosisjon.Navn; var posisjoner = deltaker.Value.OrderBy(x => x.Tidspunkt).ToList(); var track = new Track(); var forrigePosisjon = førstePosisjon; foreach (var pos in posisjoner) { // Utafor boksen if (pos.Latitude > maxLat || pos.Latitude < minLat || pos.Longitude > maxLon || pos.Longitude < minLon) { continue; } var meter = DistanseKalkulator.MeterMellom(forrigePosisjon.Latitude, forrigePosisjon.Longitude, pos.Latitude, pos.Longitude); var sekunder = pos.Tidspunkt.Subtract(forrigePosisjon.Tidspunkt).TotalSeconds; if (sekunder > 0) { var fart = meter / sekunder; if (fart > 8.333) // raskere enn 12 blank på 100m { continue; } } track.AddWhen(pos.Tidspunkt); track.AddCoordinate(new Vector(pos.Latitude, pos.Longitude)); forrigePosisjon = pos; } placemark.Geometry = track; lagDictionary[førstePosisjon.LagId].AddFeature(placemark); } } Serializer serializer = new Serializer(); serializer.Serialize(kml); return(serializer.Xml); }
public void OnCreatingDatabase() { var dataContextFactory = new DataContextFactory("Host=localhost;Port=5432;Database=shm1;Username=postgres;Password=qwerty1"); var dataContext = dataContextFactory.Create(); }
public Logic() { data = DataContextFactory.Create("SqlData"); }
public ProductBrandRepository(int companyId) : base(DataContextFactory.Create <DataContext>()) { CompanyId = companyId; }
public StoredValueCardPayRecordRepository() : base(DataContextFactory.Create <DataContext>()) { }
public PayWayRepository() : base(DataContextFactory.Create <DataContext>()) { }
public BaseEFRepository() : this(DataContextFactory.Create <DataContext>()) { }
public SysStoreUserInfoRepository() : base(DataContextFactory.Create <DataContext>()) { }
public MemberRepository() : base(DataContextFactory.Create <DataContext>()) { }
public Logic() { data = DataContextFactory.Create(ConfigurationManager.AppSettings.GetKey(4)); }
public ProductChangePriceRepository(int companyId) : base(DataContextFactory.Create <DataContext>()) { CompanyId = companyId; }
public MySqlEfBraaapRepository(IConfiguration configuration) { _connectionString = configuration.GetConnectionString("MySql"); ctx = DataContextFactory.Create(_connectionString); }
private static TestDataContext CreateDataContext() { return(DataContextFactory.Create <TestDataContext>()); }