public ResolverGroupTypeRefData InsertorUpdate(string typeName)
{
var resolverGroupType = _resolverGroupTypeRefDataRepository.Query(x => x.ResolverGroupTypeName == typeName.Trim()).FirstOrDefault();
if (resolverGroupType == null)
{
resolverGroupType = new ResolverGroupTypeRefData
{
ResolverGroupTypeName = typeName.Trim(),
SortOrder = 5,
Visible = false
};
_resolverGroupTypeRefDataRepository.Insert(resolverGroupType);
_unitOfWork.Save();
}
else
{
var customerSpecificTypeThreshold = _parameterService.GetParameterByNameAndCache <int>(ParameterNames.CustomerSpecificTypeThreshold);
if (!resolverGroupType.Visible &&
GetNumberOfResolverGroupTypeReferences(resolverGroupType.Id) >= customerSpecificTypeThreshold - 1)
{
resolverGroupType.Visible = true;
_resolverGroupTypeRefDataRepository.Update(resolverGroupType);
_unitOfWork.Save();
}
}
return(resolverGroupType);
}
public void ResolverGroupTypeRefDataService_Update_CallSaveChanges()
{
#region Arrange
var component = new ResolverGroupTypeRefData
{
Id = 4,
ResolverGroupTypeName = "Resolver MJJ",
};
#endregion
#region Act
_resolverGroupTypeRefDataService.Update(component);
#endregion
#region Assert
_mockResolverGroupTypeRefDataRepository.Verify(x => x.Update(It.IsAny <ResolverGroupTypeRefData>()), Times.Once());
_mockUnitOfWork.Verify(x => x.Save(), Times.Exactly(1));
#endregion
}
public void ResolverGroupTypeRefDataService_Create_CallSaveChanges()
{
#region Arrange
var resolverGroup = new ResolverGroupTypeRefData
{
Id = 5,
ResolverGroupTypeName = "Resolver MJJ",
SortOrder = 5
};
#endregion
#region Act
var response = _resolverGroupTypeRefDataService.Create(resolverGroup);
#endregion
#region Assert
_mockResolverGroupTypeRefDataRepository.Verify(x => x.Insert(It.IsAny <ResolverGroupTypeRefData>()), Times.Once());
_mockUnitOfWork.Verify(x => x.Save(), Times.Exactly(1));
Assert.IsNotNull(response);
Assert.AreEqual(5, response);
#endregion
}
public void Delete(ResolverGroupTypeRefData entity)
{
RetryableOperation.Invoke(ExceptionPolicies.General, () =>
{
_resolverGroupTypeRefDataRepository.Delete(entity);
_unitOfWork.Save();
});
}
public int Create(ResolverGroupTypeRefData entity)
{
RetryableOperation.Invoke(ExceptionPolicies.General, () =>
{
_resolverGroupTypeRefDataRepository.Insert(entity);
_unitOfWork.Save();
});
return(entity.Id);
}
public ResolverGroupTypeRefData GetById(int id)
{
ResolverGroupTypeRefData result = null;
RetryableOperation.Invoke(ExceptionPolicies.General, () =>
{
result = _resolverGroupTypeRefDataRepository.GetById(id);
});
return(result);
}
public void ResolverGroupTypeRefDataService_Delete_CallSaveChanges()
{
#region Arrange
var resolverGroup = new ResolverGroupTypeRefData
{
Id = 4,
};
#endregion
#region Act
_resolverGroupTypeRefDataService.Delete(resolverGroup);
#endregion
#region Assert
_mockResolverGroupTypeRefDataRepository.Verify(x => x.Delete(It.IsAny <ResolverGroupTypeRefData>()), Times.Once());
_mockUnitOfWork.Verify(x => x.Save(), Times.Exactly(1));
#endregion
}
public void Execute()
{
foreach (var resolver in _resolvers)
{
int sqlResult;
using (var sourceDbContext = new SLMDataContext("Name=SLMSourceDataContext"))
{
sqlResult = sourceDbContext.Database.SqlQuery <int>($"SELECT Count(*) FROM RESOLVER WHERE Id = {resolver.Id} AND ServiceComponent_Id IS NULL").FirstOrDefault();
}
if (sqlResult > 0)
{
if (resolver.ServiceDeliveryUnitType != null)
{
if (!_dataContext.ServiceDeliveryUnitTypeRefData.Any(x => x.ServiceDeliveryUnitTypeName == resolver.ServiceDeliveryUnitType.ServiceDeliveryUnitTypeName))
{
var serviceDeliveryUnitType = new ServiceDeliveryUnitTypeRefData
{
ServiceDeliveryUnitTypeName = resolver.ServiceDeliveryUnitType.ServiceDeliveryUnitTypeName,
SortOrder = resolver.ServiceDeliveryUnitType.SortOrder,
Visible = resolver.ServiceDeliveryUnitType.Visible
};
_dataContext.ServiceDeliveryUnitTypeRefData.Add(serviceDeliveryUnitType);
_unitOfWork.Save();
}
}
if (resolver.ResolverGroupType != null)
{
if (!_dataContext.ResolverGroupTypeRefData.Any(x => x.ResolverGroupTypeName == resolver.ResolverGroupType.ResolverGroupTypeName))
{
var resolverGroupType = new ResolverGroupTypeRefData
{
ResolverGroupTypeName = resolver.ResolverGroupType.ResolverGroupTypeName,
SortOrder = resolver.ResolverGroupType.SortOrder,
Visible = resolver.ResolverGroupType.Visible
};
_dataContext.ResolverGroupTypeRefData.Add(resolverGroupType);
_unitOfWork.Save();
}
}
var newResolver = new Resolver
{
ServiceDesk = _serviceDesk,
ServiceDeskId = _serviceDesk.Id,
ServiceDeliveryOrganisationType = _dataContext.ServiceDeliveryOrganisationTypeRefData.Single(x => x.ServiceDeliveryOrganisationTypeName == resolver.ServiceDeliveryOrganisationType.ServiceDeliveryOrganisationTypeName),
ServiceDeliveryOrganisationNotes = resolver.ServiceDeliveryOrganisationNotes,
ServiceDeliveryUnitNotes = resolver.ServiceDeliveryUnitNotes,
ServiceDeliveryUnitType = resolver.ServiceDeliveryUnitType != null?_dataContext.ServiceDeliveryUnitTypeRefData.Single(x => x.ServiceDeliveryUnitTypeName == resolver.ServiceDeliveryUnitType.ServiceDeliveryUnitTypeName) : null,
ResolverGroupType = resolver.ResolverGroupType != null?_dataContext.ResolverGroupTypeRefData.Single(x => x.ResolverGroupTypeName == resolver.ResolverGroupType.ResolverGroupTypeName) : null,
InsertedBy = resolver.InsertedBy,
InsertedDate = resolver.InsertedDate,
UpdatedBy = resolver.UpdatedBy,
UpdatedDate = resolver.UpdatedDate
};
_serviceDesk.Resolvers.Add(newResolver);
_unitOfWork.Save();
}
}
}
public void Execute()
{
if (_serviceComponent.Resolver.ServiceDeliveryUnitType != null)
{
if (!_dataContext.ServiceDeliveryUnitTypeRefData.Any(x => x.ServiceDeliveryUnitTypeName == _serviceComponent.Resolver.ServiceDeliveryUnitType.ServiceDeliveryUnitTypeName))
{
var serviceDeliveryUnitType = new ServiceDeliveryUnitTypeRefData
{
ServiceDeliveryUnitTypeName = _serviceComponent.Resolver.ServiceDeliveryUnitType.ServiceDeliveryUnitTypeName,
SortOrder = _serviceComponent.Resolver.ServiceDeliveryUnitType.SortOrder,
Visible = _serviceComponent.Resolver.ServiceDeliveryUnitType.Visible
};
_dataContext.ServiceDeliveryUnitTypeRefData.Add(serviceDeliveryUnitType);
_unitOfWork.Save();
}
}
if (_serviceComponent.Resolver.ResolverGroupType != null)
{
if (!_dataContext.ResolverGroupTypeRefData.Any(x => x.ResolverGroupTypeName == _serviceComponent.Resolver.ResolverGroupType.ResolverGroupTypeName))
{
var resolverGroupType = new ResolverGroupTypeRefData
{
ResolverGroupTypeName = _serviceComponent.Resolver.ResolverGroupType.ResolverGroupTypeName,
SortOrder = _serviceComponent.Resolver.ResolverGroupType.SortOrder,
Visible = _serviceComponent.Resolver.ResolverGroupType.Visible
};
_dataContext.ResolverGroupTypeRefData.Add(resolverGroupType);
_unitOfWork.Save();
}
}
var newResolver = new Resolver
{
ServiceDesk = _serviceDesk,
ServiceDeskId = _serviceDesk.Id,
ServiceComponent = _targetServiceComponent,
ServiceDeliveryOrganisationType = _dataContext.ServiceDeliveryOrganisationTypeRefData.Single(x => x.ServiceDeliveryOrganisationTypeName == _serviceComponent.Resolver.ServiceDeliveryOrganisationType.ServiceDeliveryOrganisationTypeName),
ServiceDeliveryOrganisationNotes = _serviceComponent.Resolver.ServiceDeliveryOrganisationNotes,
ServiceDeliveryUnitNotes = _serviceComponent.Resolver.ServiceDeliveryUnitNotes,
ServiceDeliveryUnitType = _serviceComponent.Resolver.ServiceDeliveryUnitType != null?_dataContext.ServiceDeliveryUnitTypeRefData.Single(x => x.ServiceDeliveryUnitTypeName == _serviceComponent.Resolver.ServiceDeliveryUnitType.ServiceDeliveryUnitTypeName) : null,
ResolverGroupType = _serviceComponent.Resolver.ResolverGroupType != null?_dataContext.ResolverGroupTypeRefData.Single(x => x.ResolverGroupTypeName == _serviceComponent.Resolver.ResolverGroupType.ResolverGroupTypeName) : null,
OperationalProcessTypes = new List <OperationalProcessType>(),
InsertedBy = _serviceComponent.Resolver.InsertedBy,
InsertedDate = _serviceComponent.Resolver.InsertedDate,
UpdatedBy = _serviceComponent.Resolver.UpdatedBy,
UpdatedDate = _serviceComponent.Resolver.UpdatedDate
};
_targetServiceComponent.Resolver = newResolver;
_unitOfWork.Save();
if (_serviceComponent.Resolver.OperationalProcessTypes != null && _serviceComponent.Resolver.OperationalProcessTypes.Any())
{
var operationalProcessTypeProcessor = new OperationalProcessTypeProcessor(newResolver, _serviceComponent.Resolver.OperationalProcessTypes, _dataContext, _unitOfWork);
operationalProcessTypeProcessor.Execute();
}
}
