public async Task PersistPrimeAsync(List <PrimeNumber> list)
{
PrimeNumberContext c = new PrimeNumberContext();
await c.BulkInsertAsync(list);
await c.BulkSaveChangesAsync();
}
/// <summary>
/// ritorna una lista di numeri primi
/// </summary>
/// <param name="lowerBound">exp</param>
/// <param name="upperBound">exp</param>
/// <returns></returns>
public List <PrimeNumber> ListOfPrimeMod(long lowerBound, long upperBound, out string msg)
{
//check per popolazione DB
long max = RetrieveLastPrimeCalc().IDN;
List <PrimeNumber> exit = new List <PrimeNumber>();
if (upperBound > max)
{
msg = $"This number is too high. Try with n < { max}!";
return(exit);
}
else if (lowerBound < 2)
{
msg = "No Prime Number < 2 for definition.";
return(exit);
}
else
{
using (var context = new PrimeNumberContext())
{
exit = context.PrimeNumbers
.Where(p => p.IDN >= lowerBound && p.IDN <= upperBound)
.Select(p => p)
.ToList();
}
}
msg = null;
return(exit);
}
public static void SeedDataForContext(this PrimeNumberContext context)
{
if (context.PrimeNumbers.Any())
{
return;
}
var primes = new List <PrimeNumber>()
{
new PrimeNumber()
{
IndexPrime = 1,
ValuePrime = 2
},
new PrimeNumber()
{
IndexPrime = 2,
ValuePrime = 3
}
};
context.PrimeNumbers.AddRange(primes);
context.SaveChanges();
}
public PrimeNumber RetrieveNthPrime(long userNth)
{
PrimeNumber nth = null;
using (PrimeNumberContext cont = new PrimeNumberContext())
{
nth = cont.PrimeNumbers
.Where(p => p.NTH == userNth)
.Select(p => p)
.FirstOrDefault();
}
return(nth);
}
public PrimeNumber RetrieveLastPrimeCalc()
{
PrimeNumber lastRetrieved;
using (PrimeNumberContext cont = new PrimeNumberContext())
{
lastRetrieved = cont.PrimeNumbers
.OrderBy(p => p.IDN)
.Select(p => p)
.LastOrDefault();
}
return(lastRetrieved);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder
app, IHostingEnvironment env, PrimeNumberContext primeNumberContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler();
}
primeNumberContext.SeedDataForContext();
app.UseMvc();
//app.Run(async (context) =>
//{
// await context.Response.WriteAsync("Hello World!");
//});
}
public PrimeNumberRepository(PrimeNumberContext context)
{
_context = context;
}
public PrimeNumberService(PrimeNumberContext primeNumberContext)
{
_primeNumberContext = primeNumberContext;
}
public AccessDBController(PrimeNumberContext pnc)
{
_pnc = pnc;
}
