public void Delete(long id)
{
Link linkEntity = _context.Links.Find(id);
_context.Links.Remove(linkEntity);
_context.SaveChanges();
}
public void AddRange(ICollection <Link> links)
{
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
{
db.Links.AddRange(links);
db.SaveChanges();
}
}
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 IActionResult Post(List <Link> linkPost)
{
_context.Links.Update(linkPost[0]);
_context.SaveChanges();
return(NoContent());
}
public void SaveChanges()
{
using (LinksDbContext db = container.GetInstance <LinksDbContext>())
db.SaveChanges();
}
