public async void SaveIOLog(string action, string actionDescription, Guid id) { bool ioLogSwitch = Convert.ToBoolean(AppSettings.Configuration["EnableInspectionOrderLogs"]); if (ioLogSwitch) { var inspectionOrder = await this.RetrieveIO(id); this.UpdateInspectionOrder(inspectionOrder); string ioString = Utils.SerializeObjectToJson(inspectionOrder); var currentUser = this.context.GetCurrentUser(); var user = _accountRepository.Retrieve(currentUser); InspectionOrderLogs inspectionOrderLogs = new InspectionOrderLogs { InspectionOrderJsonData = ioString, Action = action, ActionDescription = actionDescription, DateCreated = DateTime.Now, InspectionOrderId = id, CreatedById = user.Id }; context.Set <InspectionOrderLogs>().Add(inspectionOrderLogs); context.SaveChanges(); } }
public TEntity Create(TEntity entity) { Context.Set <TEntity>().Add(entity); Context.SaveChanges(); return(entity); }
public RetrieveResult <InspectionOrderWildfireAssessmentChildMitigationRecommendations> RetrieveView(DataSourceRequest request, Guid mitigationRecommendationsId) { var dbSet = context.Set <InspectionOrderWildfireAssessmentChildMitigationRecommendations>() .Include(a => a.Image) .Include(a => a.User) .Where(a => a.IoWaParentMitigationRecommendationsId == mitigationRecommendationsId) .OrderBy(a => a.Image.CreatedAt); return(Retrieve(dbSet, request)); }
public RetrieveResult <WildfireAssessmentMitigationRecommendationsViewModel> RetrieveView(DataSourceRequest request, Guid mitigationRecommendationId) { var dbSet = context.Set <InspectionOrderWildfireAssessmentMitigationRecommendations>() .Include(a => a.Image) .Where(a => a.InspectionOrderWildfireAssessmentMitigation.Id == mitigationRecommendationId) .OrderBy(a => a.Image.CreatedAt); var resultList = Retrieve(dbSet, request); var mitigationList = new RetrieveResult <WildfireAssessmentMitigationRecommendationsViewModel>(); mitigationList.PageNo = resultList.PageNo; mitigationList.SortBy = resultList.SortBy; mitigationList.RecordPage = resultList.RecordPage; mitigationList.TotalRecords = resultList.TotalRecords; mitigationList.Results = resultList.Results.Select(mitigation => new WildfireAssessmentMitigationRecommendationsViewModel { InspectionOrderWildfireAssessmentMitigationId = mitigation.InspectionOrderWildfireAssessmentMitigationId, InspectionOrderWildfireAssessmentMitigation = mitigation.InspectionOrderWildfireAssessmentMitigation, Id = mitigation.Id, Description = mitigation.Description, ImageId = mitigation.ImageId, Image = mitigation.Image, ChildMitigation = mitigation.ChildMitigation, ChildMitigationCount = _inspectionOrderWildfireAssessmentChildMitigationRecommendationsRepository.childMitigationCount(mitigation.Id), Status = mitigation.Status }).ToList(); return(mitigationList); }
public IQueryable <InspectionStatusGroupingsView> Retrieve(string Inspector) { if (String.IsNullOrWhiteSpace(Inspector)) { return(context.Set <InspectionStatus>().OrderBy(x => x.SortOrder).AsQueryable().Select( list => new InspectionStatusGroupingsView { StatusId = list.Id, Status = list.Name, ZeroToNineteenDays = _inspectionOrderRepository.RetrieveIOView() .Count(io => io.DateDifference == DateDifferenceConstants.ZeroToNineteenDays && io.StatusId == list.Id), TwentyToThirtyNineDays = _inspectionOrderRepository.RetrieveIOView() .Count(io => io.DateDifference == DateDifferenceConstants.TwentyToThirtyNineDays && io.StatusId == list.Id), FortyToFiftyNineDays = _inspectionOrderRepository.RetrieveIOView() .Count(io => io.DateDifference == DateDifferenceConstants.FortyToFiftyNineDays && io.StatusId == list.Id) })); } else { return(context.Set <InspectionStatus>().OrderBy(x => x.SortOrder).AsQueryable().Select( list => new InspectionStatusGroupingsView { StatusId = list.Id, Status = list.Name, ZeroToNineteenDays = _inspectionOrderRepository.RetrieveIOView() .Count(io => io.Username == Inspector && io.DateDifference == DateDifferenceConstants.ZeroToNineteenDays && io.StatusId == list.Id), TwentyToThirtyNineDays = _inspectionOrderRepository.RetrieveIOView() .Count(io => io.Username == Inspector && io.DateDifference == DateDifferenceConstants.TwentyToThirtyNineDays && io.StatusId == list.Id), FortyToFiftyNineDays = _inspectionOrderRepository.RetrieveIOView() .Count(io => io.Username == Inspector && io.DateDifference == DateDifferenceConstants.FortyToFiftyNineDays && io.StatusId == list.Id) })); } }
public void CreateUser(ApplicationUser user) { context.Set <ApplicationUser>().Add(user); context.SaveChanges(); }
public RetrieveResult <InspectionOrderNotesView> RetrieveView(DataSourceRequest request, Guid orderId) { var dbSet = context.Set <InspectionOrderNotesView>().Where(a => a.InspectionOrderId == orderId); return(Retrieve(dbSet, request)); }
public IQueryable <TEntity> Retrieve <TEntity>() where TEntity : class { return(context.Set <TEntity>().AsNoTracking()); }
public Image InsertOrUpdateWildfireAssessmentMitigationRequirement(InspectionOrder ioFromClient) { var existingIo = Context.Set <InspectionOrder>() .Include(x => x.WildfireAssessment) .ThenInclude(x => x.Mitigation) .ThenInclude(x => x.Requirements) .SingleOrDefault(x => x.Id.Equals(ioFromClient.Id)); if (existingIo == null) { throw new Exception("Inspection Order not found."); } var wildfireAssessment = existingIo.WildfireAssessment; if (wildfireAssessment == null) { wildfireAssessment = new InspectionOrderWildfireAssessment { Id = ioFromClient.Id }; context.Entry(wildfireAssessment).State = EntityState.Added; } var mitigation = wildfireAssessment.Mitigation; if (mitigation == null) { mitigation = new InspectionOrderWildfireAssessmentMitigation { Id = ioFromClient.Id }; context.Entry(mitigation).State = EntityState.Added; } if (mitigation.Requirements == null) { mitigation.Requirements = new List <InspectionOrderWildfireAssessmentMitigationRequirements>(); } var pmFromClient = ioFromClient.WildfireAssessment.Mitigation.Requirements.First(); pmFromClient.InspectionOrderWildfireAssessmentMitigationId = mitigation.Id; var requirementsDbSet = context.Set <InspectionOrderWildfireAssessmentMitigationRequirements>(); var imageFromClient = pmFromClient.Image; var isAdd = (imageFromClient.Id == Guid.Empty); var newId = Guid.NewGuid(); if (isAdd) { imageFromClient.Id = newId; _imageService.UpdateImageFile(imageFromClient, newId); pmFromClient.Image = imageFromClient; requirementsDbSet.Add(pmFromClient); context.SaveChanges(); return(pmFromClient.Image); } else // update { var existingPm = requirementsDbSet.SingleOrDefault( w => w.InspectionOrderWildfireAssessmentMitigationId == pmFromClient.InspectionOrderWildfireAssessmentMitigationId && w.ImageId == imageFromClient.Id); if (existingPm == null) { throw new Exception("Image not found."); } context.Entry(existingPm).CurrentValues.SetValues(pmFromClient); // this means that the image file from the client has changed if (imageFromClient.File != null) { _imageService.UpdateImageFile(imageFromClient, newId); var existingImage = _imageRepository.Retrieve(existingPm.ImageId); context.Entry(existingImage).CurrentValues.SetValues(imageFromClient); try { context.SaveChanges(); _imageService.DeleteImageFileInDisk(existingPm.Image.FilePath); _imageService.DeleteImageFileInDisk(existingPm.Image.ThumbnailPath); return(existingPm.Image); } catch (Exception e) { } } else { context.SaveChanges(); } return(imageFromClient); } }
public ApplicationRole RetrieveByName(string roleName) { return(_context.Set <ApplicationRole>().AsNoTracking().SingleOrDefault(x => x.NormalizedName.Equals(roleName.ToUpper()))); }
public void AddRoleToUser(ApplicationUserRole userRole) { context.Set <ApplicationUserRole>().Add(userRole); context.SaveChanges(); }