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());
}
