public ActionResult IndexPost(HttpPostedFileBase img)
{
//get id of current book
int bid = Int32.Parse(Request["bid"]);
string[] category_ids = Request["category"].Split(',');
string title = Request["title"];
//string img = Request["img"];
string languge = Request["language"];
string des = Request["description"];
account a = (account)Session["user"];
BookDAO bd = new BookDAO();;
book b = bd.getOne(bid);
b.name = title;
b.img = "img";
b.language = languge;
b.des = des;
bd.updateBook(b);
//remove all old categories
categoryDAO cd = new categoryDAO();
cd.removeCateOfBook(bid);
//add categories
for (int i = 0; i < category_ids.Length - 1; i++)
{
int cid = Int32.Parse(category_ids[i]);
bd.addCforlast(cid, bid);
}
AuthorDAO authorDAO = new AuthorDAO();
//check if book's author is already existed
if (Request["isNewAuthor"] == null)
{
//add a connection between book and author
int aid = Int32.Parse(Request["authorid"]);
authorDAO.AddAuthorForBook(aid, bid);
}
else
{
//create new author
string author_name = Request["author_name"];
string lifestory = Request["lifestory"];
string nation = Request["nation"];
string dob = DateTime.Parse(Request["dob"]).ToString("yyyy-MM-dd");
authorDAO.AddAuthor(author_name, lifestory, nation, dob);
//add a connection between book and new author
authorDAO.AddAuthorForBook(authorDAO.getLastId(), bid);
}
if (img.ContentLength > 0)
{
var extenstion = Path.GetExtension(img.FileName);
string fileName = "i" + bid + extenstion;
string savedFileName = Server.MapPath("~/assets/img/book/" + fileName);
img.SaveAs(savedFileName);
bd.updateBook(new book(bid, des, title, des, a, languge, fileName, DateTime.Now, 0, 0));
}
return(RedirectToAction("Index", "Manage"));
}
public ActionResult IndexPost()
{
//get id of current book
int bid = Int32.Parse(Request["bid"]);
string[] category_ids = Request["category"].Split(',');
string title = Request["title"];
string img = Request["img"];
string languge = Request["language"];
string des = Request["description"];
account a = (account)Session["user"];
BookDAO bd = new BookDAO();;
book b = bd.getOne(bid);
b.name = title;
b.img = img;
b.language = languge;
b.des = des;
bd.updateBook(b);
//remove all old categories
categoryDAO cd = new categoryDAO();
cd.removeCateOfBook(bid);
//add categories
for (int i = 0; i < category_ids.Length - 1; i++)
{
int cid = Int32.Parse(category_ids[i]);
bd.addCforlast(cid, bid);
}
AuthorDAO authorDAO = new AuthorDAO();
//check if book's author is already existed
if (Request["isNewAuthor"] == null)
{
//add a connection between book and author
int aid = Int32.Parse(Request["authorid"]);
authorDAO.AddAuthorForBook(aid, bid);
}
else
{
//create new author
string author_name = Request["author_name"];
string lifestory = Request["lifestory"];
string nation = Request["nation"];
string dob = DateTime.Parse(Request["dob"]).ToString("yyyy-MM-dd");
authorDAO.AddAuthor(author_name, lifestory, nation, dob);
//add a connection between book and new author
authorDAO.AddAuthorForBook(authorDAO.getLastId(), bid);
}
return(RedirectToAction("Index", "Manage"));
}
public ActionResult IndexPost()
{
//get properties of book
string[] category_ids = Request["category"].Split(',');
string title = Request["title"];
string img = Request["img"];
string languge = Request["language"];
string des = Request["description"];
account a = (account)Session["user"];
BookDAO bd = new BookDAO();
//add book to database
bd.addBook(title, des, a.Username, languge, img);
//get id of current book
int bid = bd.getLastId();
//add all the categories of book to book_categories
for (int i = 0; i < category_ids.Length - 1; i++)
{
int cid = Int32.Parse(category_ids[i]);
bd.addCforlast(cid, bid);
}
AuthorDAO authorDAO = new AuthorDAO();
//check if book's author is already existed
if (Request["isNewAuthor"] == null)
{
//add a connection between book and author
int aid = Int32.Parse(Request["authorid"]);
authorDAO.AddAuthorForBook(aid, bid);
}
else
{
//create new author
string author_name = Request["author_name"];
string lifestory = Request["lifestory"];
string nation = Request["nation"];
string dob = DateTime.Parse(Request["dob"]).ToString("yyyy-MM-dd");
authorDAO.AddAuthor(author_name, lifestory, nation, dob);
//add a connection between book and new author
authorDAO.AddAuthorForBook(authorDAO.getLastId(), bid);
}
return(RedirectToAction("Index", "Manage"));
}
