public bool SaveRecentConnection(RecentQueries recentQueries) { try { recentQueries.Timestamp = DateTime.Now; RecentQueries temprc = Db4oClient.CurrentRecentConnection.ChkIfRecentConnIsInDb(); if (temprc != null) { temprc.Timestamp = DateTime.Now; temprc.QueryList = recentQueries.QueryList; temprc.ConnParam.ConnectionReadOnly = recentQueries.ConnParam.ConnectionReadOnly; } else { temprc = recentQueries; temprc.TimeOfCreation = Sharpen.Runtime.CurrentTimeMillis(); } IObjectContainer dbrecentConn = Db4oClient.RecentConn; dbrecentConn.Store(temprc); dbrecentConn.Commit(); Db4oClient.CloseRecentConnectionFile(); } catch (Exception oEx) { LoggingHelper.HandleException(oEx); return(false); } return(true); }
private void LoadQueries() { RecentQueries.Clear(); RecentQueries.AddRange(PerDatabaseState.QueryHistoryManager.RecentQueries.Where(q => !q.IsPinned)); PinnedQueries.Clear(); PinnedQueries.AddRange(PerDatabaseState.QueryHistoryManager.RecentQueries.Where(q => q.IsPinned).OrderBy(q => q.IndexName).ThenBy(q => q.Query)); }
private void GenerateDatabase() { string databaseFile = Path.GetTempFileName(); Db4oClient.conn = new ConnParams(databaseFile,false); RecentQueries currRecentQueries = new RecentQueries(Db4oClient.conn); Db4oClient.CurrentRecentConnection = currRecentQueries; Store(); }
private void GenerateDatabase() { string databaseFile = Path.GetTempFileName(); Db4oClient.conn = new ConnParams(databaseFile, false); RecentQueries currRecentQueries = new RecentQueries(Db4oClient.conn); Db4oClient.CurrentRecentConnection = currRecentQueries; Store(); }
private void SaveIndex() { try { SaveIndexClass saveIndexInstance = new SaveIndexClass(Helper.ClassName); foreach (DataGridViewRow row in dbGridViewProperties.Rows) { bool boolValue = Convert.ToBoolean(row.Cells[2].Value); saveIndexInstance.Fieldname.Add(row.Cells[0].Value.ToString()); saveIndexInstance.Indexed.Add(boolValue); } CloseQueryResultToolWindows(); ConnParams conparam = dbInteraction.GetCurrentRecentConnection().ConnParam; dbInteraction.CloseCurrDb(); saveIndexInstance.SaveIndex(); RecentQueries currRecentConnection = new RecentQueries(conparam); Db4oClient.conn = conparam; RecentQueries tempRc = currRecentConnection.ChkIfRecentConnIsInDb(); if (tempRc != null) currRecentConnection = tempRc; currRecentConnection.Timestamp = DateTime.Now; dbInteraction.ConnectoToDB(currRecentConnection); dbInteraction.SetCurrentRecentConnection(currRecentConnection); //Only if following line is added the index is saved. OMQuery omQuery = new OMQuery(saveIndexInstance.Classname , DateTime.Now); long[] objectid = dbInteraction.ExecuteQueryResults(omQuery); if (ObjectBrowser.Instance.ToolStripButtonAssemblyView.Checked) ObjectBrowser.Instance.DbtreeviewObject.FindNSelectNode(ObjectBrowser.Instance.DbAssemblyTreeView.Nodes[0], saveIndexInstance.Classname, ObjectBrowser.Instance.DbAssemblyTreeView); else ObjectBrowser.Instance.DbtreeviewObject.FindNSelectNode(ObjectBrowser.Instance.DbtreeviewObject.Nodes[0], saveIndexInstance.Classname, ObjectBrowser.Instance.DbtreeviewObject); tabStripProperties.SelectedItem = tabItemClassProperties; MessageBox.Show("Index Saved Successfully!", Helper.GetResourceString(Constants.PRODUCT_CAPTION), MessageBoxButtons.OK); } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
public void LoadAppropriatedata() { DefaultSetting(); Helper.ClassName = null; dbInteractionObject = new dbInteraction(); storedclasses = dbInteractionObject.FetchAllStoredClasses(); if (storedclasses != null) { classCount = storedclasses.Count; } //Assembly view disabled for java db. I don't know any other way ICollection keysCollection = storedclasses.Keys; foreach (string str in keysCollection) { if (!str.Contains(",")) { toolStripButtonAssemblyView.Enabled = false; break; } } //Populate the TreeView dbtreeviewObject.AddFavouritFolderFromDatabase(); dbtreeviewObject.AddTreeNode(storedclasses, null); SelectFirstClassNode(); propertiesTab = PropertiesTab.Instance; if (classCount == 0) { propertiesTab.ShowClassProperties = false; toolStripButtonAssemblyView.Enabled = toolStripButtonFlatView.Enabled = false; } recConnection = dbInteraction.GetCurrentRecentConnection(); PopulateSearchStrings(); dbtreeviewObject.Focus(); dbtreeviewObject.Refresh(); OMETrace.WriteFunctionEnd(); instance = this; }
private void RefreshConnectionData(string filepath) { ConnParams conParams = new ConnParams(filepath, false); RecentQueries recQueries = new RecentQueries(conParams); recQueries = recQueries.ChkIfRecentConnIsInDb(); if (recQueries != null) { FavouriteList favList = new FavouriteList(conParams); favList.RemoveFavouritFolderForAConnection(); GroupofSearchStrings grpSearchString = new GroupofSearchStrings(conParams); grpSearchString.RemovesSearchStringsForAConnection(); recQueries.deleteRecentQueriesForAConnection(); } }
public static void Create() { try { dbInteraction.CreateDemoDb(demoFilePath); ConnParams conparam = new ConnParams(demoFilePath,false); RecentQueries currRecentConnection = new RecentQueries(conparam); RecentQueries tempRc = currRecentConnection.ChkIfRecentConnIsInDb(); if (tempRc != null) currRecentConnection = tempRc; currRecentConnection.Timestamp = DateTime.Now; currRecentConnection.ConnParam = conparam; dbInteraction.ConnectoToDB(currRecentConnection); dbInteraction.SetCurrentRecentConnection(currRecentConnection); } catch (Exception e) { LoggingHelper.ShowMessage(e); } }
public static void Create() { try { dbInteraction.CreateDemoDb(demoFilePath); ConnParams conparam = new ConnParams(demoFilePath, false); RecentQueries currRecentConnection = new RecentQueries(conparam); RecentQueries tempRc = currRecentConnection.ChkIfRecentConnIsInDb(); if (tempRc != null) { currRecentConnection = tempRc; } currRecentConnection.Timestamp = DateTime.Now; currRecentConnection.ConnParam = conparam; dbInteraction.ConnectoToDB(currRecentConnection); dbInteraction.SetCurrentRecentConnection(currRecentConnection); } catch (Exception e) { LoggingHelper.ShowMessage(e); } }
private void buttonConnect_Click(object sender, EventArgs e) { try { ConnParams conparam = null; if (radioButtonLocal.Checked) { if (!(Validations.ValidateLocalLoginParams(ref comboBoxFilePath, ref textBoxConnection))) { return; } conparam = new ConnParams(textBoxConnection.Text.Trim(), chkReadOnly.Checked); } else { if (!(Validations.ValidateRemoteLoginParams(ref comboBoxFilePath, ref textBoxHost, ref textBoxPort, ref textBoxUserName, ref textBoxPassword))) { return; } string connection = STRING_SERVER + textBoxHost.Text.Trim() + STRING_COLON + textBoxPort.Text.Trim() + STRING_COLON + textBoxUserName.Text.Trim(); conparam = new ConnParams(connection, textBoxHost.Text.Trim(), textBoxUserName.Text.Trim(), textBoxPassword.Text.Trim(), Convert.ToInt32(textBoxPort.Text.Trim())); } RecentQueries currRecentQueries = new RecentQueries(conparam); RecentQueries tempRecentQueries = currRecentQueries.ChkIfRecentConnIsInDb(); if (tempRecentQueries != null) { currRecentQueries = tempRecentQueries; currRecentQueries.ConnParam.ConnectionReadOnly = chkReadOnly.Checked; } string exceptionString = dbInteraction.ConnectoToDB(currRecentQueries); if (exceptionString == string.Empty) { dbInteraction.SetCurrentRecentConnection(currRecentQueries); dbInteraction.SaveRecentConnection(currRecentQueries); AfterSuccessfullyConnected(); loginToolWindow.Close(vsSaveChanges.vsSaveChangesNo); Helper.CheckIfLoginWindowIsVisible = false; ObjectBrowserToolWin.CreateObjectBrowserToolWindow(); ObjectBrowserToolWin.ObjBrowserWindow.Visible = true; PropertyPaneToolWin.CreatePropertiesPaneToolWindow(true); PropertyPaneToolWin.PropWindow.Visible = true; CreateQueryBuilderToolWindow(); } else { dbInteraction.CloseCurrDb(); textBoxConnection.Clear(); MessageBox.Show(exceptionString, Helper.GetResourceString(Common.Constants.PRODUCT_CAPTION), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
private void buttonConnect_Click(object sender, EventArgs e) { try { ConnParams conparam = null; if (radioButtonLocal.Checked) { if (!(Validations.ValidateLocalLoginParams(ref comboBoxFilePath, ref textBoxConnection))) return; conparam = new ConnParams(textBoxConnection.Text.Trim(), chkReadOnly.Checked); } else { if (!(Validations.ValidateRemoteLoginParams(ref comboBoxFilePath, ref textBoxHost, ref textBoxPort, ref textBoxUserName, ref textBoxPassword))) return; string connection = STRING_SERVER + textBoxHost.Text.Trim() + STRING_COLON + textBoxPort.Text.Trim() + STRING_COLON + textBoxUserName.Text.Trim(); conparam = new ConnParams(connection, textBoxHost.Text.Trim(), textBoxUserName.Text.Trim(), textBoxPassword.Text.Trim(), Convert.ToInt32(textBoxPort.Text.Trim())); } RecentQueries currRecentQueries = new RecentQueries(conparam); RecentQueries tempRecentQueries = currRecentQueries.ChkIfRecentConnIsInDb(); if (tempRecentQueries != null) { currRecentQueries = tempRecentQueries; currRecentQueries.ConnParam.ConnectionReadOnly = chkReadOnly.Checked; } string exceptionString = dbInteraction.ConnectoToDB(currRecentQueries); if (exceptionString == string.Empty) { dbInteraction.SetCurrentRecentConnection(currRecentQueries); dbInteraction.SaveRecentConnection(currRecentQueries); AfterSuccessfullyConnected(); loginToolWindow.Close(vsSaveChanges.vsSaveChangesNo); Helper.CheckIfLoginWindowIsVisible = false; ObjectBrowserToolWin.CreateObjectBrowserToolWindow(); ObjectBrowserToolWin.ObjBrowserWindow.Visible = true; PropertyPaneToolWin.CreatePropertiesPaneToolWindow(true); PropertyPaneToolWin.PropWindow.Visible = true; CreateQueryBuilderToolWindow(); } else { dbInteraction.CloseCurrDb(); textBoxConnection.Clear(); MessageBox.Show(exceptionString, Helper.GetResourceString(Common.Constants.PRODUCT_CAPTION), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
public static long GetTimeforRecentQueriesCreation(ConnParams conn) { RecentQueries rQueries = new RecentQueries(conn); return(rQueries.ReturnTimeWhenRecentQueriesCreated()); }
public static void SaveRecentConnection(RecentQueries recQueries) { Config.Config.Instance.SaveRecentConnection(recQueries); }
public static void RemoveRecentQueries(ConnParams conn) { RecentQueries recentQueries = new RecentQueries(conn); recentQueries.deleteRecentQueriesForAConnection(); }
public static string ConnectoToDB(RecentQueries recConnection) { DBConnect db = new DBConnect(); return db.dbConnection(recConnection.ConnParam); }
public static void SetCurrentRecentConnection(RecentQueries conn) { Db4oClient.CurrentRecentConnection = conn; }
public static long GetTimeforRecentQueriesCreation(ConnParams conn) { RecentQueries rQueries = new RecentQueries(conn); return rQueries.ReturnTimeWhenRecentQueriesCreated(); }
public static string ConnectoToDB(RecentQueries recConnection) { DBConnect db = new DBConnect(); return(db.dbConnection(recConnection.ConnParam)); }