internal List <ExportJobSettingsEntity> GetExportJobSettings() { List <ExportJobSettingsEntity> results = new List <ExportJobSettingsEntity>(); 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 ExportJobSettingsAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }
internal List <ExportJobSettingsEntity> GetPurgeExportedFiles() { List <ExportJobSettingsEntity> results = new List <ExportJobSettingsEntity>(); 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 ExportJobSettingsAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }
// Monitor Export Job Queue Details // MP-846 Admin database cleanup and code cleanup.-CLIENT internal ExportJobSettingsEntity GetExportJobSettingsByIdByClient(int Id) { List <ExportJobSettingsEntity> results = new List <ExportJobSettingsEntity>(); 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 ExportJobSettingsAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results.FirstOrDefault()); }
internal List <ExportJobSettingsEntity> GetExportJobSettingsByUserId(string ExportType, int?UserId, int ApplicationId) { List <ExportJobSettingsEntity> results = new List <ExportJobSettingsEntity>(); 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)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new ExportJobSettingsAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }