public ActionResult Edit(int id)
{
sp_bookList_Result list = dbEntities.sp_bookList().FirstOrDefault(a => a.Id == id);
if (list != null)
{
ViewBag.SubjectArea = _downList.GetBookCategory();
ViewBag.Program = _downList.GetProgramlist();
ViewBag.EditionList = _downList.GetEdition();
ModelBook modelBook = new ModelBook();
modelBook.Author = list.Author;
modelBook.Book_Title = list.Book_Title;
modelBook.Description = list.Description;
modelBook.EditionId = Convert.ToInt32(list.EditionId);
modelBook.ProgramId = Convert.ToInt32(list.ProgramId);
modelBook.SubjectArea_CategoryId = Convert.ToString(list.SubjectArea_CategoryId);
modelBook.MultiCategegory = GetMultiCategory(list.SubjectArea_CategoryId.Split(','));
modelBook.UserId = list.Author;
modelBook.UserType = list.Author;
modelBook.Id = list.Id;
modelBook.Published = Convert.ToBoolean(list.Published);
return(View("Create", modelBook));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
ViewBag.Books = singelton.GetBooks;
return(View("Show_Table"));
}
Book Find_book = singelton.GetBooks.Find(Book => Book.Id == id);
if (Find_book == null)
{
ViewBag.Books = singelton.GetBooks;
return(View("Show_Table"));
}
ShovEdit_RadioAndChec(Find_book);
ModelBook model = new ModelBook()
{
ISBN = Find_book.ISBN,
Name = Find_book.Name,
PageCount = Find_book.PageCount.ToString(),
PublishDate = Find_book.PublishDate.ToString("yyyy-MM-dd"),
Id = Find_book.Id
};
return(View(model));
}
public ActionResult Edit(ModelBook model, int id)
{
if (ModelState.IsValid)
{
Book Find_book = singelton.GetBooks.Find(Book => Book.Id == id);
Find_book.Raname_Book(model.Name, model.PublishDate, model.PageCount, model.ISBN);
Publisher Find_publich =
singelton.GetPublishers.Find(Publisher => Publisher.Id == Convert.ToInt32(model.RadioCeck));
Find_book.publisher = Find_publich;
Find_book.Clear_Author();
foreach (string VARIABLE in model.SelectedCeck)
{
Author Find_Author = singelton.GetAuthors.Back_Author(Convert.ToInt32(VARIABLE));
Find_book.Add_BookAutor(Find_Author);
}
return(RedirectToAction("Show_Table"));
}
else
{
Book Find_Book = singelton.GetBooks.Find(Book => Book.Id == id);
EditShow_Radio_Check(Find_Book);
return(View());
}
}
public ModelBook FindOne(string name)
{
Console.WriteLine("Find one book use dalpg");
ModelBook book = new ModelBook();
book.Name = $"{this.GetType().Name}大全";
book.Author = "zhangsan";
book.Price = 9.9M;
book.CreatedTime = DateTime.Now;
return(book);
}
public int UpdateBook(ModelBook modelBook, ModelUser user)
{
tbl_Book _book = dbEntities.tbl_Book.FirstOrDefault(a => a.Id == modelBook.Id);
if (_book != null)
{
_book.Book_Title = modelBook.Book_Title;
_book.EditionId = modelBook.EditionId;
_book.ProgramId = modelBook.ProgramId;
_book.SubjectArea_CategoryId = Convert.ToString(modelBook.SubjectArea_CategoryId);
_book.Author = modelBook.Author;
_book.Description = modelBook.Description;
_book.UserId = user.Id.ToString();
_book.UserType = user.Type;
_book.Published = modelBook.Published;
return(dbEntities.SaveChanges());
}
return(0);
}
public ActionResult Edit(ModelBook book)
{
if (ModelState.IsValid)
{
var find_book = singelton.GetBooks.Find(Book => Book.Id == book.Id);
find_book.Raname_Book(book.Name, book.PublishDate, book.PageCount, book.ISBN);
Publisher find_Publischer = singelton.GetPublishers.Find(Pub => Pub.Id == Convert.ToInt32(book.RadioCeck));
find_book.Add_BookPublicher(find_Publischer);
find_book.Clear_Author();
foreach (var VARIABLE in book.SelectedCeck)
{
var find_Author = singelton.GetAuthors.Find(Author => Author.Id == Convert.ToInt32(VARIABLE));
find_book.Add_Author(find_Author);
}
ViewBag.Books = singelton.GetBooks;
return(RedirectToAction("Show_Table"));
}
else
{
return(View());
}
}
public ActionResult Index(ModelBook model)
{
if (ModelState.IsValid)
{
Book book = new Book(model.Name, model.PublishingDate, model.PageCount, model.ISBN);
foreach (string VARIABLE in model.SelectedCheck)
{
Author FindAuthor = singleton.GetAuthors.BackAuthor(Convert.ToInt32(VARIABLE));
book.AddBookAuthor(FindAuthor);
}
Publisher pub = singleton.GetPublisher.Find(Publisher => Publisher.Id == Convert.ToInt32(model.RadioCheck));
book.AddBookPublisher(pub);
singleton.AddBook(book);
ViewBag.Book = singleton.GetBooks;
return(RedirectToAction("Show_Table"));
}
else
{
Show_RadioAndCeck();
return(View());
}
}
public ActionResult Index(ModelBook book)
{
if (ModelState.IsValid)
{
Book booksBook = new Book(book.Name, book.PublishDate, book.PageCount, book.ISBN);
foreach (var VARIABLE in book.SelectedCeck)
{
var find_Author = singelton.GetAuthors.Find(Author => Author.Id == Convert.ToInt32(VARIABLE));
booksBook.Add_Author(find_Author);
}
var find_Publisher =
singelton.GetPublishers.Find(Publisher => Publisher.Id == Convert.ToInt32(book.RadioCeck));
booksBook.Add_BookPublicher(find_Publisher);
singelton.Add_Book(booksBook);
ViewBag.Books = singelton.GetBooks;
return(RedirectToAction("Show_Table"));
}
else
{
Show_RadioAndCeck();
return(View());
}
}
public bool Add(ModelBook book)
{
Console.WriteLine("Added a book use dalpg.");
return(true);
}
public ActionResult UploadData(ModelBook FileData)
{
string FileName = "";
ModelUser user = (ModelUser)Session["User"];
if (user == null)
{
FileName = "Please login first";
return(Json(FileName, JsonRequestBehavior.AllowGet));
}
try
{
ModelState["Id"].Errors.Clear();
if (ModelState.IsValid)
{
int splitsubjectArea = Convert.ToInt32(FileData.SubjectArea_CategoryId.Split(',')[0]);
if (FileData.Id > 0)
{
UpdateBook(FileData, user);
FileName = "Successfully updated";
}
else
{
if (dbEntities.tbl_Book.Count(a => a.Book_Title == FileData.Book_Title) > 0)
{
FileName = "Book name is already added.";
}
else
{
var maxId = dbEntities.tbl_Book.Max(a => a.Id);
var categoryname = dbEntities.tbl_SubjectArea.FirstOrDefault(a => a.Id == splitsubjectArea);
foreach (HttpPostedFileBase file in FileData.BookdocumBase)
{
string fname;
Int64 id = Convert.ToInt64(maxId) + 1;
if (file.ContentType.Contains("image"))
{
var coverfname = Path.Combine(Server.MapPath("~/Content/assets/img/avatars/cover/"), id + ".png");
file.SaveAs(coverfname);
}
else
{
fname = id + ".pdf";
fname = Path.Combine(Server.MapPath("~/App_Data/" + categoryname.SubectArea_Name), fname);
file.SaveAs(fname);
}
}
tbl_Book _book = new tbl_Book();
_book.Book_Title = FileData.Book_Title;
_book.EditionId = FileData.EditionId;
_book.ProgramId = FileData.ProgramId;
_book.SubjectArea_CategoryId = FileData.SubjectArea_CategoryId;
_book.Author = FileData.Author;
_book.Description = FileData.Description;
_book.UserId = user.Id.ToString();
_book.UserType = user.Type;
_book.Published = FileData.Published;
dbEntities.tbl_Book.Add(_book);
dbEntities.SaveChanges();
FileName = "Success";
}
}
}
else
{
FileName = "Required all input data fill up ";
}
}
catch (Exception e)
{
FileName = e.GetBaseException().ToString();
}
return(Json(FileName, JsonRequestBehavior.AllowGet));
//return View();
}
public bool Add(ModelBook book)
{
Console.WriteLine("BLL_B bllBook Add.");
return(_iDalBook.Add(book));
}
