private LookupItem[] ReadLookupFromDb(string lookupTableName)
{
return(DataVaultCommand.ReadOnlyStoredProcedure(DataSession, nameof(ReadLookup))
.WithParameter("LOOKUP_TABLE", EntityHelper.NormalizeTableName(lookupTableName))
.WithParameter("CODE", string.Empty) // TODO
.ExecuteWithErrorHandling <LookupItem[]>());
}
public void DeleteRecord <TEntity>(string hubPk) where TEntity : IDvHubEntity
{
string stpName = nameof(DeleteRecord) + EntityHelper.GetEntityName <TEntity>();
DataVaultCommand.UpdateStoredProcedure(DataSession, _auditContext, stpName)
.WithHubPk(hubPk)
.Execute();
}
public void UnLinkRecord <TEntity>(string linkPk) where TEntity : IDvLinkEntity
{
string stpName = nameof(UnLinkRecord) + EntityHelper.GetEntityName <TEntity>();
DataVaultCommand.UpdateStoredProcedure(DataSession, _auditContext, stpName)
.WithLinkPk(linkPk)
.Execute();
}
public void UpdateLink <TEntity>(string linkPk, object satData) where TEntity : IDvLinkEntity
{
string stpName = nameof(UpdateLink) + EntityHelper.GetEntityName <TEntity>();
DataVaultCommand.UpdateStoredProcedure(DataSession, _auditContext, stpName)
.WithLinkPk(linkPk)
.WithSatData(satData)
.Execute();
}
public string LinkRecord <TEntity>(object foreignKeys, object satData) where TEntity : IDvLinkEntity
{
string stpName = nameof(LinkRecord) + EntityHelper.GetEntityName <TEntity>();
return(DataVaultCommand.UpdateStoredProcedure(DataSession, _auditContext, stpName)
.WithForeignKeys(foreignKeys ?? new { })
.WithSatData(satData)
.ExecuteWithErrorHandling());
}
public string CreateRecord <TEntity>(object hubData, object satData) where TEntity : IDvHubEntity
{
string stpName = nameof(CreateRecord) + EntityHelper.GetEntityName <TEntity>();
return(DataVaultCommand.UpdateStoredProcedure(DataSession, _auditContext, stpName)
.WithHubData(hubData ?? new { })
.WithSatData(satData)
.ExecuteWithErrorHandling());
}
public TEntity ReadRecord <TEntity>(object hubData, object satData) where TEntity : IDvHubEntity
{
string stpName = nameof(ReadRecord) + EntityHelper.GetEntityName <TEntity>();
return(DataVaultCommand.ReadOnlyStoredProcedure(DataSession, stpName)
.WithHubData(hubData)
.WithSatData(satData ?? new[] { "*" })
.ExecuteWithErrorHandling <TEntity>());
}
public TEntity[] ReadView <TEntity>(string viewName, object satQuery) where TEntity : IDvEntity
{
string stpName = nameof(ReadView) + viewName;
return(DataVaultCommand.ReadOnlyStoredProcedure(DataSession, stpName)
.WithSatQuery(satQuery)
.ExecuteWithErrorHandling <TEntity[]>()
?? Array.Empty <TEntity>());
}
public TEntity[] ReadLinks <TEntity>(object satQuery) where TEntity : IDvLinkEntity
{
string stpName = nameof(ReadLinks) + EntityHelper.GetEntityName <TEntity>();
return(DataVaultCommand.ReadOnlyStoredProcedure(DataSession, stpName)
.WithSatQuery(satQuery)
.ExecuteWithErrorHandling <TEntity[]>()
?? Array.Empty <TEntity>());
}
internal static DataVaultCommand ReadOnlyStoredProcedure(IDataSession dataSession, string stpName)
{
var dataVaultCommandBuilder = new DataVaultCommand(dataSession.StoredProcedure(stpName));
dataVaultCommandBuilder.DataCommand
.ParameterOut <string>(DataVaultParams.StatusCode, p => dataVaultCommandBuilder.DataVaultResult.StatusCode = p.ToEnumOrDefault(DataVaultBusinessErrorCode.Failed))
.ParameterOut <string>(DataVaultParams.Result, p => dataVaultCommandBuilder.DataVaultResult.JsonResult = p);
return(dataVaultCommandBuilder);
}
public string UpdateRecord <TEntity>(string hubPk, object satData) where TEntity : IDvHubEntity
{
var validSatData = JObject.FromObject(satData)
.PropertyValues()
.Any(value => !value.IsNullOrEmpty());
if (!validSatData)
{
return(hubPk);
}
string stpName = nameof(UpdateRecord) + EntityHelper.GetEntityName <TEntity>();
return(DataVaultCommand.UpdateStoredProcedure(DataSession, _auditContext, stpName)
.WithHubPk(hubPk)
.WithSatData(satData)
.ExecuteWithErrorHandling());
}
public LookupItem[] ReadLookups()
{
return(DataVaultCommand.ReadOnlyStoredProcedure(DataSession, nameof(ReadLookups))
.ExecuteWithErrorHandling <LookupItem[]>());
}
