/// <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); } }
/// <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); } }