public ActionResult BookDelete(int id)
{
var q = db.Tbl_Book.Where(a => a.Book_ID == id).SingleOrDefault();
BookDeleteModel model = new BookDeleteModel();
model.ID = q.Book_ID;
model.Name = q.Book_Name;
return(View(model));
}
public ActionResult BookDelete(BookDeleteModel model)
{
Tbl_Book _Book = db.Tbl_Book.Where(a => a.Book_ID == model.ID).SingleOrDefault();
if (_Book.Tbl_BookDetails.BD_FileEnabel)
{
foreach (var item in _Book.Tbl_Files.ToList())
{
string path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), item.File_Path);
string root = Path.Combine(Server.MapPath("~/App_Data/Upload/"), item.File_FolderName.ToString());
db.Tbl_Files.Remove(item);
FileManagement file = new FileManagement();
file.DeleteFileWithPath(path);
file.Dir_Empty(root);
}
}
db.Tbl_BookDetails.Remove(_Book.Tbl_BookDetails);
if (_Book.Tbl_BookAcsses.BookAcsses_Custom)
{
foreach (var item in db.Tbl_BookCustomAcsses.Where(a => a.Tbl_BookAcsses == _Book.Tbl_BookAcsses).ToList())
{
db.Tbl_BookCustomAcsses.Remove(item);
}
}
db.Tbl_BookAcsses.Remove(_Book.Tbl_BookAcsses);
var tags = db.Tbl_BookTag.Where(a => a.BT_BookID == model.ID).ToList();
foreach (var item in tags)
{
db.Tbl_BookTag.Remove(item);
}
db.Tbl_Book.Remove(_Book);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
return(RedirectToAction("BookList", "Book"));
}
else
{
return(null);
}
}
