// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ApplicantsDbContext db) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } db.Database.EnsureCreated(); app.UseCors(builder => builder .AllowAnyOrigin() .AllowAnyMethod() .AllowAnyHeader() ); app.UseHttpsRedirection(); app.UseRouting(); app.UseSwagger(); app.UseSwaggerUI(options => options.SwaggerEndpoint("/swagger/v1/swagger.json", "Applicant API v1")); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapGet("/", context => { context.Response.Redirect("/swagger/"); return(Task.CompletedTask); }); endpoints.MapControllers(); }); }
void DoImport(string[] fileNames) { var list = new List <IEnumerable <Applicant> >(); foreach (var fileName in fileNames) { try { list.Add(CsvHelper.ImportCsvFile(fileName)); } catch (Exception ex) { Dispatcher.Invoke(() => MessageBox.Show(string.Format(_errorImportFile, fileName, ex), Title)); } } var db = new ApplicantsDbContext(); try { foreach (var l in list) { foreach (var i in l) { db.Insert(i); } } } catch (Exception ex) { Dispatcher.Invoke(() => MessageBox.Show(string.Format(_erorImport, ex), Title)); } }
void ReloadData() { var db = new ApplicantsDbContext(); if (_viewModel.Applicants != null) { _viewModel.Applicants.ListChanged -= ApplicantsOnCollectionChanged; } _viewModel.Applicants = new BindingList <Applicant>(db.Applicants.Select(c => c).ToList()); _viewModel.Applicants.ListChanged += ApplicantsOnCollectionChanged; }
void ApplicantsOnCollectionChanged(object sender, ListChangedEventArgs e) { if (e.ListChangedType == ListChangedType.ItemChanged) { var newa = _viewModel.Applicants[e.NewIndex]; var db = new ApplicantsDbContext(); try { db.Update(newa); } catch (Exception ex) { MessageBox.Show(string.Format(_errorUpdate, ex), Title); } } }
void AddCommandExecuted(object sender, ExecutedRoutedEventArgs e) { var db = new ApplicantsDbContext(); var n = new Applicant() { ApplicantId = Guid.NewGuid() }; try { db.Insert(n); } catch (Exception ex) { MessageBox.Show(string.Format(_erroradding, ex), Title); } finally { ReloadData(); _viewModel.Current = _viewModel.Applicants.FirstOrDefault(a => a.ApplicantId == n.ApplicantId); } }
void DeleteCommandExecuted(object sender, ExecutedRoutedEventArgs e) { var a = _viewModel.Current; if (a == null) { return; } var db = new ApplicantsDbContext(); try { db.Delete(a); } catch (Exception ex) { MessageBox.Show(string.Format(_errorDelete, ex), Title); } finally { ReloadData(); } }
void ClearCommandExecuted(object sender, ExecutedRoutedEventArgs e) { var res = MessageBox.Show(_messageClear, Title, MessageBoxButton.YesNo, MessageBoxImage.Question); if (res != MessageBoxResult.Yes) { return; } var db = new ApplicantsDbContext(); try { db.Applicants.Delete(); } catch (Exception ex) { MessageBox.Show(string.Format(_errorClear, ex), Title); } finally { ReloadData(); } }
public ApplicantService(ApplicantsDbContext db) { _db = db; }