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);
}
