public void Delete(ChapterDefinitionFile file)
        {
            var fileToDelete = from f in db.ChapterDefinitionFiles
                          where f.FileName == file.FileName
                          select f;
            ;

            db.ChapterDefinitionFiles.DeleteAllOnSubmit(fileToDelete);
            db.SubmitChanges();
        }
        public int Save(ChapterDefinitionFile file)
        {
            if (file != null)
            {
                if (file.Id == 0)
                {
                    file.CreationTime = DateTime.Now;
                    file.ModificationTime = DateTime.Now;
                    db.ChapterDefinitionFiles.InsertOnSubmit(file);
                    db.SubmitChanges();
                }
                else
                {
                    var chapterDefinitionFile = db.ChapterDefinitionFiles.Single(c => c.Id == file.Id);
                    chapterDefinitionFile.ModificationTime = DateTime.Now;
                    db.SubmitChanges();
                }

                return file.Id;
            }
            return 0;
        }
 public void Update(ChapterDefinitionFile file)
 {
 }