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