public void DeleteBookSoftCopy(int?bSCID) { BOOK_SOFTCOPY bookSoftCopy = dataAccess.BOOK_SOFTCOPies.Single(bSoftCopy => bSoftCopy.BSCID == bSCID); dataAccess.BOOK_SOFTCOPies.DeleteOnSubmit(bookSoftCopy); dataAccess.SaveChanges(); }
public void UpdateBookSoftCopy(BOOK_SOFTCOPY bSoftCopy) { BOOK_SOFTCOPY bookSoftCopy = dataAccess.BOOK_SOFTCOPies.Single(bSC => bSC.BSCID == bSoftCopy.BSCID); bookSoftCopy = bSoftCopy; dataAccess.SaveChanges(); }
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 void InsertBookSoftCopy(BOOK_SOFTCOPY copy) { dataAccess.BOOK_SOFTCOPies.InsertOnSubmit(copy); dataAccess.SaveChanges(); }
internal static void AddBookSoftCopy(BOOK_SOFTCOPY bSC) { Service.InsertBookSoftCopy(bSC); }