/// <summary>
/// Loads export histories list.
/// </summary>
private void LoadExportHistories()
{
lstExports.Items.Clear();
string where = null;
int siteId = ValidationHelper.GetInteger(siteSelector.Value, 0);
if (siteId != 0)
{
where += "ExportSiteID=" + siteSelector.Value;
}
else
{
where += "ExportSiteID IS NULL";
}
DataSet ds = ExportHistoryInfoProvider.GetExportHistories(where, "ExportDateTime DESC", "ExportDateTime,ExportFileName,ExportID", 0);
if (!DataHelper.DataSourceIsEmpty(ds))
{
radExport.Enabled = true;
foreach (DataRow dr in ds.Tables[0].Rows)
{
lstExports.Items.Add(new ListItem(ValidationHelper.GetString(dr["ExportDateTime"], "yyyy-mm-ddd") + " - " + ValidationHelper.GetString(dr["ExportFileName"], "filename"), ValidationHelper.GetString(dr["ExportID"], null)));
}
}
}
/// <summary>
/// Loads export histories list.
/// </summary>
private void LoadExportHistories()
{
lstExports.Items.Clear();
var where = new WhereCondition();
int siteId = ValidationHelper.GetInteger(siteSelector.Value, 0);
if (siteId != 0)
{
where.Where("ExportSiteID", QueryOperator.Equals, siteSelector.Value);
}
else
{
where.WhereNull("ExportSiteID");
}
var histories = ExportHistoryInfoProvider.GetExportHistories()
.Where(where)
.OrderByDescending("ExportDateTime")
.Columns(new[] { "ExportDateTime", "ExportFileName", "ExportID" });
if (DataHelper.DataSourceIsEmpty(histories))
{
return;
}
radExport.Enabled = true;
foreach (DataRow dr in histories.Tables[0].Rows)
{
lstExports.Items.Add(new ListItem(ValidationHelper.GetString(dr["ExportDateTime"], "yyyy-mm-ddd") + " - " + ValidationHelper.GetString(dr["ExportFileName"], "filename"), ValidationHelper.GetString(dr["ExportID"], null)));
}
}
