internal void RemoveFolderfromDatabase(FavouriteFolder favFolder)
{
try
{
container = Db4oClient.RecentConn;
FavouriteList favList = FetchAllFavouritesForAConnection();
List <FavouriteFolder> lstFavFolder = favList.lstFavFolder;
bool check = false;
FavouriteFolder temp = null;
foreach (FavouriteFolder str in lstFavFolder)
{
if (str.FolderName.Equals(favFolder.FolderName))
{
temp = str;
check = true;
break;
}
}
if (check == true)
{
lstFavFolder.Remove(temp);
favList.lstFavFolder = lstFavFolder;
container.Delete(temp);
container.Ext().Store(favList, 5);
container.Commit();
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
}
internal void RemoveFavouritFolderForAConnection()
{
try
{
FavouriteList Fav = FetchAllFavouritesForAConnection();
if (Fav != null)
{
for (int i = 0; i < Fav.lstFavFolder.Count; i++)
{
FavouriteFolder favFolder = Fav.lstFavFolder[i];
if (favFolder != null)
{
container.Delete(favFolder);
}
}
Fav.lstFavFolder.Clear();
Fav.m_TimeOfCreation = Sharpen.Runtime.CurrentTimeMillis();
container.Delete(Fav);
container.Ext().Store(Fav, 5);
container.Commit();
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
}
internal FavouriteFolder FindFolderWithClassesByFolderName(string folderName)
{
FavouriteFolder favFolder = null;
try
{
IQuery query = Db4oClient.OMNConnection.Query();
query.Constrain(typeof(FavouriteFolderList));
query.Descend("m_connParam").Descend("m_connection").Constrain(m_connParam.Connection);
IQuery query1 = query.Descend("m_lstFavfolder").Descend("_items");
query1.Constrain(typeof(FavouriteFolder));
query1.Descend("m_folderName").Constrain(folderName);
IObjectSet objSet = query1.Execute();
if (objSet.Count != 0)
{
favFolder = objSet.Next() as FavouriteFolder;
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
finally
{
Db4oClient.CloseRecentConnectionFile();
}
return(favFolder);
}
internal void RenameFolderInDatabase(FavouriteFolder oldFavFolder, FavouriteFolder newFavFolder)
{
try
{
FavouriteFolderList favList = FetchAllFavouritesForAConnection();
if (favList == null)
{
return;
}
foreach (FavouriteFolder str in favList.lstFavFolder.Where(str => str != null && str.FolderName.Equals(oldFavFolder.FolderName)))
{
favList.lstFavFolder.Remove(str);
Db4oClient.OMNConnection.Delete(str);
str.FolderName = newFavFolder.FolderName;
favList.lstFavFolder.Add(str);
Db4oClient.OMNConnection.Store(favList);
Db4oClient.OMNConnection.Commit();
break;
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
finally
{
Db4oClient.CloseRecentConnectionFile();
}
}
private void buttonFavouritesDelete_Click(object sender, RoutedEventArgs e)
{
FavouriteBase item = treeView.SelectedItem as FavouriteBase;
if (item != null)
{
FavouriteFolder parent = FindParent(_rootFolder, item);
if (parent != null)
{
string res = item is FavouriteFolder ? "QUESTIONDELETEFAVOURITEFOLDER" : "QUESTIONDELETEFAVOURITE";
DialogPanel.ShowQuestionBox(CultureHelper.GetString(Properties.Resources.ResourceManager, res),
DialogButtons.Yes | DialogButtons.No,
delegate(DialogResult dialogResult)
{
if (dialogResult == DialogResult.Yes)
{
parent.Children.Remove(item);
}
}
);
}
}
UpdateButtonStates();
}
internal void AddFolderToDatabase(FavouriteFolder favFolder)
{
try
{
container = Db4oClient.RecentConn;
if (m_lstFavfolder != null)
{
FavouriteList favList = FetchAllFavouritesForAConnection();
if (favList == null)
{
favList = new FavouriteList(m_connParam);
List <FavouriteFolder> lstFavfolder = new List <FavouriteFolder>();
favList.m_TimeOfCreation = Sharpen.Runtime.CurrentTimeMillis();
lstFavfolder.Add(favFolder);
container.Store(favList);
container.Commit();
return;
}
container.Activate(favList, 5);
List <FavouriteFolder> lstFavFolder = favList.lstFavFolder;
bool check = false;
FavouriteFolder temp = null;
foreach (FavouriteFolder str in lstFavFolder)
{
if (str != null)
{
if (str.FolderName.Equals(favFolder.FolderName))
{
temp = str;
check = true;
break;
}
}
}
if (check == false)
{
lstFavFolder.Add(favFolder);
}
else
{
lstFavFolder.Remove(temp);
lstFavFolder.Add(favFolder);
container.Delete(temp);
}
favList.lstFavFolder = lstFavFolder;
container.Ext().Store(favList, 5);
container.Commit();
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
}
/// <summary>
/// Default Constructor
/// </summary>
public AbstractCoreLogic()
{
_numItemsToRetrieve = 100;
_searchHistory = new List <SearchDescription>();
_favourites = new FavouriteFolder();
_apiCredentials = new ObservableCollection <ApiCredential>();
_selectedSearchProviders = new List <string>();
_selectedVisualisation = "Network";
_historyItemsToKeep = 50;
_thumbnailCacheSize = 50;
}
internal void AddFolderToDatabase(FavouriteFolder favFolder)
{
try
{
FavouriteFolderList favList = FetchAllFavouritesForAConnection();
if (favList == null)
{
favList = new FavouriteFolderList(m_connParam)
{
TimeOfCreation = Sharpen.Runtime.CurrentTimeMillis()
};
favList.lstFavFolder.Add(favFolder);
Db4oClient.OMNConnection.Store(favList);
Db4oClient.OMNConnection.Commit();
}
else
{
bool check = false;
foreach (
FavouriteFolder str in
favList.lstFavFolder.Where(str => str != null && str.FolderName.Equals(favFolder.FolderName))
)
{
favList.lstFavFolder.Remove(str);
favList.lstFavFolder.Add(favFolder);
Db4oClient.OMNConnection.Delete(str);
check = true;
break;
}
if (!check)
{
favList.lstFavFolder.Add(favFolder);
}
}
Db4oClient.OMNConnection.Store(favList);
Db4oClient.OMNConnection.Commit();
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
finally
{
Db4oClient.CloseRecentConnectionFile();
}
}
protected void FavouritesDeserialise(byte[] data)
{
if (data != null)
{
FavouriteFolder newFavourites = Obany.Language.Xml.XmlHelper.BinaryDeserialize <FavouriteFolder>(data);
if (newFavourites != null)
{
if (newFavourites.Children != null)
{
if (newFavourites.Children.Count > 0)
{
_favourites = newFavourites;
}
}
}
}
}
private FavouriteFolder FindParent(FavouriteFolder favouriteFolder, FavouriteBase favouriteItem)
{
FavouriteFolder foundParent = null;
if (favouriteFolder.Children.Contains(favouriteItem))
{
foundParent = favouriteFolder;
}
else
{
for (int i = 0; i < favouriteFolder.Children.Count && foundParent == null; i++)
{
FavouriteFolder childFolder = favouriteFolder.Children[i] as FavouriteFolder;
if (childFolder != null)
{
foundParent = FindParent(childFolder, favouriteItem);
}
}
}
return(foundParent);
}
internal void RemoveFolderfromDatabase(FavouriteFolder favFolder)
{
try
{
FavouriteFolderList favList = FetchAllFavouritesForAConnection();
foreach (FavouriteFolder str in favList.lstFavFolder.Where(str => str.FolderName.Equals(favFolder.FolderName)))
{
favList.lstFavFolder.Remove(str);
Db4oClient.OMNConnection.Delete(str);
Db4oClient.OMNConnection.Store(favList);
Db4oClient.OMNConnection.Commit();
break;
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
finally
{
Db4oClient.CloseRecentConnectionFile();
}
}
public static void RenameFolderInDatabase(FavouriteFolder oldFav, FavouriteFolder newFav)
{
ManageFavouriteFolder lstFav = new ManageFavouriteFolder(GetCurrentConnParams());
lstFav.RenameFolderInDatabase(oldFav, newFav);
}
public static void SaveFavourite(FavouriteFolder favFolder)
{
ManageFavouriteFolder favouriteList = new ManageFavouriteFolder(GetCurrentConnParams());
favouriteList.AddFolderToDatabase(favFolder);
}
public static void RenameFolderInDatabase(FavouriteFolder oldFav, FavouriteFolder newFav)
{
ManageFavouriteFolder lstFav = new ManageFavouriteFolder(GetCurrentConnParams());
lstFav.RenameFolderInDatabase(oldFav, newFav);
}
public static void UpdateFavourite(FavouriteFolder favFolder)
{
ManageFavouriteFolder favouriteList = new ManageFavouriteFolder(GetCurrentConnParams());
favouriteList.RemoveFolderfromDatabase(favFolder);
}
public static void UpdateFavourite(ConnParams conn, FavouriteFolder FavFolder)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav.RemoveFolderfromDatabase(FavFolder);
}
public static void SaveFavourite(ConnParams conn, FavouriteFolder FavFolder)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav.AddFolderToDatabase(FavFolder);
}
public virtual void AccountEndSession()
{
_favourites = new FavouriteFolder();
_searchHistory = new List <SearchDescription>();
_apiCredentials = new ObservableCollection <ApiCredential>();
}
public static void RenameFolderInDatabase(ConnParams conn, FavouriteFolder oldFav, FavouriteFolder newFav)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav.RenameFolderInDatabase(oldFav, newFav);
}
void treeView_MoveToParent(object newParent, object item, bool addAtStart)
{
FavouriteBase favouriteBase = item as FavouriteBase;
if (favouriteBase != null)
{
FavouriteFolder newFavouriteFolder;
if (newParent == null)
{
newFavouriteFolder = _rootFolder;
}
else
{
newFavouriteFolder = newParent as FavouriteFolder;
}
if (newFavouriteFolder != null)
{
FavouriteFolder originalFavouriteFolder = FindParent(_rootFolder, favouriteBase);
if (originalFavouriteFolder != null)
{
// Only move the item if the folder has really changed
if (originalFavouriteFolder != newFavouriteFolder)
{
originalFavouriteFolder.Children.Remove(favouriteBase);
// If we are adding a folder make sure it comes before any favourites
if (favouriteBase is FavouriteFolder)
{
int foundIdx = -1;
if (favouriteBase is FavouriteFolder && addAtStart)
{
foundIdx = 0;
}
else
{
for (int i = 0; i < newFavouriteFolder.Children.Count && foundIdx == -1; i++)
{
if (newFavouriteFolder.Children[i] is Favourite)
{
foundIdx = i;
}
}
if (foundIdx == -1)
{
foundIdx = newFavouriteFolder.Children.Count;
}
}
newFavouriteFolder.Children.Insert(foundIdx, favouriteBase);
}
else
{
newFavouriteFolder.Children.Add(favouriteBase);
}
}
}
}
}
}
public static void SaveFavourite(FavouriteFolder favFolder)
{
ManageFavouriteFolder favouriteList = new ManageFavouriteFolder(GetCurrentConnParams());
favouriteList.AddFolderToDatabase(favFolder);
}
private void TreeView_OnContextMenuItemClicked(object sender, DBContextItemClickedEventArg e)
{
try
{
queryBuilder = ((ViewBase.GetWindow(Constants.QUERYBUILDER)).Object) as QueryBuilder;
switch (e.Tag.ToString())
{
case Common.Constants.CONTEXT_MENU_SHOW_ALL_OBJECTS:
ShowAllObjects();
break;
case Common.Constants.CONTEXT_MENU_ADD_TO_ATTRIBUTE:
if (queryBuilder != null)
{
AddToAttributeList(queryBuilder.DataGridViewAttributes, (TreeNode)e.Data);
ApplicationObject.ToolWindows.DTE.Windows.Item(Constants.QUERYBUILDER).Activate();
}
break;
case Common.Constants.CONTEXT_MENU_EXPRESSION_GROUP:
string itmName = ((ToolStripItem)e.Item).Name;
char[] splitChar = { '_' };
int lastIndex = itmName.LastIndexOf("_");
int index = Convert.ToInt32(itmName.Split(splitChar, itmName.Length - lastIndex)[1].Split(splitChar)[1]);
DataGridViewGroup dgvGroup = (DataGridViewGroup)queryBuilder.TableLayoutPanelQueries.Controls[index];
dbDataGridView datagridObject = dgvGroup.DataGridViewQuery;
bool rowAdded = datagridObject.AddToQueryBuilder((TreeNode)e.Data, queryBuilder);
if (rowAdded)
{
queryBuilder = ((ViewBase.GetWindow(Constants.QUERYBUILDER)).Object) as QueryBuilder;
queryBuilder.EnableRunQuery = true;
}
ApplicationObject.ToolWindows.DTE.Windows.Item(Constants.QUERYBUILDER).Activate();
break;
case "Rename":
dbtreeviewObject.LabelEdit = true;
dbtreeviewObject.SelectedNode.BeginEdit();
break;
case "Delete Folder":
FavouriteFolder Fav = new FavouriteFolder(null, ((TreeNode)e.Data).Text);
OMEInteraction.UpdateFavourite(Fav);
dbtreeviewObject.Nodes.Remove((TreeNode)e.Data);
break;
case "Delete Class":
TreeNode tNode = (TreeNode)e.Data;
TreeNode parentNode = ((TreeNode)e.Data).Parent;
if (tNode != null && parentNode != null)
{
Fav = new FavouriteFolder(null, tNode.Parent.Text);
parentNode.Nodes.Remove(tNode);
if (parentNode.Nodes.Count > 0)
{
List <string> lststr = new List <string>();
foreach (TreeNode tempNode in parentNode.Nodes)
{
lststr.Add(tempNode.Text);
}
Fav.ListClass = lststr;
}
OMEInteraction.SaveFavourite(Fav);
}
break;
}
}
catch (Exception oEx)
{
LoggingHelper.ShowMessage(oEx);
}
}
public static void UpdateFavourite(FavouriteFolder favFolder)
{
ManageFavouriteFolder favouriteList = new ManageFavouriteFolder(GetCurrentConnParams());
favouriteList.RemoveFolderfromDatabase(favFolder);
}
private void buttonFavouritesNewFolder_Click(object sender, RoutedEventArgs e)
{
FavouriteFolder newFolder = new FavouriteFolder();
newFolder.Name = CultureHelper.GetString(Properties.Resources.ResourceManager, "FAVOURITESNEWFOLDER");
Dialogs.FavouriteName dialog = new FavouriteName();
dialog.ItemName = newFolder.Name;
DialogPanel.ShowDialog(Properties.Resources.ResourceManager, "PROPERTIES", dialog, "textFavouriteName", DialogButtons.Ok | DialogButtons.Cancel,
delegate(DialogResult dialogResult)
{
if (dialogResult == DialogResult.Ok)
{
newFolder.Name = dialog.ItemName;
if (string.IsNullOrEmpty(newFolder.Name))
{
newFolder.Name = CultureHelper.GetString(Properties.Resources.ResourceManager, "FAVOURITESNEWFOLDER");
}
FavouriteFolder parent = treeView.SelectedItem as FavouriteFolder;
if (parent == null)
{
parent = FindParent(_rootFolder, treeView.SelectedItem as FavouriteBase);
}
if (parent == null)
{
parent = _rootFolder;
}
if (parent != null)
{
int foundIdx = -1;
for (int i = 0; i < parent.Children.Count && foundIdx == -1; i++)
{
if (parent.Children[i] is Favourite)
{
foundIdx = i;
}
}
if (foundIdx == -1)
{
foundIdx = parent.Children.Count;
}
parent.Children.Insert(foundIdx, newFolder);
TreeViewItem tviParent = treeView.GetContainerFromItem(parent) as TreeViewItem;
if (tviParent != null)
{
tviParent.IsExpanded = true;
}
TreeViewItem tvi = treeView.GetContainerFromItem(newFolder) as TreeViewItem;
if (tvi != null)
{
tvi.IsSelected = true;
}
}
}
}
);
}
