/// <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> /// 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> /// 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); } }
/// <summary> /// GetId checks if the SearchName and DirectoryName already exists /// and returns it Id: /// 0 if not exist, /// current Id if exist /// </summary> /// <param name="search">Gets an object from BOL</param> /// <returns>Returns a status of the SearchId</returns> #region public static int GetId(SearchModel search) public static int GetId(SearchModel search) { try { using (FilesDBEntities ef = new FilesDBEntities()) { var searchId = ef.Searches .Where((s) => s.SearchName == search.SearchName && s.DirectoryName == search.DirectoryName) .Select((s) => s.SearchID); if (searchId != null) { return(searchId.FirstOrDefault()); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(0); }
/// <summary> /// GetId checks if the FileName already exists /// and returns it Id: /// 0 if not exist, /// current Id if exist /// </summary> /// <param name="searchFile">Gets an object from BOL</param> /// <returns>Returns a status of the</returns> #region public static int GetId(FileModel searchFile) public static int GetId(FileModel searchFile) { try { using (FilesDBEntities ef = new FilesDBEntities()) { var fileId = ef.Files .Where((s) => s.FileName == searchFile.FileName) .Select((s) => s.FileId); if (fileId != null) { return(fileId.FirstOrDefault()); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(0); }