public async Task <List <T> > List()
{
using ContextBase data = new ContextBase(_OptionBuilder);
return(await data.Set <T>().ToListAsync());
}
public virtual TEntity Adicionar(TEntity entity)
{
_context.Set <TEntity>().Add(entity);
_context.SaveChanges();
return(entity);
}
public int Create(List <int> insertedViewElement, List <int> deletedviewElementRole, int roleId,
bool allowSaveChange = true)
{
var addedViewElemetId = new List <int>();
var allViewElements = new List <ViewElement>();
var allParentViewElements = new List <ViewElement>();
var findedRole = ContextBase.Set <ViewElementRole>().Where(x => x.RoleId == roleId);
var existedVElement = findedRole.Select(a => a.ViewElement.Id).ToList();
//در دیتابیس هستند در لیست حذف شده هم هست
var deleteElement = from x in existedVElement
where deletedviewElementRole.Contains(x)
select x;
//لیست آیتم هایی که در دیتابیس هست و قرار نیست حذف شود
var fff =
findedRole.Where(a => a.ViewElement.IsHidden != true)
.Select(a => a.ViewElement.Id)
.ToList();
var existedItemForAdd = fff.Where(item => !deleteElement.Contains(item)).ToList();
foreach (int item in existedItemForAdd)
{
if (!insertedViewElement.Contains(item))
{
insertedViewElement.Add(item);
}
}
foreach (var vId in existedVElement)
{
var findedVElement = ContextBase.Set <ViewElementRole>().FirstOrDefault(x => x.RoleId == roleId && x.ViewElementId == vId);
if (findedVElement != null)
{
ContextBase.Set <ViewElementRole>().Remove(findedVElement);
}
}
foreach (var velementId in insertedViewElement)
{
//var foundVelement = ContextBase.Set<ViewElement>().Find(velementId);
var founded = viewElementRepository.GetViewElementAndChildsById(velementId);
if (founded.ChildrenViewElement != null)
{
foreach (var childElement in founded.ChildrenViewElement)
{
var parentElement = viewElementRepository.GetViewElementAndChildsById(childElement.ParentId ?? 0);
List <ViewElement> resultElements;
resultElements = GetHiddenEelements(parentElement);
if (resultElements != null)
{
foreach (var resultElement in resultElements)
{
var hElement = ContextBase.Set <ViewElement>().Find(resultElement.Id);
if (!addedViewElemetId.Any(a => a.Equals(hElement.Id)))
{
Create(new ViewElementRole()
{
RoleId = roleId,
ViewElementId = hElement.Id
}, false);
}
//...
addedViewElemetId.Add(hElement.Id);
allViewElements.Add(founded);
}
}
}
}
//foundVelement.Roles.Add(findedRole);
if (!addedViewElemetId.Any(a => a.Equals(founded.Id)))
{
Create(new ViewElementRole()
{
RoleId = roleId,
ViewElementId = founded.Id
}, false);
}
//...
addedViewElemetId.Add(founded.Id);
allViewElements.Add(founded);
}
//...
foreach (var item in allViewElements)
{
if (!allViewElements.Any(r => r.Id == item.ParentId))
{
var foundParent = ContextBase.Set <ViewElement>().Find(item.ParentId); //Find(item.ParentId);
if (foundParent != null)
{
if (!allParentViewElements.Any(a => a.Id == foundParent.Id))
{
allParentViewElements.Add(foundParent);
}
}
}
}
foreach (var parent in allParentViewElements)
{
if (parent.ChildrenViewElement != null)
{
var hiddenElements = parent.ChildrenViewElement.Where(a => a.IsHidden).ToList();
foreach (var hItem in hiddenElements)
{
// hItem.Roles.Add(findedRole);
if (!addedViewElemetId.Any(a => a.Equals(hItem.Id)))
{
Create(new ViewElementRole()
{
RoleId = roleId,
ViewElementId = hItem.Id
}, false);
}
addedViewElemetId.Add(hItem.Id);
allViewElements.Add(hItem);
}
}
}
var roles = findedRole.Select(x => x.Role).FirstOrDefault();
if (roles != null)
{
ContextBase.Set <Role>().Attach(roles);
}
if (allowSaveChange)
{
// return ContextBase.SaveChanges();
return(SaveChanges());
}
return(0);
}
public bool HasAdminRecord()
{
return(ContextBase.Set <UserProfile>().Any(a => a.UserName == GeneralConstant.AdminUserName));
}
public void Add(TEntity entity)
{
_dbContext.Set <TEntity>().Add(entity);
}
public Repositorio(ContextBase db)
{
Db = db;
DbSet = db.Set <T>();
}
public async Task <T> GetEntityById(int Id)
{
using (var data = new ContextBase(_OptionsBuild)) return(await data.Set <T>().FindAsync(Id));
}
public RepositoryGenerics(ContextBase context)
{
_contexto = context;
DbSet = _contexto.Set <T>();
}
protected Repository(ContextBase context)
{
Db = context;
DbSet = Db.Set <T>();
}
public int Create(List <int> inseretedCompanyViewElement, List <int> deletedCompanyViewElement, int CompanyId, bool allowSaveChange = true)
{
var addedViewElemetId = new List <int>();
var allViewElements = new List <ViewElement>();
var allParentViewElements = new List <ViewElement>();
var foundedCompany = ContextBase.Set <Company>().Find(CompanyId);
var existedVElement = foundedCompany.CompanyViewElements.Select(a => a.ViewElement.Id).ToList();
//در دیتابیس هستند در لیست حذف شده هم هست
var deleteElement = from x in existedVElement
where deletedCompanyViewElement.Contains(x)
select x;
//لیست آیتم هایی که در دیتابیس هست و قرار نیست حذف شود
var neverDeleteItem =
foundedCompany.CompanyViewElements.Where(a => a.ViewElement.IsHidden != true)
.Select(a => a.ViewElement.Id)
.ToList();
var existedItemForAdd = neverDeleteItem.Where(item => !deleteElement.Contains(item)).ToList();
foreach (int item in existedItemForAdd)
{
if (!inseretedCompanyViewElement.Contains(item))
{
inseretedCompanyViewElement.Add(item);
}
}
foreach (var vId in existedVElement)
{
var foundedViewElement = ContextBase.Set <CompanyViewElement>().Find(vId, CompanyId);
ContextBase.Set <CompanyViewElement>().Remove(foundedViewElement);
}
foreach (var velementId in inseretedCompanyViewElement)
{
var foundVelement = ContextBase.Set <ViewElement>().Find(velementId);
foreach (var childElement in foundVelement.ChildrenViewElement)
{
var parentElement = ContextBase.Set <ViewElement>().Find(childElement.ParentId);
List <ViewElement> resultElements;
resultElements = GetHiddenEelements(parentElement);
if (resultElements != null)
{
foreach (var resultElement in resultElements)
{
var hElement = ContextBase.Set <ViewElement>().Find(resultElement.Id);
if (!addedViewElemetId.Any(a => a.Equals(hElement.Id)))
{
Create(new CompanyViewElement()
{
CompanyId = CompanyId,
ViewElementId = hElement.Id
}, false);
}
//...
addedViewElemetId.Add(hElement.Id);
allViewElements.Add(foundVelement);
}
}
}
if (!addedViewElemetId.Any(a => a.Equals(foundVelement.Id)))
{
Create(new CompanyViewElement()
{
CompanyId = CompanyId,
ViewElementId = foundVelement.Id
}, false);
}
//...
addedViewElemetId.Add(foundVelement.Id);
allViewElements.Add(foundVelement);
}
//...
foreach (var item in allViewElements)
{
if (!allViewElements.Any(r => r.Id == item.ParentId))
{
var foundParent = ContextBase.Set <ViewElement>().Find(item.ParentId); //Find(item.ParentId);
if (foundParent != null)
{
if (!allParentViewElements.Any(a => a.Id == foundParent.Id))
{
allParentViewElements.Add(foundParent);
}
}
}
}
foreach (var parent in allParentViewElements)
{
if (parent.ChildrenViewElement != null)
{
var hiddenElements = parent.ChildrenViewElement.Where(a => a.IsHidden).ToList();
foreach (var hItem in hiddenElements)
{
if (!addedViewElemetId.Any(a => a.Equals(hItem.Id)))
{
Create(new CompanyViewElement()
{
CompanyId = CompanyId,
ViewElementId = hItem.Id
}, false);
}
addedViewElemetId.Add(hItem.Id);
allViewElements.Add(hItem);
}
}
}
ContextBase.Set <Company>().Attach(foundedCompany);
if (allowSaveChange)
{
return(SaveChanges());
}
return(0);
}
public void Add(TEntity entity)
{
_context.Set <TEntity>().Add(entity);
_context.SaveChanges();
}
public async Task AddAsync(T entity)
{
await _context.Set <T>().AddAsync(entity);
}
public RepositoryBase(ContextBase context)
{
Context = context;
Set = Context.Set <EntityType>();
}
public RepositoryBase(ContextBase context)
{
_context = context;
DbSet = _context.Set <TEntity>();
}
public async Task Update(T Object)
{
using ContextBase data = new ContextBase(_OptionBuilder);
_ = data.Set <T>().Update(Object);
_ = await data.SaveChangesAsync();
}
public IQueryable <CompanyChart> GetCompanyChart(int?id)
{
// var currentCMPchartId = UserLog.GetCompanyId();
return(ContextBase.Set <CompanyChart>().Where(a => a.ParentId == id).Include("ChildCompanyChart").Include("CompanyChartRoles"));
}
public RepositoryBase(ContextBase contextBase)
{
_contextBase = contextBase;
_dbSet = contextBase.Set <TEntity>();
}
public async Task Add(T Objeto)
{
await _context.Set <T>().AddAsync(Objeto);
await _context.SaveChangesAsync();
}
public CustomerRepository(ContextBase context)
{
Db = context;
DbSet = Db.Set <Customer>();
}
// GET: Cursos/Create
public IActionResult Create()
{
ViewData["ProfessorId"] = new SelectList(_context.Set <Professor>(), "Id", "Nome");
return(View());
}
public async Task <List <T> > List()
{
using (var data = new ContextBase(_OptionsBuild)) return(await data.Set <T>().AsNoTracking().ToListAsync());
}
//public int UpdateHeaderUser(User user, int currentOrganizationId, bool allowSaveChange = true)
//{
// var CurrentUser = ContextBase.Set<User>().Find(user.Id);
// _dbContext.Entry(CurrentUser).CurrentValues.SetValues(user);
// foreach (var role in user.UserRoles.ToList())
// {
// var rep = new UserRoleRepository(_dbContext, UserLog);
// rep.Update(role, false);
// }
// if (allowSaveChange)
// return SaveChanges();
// return 0;
//}
public bool IsDuplicateUserName(string userName, int userId)
{
var useName = userName.Trim().CorrectPersianChars();
return(ContextBase.Set <User>().Any(a => a.UserProfile.UserName == useName && a.Id != userId));
}