public IEnumerable <Currency> GetCurrencies() { using (var ctx = new OrganizerContext()) { return(ctx.Currencies.ToList()); } }
public IEnumerable <Card> GetCardsByType(CardType cardType) { using (var ctx = new OrganizerContext()) { return(ctx.Cards.Where(c => c.Type == cardType)); } }
public IEnumerable <string> GetMovementDescriptions() { using (var ctx = new OrganizerContext()) { return(ctx.Movements.Select(m => m.Description).Distinct().ToList()); } }
public IEnumerable <CardCompany> GetCardCompanies() { using (var ctx = new OrganizerContext()) { return(ctx.CardCompanies.ToList()); } }
public IEnumerable <Movement> GetMovements() { using (var ctx = new OrganizerContext()) { return(ctx.Movements.ToList()); } }
public Movement GetMovementById(long entryId) { using (var ctx = new OrganizerContext()) { return(ctx.Movements.Find(entryId)); } }
public Currency GetCurrencyById(long currencyId) { using (var ctx = new OrganizerContext()) { return(ctx.Currencies.Find(currencyId)); } }
public CardCompany GetCardCompanyById(long cardCompanyId) { using (var ctx = new OrganizerContext()) { return(ctx.CardCompanies.Find(cardCompanyId)); } }
public IEnumerable <Account> GetAccounts() { using (var ctx = new OrganizerContext()) { return(ctx.Accounts.ToList()); } }
public Account GetAccountById(long accountId) { using (var ctx = new OrganizerContext()) { return(ctx.Accounts.Find(accountId)); } }
public Card GetCardById(long cardId) { using (var ctx = new OrganizerContext()) { return(ctx.Cards.Find(cardId)); } }
public UpstreamApiAppointments(OrganizerContext context, IHttpClientFactory httpClientFactory, IConfiguration configuration, ILogger <UpstreamApiAppointments> logger) { _context = context; _httpClientFactory = httpClientFactory; _configuration = configuration; _logger = logger; }
public int UpdateMovement(Movement movement) { using (var ctx = new OrganizerContext()) { ctx.Entry(movement).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int AddMovement(Movement movement) { using (var ctx = new OrganizerContext()) { ctx.Movements.Add(movement); return(ctx.SaveChanges()); } }
public AppointmentsController(OrganizerContext context, IMapper mapper, IWarningChecker warningChecker, IConfiguration configuration, IUpstreamApiAppointments upstreamAppointment) { _context = context; _mapper = mapper; _warningChecker = warningChecker; _configuration = configuration; _upstreamAppointments = upstreamAppointment; }
public int AddCard(Card card) { using (var ctx = new OrganizerContext()) { ctx.Cards.Add(card); return(ctx.SaveChanges()); } }
public int UpdateAccount(Account account) { using (var ctx = new OrganizerContext()) { ctx.Entry(account).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int AddCurrency(Currency currency) { using (var ctx = new OrganizerContext()) { ctx.Currencies.Add(currency); return(ctx.SaveChanges()); } }
public int AddAccount(Account account) { using (var ctx = new OrganizerContext()) { ctx.Accounts.Add(account); return(ctx.SaveChanges()); } }
public int UpdateCurrency(Currency currency) { using (var ctx = new OrganizerContext()) { ctx.Entry(currency).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int UpdateCardCompany(CardCompany cardCompany) { using (var ctx = new OrganizerContext()) { ctx.Entry(cardCompany).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int AddCardCompany(CardCompany cardCompany) { using (var ctx = new OrganizerContext()) { ctx.CardCompanies.Add(cardCompany); return(ctx.SaveChanges()); } }
public static List <User> AddExampleUsersToDatabase(DbContextOptions <OrganizerContext> dbContextOptions, MiniAutoFixture miniAutoFixture) { using (OrganizerContext organizerContext = new OrganizerContext(dbContextOptions)) { List <User> userList = Enumerable.Range(1, 10).Select(a => CreateUser(0, miniAutoFixture)).ToList(); userList.ForEach(user => organizerContext.Add(user)); organizerContext.SaveChanges(); return(userList); } }
public int RemoveAccount(long accountId) { using (var ctx = new OrganizerContext()) { var account = ctx.Accounts.Find(accountId); if (account == null) { return(0); } ctx.Accounts.Remove(account); return(ctx.SaveChanges()); } }
public int RemoveCurrency(long currencyId) { using (var ctx = new OrganizerContext()) { var currency = ctx.Currencies.Find(currencyId); if (currency == null) { return(0); } ctx.Currencies.Remove(currency); return(ctx.SaveChanges()); } }
public int RemoveCardCompany(long cardCompanyId) { using (var ctx = new OrganizerContext()) { var cardCompany = ctx.CardCompanies.Find(cardCompanyId); if (cardCompany == null) { return(0); } ctx.CardCompanies.Remove(cardCompany); return(ctx.SaveChanges()); } }
public AuthenticatieRepository(OrganizerContext context, ILidRepository lidRepository, ILoginRepository loginRepository, IInschrijvingRepository inschrijvingsRepository, IAppSettings appSettings) { _context = context ?? throw new ArgumentNullException(nameof(context)); _lidRepository = lidRepository ?? throw new ArgumentNullException(nameof(lidRepository)); _loginRepository = loginRepository ?? throw new ArgumentNullException(nameof(loginRepository)); _inschrijvingRepository = inschrijvingsRepository ?? throw new ArgumentNullException(nameof(inschrijvingsRepository)); if (appSettings == null) { throw new ArgumentNullException(nameof(appSettings)); } _jwtAuthenticationSecret = appSettings.JwtAuthenticationSecret(); _salt = appSettings.SaltApi(); }
public int RemoveMovement(long entryId) { using (var ctx = new OrganizerContext()) { var entry = ctx.Movements.Find(entryId); if (entry == null) { return(0); } ctx.Movements.Remove(entry); return(ctx.SaveChanges()); } }
public FabrieksInstellingRepository(OrganizerContext context, IBetaalmethodeRepository betaalmethodeRepository, IBetaaltransactieRepository betaaltransactieRepository, ICheckInRepository checkInRepository, IEvenementCategorieRepository evenementCategorieRepository, IEvenementRepository evenementRepository, IInschrijvingRepository inschrijvingRepository, IInschrijvingsstatusRepository inschrijvingsstatusRepository, ILidRepository lidRepository, ILoginRepository loginRepository, INieuwsbriefRepository nieuwsbriefRepository) { _context = context ?? throw new ArgumentNullException(nameof(context)); _betaalmethodeRepository = betaalmethodeRepository ?? throw new ArgumentNullException(nameof(betaalmethodeRepository)); _betaaltransactieRepository = betaaltransactieRepository ?? throw new ArgumentNullException(nameof(betaaltransactieRepository)); _checkInRepository = checkInRepository ?? throw new ArgumentNullException(nameof(checkInRepository)); _evenementCategorieRepository = evenementCategorieRepository ?? throw new ArgumentNullException(nameof(evenementCategorieRepository)); _evenementRepository = evenementRepository ?? throw new ArgumentNullException(nameof(evenementRepository)); _inschrijvingRepository = inschrijvingRepository ?? throw new ArgumentNullException(nameof(inschrijvingRepository)); _inschrijvingsstatusRepository = inschrijvingsstatusRepository ?? throw new ArgumentNullException(nameof(inschrijvingsstatusRepository)); _lidRepository = lidRepository ?? throw new ArgumentNullException(nameof(lidRepository)); _loginRepository = loginRepository ?? throw new ArgumentNullException(nameof(loginRepository)); _nieuwsbriefRepository = nieuwsbriefRepository ?? throw new ArgumentNullException(nameof(nieuwsbriefRepository)); }
public static List <Task> AddExampleTasksToDatabase(DbContextOptions <OrganizerContext> dbContextOptions, MiniAutoFixture miniAutoFixture, out List <User> userList) { using (OrganizerContext organizerContext = new OrganizerContext(dbContextOptions)) { userList = new List <User>(); User user1 = DbSetTools.CreateUser(0, miniAutoFixture); organizerContext.Add(user1); userList.Add(user1); User user2 = DbSetTools.CreateUser(0, miniAutoFixture); organizerContext.Add(user2); userList.Add(user2); User user3 = DbSetTools.CreateUser(0, miniAutoFixture); organizerContext.Add(user3); userList.Add(user3); List <Task> taskList = Enumerable .Range(1, 10) .Select(a => CreateTask(0, user1, miniAutoFixture)) .ToList() .Concat( Enumerable.Range(11, 10) .Select(a => CreateTask(0, user2, miniAutoFixture)) .ToList() ) .Concat( Enumerable.Range(21, 10) .Select(a => CreateTask(0, user3, miniAutoFixture)) .ToList() ) .ToList(); taskList.ForEach(task => organizerContext.Add(task)); organizerContext.SaveChanges(); return(taskList); } }
public OrganizerContext organizer() { OrganizerContext _localctx = new OrganizerContext(Context, State); EnterRule(_localctx, 158, RULE_organizer); int _la; try { EnterOuterAlt(_localctx, 1); { State = 1714; k_organizer(); State = 1718; ErrorHandler.Sync(this); _la = TokenStream.La(1); while (_la==SCOL) { { { State = 1715; orgparam(); } } State = 1720; ErrorHandler.Sync(this); _la = TokenStream.La(1); } State = 1721; Match(COL); State = 1722; cal_address(); State = 1723; Match(CRLF); } } catch (RecognitionException re) { _localctx.exception = re; ErrorHandler.ReportError(this, re); ErrorHandler.Recover(this, re); } finally { ExitRule(); } return _localctx; }
private void WindowLoaded(object sender, RoutedEventArgs e) { Database.SetInitializer<OrganizerContext>(new OrganizerContextInitializer()); context = new OrganizerContext(); context.Manufacturers.Load(); this.DataContext = context.Manufacturers.Local; ORM.ItemsSource = context.Manufacturers.Local; datagrid.ItemsSource = context.Parts.Local; // TODO: Rewrite this as LINQ for(int i = 0; i < datagrid.Columns.Count; i++) { var header = datagrid.Columns[i].Header; if(header is string) { if(((string)header).Contains("ID")) { datagrid.Columns[i].Visibility = System.Windows.Visibility.Collapsed; } } } }