public ActionResult BookPublish(BookPublishModel model)
{
Tbl_Book book = new Tbl_Book();
book = db.Tbl_Book.Where(a => a.Book_ID == model.ID).SingleOrDefault();
book.Tbl_BookAcsses.BookAcsses_Guest = model.GusetSearch;
book.Tbl_BookAcsses.BookAcsses_Global = model.GlobalAcsses;
book.Tbl_BookAcsses.BookAcsses_Local = model.LocalAcsses;
book.Tbl_BookAcsses.BookAcsses_Custom = model.Custom;
book.Book_Publish = model.Publish;
db.Entry(book).State = System.Data.Entity.EntityState.Modified;
db.Entry(book.Tbl_BookAcsses).State = System.Data.Entity.EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
ViewBag.Message = "عملبات با موفقیت انجام شده!";
ViewBag.State = "Sucsse";
return(RedirectToAction("BookShow", "Book", new { id = model.ID }));
}
else
{
ViewBag.Message = "عملبات با موفقیت انجام نشده!";
ViewBag.State = "Error";
return(RedirectToAction("BookShow", "Book", new { id = model.ID }));
}
}
public ActionResult BookAdd(Tbl_Book tbl, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/Books/"), pic);
file.SaveAs(path);
}
tbl.BookImage = pic;
_unitOfWork.GetRepositoryInstance <Tbl_Book>().Add(tbl);
return(RedirectToAction("Index"));
}
public ActionResult BookEdit(Tbl_Book tbl, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/ProductImg/"), pic);
file.SaveAs(path);
}
tbl.ProductImage = file != null ? pic : tbl.ProductImage;
tbl.ModifiedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Book>().Update(tbl);
return(RedirectToAction("Book"));
}
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);
}
}
public ActionResult BookNew(BookNewModel model)
{
Tbl_Book _book = new Tbl_Book();
Tbl_BookDetails _details = new Tbl_BookDetails();
Tbl_BookAcsses _acsses = new Tbl_BookAcsses();
Membership membership = new Membership();
Rep_Book rep = new Rep_Book();
model.DetailsNav = rep.Get_BookDetailsListByBookType(model.ID);
_book.Book_Code = model.Book.Book_Code;
_book.Book_Name = model.Book.Book_Name;
_book.Book_BookTypeID = model.ID;
_book.Book_UploaderUserID = membership.Get_IDByUserName(User.Identity.Name);
_book.Book_Publish = false;
_details.BD_DigitalVersionAvailable = model.Details.BD_DigitalVersionAvailable;
if (model.Details.BD_DigitalVersionAvailable)
{
_details.BD_FileEnabel = true;
}
_details.BD_PhysicalVersionAvailable = model.Details.BD_PhysicalVersionAvailable;
if (model.Details.BD_PhysicalVersionAvailable)
{
_details.BD_LibraryID = model.Details.BD_LibraryID;
}
_details.BD_PageCount = model.Details.BD_PageCount;
_details.BD_LanguageID = model.Details.BD_LanguageID;
foreach (var item in model.DetailsNav)
{
switch (item)
{
case "Titel":
_details.BD_Titel = model.Details.BD_Titel;
break;
case "Abstract":
_details.BD_Abstract = model.Details.BD_Abstract;
break;
case "Student":
_details.BD_StudentID = model.Details.BD_StudentID;
break;
case "Master":
_details.BD_MasterID = model.Details.BD_MasterID;
break;
case "ISBN":
_details.BD_ISBN = model.Details.BD_ISBN;
break;
case "Group":
_details.BD_GroupID = model.Details.BD_GroupID;
break;
case "Branch":
_details.BD_BranchID = model.Details.BD_BranchID;
break;
case "Publishers":
_details.BD_Publishers = model.Details.BD_Publishers;
break;
case "Subject":
_details.BD_Subject = model.Details.BD_Subject;
break;
case "Description":
_details.BD_Description = model.Details.BD_Description;
break;
case "WriterName":
_details.BD_WriterName = model.Details.BD_WriterName;
break;
case "ReleaseCount":
_details.BD_ReleaseCount = model.Details.BD_ReleaseCount;
break;
case "Translator":
_details.BD_Translator = model.Details.BD_Translator;
break;
default:
break;
}
}
_acsses.BookAcsses_Guest = false;
_acsses.BookAcsses_Global = false;
_acsses.BookAcsses_Local = false;
_acsses.BookAcsses_Custom = false;
db.Tbl_BookDetails.Add(_details);
db.Tbl_BookAcsses.Add(_acsses);
_book.Tbl_BookDetails = _details;
_book.Tbl_BookAcsses = _acsses;
db.Tbl_Book.Add(_book);
foreach (var item in model.Tag)
{
Tbl_BookTag _booktag = new Tbl_BookTag();
int id = 0;
if (Int32.TryParse(item, out id))
{
Tbl_Tag tag = db.Tbl_Tag.Where(a => a.Tag_ID == id).SingleOrDefault();
if (tag == null)
{
Tbl_Tag _tag = new Tbl_Tag();
_tag.Tag_Name = item;
db.Tbl_Tag.Add(_tag);
_booktag.Tbl_Tag = _tag;
_booktag.Tbl_Book = _book;
}
else
{
_booktag.Tbl_Tag = tag;
_booktag.Tbl_Book = _book;
}
}
else
{
Tbl_Tag _tag = new Tbl_Tag();
_tag.Tag_Name = item;
db.Tbl_Tag.Add(_tag);
_booktag.Tbl_Tag = _tag;
_booktag.Tbl_Book = _book;
}
db.Tbl_BookTag.Add(_booktag);
}
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
ViewBag.Message = "عملبات با موفقیت انجام شده!";
ViewBag.State = "Sucsse";
if (_details.BD_DigitalVersionAvailable)
{
return(RedirectToAction("BookUplaod", "Book", new { id = _book.Book_ID }));
}
else
{
if (User.IsInRole("Publish"))
{
return(RedirectToAction("BookPublish", "Book", new { id = _book.Book_ID }));
}
return(RedirectToAction("BookList", "Book"));
}
}
else
{
ViewBag.Message = "عملبات با موفقیت انجام نشده!";
ViewBag.State = "Error";
return(RedirectToAction("BookNew", "Book", new { id = model.ID }));
}
}
public ActionResult BookEdit(BookEditModel model)
{
Tbl_Book _book = new Tbl_Book();
Tbl_BookDetails _details = new Tbl_BookDetails();
Tbl_BookTag _tag = new Tbl_BookTag();
Membership membership = new Membership();
Rep_Book rep = new Rep_Book();
var q = db.Tbl_Book.Where(a => a.Book_ID == model.ID).SingleOrDefault();
_book = q;
_details = q.Tbl_BookDetails;
model.DetailsNav = rep.Get_BookDetailsListByBookType(q.Tbl_BookType.BookType_ID);
_book.Book_Code = model.Book.Book_Code;
_book.Book_Name = model.Book.Book_Name;
_book.Book_UploaderUserID = membership.Get_IDByUserName(User.Identity.Name);
_details.BD_DigitalVersionAvailable = model.Details.BD_DigitalVersionAvailable;
if (model.Details.BD_DigitalVersionAvailable)
{
_details.BD_FileEnabel = true;
}
_details.BD_PhysicalVersionAvailable = model.Details.BD_PhysicalVersionAvailable;
if (model.Details.BD_PhysicalVersionAvailable)
{
_details.BD_LibraryID = model.Details.BD_LibraryID;
}
_details.BD_PageCount = model.Details.BD_PageCount;
_details.BD_LanguageID = model.Details.BD_LanguageID;
foreach (var item in model.DetailsNav)
{
switch (item)
{
case "Titel":
_details.BD_Titel = model.Details.BD_Titel;
break;
case "Abstract":
_details.BD_Abstract = model.Details.BD_Abstract;
break;
case "Student":
_details.BD_StudentID = model.Details.BD_StudentID;
break;
case "Master":
_details.BD_MasterID = model.Details.BD_MasterID;
break;
case "ISBN":
_details.BD_ISBN = model.Details.BD_ISBN;
break;
case "Group":
_details.BD_GroupID = model.Details.BD_GroupID;
break;
case "Branch":
_details.BD_BranchID = model.Details.BD_BranchID;
break;
case "Publishers":
_details.BD_Publishers = model.Details.BD_Publishers;
break;
case "Subject":
_details.BD_Subject = model.Details.BD_Subject;
break;
case "Description":
_details.BD_Description = model.Details.BD_Description;
break;
case "WriterName":
_details.BD_WriterName = model.Details.BD_WriterName;
break;
case "ReleaseCount":
_details.BD_ReleaseCount = model.Details.BD_ReleaseCount;
break;
case "Translator":
_details.BD_Translator = model.Details.BD_Translator;
break;
default:
break;
}
}
db.Entry(_details).State = System.Data.Entity.EntityState.Modified;
db.Entry(_book).State = System.Data.Entity.EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
return(RedirectToAction("BookShow", "Book", new { id = _book.Book_ID }));
}
else
{
ViewBag.Message = "عملبات با موفقیت انجام نشده!";
ViewBag.State = "Error";
return(RedirectToAction("BookShow", "Book", new { id = _book.Book_ID }));
}
}
