public bool AddPFileDetail(int areaId, string filePath, string fileName, string title, string description)
{
//filename must include relative path from bbs
//determines file size on its own
//Will not allow re-add of the same filename to the same area
bool b = false;
try
{
if (!PFileExistsInArea(areaId, fileName))
{
if (File.Exists(filePath + fileName))
{
PFileDetail pfd = new PFileDetail()
{
PFileAreaId = areaId,
Filename = fileName,
FilePath = filePath,
Title = title,
Description = description
};
_bbsDataContext.PFileDetails.Add(pfd);
_bbsDataContext.SaveChanges();
b = true;
}
}
}
catch (Exception e)
{
b = false;
LoggingAPI.LogEntry("Exception in DataInterface.AddGFile: " + e);
}
return(b);
}
public PFileDetail GetPFileDetailByAreaAndNumber(int area, int number)
{
PFileDetail pf = null;
try
{
BBSDataDataContext bbs = GetDataContext();
pf = bbs.PFileDetails.FirstOrDefault(p => p.ParentAreaId.Equals(area) && p.PFileNumber.Equals(number));
}
catch (Exception e)
{
LoggingAPI.LogEntry("Exception in DataInterface.GetPFileDetailByAreaAndNumber: " + e.Message);
pf = null;
}
return(pf);
}
public PFileDetail GetPFileDetailByAreaAndNumber(int?area, int number)
{
PFileDetail pf = null;
try
{
pf = _bbsDataContext.PFileDetails.FirstOrDefault(p => p.PFileAreaId.Equals(area) //& p.PFileNumber.Equals(number)
);
}
catch (Exception e)
{
LoggingAPI.Error(e);
pf = null;
}
return(pf);
}
