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