public void AddRange(ICollection <Link> links)
{
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
{
db.Links.AddRange(links);
db.SaveChanges();
}
}
public bool Contains(string url)
{
Link args = null;
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
args = db.Links.Where(link => link.Url == url).FirstOrDefault();
if (args == null)
{
return(false);
}
return(true);
}
public void CheckAddSave(Link link)
{
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
{
var args = db.Links.Where(item => item.Url == link.Url).FirstOrDefault();
if (args != null)
{
return;
}
db.Links.Add(link);
db.SaveChanges();
}
}
public void RemoveDuplicate()
{
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
{
var duplicates = db.Links.GroupBy(link => link.Url)
.Where(g => g.Count() > 1)
.Select(y => y.Key)
.ToList();
foreach (var dup in duplicates)
{
var link = db.Links.Where(li => li.Url == dup).First();
db.Links.Remove(link);
}
db.SaveChanges();
}
}
public HomeController(ILogger <HomeController> logger, LinksDbContext context, HttpGetClass getClass)
{
_logger = logger;
_context = context;
_getClass = getClass;
}
public LinksRepository(LinksDbContext context)
{
_context = context;
}
public void SaveChanges()
{
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
db.SaveChanges();
}
public ICollection <string> GetAllWithIteration(int iteration)
{
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
return(db.Links.Where(link => link.IterationId == iteration).Select(link => link.Url).ToList());
}
