public bool CreateFile(File file)
{
try
{
CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext();
WorkLinqToSql.Document document = new WorkLinqToSql.Document();
document.UserAuthor = file.AuthorID;
document.Status = (int)Record.StatusType.PREMODERATION;
document.MachineID = file.RecordID;
document.PathToFile = file.PachToFile;
document.DocumentName = file.DocumentName;
document.DocumentType = file.DocumentType;
document.FileName = file.FileName;
document.FileType = file.FileType;
document.Size = file.Size;
document.MachineID = file.RecordID;
context.Document.InsertOnSubmit(document);
context.Document.Context.SubmitChanges();
}
catch
{
return(false);
}
return(true);
}
public File ToFile(WorkLinqToSql.Document document)
{
string userName = "******";
try
{
CatalogDatabaseDataContext context = new CatalogDatabaseDataContext();
var author = (from user in context.AspNetUsers where (document.UserAuthor == user.Id) select user).Single();
userName = author.FirstName + author.LastName;
}
catch { }
CatalogAppMVC.Models.File file = new File(document.Id, document.UserAuthor, document.DocumentName, document.DocumentType, document.FileName, document.FileType, document.Size, document.PathToFile);
return(file);
}
public bool RemoveFile(int fileID)
{
try
{
CatalogDatabaseDataContext context = new CatalogDatabaseDataContext();
WorkLinqToSql.Document doc = (from file in context.Document where file.Id == fileID select file).Single <WorkLinqToSql.Document>();
context.Document.DeleteOnSubmit(doc);
context.Document.Context.SubmitChanges();
}
catch
{
return(false);
}
return(true);
}