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 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);
}
}
private FavouriteList FetchAllFavouritesForAConnection()
{
FavouriteList FavList = null;
try
{
container = Db4oClient.RecentConn;
IQuery query = container.Query();
query.Constrain(typeof(FavouriteList));
query.Descend("m_connParam").Descend("m_connection").Constrain(m_connParam.Connection);
IObjectSet objSet = query.Execute();
if (objSet != null)
{
if (objSet.Count != 0)
{
FavList = (FavouriteList)objSet.Next();
}
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
return(FavList);
}
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);
}
}
internal long ReturnTimeWhenFavouriteListCreated()
{
FavouriteList Fav = null;
try
{
Fav = FetchAllFavouritesForAConnection();
if (Fav != null)
{
return(Fav.TimeOfCreation > 0 ? Fav.TimeOfCreation : 0);
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
return(0);
}
internal List <FavouriteFolder> ReturnFavouritFolderList()
{
List <FavouriteFolder> FavList = null;
try
{
FavouriteList Fav = FetchAllFavouritesForAConnection();
if (Fav != null)
{
FavList = Fav.lstFavFolder;
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
return(FavList);
}
internal FavouriteList FindFolderWithClassesByFolderName(string folderName)
{
FavouriteList FavList = null;
try
{
container = Db4oClient.RecentConn;
IQuery query = container.Query();
query.Constrain(typeof(FavouriteList));
query.Descend("m_connParam").Descend("m_connection").Constrain(m_connParam.Connection);
query.Descend("m_lstFavfolder").Descend("m_folderName").Constrain(folderName);
IObjectSet objSet = query.Execute();
if (objSet.Count != 0)
{
FavList = (FavouriteList)objSet.Next();
}
}
catch (Exception oEx)
{
LoggingHelper.HandleException(oEx);
}
return(FavList);
}
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);
}
}
public static void RemoveFavFolder(ConnParams conn)
{
FavouriteList favouriteList = new FavouriteList(conn);
favouriteList.RemoveFavouritFolderForAConnection();
}
public static void RenameFolderInDatabase(ConnParams conn, FavouriteFolder oldFav, FavouriteFolder newFav)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav.RenameFolderInDatabase(oldFav, newFav);
}
public static FavouriteFolder GetFolderfromDatabaseByFoldername(ConnParams conn, string folderName)
{
FavouriteList lstFav = new FavouriteList(conn);
lstFav = lstFav.FindFolderWithClassesByFolderName(folderName);
return lstFav.lstFavFolder[0];
}
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 static long GetTimeforFavCreation(ConnParams conn)
{
FavouriteList lstFav = new FavouriteList(conn);
return lstFav.ReturnTimeWhenFavouriteListCreated();
}
public static List<FavouriteFolder> GetFavourites(ConnParams conn)
{
FavouriteList lstFav = new FavouriteList(conn);
return lstFav.ReturnFavouritFolderList();
}
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();
}
}
