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