public override List<string> getAllDataBases()
{
connect();
DataTable databases = null;
try
{
using (sqlConnection)
{
sqlConnection.Open();
databases = sqlConnection.GetSchema("Databases");
sqlConnection.Close();
}
}
catch (SqlException ex)
{
System.Windows.MessageBox.Show(ex.ToString());
}
List<string> data = new List<string>();
if (databases != null)
{
foreach (DataRow row in databases.Rows)
{
data.Add(row.ItemArray[0].ToString());
}
}
data.Remove("master");
data.Remove("model");
data.Remove("msdb");
data.Remove("tempdb");
return data;
}
public override List<string> getAllDataBases()
{
connect();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "SHOW DATABASES;";
//========================================================
MySqlDataReader Reader;
List<string> data = new List<string>();
try
{
Reader = command.ExecuteReader();
while (Reader.Read())
{
//добавление баз данных всех
data.Add(Reader.GetValue(0).ToString());
}
disconnect();
}
catch (MySqlException ex)
{
System.Windows.MessageBox.Show(ex.ToString());
}
data.Remove("information_schema");
data.Remove("performance_schema");
data.Remove("mysql");
return data;
}
/// <summary>
/// Back, pop_back
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
private static IUndoRedoCommand _Pop(List<IUndoRedoCommand> list)
{
// 最後に追加したコマンドの取得
var command = list.Last();
// コマンドをリストから削除
list.Remove(command);
return command;
}
/// <summary>
/// push_back, pop_front
/// </summary>
/// <param name="list"></param>
/// <param name="command"></param>
private static void _PushAndPopFront(List<IUndoRedoCommand> list, IUndoRedoCommand command)
{
// 最後にコマンドを追加
list.Add(command);
// 最初のコマンドを削除
list.Remove(list.First());
}
private void selectedCellsChangedHandler(object param = null)
{
IEnumerable<object> selected = param as IEnumerable<object>;
var selectedDataItems = selected.Cast<DataItemViewModel>().ToList();
// Clone the SelectedEntries
List<DataItemViewModel> clonedSelectedEntries = new List<DataItemViewModel>(selectedDataItems);
// keep the previous entry that is part of the selection
DataItemViewModel previousSelectedItem = null;
// Keep the previous entry that is in the list
DataItemViewModel previousItem = null;
// build list backwards so that diffs happen in order going up
int viewCount = Data.Count;
for (int i = viewCount - 1; i >= 0; i--)
{
// Get current item in the list
var currentItem = Data[i] as DataItemViewModel;
// If the item is part of the selection we will want some kind of diff
if (clonedSelectedEntries.Contains(currentItem))
{
// If the previous selected item is null
// this means that it is the bottom most item in the selection
// and compare it to the previous non selected string
if (previousSelectedItem != null)
{
currentItem.PrevName = previousSelectedItem.Name;
currentItem.IsVisualDiffVisible = true;
}
else if (previousItem != null) // if there is a previous selected item compare the item with that one
{
currentItem.PrevName = previousItem.Name;
currentItem.IsVisualDiffVisible = true;
}
else //the selected item is the bottom item with nothing else to compare, so just show differences from an empty string
{
currentItem.PrevName = String.Empty;
currentItem.IsVisualDiffVisible = true;
}
// Set the previously selected item to the current item to keep for comparison with the next selected item on the way up
previousSelectedItem = currentItem;
// clean up
clonedSelectedEntries.Remove(currentItem);
}
else // if item is not part of the selection we will want the original text
{
currentItem.PrevName = String.Empty;
currentItem.IsVisualDiffVisible = false;
}
// regardless of whether item is in selection or not we keep it as the previous item when we move up to the next one
previousItem = currentItem;
}
}
