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