public static FavouriteFolder GetFolderfromDatabaseByFoldername(ConnParams conn, string folderName)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav = lstFav.FindFolderWithClassesByFolderName(folderName);
return(lstFav.lstFavFolder[0]);
}
private void ConnectAfterCreatingNewAppDomain(ConnParams conparam)
{
ConnectionDetails currConnectionDetails = new ConnectionDetails(conparam);
long id = OMEInteraction.ChkIfRecentConnIsInDb(conparam);
if (id > 0)
{
currConnectionDetails = OMEInteraction.GetConnectionDetailsObject(id);
if (currConnectionDetails != null)
{
currConnectionDetails.ConnParam.ConnectionReadOnly = chkReadOnly.Checked;
}
}
currConnectionDetails.CustomConfigAssemblyPath = txtCustomConfigAssemblyPath.Text.Trim();
string exceptionString = AssemblyInspectorObject.Connection.ConnectToDatabase(currConnectionDetails,
checkCustomConfig);
if (exceptionString == string.Empty)
{
SaveConnectionAndCreateToolWindows(currConnectionDetails);
CreateQueryBuilderToolWindow();
}
else
{
AssemblyInspectorObject.Connection.Closedb();
textBoxConnection.Clear();
MessageBox.Show(exceptionString,
Helper.GetResourceString(Common.Constants.PRODUCT_CAPTION),
MessageBoxButtons.OK,
MessageBoxIcon.Error);
AppDomain.Unload(appDomain.workerAppDomain);
dbInteraction.SetAssemblyPathtoNull();
}
}
public static void Create()
{
try
{
dbInteraction.CreateDemoDb(demoFilePath);
ConnParams conparam = new ConnParams(demoFilePath, false);
ConnectionDetails connectionDetails = new ConnectionDetails(conparam);
long id = OMEInteraction.ChkIfRecentConnIsInDb(conparam);
if (id > 0)
{
ConnectionDetails tempConnectionDetail = OMEInteraction.GetConnectionDetailsObject(id);
if (tempConnectionDetail != null)
{
connectionDetails = tempConnectionDetail;
}
}
connectionDetails.Timestamp = DateTime.Now;
connectionDetails.ConnParam = conparam;
AssemblyInspectorObject.Connection.ConnectToDatabase(connectionDetails, false);
OMEInteraction.SetCurrentRecentConnection(connectionDetails.ConnParam);
OMEInteraction.SaveRecentConnection(connectionDetails);
}
catch (Exception e)
{
LoggingHelper.ShowMessage(e);
}
}
private void btnClearCustomConfig_Click(object sender, EventArgs e)
{
if (comboBoxFilePath.SelectedItem != null)
{
ConnParams param = new ConnParams(comboBoxFilePath.SelectedItem.ToString());
OMEInteraction.DeleteConfigConnection(txtCustomConfigAssemblyPath.Text.Trim(), param);
}
txtCustomConfigAssemblyPath.Clear();
}
public static void SaveSearchString(ConnParams conn, SeachString searchString)
{
GroupofSearchStrings searchStrings = new GroupofSearchStrings(conn);
if (searchString.SearchString != string.Empty)
{
searchStrings.AddSearchStringToList(searchString);
}
}
public ProxyConnParam CovertoProxy(ConnParams connParams)
{
DbConnectionStr = connParams.Connection;
Host = connParams.Host;
Port = connParams.Port;
UserName = connParams.UserName;
PassWord = connParams.PassWord;
ReadOnly = connParams.ConnectionReadOnly;
return(this);
}
public string dbConnection(ConnParams login, bool customConfig)
{
try
{
Db4oClient.CurrentConnParams = login;
Db4oClient.CustomConfig = customConfig;
IObjectContainer objectContainer = Db4oClient.Client;
return(Db4oClient.ExceptionConnection);
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
return("");
}
}
private void RefreshConnectionData(string filepath)
{
ConnParams conParams = new ConnParams(filepath, false);
long id = OMEInteraction.ChkIfRecentConnIsInDb(conParams);
if (id > 0)
{
ConnectionDetails connectionDetails = OMEInteraction.GetConnectionDetailsObject(id);
if (connectionDetails != null)
{
OMEInteraction.RemoveFavFolder();
OMEInteraction.RemoveSearchString();
OMEInteraction.RemoveRecentQueries();
}
}
}
//
public string dbConnection(ConnParams login)
{
try
{
Db4oFactory.Configure().AllowVersionUpdates(true);
Db4oClient.conn = login;
dbConn = Db4oClient.Client;
return(Db4oClient.exceptionConnection);
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
return("");
}
}
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);
}
}
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();
}
}
/// <summary>
/// Static property which closes the corresponding object container for the current logon identity.
/// </summary>
public static void CloseConnection()
{
try
{
if (objContainer != null)
{
objContainer.Close();
objContainer = null;
isConnected = false;
conn = null;
}
embeddedConfig = null;
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
}
private void buttonConnect_Click(object sender, EventArgs e)
{
try
{
ConnParams conparam;
checkCustomConfig = false;
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()));
}
dbInteraction.SetPathForConnection(conparam.Connection);
CheckCustomConfig();
if (CreateAppDomain())
{
ConnectAfterCreatingNewAppDomain(conparam);
}
}
catch (Exception oEx)
{
LoggingHelper.ShowMessage(oEx);
}
}
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 long ChkIfRecentConnIsInDb(ConnParams connectionDetails)
{
ManageConnectionDetails manage = new ManageConnectionDetails(connectionDetails);
return(manage.ChkIfRecentConnIsInDb());
}
public static void SetCurrentRecentConnection(ConnParams conn)
{
Db4oClient.CurrentConnParams = conn;
}
public static void DeleteConfigConnection(string path, ConnParams connnection)
{
ManageConnectionDetails manage = new ManageConnectionDetails(connnection);
manage.RemoveCustomConfigPath(path);
}
public static long GetTimeforSearchStringCreation(ConnParams conn)
{
GroupofSearchStrings lstsearchstring = new GroupofSearchStrings(conn);
return(lstsearchstring.ReturnTimeWhenSearchStringCreated());
}
public ManageFavouriteFolder(ConnParams connParam)
{
m_connParam = connParam;
}
public static long GetTimeforRecentQueriesCreation(ConnParams conn)
{
RecentQueries rQueries = new RecentQueries(conn);
return(rQueries.ReturnTimeWhenRecentQueriesCreated());
}
public static void SaveFavourite(ConnParams conn, FavouriteFolder FavFolder)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav.AddFolderToDatabase(FavFolder);
}
public static void RemoveRecentQueries(ConnParams conn)
{
RecentQueries recentQueries = new RecentQueries(conn);
recentQueries.deleteRecentQueriesForAConnection();
}
public static long GetTimeforFavCreation(ConnParams conn)
{
FavouriteList lstFav = new FavouriteList(conn);
return(lstFav.ReturnTimeWhenFavouriteListCreated());
}
public static void RenameFolderInDatabase(ConnParams conn, FavouriteFolder oldFav, FavouriteFolder newFav)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav.RenameFolderInDatabase(oldFav, newFav);
}
private void SaveIndex()
{
ConnParams conparam = null;
bool customConfig = false;
SaveIndexClass saveIndexInstance = null;
try
{
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();
conparam = OMEInteraction.GetCurrentConnParams();
OMEInteraction.CloseOMEdb();
customConfig = AssemblyInspectorObject.Connection.CheckForCustomConfig();
AssemblyInspectorObject.Connection.Closedb();
AssemblyInspectorObject.Connection.SaveIndex(saveIndexInstance.Fieldname, saveIndexInstance.Classname,
saveIndexInstance.Indexed, conparam.Connection, customConfig);
MessageBox.Show("Index Saved Successfully!", Helper.GetResourceString(Constants.PRODUCT_CAPTION), MessageBoxButtons.OK);
}
catch (Exception oEx)
{
LoggingHelper.ShowMessage(oEx);
}
try
{
ConnectionDetails currConnectionDetails = new ConnectionDetails(conparam);
long id = OMEInteraction.ChkIfRecentConnIsInDb();
if (id > 0)
{
ConnectionDetails tempConnectionDetails = OMEInteraction.GetConnectionDetailsObject(id);
if (tempConnectionDetails != null)
{
currConnectionDetails = tempConnectionDetails;
}
currConnectionDetails.Timestamp = DateTime.Now;
AssemblyInspectorObject.Connection.ConnectToDatabase(currConnectionDetails, customConfig);
OMEInteraction.SetCurrentRecentConnection(currConnectionDetails.ConnParam);
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;
}
}
catch (Exception Ex)
{
LoggingHelper.ShowMessage(Ex);
}
}
public static void RemoveFavFolder(ConnParams conn)
{
FavouriteList favouriteList = new FavouriteList(conn);
favouriteList.RemoveFavouritFolderForAConnection();
}
public FavouriteList(ConnParams connParam)
{
m_connParam = connParam;
m_lstFavfolder = new List <FavouriteFolder>();
}
public ManageSearchStrings(ConnParams connParam)
{
m_connParam = connParam;
}
public static void UpdateFavourite(ConnParams conn, FavouriteFolder FavFolder)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav.RemoveFolderfromDatabase(FavFolder);
}
public static void RemoveSearchString(ConnParams conn)
{
GroupofSearchStrings SearchStringList = new GroupofSearchStrings(conn);
SearchStringList.RemovesSearchStringsForAConnection();
}
