private void btnClearCache_Click(object sender, EventArgs e)
{
int successCount = 0;
this.Cursor = Cursors.WaitCursor;
foreach (ListViewItem item in lvwDataSources.CheckedItems)
{
Data.ExternalSystem selectedDataSource = item.Tag as Data.ExternalSystem;
try
{
ServiceCommunicator.ClearDataSource(selectedDataSource.ExternalSystemId, selectedDataSource.ExternalSystemName);
successCount++;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
this.Cursor = Cursors.Default;
if (successCount == lvwDataSources.CheckedItems.Count)
{
MessageBox.Show("Success!", "Cache Cleared", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if ((successCount == 0) &&
(lvwDataSources.CheckedItems.Count > 0))
{
MessageBox.Show("All Failed!", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Partially Failed!", "Partially Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public BindingList <ExternalSystem> GetAllExternalSystems(bool?onlySystemType)
{
List <ExternalSystem> returnList = new List <ExternalSystem>();
string commandText = string.Empty;
if (onlySystemType == null) //get all
{
commandText = "select [Id],[Name],[IsSystem] from IdpeDataSource order by [Id], [IsSystem] desc";
}
else
{
commandText = "select [Id],[Name],[IsSystem] from IdpeDataSource where [IsSystem] = " + (onlySystemType == true ? "1" : "0") + " order by [Id], [IsSystem] desc";
}
DataTable table = CoreDatabaseObjects.Instance.ExecuteCommand(commandText);
if (table == null)
{
return(new BindingList <ExternalSystem>(returnList));
}
foreach (DataRow row in table.Rows)
{
ExternalSystem es = new ExternalSystem();
es.ExternalSystemId = (int)row["Id"].ToString().ParseInt();
es.ExternalSystemName = row["Name"] != DBNull.Value ? row["Name"].ToString() : null;
es.IsSystemType = (bool)row["IsSystem"].ToString().ParseBool();
es.IsHavingVersion = IsHavingVersion(VersionObjectTypes.DataSource, es.ExternalSystemId);
returnList.Add(es);
}
return(new BindingList <ExternalSystem>(returnList));
}
