public void Down(BiContext context)
{
var weeks = context.Set <WeekEntity>().ToList();
context.Set <WeekEntity>().RemoveRange(weeks);
context.SaveChanges();
}
public ReportRepository(BiContext context, WeekRepository repository, CompanyRepository companyRepository, EventRepository eventRepository)
{
this.context = context;
this._weekRepository = repository;
this._companyRepository = companyRepository;
this._eventRepository = eventRepository;
}
public UserRepository(BiContext context,
IPasswordHasher <UserEntity> passwordHasher,
EventRepository eventRepository)
{
this.context = context;
this.passwordHasher = passwordHasher;
this.eventRepository = eventRepository;
}
public void Down(BiContext context)
{
var dbUser = context.Set <UserEntity>();
var users = dbUser.Where(u => listUsers.Any(lu => lu.Email == u.Email)).ToList();
dbUser.RemoveRange(users);
context.SaveChanges();
}
public void Up(BiContext context)
{
var dbUser = context.Set <UserEntity>();
var passwordHasher = new PasswordHasher <UserEntity>();
listUsers.ForEach(user => user.Password = passwordHasher.HashPassword(user, user.Password));
dbUser.AddRange(listUsers);
context.SaveChanges(); // Not async
}
public static void BiSeedDown(this MigrationBuilder migrationBuilder, int version)
{
var context = new BiContext();
modules.ForEach(mod => mod.ConfigureSeeds(context)
.Where(s => s.Version == version)
.ToList()
.ForEach(s => s.Down(context)));
}
public static void DownRootUsers(this MigrationBuilder migrationBuilder)
{
using (var db = new BiContext()){
var dbUser = db.Set <UserEntity>();
users.ForEach(u => { // no tengo ids
var foundUser = dbUser.First(dbu => dbu.Email == u.Email);
dbUser.Remove(foundUser);
});
db.SaveChanges();
}
}
private List <long> UserFromReport(BiContext context, ReportEntity report)
{
var _dbCompany = context.Set <CompanyEntity>();
var _dbUser = context.Set <PermissionEntity>();
var userList = new List <long>();
var company = _dbCompany.Find(report.CompanyId);
userList.Add(report.UserId);
while (company.ParentId != null)
{
company = _dbCompany.Find(company.ParentId);
}
var ceo = _dbUser.Where(p => p.CompanyId == company.Id && (p.RoleId == 602 || p.RoleId == 603))
.Select(p => p.UserId).ToList();
return(userList.Concat(ceo).ToList());
}
public static void UpRootUsers(this MigrationBuilder migrationBuilder)
{
using (var db = new BiContext()){
var dbUser = db.Set <UserEntity>();
var dbRoot = db.Set <RootEntity>();
var hasher = new PasswordHasher <UserEntity>();
users.ForEach(u => {
u.Password = hasher.HashPassword(u, u.Password);
var entry = dbUser.Add(u);
});
db.SaveChanges();
users.ForEach(u => {
var foundUser = dbUser.First(dbu => dbu.Email == u.Email);
dbRoot.Add(new RootEntity {
UserId = foundUser.Id
});
});
db.SaveChanges();
}
}
public CompanyRepository(BiContext context, EventRepository eventRepository)
{
this.context = context;
this.eventRepository = eventRepository;
}
public GoodsTypeRepository(BiContext biContext)
{
_biContext = biContext;
}
public InvoiceRepository(BiContext context)
{
this.context = context;
}
public OrderDAL(BiContext context)
{
_context = context;
}
public MovementRepository(BiContext context)
{
this.context = context;
}
public static void BiInitialize(this BiContext biContext, UserManager <UserEntity> _manager)
{
modules.ForEach(item => item.ConfigureInitializer(biContext, _manager));
}
public ServiceSaleRepository(BiContext context)
{
this.context = context;
}
public BankRepository(BiContext context)
{
this.context = context;
}
public ClientRepository(BiContext context)
{
this.context = context;
}
public FilesRepository(BiContext biContext)
{
this._context = biContext;
}
public void ConfigureInitializer(BiContext context, UserManager <UserEntity> userManager)
{
}
public GoodsGroupRepository(BiContext biContext)
{
_biContext = biContext;
}
public NotificationsIOSRepository(BiContext biContext)
{
this._context = biContext;
}
public LenderRepository(BiContext context)
{
this.context = context;
}
public OrderLineItemDAL(BiContext context)
{
_context = context;
}
public List <ISeed> ConfigureSeeds(BiContext context)
{
return(new List <ISeed>());
}
public DepartmentRepository(BiContext context, EventRepository eventRepo)
{
this.context = context;
this.eventRepo = eventRepo;
}
public void Up(BiContext context)
{
context.Set <WeekEntity>().AddRange(this.Weeks);
context.SaveChanges();
}
public SmallBoxRepository(BiContext context)
{
this.context = context;
}
public PermissionRepository(BiContext context, EventRepository eventRepo)
{
this.context = context;
this.eventRepository = eventRepo;
}
public CommentDAL(BiContext context)
{
_context = context;
}
