public static DataSet GetChildren(TaskAlgorithmDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.TaskAlgorithmChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, TaskAlgorithmDataModel.DataColumns.TaskAlgorithmId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return oDT.DBDataset;
}
public static DataSet GetChildren(RunTimeFeatureDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.RunTimeFeatureChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, RunTimeFeatureDataModel.DataColumns.RunTimeFeatureId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet GetChildren(ApplicationEntityParentalHierarchyDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationEntityParentalHierarchyChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ApplicationEntityParentalHierarchyDataModel.DataColumns.ApplicationEntityParentalHierarchyId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet GetChildren(SystemForeignRelationshipTypeDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.SystemForeignRelationshipTypeChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, SystemForeignRelationshipTypeDataModel.DataColumns.SystemForeignRelationshipTypeId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet GetChildren(UseCaseWorkFlowCategoryDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.UseCaseWorkFlowCategoryChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, UseCaseWorkFlowCategoryDataModel.DataColumns.UseCaseWorkFlowCategoryId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet GetChildren(FunctionalityActiveStatusDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FunctionalityActiveStatusChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet GetChildren(NotificationSubscriberDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.NotificationSubscriberChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, NotificationSubscriberDataModel.DataColumns.NotificationSubscriberId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet GetChildren(ProjectPortfolioGroupDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ProjectPortfolioGroupChildrenGet" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ProjectPortfolioGroupDataModel.DataColumns.ProjectPortfolioGroupId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
static private DataSet GetChildren(Data data, int auditId)
{
var sql = "EXEC dbo.ApplicationUserChildrenGet " +
" " + BaseColumns.ToSQLParameter(BaseColumns.AuditId, auditId) +
", " + data.ToSQLParameter(DataColumns.ApplicationUserId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
private static DataSet GetChildren(DataModel.Framework.Core.ApplicationRouteDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationRouteChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, DataModel.Framework.Core.ApplicationRouteDataModel.DataColumns.ApplicationRouteId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
static public DataSet DeleteChildren(ApplicationDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationChildrenDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ApplicationDataModel.DataColumns.ApplicationId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Delete Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
private static DataSet GetChildren(FunctionalityImageXFunctionalityImageAttributeDataModel data, int auditId)
{
var sql = "EXEC dbo.FunctionalityImageXFunctionalityImageAttributeChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, FunctionalityImageXFunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageXFunctionalityImageAttributeId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
private static DataSet GetChildren(DomainModel.FieldConfigurationModeAccessMode data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeXApplicationRoleChildrenGet " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeAccessMode.DataColumns.FieldConfigurationModeAccessModeId);
var oDT = new Framework.Components.DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public void GetData(string sql, string connectionKey)
{
var formattedSQL = FormatSQL(sql, connectionKey);
Log4Net.SqlStatementStack.Push(new Log4Net.SqlStatementStackMessage(formattedSQL));
Log4Net.LogDebug(formattedSQL, connectionKey);
var connectionString = StartUp.GetConnectionString(connectionKey);
DBTable = new DataTable();
using (var connection = new SqlConnection(connectionString))
{
//var conn = new ProfiledDbConnection(connection, MiniProfiler.Current)
var dbCommand = new SqlCommand(sql, connection);
dbCommand.CommandTimeout = StartUp.TimeOut;
var dbAdapter = new SqlDataAdapter(dbCommand);
//var prdataAdapter = new ProfiledDbDataAdapter(DBAdapter);
DBTable.BeginLoadData();
dbAdapter.Fill(DBTable);
DBTable.EndLoadData();
DBTable.CaseSensitive = false;
connection.Close();
}
DBDataSet.LogResultCount(DBTable);
#region log exception
if (!sql.StartsWith("exec AuditDetailInsert") && !sql.StartsWith("exec AuditSummaryUpdate") && !sql.StartsWith("exec AuditSummaryInsert"))
{
DBDataReader.MessageLog("SQL: " + formattedSQL);
}
#endregion log exception
}