/// <summary>
        /// InsertRequest insert into DB a SearchName and DirectoryName
        /// using a stored procedure that created in SQL
        /// </summary>
        /// <param name="newSearch">An object from BOL that will be passed to DB</param>
        #region public static void InsertRequest(SearchModel newSearch)

        public static void InsertRequest(SearchModel newSearch)
        {
            try
            {
                using (FilesDBEntities ef = new FilesDBEntities())
                {
                    ef.InsertSearches(newSearch.SearchName, newSearch.DirectoryName);
                    ef.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
        /// <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);
            }
        }
Example #3
0
        /// <summary>
        /// InsertFile insert into DB a FileName
        /// using a stored procedure that created in SQL
        /// </summary>
        /// <param name="newFile">An object from BOL that will be passed to DB</param>
        #region  public static void InsertFile(FileModel newFile)


        public static void InsertFile(FileModel newFile)
        {
            try
            {
                using (FilesDBEntities ef = new FilesDBEntities())
                {
                    ef.InsertFiles(newFile.FileName);
                    ef.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }