public ActionResult Index(Personne p) { MailingContext db = new MailingContext(); db.Personnes.Add(p); db.SaveChanges(); return(View("merci", p)); }
public ActionResult Lister() { MailingContext db = new MailingContext(); return(View(db.Personnes.ToList())); ////Call the Repository //MailingRepository reader = new MailingRepository(); //return View(reader.GetPersonnes()); }
public static void Initialize(MailingContext context) { context.Database.EnsureCreated(); if (context.Topics.Any()) { return; } Seed(context); }
public ActionResult DeleteConfirm(int id) { MailingContext db = new MailingContext(); Personne p = (from pers in db.Personnes where pers.PersonneID == id select pers).FirstOrDefault(); db.Personnes.Remove(p); db.SaveChanges(); return(View("Deleted", id)); }
public MailingTestBase() { var options = new DbContextOptionsBuilder <MailingContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()) .Options; _context = new MailingContext(options); _context.Database.EnsureCreated(); MailingInitializer.Initialize(_context); }
private static void Seed(MailingContext context) { var topicsNames = new[] { "Sport", "Books", "Electronics", "Toys", "Movies", "Automotive", "Clothing", "Beauty", "Games", "Garden" }; var topics = topicsNames.Select(value => new Topic { Name = value }); context.Topics.AddRange(topics); context.SaveChanges(); }
public ActionResult Delete(int id) { MailingContext db = new MailingContext(); Personne p = (from pers in db.Personnes where pers.PersonneID == id select pers).FirstOrDefault(); //Linq pseudo sql //Personne p2 = db.Personnes.Where(pers => pers.PersonneID == id). // FirstOrDefault(); ////linq Orienté Object if (p == null) { return(new HttpStatusCodeResult(404, "Pas de personne avec ce ID")); } return(View(p)); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, MailingContext context) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Error"); // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseSpaStaticFiles(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller}/{action=Index}/{id?}"); }); app.UseSpa(spa => { spa.Options.SourcePath = "ClientApp"; if (env.IsDevelopment()) { spa.UseReactDevelopmentServer(npmScript: "start"); } }); MailingInitializer.Initialize(context); }
public TopicsController(MailingContext context) { _context = context; }
public AddressesController(MailingContext context, IMailingService mailingService) { _context = context; _mailingService = mailingService; }
public UnsubscribeController(MailingContext context, IMailingService mailingService) { _context = context; _mailingService = mailingService; }