コード例 #1
0
        public bool exists(string fileID)
        {
            DatabaseEntities _database = null;

            try
            {
                _database = new DatabaseEntities();

                _database.Database.Connection.Open();

                var file = _database.CloudManagers;

                foreach (CloudManager item in file)
                {
                    if (item.File_ID.Equals(fileID))        //path ( da jetzt primary key? )
                    {
                        return true;
                    }
                }

                
            }
            catch(Exception)
            {
                return false;
            }
            finally
            {
                _database.Database.Connection.Close();
            }

            return false;

            
        }
コード例 #2
0
        public static void RefreshDatabasePathSettings()
        {
            string filePath = "attachdbfilename=" + Directory.GetCurrentDirectory().ToString() + @"Bin\Debug\Database\Database.mdf";


            //SqlConnection cn = new SqlConnection(global::DBTestCM.Properties.Settings.Default.DatabaseConnectionString);
            try
            {

                DatabaseEntities _database = new DatabaseEntities();


                string s = ConfigurationManager.ConnectionStrings["DatabaseEntities"].ConnectionString;
                if (!s.Contains(filePath))
                {
                    int index = -1;
                    if (s.Contains("attachdbfilename"))
                    {
                        index = s.IndexOf("attachdbfilename");
                    }
                    else if (!s.Contains("attachdbfilename"))
                    {
                        string path = Environment.CurrentDirectory;

                        string[] splits = path.Split('\\');
                        string totalResult = "";
                        for (int i = 0; i < splits.Length - 2; i++)
                        {
                            totalResult += splits[i] + "\\";
                        }
                        totalResult += "Database.mdf";

                        index = s.ToLower().IndexOf(totalResult.ToLower());
                    }

                    string _result = s.Replace(s.Substring(index, s.IndexOf(";", index) - index), filePath);

                    var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
                    config.ConnectionStrings.ConnectionStrings["DatabaseEntities"].ConnectionString = _result;
                    config.Save(ConfigurationSaveMode.Modified, true);
                    ConfigurationManager.RefreshSection("connectionStrings");

                    Console.WriteLine(_result);
                }
            }
            catch (Exception) { }


        }
コード例 #3
0
        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();
            }

            
        }
コード例 #4
0
        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();
            }


        }