public void execEntry(string fileID, string cloudID, string fileName, string filePath, DateTime lastUpdated, bool isDeleted, bool isFolder, bool isInRoot, string cloudPath) { DatabaseEntities _database = null; try { _database = new DatabaseEntities(); _database.Database.Connection.Open(); CloudManager entry = new CloudManager(); var data = _database.CloudManagers; foreach(CloudManager cm in data) { if(cm.File_Path.Equals(filePath)) { _database.CloudManagers.Remove(cm); } } entry.File_ID = fileID; entry.Cloud_ID = cloudID; entry.File_Name = fileName; entry.File_Path = filePath; entry.File_LastChanged = lastUpdated; entry.File_IsDeleted = isDeleted; entry.IsFolder = isFolder; entry.File_IsInRoot = isInRoot; entry.Cloud_Path = cloudPath; _database.CloudManagers.Add(entry); _database.SaveChanges(); } catch (Exception) { _database.Database.Connection.Close(); } finally { _database.Database.Connection.Close(); } }
public void execEntry(string fileName, string filePath, bool isFolder,string cloudname) { DatabaseEntities _database = null; try { _database = new DatabaseEntities(); _database.Database.Connection.Open(); CloudManager entry = new CloudManager(); var data = _database.CloudManagers; foreach (CloudManager cm in data) { if (cm.File_Path.Equals(filePath)) { _database.CloudManagers.Remove(cm); } } entry.File_ID = String.Empty; entry.Cloud_ID = cloudname; entry.File_Name = fileName; entry.File_Path = filePath; entry.File_LastChanged = null; entry.IsFolder = isFolder; entry.Cloud_Path = String.Empty; _database.CloudManagers.Add(entry); _database.SaveChanges(); } catch (Exception) { _database.Database.Connection.Close(); } finally { _database.Database.Connection.Close(); } }