private static DataSet GetChildren(TaskScheduleDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskScheduleChildrenGet " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TaskScheduleDataModel.DataColumns.TaskScheduleId); var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey); return(oDT.DBDataset); }
private static DataSet GetChildren(ApplicationMonitoredEventProcessingStateDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.ApplicationMonitoredEventProcessingStateChildrenGet " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, ApplicationMonitoredEventProcessingStateDataModel.DataColumns.ApplicationMonitoredEventProcessingStateId); var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey); return(oDT.DBDataset); }
private static DataSet GetChildren(Data data, int auditId) { var sql = "EXEC dbo.UserPreferenceDataTypeChildrenGet " + " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) + ", " + data.ToSQLParameter(DataColumns.UserPreferenceDataTypeId); var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey); return(oDT.DBDataset); }