public FileEntity Edit(FileEntity model)
{
FileEntity entity = null;
using (var context = new RuporDbContext())
{
if (model.Id > 0)
{
entity = context.Files.FirstOrDefault(f => f.Id == model.Id);
}
else
{
entity = new FileEntity();
context.Files.Add(entity);
}
entity.FileExtension = model.FileExtension;
entity.FileName = model.FileName;
entity.Name = model.Name;
entity.Picture = model.Picture;
entity.Alt = model.Alt;
entity.ContentType = model.ContentType;
entity.FileArea = model.FileArea;
entity.IsDefault = model.IsDefault;
entity.FileType = model.FileType;
context.SaveChanges();
}
return(entity);
}
public static AppRoleManager Create(IdentityFactoryOptions <AppRoleManager> options, IOwinContext context)
{
var dbContext = new RuporDbContext();
var roleManager =
new AppRoleManager(new RoleStore <IdentityRole>(dbContext));
return(roleManager);
}
public void Remove(FileEntity entry)
{
using (var context = new RuporDbContext())
{
context.Files.Attach(entry);
context.Files.Remove(entry);
context.SaveChanges();
}
}
public void Remove(int[] ids)
{
using (var context = new RuporDbContext())
{
var files = context.Files.Where(f => ids.Any(id => id == f.Id));
context.Files.RemoveRange(files);
context.SaveChanges();
}
}
public void Remove(int id)
{
using (var context = new RuporDbContext())
{
var file = context.Files.FirstOrDefault(f => f.Id == id);
context.Files.Remove(file);
context.SaveChanges();
}
}
public IEnumerable <FileEntity> Get(Expression <Func <FileEntity, bool> > expr)
{
ICollection <FileEntity> files = new List <FileEntity>();
using (var context = new RuporDbContext())
{
files = context.Files.Where(expr).ToList();
}
return(files);
}
public void Remove(int id)
{
if (id > 0)
{
using (var context = new RuporDbContext())
{
var result = context.FeedChannel
.FirstOrDefault(x => x.Id == id);
context.FeedChannel.Remove(result);
}
}
}
private FileEntity Get(int id)
{
FileEntity file = null;
if (id > 0)
{
using (var context = new RuporDbContext())
{
file = context.Files.FirstOrDefault(x => x.Id == id);
}
}
return(file);
}
public IEnumerable <FeedChannelEntity> Get(string category)
{
IEnumerable <FeedChannelEntity> result = null;
using (var context = new RuporDbContext())
{
result = context
.FeedChannel
.Include(ch => ch.Categories)
.Where(ch => ch.Categories.Any(c => c.Name.ToLower().Contains(category.ToLower())))
.ToList();
}
return(result);
}
public FeedChannelEntity this[int id]
{
get
{
FeedChannelEntity result = null;
if (id > 0)
{
using (var context = new RuporDbContext())
{
result = context.FeedChannel
.FirstOrDefault(x => x.Id == id);
}
}
return(result);
}
}
public FeedChannelEntity this[string url]
{
get
{
FeedChannelEntity result = null;
if (!string.IsNullOrEmpty(url))
{
using (var context = new RuporDbContext())
{
result = context.FeedChannel
.FirstOrDefault(x => x.TargetUrl.ToLower().Contains(url.ToLower()));
}
}
return(result);
}
}
public FeedChannelEntity Add(FeedChannelEntity editedInstance)
{
FeedChannelEntity result = null;
if (editedInstance != null)
{
using (var context = new RuporDbContext())
{
result = new FeedChannelEntity();
result.Name = editedInstance.Name;
result.TargetUrl = editedInstance.TargetUrl;
result.ChannelPictureId = editedInstance.ChannelPictureId;
result.Categories = editedInstance.Categories;
result.Description = editedInstance.Description;
result = context.FeedChannel.Add(result);
}
}
return(result);
}
public static AppUserManager GetInstance(IdentityFactoryOptions <AppUserManager> option, IOwinContext owinContext)
{
var dbContext = new RuporDbContext();
var usermgr = new AppUserManager(new UserStore <UserEntity>(dbContext));
usermgr.PasswordValidator = new PasswordValidator
{
RequireDigit = true,
RequiredLength = 8,
RequireUppercase = true,
RequireLowercase = true,
};
usermgr.UserValidator = new UserValidator <UserEntity>(usermgr)
{
RequireUniqueEmail = true,
AllowOnlyAlphanumericUserNames = true
};
var tokenProvider = new DpapiDataProtectionProvider("therupor");
usermgr.UserTokenProvider = new DataProtectorTokenProvider <UserEntity>(tokenProvider.Create("EmailConfirmation"));
return(usermgr);
}
public EFBaseService()
{
DbContext = CreateContext();
}
