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;
}
}
}
}
