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();
}