/// <summary> /// 初始化基本变量 /// </summary> /// <returns></returns> static bool Init() { var serverUser = GeneralProcess.GetUserByLoginName(AppConfig.ServerAccount); if (serverUser == null) { Log("通信管理员账号信息错误,请检查配置!"); return(false); } ProcessInvoke.SetupGlobalRepositoryContext(serverUser, serverUser.Domain); using (var context = new RepositoryDbContext()) { foreach (var data in AppConfig.CommandDatas) { ProduceDatas.Add(context.Set <CommandData>().First(obj => obj.DataName == data)); } foreach (var data in AppConfig.RunningTimeDatas) { RunningTimeDatas.Add(context.Set <CommandData>().First(obj => obj.DataName == data)); } _hotelGuids = context.Set <HotelRestaurant>().ToList(); } _produceEndDayHour = DateTime.Now.AddHours(-1).GetCurrentHour(); _produceEndDay = DateTime.Now.AddDays(-1).GetToday(); Log($"【{DateTime.Now:yyyy-MM-dd HH:mm:ss}】系统初始化完成。"); return(true); }
/// <summary> /// 读取权限信息 /// </summary> public static void LoadBaseInfomations() { RefreashUserPermissionsCache(); RefreashRolePermissionsCache(); RefreashModules(); RefreashPermissions(); using (var context = new RepositoryDbContext()) { var commandDatas = context.Set <CommandData>(); CommandDataId.CleanerCurrent = commandDatas.First(obj => obj.DataName == ProtocolDataName.CleanerCurrent).Id; CommandDataId.CleanerSwitch = commandDatas.First(obj => obj.DataName == ProtocolDataName.CleanerSwitch).Id; CommandDataId.FanCurrent = commandDatas.First(obj => obj.DataName == ProtocolDataName.FanCurrent).Id; CommandDataId.FanSwitch = commandDatas.First(obj => obj.DataName == ProtocolDataName.FanSwitch).Id; CommandDataId.LampblackInCon = commandDatas.First(obj => obj.DataName == ProtocolDataName.LampblackInCon).Id; CommandDataId.LampblackOutCon = commandDatas.First(obj => obj.DataName == ProtocolDataName.LampblackOutCon).Id; } }
public override async Task <DAL.App.DTO.BillLine> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var billLine = await RepositoryDbSet.FindAsync(id); if (billLine != null) { await RepositoryDbContext.Entry(billLine) .Reference(c => c.Bill) .LoadAsync(); await RepositoryDbContext.Entry(billLine.Bill) .Reference(c => c.Comment) .LoadAsync(); await RepositoryDbContext.Entry(billLine.Bill.Comment) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(billLine) .Reference(c => c.Product) .LoadAsync(); await RepositoryDbContext.Entry(billLine.Product) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); } return(BillLineMapper.MapFromDomain(billLine)); }
public async Task <NthChildInFamilyDTO> GetNthChildInFamily(int id) { // get mom var mom = await RepositoryDbContext.Set <Domain.PersonInRelationship>() .Where(w => w.Person1Id == id && w.Relationship.Relation == Relation.Ema) .Select(e => e.Person).FirstOrDefaultAsync(); // get dad var dad = await RepositoryDbContext.Set <Domain.PersonInRelationship>() .Where(w => w.Person1Id == id && w.Relationship.Relation == Relation.Isa) .Select(e => e.Person).FirstOrDefaultAsync(); // get children var childrenCount = await RepositoryDbContext.Set <Domain.PersonInRelationship>() .Include(i => i.Person) .Include(i => i.Person1) .Where(w => (dad != null && w.PersonId == dad.Id) && w.Relationship.Relation == Relation.Isa || (mom != null && w.PersonId == mom.Id) && w.Relationship.Relation == Relation.Ema) .Select(e => e.Person1).Distinct().CountAsync(); return(_personMapper.MapToNthChild( childrenCount, await RepositoryDbSet.Where(w => w.Id == id).FirstOrDefaultAsync())); }
public AnalysisCreatorController(RepositoryDbContext context, IGitCloneServices gitCloneServices, ICounterChange counterChange, IGitInitService gitInitService) { this.gitCloneServices = gitCloneServices; this.gitInitService = gitInitService; this.counterChange = counterChange; _context = context; }
public override async Task <DTO.Dog> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var dog = await RepositoryDbSet.FindAsync(id); if (dog != null) { await RepositoryDbContext.Entry(dog) .Reference(c => c.Sex) .LoadAsync(); await RepositoryDbContext.Entry(dog.Sex) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(dog) .Reference(c => c.Breed) .LoadAsync(); await RepositoryDbContext.Entry(dog.Breed) .Reference(c => c.BreedName) .LoadAsync(); await RepositoryDbContext.Entry(dog.Breed.BreedName) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); } return(DogMapper.MapFromDomain(dog)); }
public async Task Create_User_Feedback_Success(int rating, string sessionId, string comment) { //Act using (var context = new RepositoryDbContext(this.repositoryDbContextMock.options)) { this.repositoryDbContextMock.usersMock = new List <User>(); var userMock = new User(Guid.NewGuid(), "User1", "UserName", "*****@*****.**"); this.repositoryDbContextMock.usersMock.Add(userMock); this.repositoryDbContextMock.userFeedbacksMock = new List <UserFeedback>(); var actionResultMessage = await this.userFeedbackRepository.AddAsync( new UserFeedback( Guid.NewGuid(), new User(userMock.Id, userMock.NickName, userMock.Name, userMock.Email), sessionId, rating, comment) ); //Asserts actionResultMessage.Should().NotBeNull(); actionResultMessage.StatusCode.Should().Be(HttpStatusCode.OK); actionResultMessage.Message.Should().Contain("Feedback"); } }
public override async Task <DAL.App.DTO.ClientGroup> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var clientGroup = await RepositoryDbSet.FindAsync(id); if (clientGroup != null) { await RepositoryDbContext.Entry(clientGroup) .Collection(c => c.Clients) .LoadAsync(); await RepositoryDbContext.Entry(clientGroup) .Reference(c => c.Name) .LoadAsync(); await RepositoryDbContext.Entry(clientGroup.Name) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(clientGroup) .Reference(c => c.Description) .LoadAsync(); await RepositoryDbContext.Entry(clientGroup.Description) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); } return(ClientGroupMapper.MapFromDomain(clientGroup)); }
public async Task Returns_All_Items() { var model1 = new ServiceApiDescriptionBuilder().WithServiceId("AllItem1").Build(); var model2 = new ServiceApiDescriptionBuilder().WithServiceId("AllItem2").Build(); using (var context = new RepositoryDbContext(DbContextOptions, StoreOptions)) { context.Apis.RemoveRange(context.Apis.ToArray()); context.Apis.Add(model1.ToEntity()); context.Apis.Add(model2.ToEntity()); context.SaveChanges(); } using (var context = new RepositoryDbContext(DbContextOptions, StoreOptions)) { var store = new ApiStore(context, new Mock <ILogger <ApiStore> >().Object); var services = (await store.GetAllAsync()).OrderBy(s => s.ServiceId).ToList(); services.Should().HaveCount(2); services[0].ServiceId.Should().Be(model1.ServiceId); services[0].ApiDocument.Info.Title.Should().Be(model1.ApiDocument.Info.Title); services[1].ServiceId.Should().Be(model2.ServiceId); services[1].ApiDocument.Info.Title.Should().Be(model2.ApiDocument.Info.Title); } }
public async Task Updates_ApiDocument_On_Existing_Item() { var model = new ServiceApiDescriptionBuilder().WithServiceId("Updates_DisplayName_On_Existing_Item").Build(); using (var context = new RepositoryDbContext(DbContextOptions, StoreOptions)) { context.Apis.Add(model.ToEntity()); context.SaveChanges(); } model.ApiDocument.Info.Title = "New title"; using (var context = new RepositoryDbContext(DbContextOptions, StoreOptions)) { var store = new ApiStore(context, new Mock <ILogger <ApiStore> >().Object); await store.StoreAsync(model); } using (var context = new RepositoryDbContext(DbContextOptions, StoreOptions)) { var item = context.Apis.SingleOrDefault(s => s.ServiceId == model.ServiceId); item.Should().NotBeNull(); var document = OpenApiDocumentHelper.ReadFromJson(item.ApiDocument); document.Info.Title.Should().Be(model.ApiDocument.Info.Title); } }
public override async Task <DAL.App.DTO.AppUserInPosition> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var workerInPosition = await RepositoryDbSet.FindAsync(id); if (workerInPosition != null) { await RepositoryDbContext.Entry(workerInPosition) .Reference(c => c.AppUserPosition) .LoadAsync(); await RepositoryDbContext.Entry(workerInPosition.AppUserPosition) .Reference(c => c.AppUserPositionValue) .LoadAsync(); await RepositoryDbContext.Entry(workerInPosition.AppUserPosition.AppUserPositionValue) .Collection(c => c.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(workerInPosition) .Reference(c => c.AppUser) .LoadAsync(); } return(AppUserInPositionMapper.MapFromDomain(workerInPosition)); }
public SignInResult PasswordSignIn(string loginName, string password, bool rememberMe, bool shouldLockout = false) { var result = new SignInResult(); using (var context = new RepositoryDbContext()) { var md5Password = Globals.GetMd5(password); var user = context.Set <WdUser>() .FirstOrDefault(obj => obj.LoginName == loginName && obj.Password == md5Password && obj.IsEnabled); if (user == null) { result.Status = SignInStatus.Failure; result.ErrorElement = "Password"; result.ErrorMessage = "无效的用户名或登陆密码"; return(result); } FormsAuthentication.SetAuthCookie(loginName, false); user.LastLoginDateTime = DateTime.Now; context.SaveChanges(); } result.Status = SignInStatus.Success; return(result); }
public async Task <PersonWithMostPredecessorsDTO> GetPersonWithMostPredecessors() { var result = new Dictionary <int, Tuple <int, Person> >(); var index = 0; var personsWithParents = await RepositoryDbContext.Set <Domain.PersonInRelationship>() .Include(i => i.Relationship) .Include(i => i.Person1) .Where(w => (w.Relationship.Relation == Relation.Ema || w.Relationship.Relation == Relation.Isa)) .Select(e => e.Person1) .Where(w => w.RelatedFrom.Any(ww => ww.Relationship.Relation == Relation.Poeg || ww.Relationship.Relation == Relation.Tütar)).ToListAsync(); foreach (var person in personsWithParents) { RelatedPersonsIds[person.Id] = new List <Person>(); await GetParents(person, person.Id); result.Add(index, new Tuple <int, Person>(RelationsCounter, person)); index += 1; RelationsCounter = new int(); } return(_personMapper.MapToPredecessorDtoFormat(result, RelatedPersonsIds)); }
/// <summary> /// 获取系统配置信息 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="exp"></param> /// <returns></returns> public static object GetConfig <T>(Expression <Func <T, bool> > exp) where T : class { using (var context = new RepositoryDbContext()) { return(context.Set <T>().Where(exp).ToList()); } }
public override async Task <DAL.App.DTO.Payment> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var payment = await RepositoryDbSet.FindAsync(id); if (payment != null) { await RepositoryDbContext.Entry(payment) .Reference(c => c.PaymentMethod) .LoadAsync(); await RepositoryDbContext.Entry(payment.PaymentMethod) .Reference(c => c.PaymentMethodValue) .LoadAsync(); await RepositoryDbContext.Entry(payment.PaymentMethod.PaymentMethodValue) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); } return(PaymentMapper.MapFromDomain(payment)); }
public override async Task <TaskerTask> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var taskerTask = await RepositoryDbSet.FindAsync(id); if (taskerTask != null) { await RepositoryDbContext.Entry(taskerTask) .Reference(c => c.TaskName) .LoadAsync(); await RepositoryDbContext.Entry(taskerTask) .Reference(c => c.Description) .LoadAsync(); await RepositoryDbContext.Entry(taskerTask.TaskName) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(taskerTask.Description) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); } return(TaskerTaskMapper.MapFromDomain(taskerTask)); }
public UnitOfWork(RepositoryDbContext context) { _context = context; AccountsRepository = new AccountRepository(context); UsersRepository = new UserRepository(context); ListOfFields = new ListOfFields(); }
private async Task <FamilyTreeDTO> GetRelatedPeople(Person childPerson, FamilyTreeDTO familyTree) { var personsQueue = new Queue <Person>(); familyTree.Family = new List <FamilyTreeDTO>(); // get all related persons var relatedPeople = await RepositoryDbContext.Set <Domain.PersonInRelationship>() .Include(i => i.Person) .Include(i => i.Person1) .Include(i => i.Relationship) .Where(w => w.PersonId == childPerson.Id) .Select(e => e.Person1).Distinct().ToListAsync(); IdsToExclude.Add(childPerson.Id); familyTree.Id = childPerson.Id; familyTree.FirstName = childPerson.FirstName; familyTree.LastName = childPerson.LastName; familyTree.Age = childPerson.Age; foreach (var person in relatedPeople.Where(person => !IdsToExclude.Contains(person.Id))) { personsQueue.Enqueue(person); } while (personsQueue.Count != 0) { var personToCheck = personsQueue.Dequeue(); familyTree.Family.Add(await GetRelatedPeople(personToCheck, new FamilyTreeDTO())); } return(familyTree); }
private async Task GetParents(Person child, int initialPersonId) { var query = RepositoryDbContext.Set <Domain.PersonInRelationship>() .Include(i => i.Relationship) .Where(w => w.Person1 == child); var mom = await query.Where(w => w.Relationship.Relation == Relation.Ema).Select(e => e.Person) .FirstOrDefaultAsync(); var dad = await query.Where(w => w.Relationship.Relation == Relation.Isa).Select(e => e.Person) .FirstOrDefaultAsync(); if (!PersonFirstNameMissing(mom)) { RelationsCounter += 1; RelatedPersonsIds[initialPersonId].Add(mom); await GetParents(mom, initialPersonId); } if (!PersonFirstNameMissing(dad)) { RelationsCounter += 1; RelatedPersonsIds[initialPersonId].Add(dad); await GetParents(dad, initialPersonId); } }
public override async Task <DAL.App.DTO.ProductService> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var productService = await RepositoryDbSet.FindAsync(id); if (productService != null) { await RepositoryDbContext.Entry(productService) .Reference(c => c.ProductForClient) .LoadAsync(); await RepositoryDbContext.Entry(productService) .Reference(c => c.WorkObject) .LoadAsync(); await RepositoryDbContext.Entry(productService) .Reference(c => c.Description) .LoadAsync(); await RepositoryDbContext.Entry(productService.Description) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); } return(ProductServiceMapper.MapFromDomain(productService)); }
public void UpdateEntity(TEntity entity, bool isSave = true) { if (isSave) { RepositoryDbContext.SaveChanges(); } }
/// <summary> /// 获取油烟设备型号信息 /// </summary> /// <returns></returns> public static List <LampblackDeviceModel> GetDeviceModels() { using (var context = new RepositoryDbContext()) { return(context.Set <LampblackDeviceModel>().ToList()); } }
public void DeleteEntity(TEntity entity, bool isSave = true) { Entities.Remove(entity); if (isSave) { RepositoryDbContext.SaveChanges(); } }
public RepositoriesViewModel() { dbContext = new RepositoryDbContext(); repSource = dbContext.Repositories.ToList(); SourceUser = new FtpUser(); TargetUser = new FtpUser(); this.Repositories = new ObservableCollection <Repository>(repSource); }
public async Task CanCreateUserAccessToken() { var user = TestDataUtil .AddUser().GetLast <User>(); _userAccessTokenRepository.Add(CreateUserAccessToken(user)); await RepositoryDbContext.SaveChangesAsync(); }
public void InsertEntity(TEntity entity, bool isSave = true) { Entities.Add(entity); if (isSave) { RepositoryDbContext.SaveChanges(); } }
public List <HotelCleaness> GetHotelCleanessList() { using (var context = new RepositoryDbContext()) { ((IObjectContextAdapter)context).ObjectContext.CommandTimeout = 180; var checkDate = DateTime.Now.AddMinutes(-2); var commandDataId = context.Set <CommandData>().First(obj => obj.DataName == ProtocolDataName.CleanerCurrent).Id; var modelId = Guid.Parse("5306DA86-7B7C-40CF-933C-642061C24761"); var cleanNess = new List <HotelCleaness>(); foreach (var hotel in context.Set <HotelRestaurant>()) { var devs = context.Set <Device>().Where(dev => dev.ProjectId == hotel.Id).Select(item => item.Identity).ToList(); var lastProtocol = context.Set <ProtocolData>() .Where(d => devs.Contains(d.DeviceIdentity)) .OrderByDescending(dat => dat.UpdateTime) .FirstOrDefault(); if (lastProtocol != null && lastProtocol.UpdateTime >= checkDate) { var hotelData = context.Set <MonitorData>().FirstOrDefault(d => d.ProjectIdentity == hotel.Identity && d.ProtocolDataId == lastProtocol.Id && d.CommandDataId == commandDataId); if (hotelData == null) { cleanNess.Add(new HotelCleaness { DistrictGuid = hotel.DistrictId, ProjectName = hotel.ProjectName, ProjectCleaness = "无数据" }); } else { cleanNess.Add(new HotelCleaness { DistrictGuid = hotel.DistrictId, ProjectName = hotel.ProjectName, ProjectCleaness = hotelData.DoubleValue != null ? GetCleanRateByDeviceModel(hotelData.DoubleValue, modelId) : "无数据" }); } } else { cleanNess.Add(new HotelCleaness { DistrictGuid = hotel.DistrictId, ProjectName = hotel.ProjectName, ProjectCleaness = "无数据" }); } } return(cleanNess); } }
/// <summary> /// 刷新权限信息缓存 /// </summary> public static void RefreashPermissions() { using (var context = new RepositoryDbContext()) { PlatformCaches.DeleteCachesByName("Permissions"); var permissions = context.Set <Permission>().ToList(); PlatformCaches.Add("Permissions", permissions, false, "System"); } }
static void Main(string[] args) { Console.WriteLine("Creating Default Db Context"); //To connect to an sql or azure sql server jusr use: UseSqlServer(connectionString) var options = new DbContextOptionsBuilder <RepositoryDbContext>() .UseSqlite("Data Source=endavaUniversity.db") //.UseLoggerFactory(loggerFactory) .Options; using (var db = new RepositoryDbContext(options)) { // Create var user = new User { FirstName = "Maria", LastName = "Antuanetta" }; Console.WriteLine($"Inserting a new user: {user.FirstName} {user.LastName}."); db.Add(user); db.SaveChanges(); // Read Console.WriteLine("Querying for a user"); var returnedUser = db.Users .OrderBy(u => u.Id) .Where(u => u.FirstName.Equals(user.FirstName)).First(); Console.WriteLine($"User: {returnedUser.FirstName} {returnedUser.LastName}; Id: {returnedUser.Id}"); // Update Console.WriteLine("Updating the user (Carlos) and adding a wallet"); returnedUser.LastName = "Carlos"; returnedUser.Wallets.Add( new Wallet { Amount = 100, Currency = "USD", }); db.SaveChanges(); // Read Console.WriteLine("Querying for an updated user"); var updatedUser = db.Users .OrderBy(u => u.Id) .Where(u => u.FirstName.Equals(user.FirstName)).First(); Console.WriteLine($"User: {updatedUser.FirstName} {updatedUser.LastName}; Id: {updatedUser.Id}"); Console.WriteLine($"User' wallet Id: {updatedUser.Wallets.First()?.Id}"); Console.WriteLine($"Wallet' user Id: {updatedUser.Wallets.First()?.UserId}"); // Delete Console.WriteLine("Delete the user"); db.Remove(updatedUser); db.SaveChanges(); } }
public override Event Update(Event entity) { var dbUnit = RepositoryDbContext.AdministrativeUnitInEvents.Where(item => item.EventId == entity.Id).ToList(); RepositoryDbContext.RemoveRange(dbUnit); var dbType = RepositoryDbContext.EventInTypes.Where(item => item.EventId == entity.Id).ToList(); RepositoryDbContext.RemoveRange(dbType); return(EventMapper.MapFromDomain(RepositoryDbSet.Update(EventMapper.MapFromDAL(entity)).Entity)); }