public void DeleteBookImage(int id)
{
BOOK_IMAGE bookImage = dataAccess.BOOK_IMAGEs.Single(bi => bi.BOOK_IMAGEID == id);
dataAccess.BOOK_IMAGEs.DeleteOnSubmit(bookImage);
dataAccess.SaveChanges();
}
public void UpdateBookImage(BOOK_IMAGE image)
{
BOOK_IMAGE bookImage = dataAccess.BOOK_IMAGEs.Single(bi => bi.BOOKID == image.BOOKID);
bookImage = image;
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 InsertBookImage(BOOK_IMAGE image)
{
dataAccess.BOOK_IMAGEs.InsertOnSubmit(image);
dataAccess.SaveChanges();
}
internal static void AddBookImage(BOOK_IMAGE bookImage)
{
Service.InsertBookImage(bookImage);
}
