/// <summary>
        /// InsertIntoFilesPerSearches insert into DB SearchId and FileId
        /// using a stored procedure that created in SQL
        /// </summary>
        ///<param name="search">An object from BOL that will be passed to DB</param>
        ///<param name="file">An object from BOL that will be passed to DB</param>
        #region private static void InsertIntoFilesPerSearches(SearchModel search, FileModel file)

        private static void InsertIntoFilesPerSearches(SearchModel search, FileModel file)
        {
            try
            {
                using (FilesDBEntities ef = new FilesDBEntities())
                {
                    ef.InsertFilesSearches(search.SearchID, file.FileId);
                    ef.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }