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 }