private static void UpdateDisconnectedPeople() { Person janeDoe; using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; janeDoe = db.People .Where(p => p.FirstName == "Jane") .FirstOrDefault(); PrintPerson(janeDoe); } janeDoe.GetType().GetProperty("FirstName").SetValue(janeDoe, "Jean"); using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; db.Entry(janeDoe).State = EntityState.Modified; db.SaveChanges(); PrintPerson(janeDoe); } janeDoe.GetType().GetProperty("FirstName").SetValue(janeDoe, "Jane"); using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; db.Entry(janeDoe).State = EntityState.Modified; db.SaveChanges(); PrintPerson(janeDoe); } }
private static void RemovePeople() { IList <Person> peopleToDelete; using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; var pplRepo = new EFDisconnectedPersonRepository(db); var peopleToDeleteIds = GetPeople().Select(p => p.DataSourceId); peopleToDelete = pplRepo.GetAll().Where(p => peopleToDeleteIds.Contains(p.DataSourceId)).ToList(); } using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; var pplRepo = new EFDisconnectedPersonRepository(db); foreach (var personToDelete in peopleToDelete) { pplRepo.Delete(personToDelete); } } // NOTE: deleting could very well be done by going off to a stored procedure, // because retrieving and then doing another query for deletion // seems a bit much // Depends on the scenario }
private static void ListAllPeople() { using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; var repo = new EFDisconnectedPersonRepository(db); PrintPerson(repo.GetAll().ToArray()); } }
private static void RemoveRelationships() { using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; db.Relations.RemoveRange(db.Relations.ToList()); db.SaveChanges(); } }
private static void InsertPeople() { using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; var repo = new EFDisconnectedPersonRepository(db); foreach (var person in GetPeople()) { repo.Add(person); } } }
public EFUnitOfWork( AbsenceManagementContext dataContext, IExternalLoginRepository externalLoginRepository, IRoleRepository roleRepository, IUserRepository userRepository ) { Database = dataContext; ExternalLoginRepository = externalLoginRepository; RoleRepository = roleRepository; UserRepository = userRepository; }
public static AbsenceManagementContext GetTransientAbsenceManagementContext( IEnumerable <Person> people = null, IEnumerable <Relation> relations = null ) { var dbConnection = Effort.DbConnectionFactory.CreateTransient(); var dbContext = new AbsenceManagementContext(dbConnection); dbContext.People.AddRange(people ?? new List <Person>()); dbContext.Relations.AddRange(relations ?? new List <Relation>()); dbContext.SaveChanges(); return(dbContext); }
private static AbsenceManagementContext SetupPersistentAbsenceManagementContext( string id = "_", IEnumerable <Person> people = null, IEnumerable <Relation> relations = null ) { var dbConnection = Effort.DbConnectionFactory.CreatePersistent(id); var dbContext = new AbsenceManagementContext(dbConnection); dbContext.People.AddRange(people ?? new List <Person>()); dbContext.Relations.AddRange(relations ?? new List <Relation>()); dbContext.SaveChanges(); return(dbContext); }
private static void InsertRelation() { using (var db = new AbsenceManagementContext()) { db.Database.Log = Console.WriteLine; var pplRepo = new EFDisconnectedPersonRepository(db); var relRepo = new EFDisconnectedRelationRepository(db); var janeDoe = pplRepo.GetAll() .FirstOrDefault(p => p.FirstName == "Jane"); var johnDoe = pplRepo.GetAll() .FirstOrDefault(p => p.FirstName == "John"); var relation = RelationBuilder .CreateRelation(RelationType.ManagerToSubordinate) .ForMaster(janeDoe) .WithSlave(johnDoe) .Build(); relRepo.Add(relation); } }
public CoverageController(UserManager <User> userM, AbsenceManagementContext ctx) { userManager = userM; data = new UnitOfWork(ctx); }
public AbsenceTypeController(AbsenceManagementContext ctx) { data = new UnitOfWork(ctx); }
//Constructor public UnitOfWork(AbsenceManagementContext ctx) { context = ctx; }
//Constructor public Repository(AbsenceManagementContext ctx) { context = ctx; dbSet = context.Set <T>(); //Will hold the DbSet<TEntity> }
public AccountController(UserManager <User> userM, SignInManager <User> signInM, AbsenceManagementContext ctx) { userManager = userM; signInManager = signInM; data = new UnitOfWork(ctx); }
public UserController(UserManager <User> userM, RoleManager <IdentityRole> roleM, AbsenceManagementContext ctx) { userManager = userM; roleManager = roleM; data = new UnitOfWork(ctx); }