public IdentityRoles GetById(string id)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
return(db.IdentityRoles.FirstOrDefault(ug => ug.Id.Equals(id)));
}
}
public Sites GetById(long?id)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
return(db.Sites.Include(s => s.Languages).FirstOrDefault(ug => ug.id == id));
}
}
public Banners GetById(long?id)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
return(db.Banners.Include(b => b.Sites).FirstOrDefault(ug => ug.id == id));
}
}
public IEnumerable <IdentityRoles> All()
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
return(db.IdentityRoles.ToList());
}
}
public IEnumerable <Languages> All()
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
return(db.Languages.OrderByDescending(l => l.title).ToList());
}
}
public Languages GetById(long?id)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
return(db.Languages.FirstOrDefault(l => l.id == id));
}
}
public IEnumerable <Banners> All()
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
return(db.Banners.Include(c => c.Sites)
.OrderByDescending(c => c.title).ToList());
}
}
public void Update(Sites site)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
if (site != null)
{
db.Entry(site).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
public void Add(Sites site)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
if (site != null)
{
db.Sites.Add(site);
db.SaveChanges();
}
}
}
public void Update(Banners banner)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
if (banner != null)
{
db.Entry(banner).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
public void Add(Banners banner)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
if (banner != null)
{
db.Banners.Add(banner);
db.SaveChanges();
}
}
}
public void Update(IdentityRoles userGroup)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
if (userGroup != null)
{
db.Entry(userGroup).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
public void Delete(long?id)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
Sites site = db.Sites.FirstOrDefault(ug => ug.id == id);
if (site != null)
{
db.Entry(site).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
public void Delete(long?id)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
Banners deleteBanner = db.Banners.FirstOrDefault(ug => ug.id == id);
if (deleteBanner != null)
{
db.Entry(deleteBanner).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
public void Delete(string id)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
IdentityRoles deleteUserGroup = db.IdentityRoles.FirstOrDefault(ug => ug.Id.Equals(id));
if (deleteUserGroup != null)
{
db.Entry(deleteUserGroup).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
public void Add(IdentityRoles newUserGroup)
{
using (UspaIdentityDb db = new UspaIdentityDb())
{
var UserManager = new UserManager <User>(new UserStore <User>(db));
if (newUserGroup != null)
{
db.IdentityRoles.Add(newUserGroup);
db.SaveChanges();
}
}
}
