internal List <MonitoringNotificationJobSettingsEntity> GetMonitoringExportJobSettings() { List <MonitoringNotificationJobSettingsEntity> results = new List <MonitoringNotificationJobSettingsEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetMonitoringExportJobSettings"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new MonitoringNotificationJobSettingsAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }
internal List <MonitoringNotificationJobSettingsEntity> GetMonitoringExportJobSettingsByUserId(int?UserId, int ApplicationId) { List <MonitoringNotificationJobSettingsEntity> results = new List <MonitoringNotificationJobSettingsEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "capp.GetMonitoringExportJobSettingsByUserId"; // MP-846 Admin database cleanup and code cleanup. sproc.StoredProceduresParameter.Add(GetParam("@UserId", !string.IsNullOrEmpty(Convert.ToString(UserId)) ? UserId.ToString() : null, SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@ApplicationId", ApplicationId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new MonitoringNotificationJobSettingsAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }