public void DeleteBookCategory(int?bCategoryID) { BOOK_CATEGORY bookCategory = dataAccess.BOOK_CATEGORies.Single(bc => bc.BOOK_CATEGORYID == bCategoryID); dataAccess.BOOK_CATEGORies.DeleteOnSubmit(bookCategory); dataAccess.SaveChanges(); }
public void UpdateBookCategory(BOOK_CATEGORY bCategory) { BOOK_CATEGORY bookCategory = dataAccess.BOOK_CATEGORies.Single(bc => bc.BOOK_CATEGORYID == bCategory.BOOK_CATEGORYID); bookCategory = bCategory; dataAccess.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { BOOK_CATEGORY bOOK_CATEGORY = db.BOOK_CATEGORY.Find(id); db.BOOK_CATEGORY.Remove(bOOK_CATEGORY); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddBook(BOOK book, List <int> Authors, List <int> Categories, List <HttpPostedFileBase> bookImages, List <HttpPostedFileBase> bookSoftCopy) { try { book.CREATED_DATE = DateTime.Now; book = BookModel.AddBook(book); foreach (int aID in Authors) { BOOK_AUTHOR bookAuthor = new BOOK_AUTHOR(); bookAuthor.BOOKID = book.BOOKID; bookAuthor.AUTHORID = aID; AuthorModel.AddBookAuthor(bookAuthor); } foreach (int bCID in Categories) { BOOK_CATEGORY bookCat = new BOOK_CATEGORY(); bookCat.BOOKID = book.BOOKID; bookCat.CATEGORYID = bCID; CategoryModel.AddBookCategory(bookCat); } foreach (HttpPostedFileBase image in bookImages) { String fname = Generator.RandomString(10) + "." + image.FileName.Split('.')[image.FileName.Split('.').Length - 1]; string path = Server.MapPath("~/UserImages/") + fname; BOOK_IMAGE bookImage = new BOOK_IMAGE(); bookImage.BOOKID = book.BOOKID; bookImage.IMAGEPATH = "/UserImages/" + fname; image.SaveAs(path); BookModel.AddBookImage(bookImage); } if (bookSoftCopy != null) { foreach (HttpPostedFileBase bookSC in bookSoftCopy) { String fname = Generator.RandomString(10) + "." + bookSC.FileName.Split('.')[bookSC.FileName.Split('.').Length - 1]; string path = Server.MapPath("~/UserImages/") + fname; BOOK_SOFTCOPY bSC = new BOOK_SOFTCOPY(); bSC.BOOKID = book.BOOKID; bSC.FILEPATH = "/UserImages/" + fname; bSC.FILESIZE = bookSC.ContentLength; bookSC.SaveAs(path); BookModel.AddBookSoftCopy(bSC); } } ViewBag.Message = SuccessMessage.BOOK_ADDED; } catch (Exception e) { ViewBag.Message = e.Message; } initialiseViewBag(); return(View(book)); }
public ActionResult Edit([Bind(Include = "ID,NAME")] BOOK_CATEGORY bOOK_CATEGORY) { if (ModelState.IsValid) { db.Entry(bOOK_CATEGORY).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bOOK_CATEGORY)); }
public ActionResult Create([Bind(Include = "ID,NAME")] BOOK_CATEGORY bOOK_CATEGORY) { if (ModelState.IsValid) { db.BOOK_CATEGORY.Add(bOOK_CATEGORY); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bOOK_CATEGORY)); }
// GET: BOOK_CATEGORY/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BOOK_CATEGORY bOOK_CATEGORY = db.BOOK_CATEGORY.Find(id); if (bOOK_CATEGORY == null) { return(HttpNotFound()); } return(View(bOOK_CATEGORY)); }
public void InsertBookCategory(BOOK_CATEGORY bCategory) { dataAccess.BOOK_CATEGORies.InsertOnSubmit(bCategory); dataAccess.SaveChanges(); }
public static bool AddBookCategory(BOOK_CATEGORY bookCategory) { Services.InsertBookCategory(bookCategory); return(true); }