public ActionResult Edit([Bind(Include = "title_id,title1,type,pub_id,price,advance,royalty,ytd_sales,notes,pubdate")] title title, string[] author_ids)
{
if (ModelState.IsValid)
{
foreach (var ta in db.titleauthors.Where(ta => ta.title_id == title.title_id).ToList())
{
db.titleauthors.Remove(ta);
}
foreach (var aid in author_ids)
{
titleauthor ta = new titleauthor();
ta.au_id = aid;
ta.title_id = title.title_id;
db.titleauthors.Add(ta);
}
db.Entry(title).State = EntityState.Modified;
db.SaveChanges();
TempData["message_css"] = "alert alert-success";
TempData["message"] = "Successful";
return(RedirectToAction("Index"));
}
ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", title.pub_id);
ViewBag.author_ids = new MultiSelectList(db.authors.Select(a => new { id = a.au_id, au_fulname = a.au_lname + " " + a.au_fname }), "id", "au_fulname");
TempData["message_css"] = "alert alert-danger";
TempData["message"] = "Invalid input";
return(View(title));
}
public ActionResult Create([Bind(Include = "au_id,title_id,au_ord,royaltyper")] titleauthor titleauthor)
{
if (ModelState.IsValid)
{
var test = db.titleauthors.Find(titleauthor.au_id, titleauthor.title_id); //find if au_id and title_id (prim key's) already exists as a combination
if (test == null)
{
db.titleauthors.Add(titleauthor);
try
{
db.SaveChanges();
}
catch (Exception e) //sql exception
{
return(RedirectToAction("../Home/Error"));
}
}
else //value already exists
{
return(RedirectToAction("../Home/Error"));
}
return(RedirectToAction("Index"));
}
ViewBag.au_id = new SelectList(db.authors, "au_id", "au_lname", titleauthor.au_id);
ViewBag.title_id = new SelectList(db.titles, "title_id", "title1", titleauthor.title_id);
return(View(titleauthor));
}
public ActionResult DeleteConfirmed(string id)
{
titleauthor titleauthor = db.titleauthors.Find(id);
db.titleauthors.Remove(titleauthor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(string id)
{
string[] splitid = id.Split(',');
titleauthor titleauthor = db.titleauthor.Find(splitid[0], splitid[1]);
db.titleauthor.Remove(titleauthor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: titleauthors/Details/5
public ActionResult Details(string au_id, string title_id)
{
titleauthor titleauthor = db.titleauthor.Find(au_id, title_id);
if (titleauthor == null)
{
return(HttpNotFound());
}
return(View(titleauthor));
}
public ActionResult Edit([Bind(Include = "au_id,title_id,au_ord,royaltyper")] titleauthor titleauthor)
{
if (ModelState.IsValid)
{
db.Entry(titleauthor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.au_id = new SelectList(db.authors, "au_id", "au_lname", titleauthor.au_id);
ViewBag.title_id = new SelectList(db.titles, "title_id", "title1", titleauthor.title_id);
return(View(titleauthor));
}
// GET: titleauthors/Edit/5
public ActionResult Edit(string au_id, string title_id)
{
titleauthor titleauthor = db.titleauthor.Find(au_id, title_id);
if (titleauthor == null)
{
return(HttpNotFound());
}
ViewBag.au_id = new SelectList(db.authors, "au_id", "au_lname", titleauthor.au_id);
ViewBag.title_id = new SelectList(db.titles, "title_id", "title", titleauthor.title_id);
return(View(titleauthor));
}
// GET: titleauthors/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
titleauthor titleauthor = db.titleauthors.Find(id);
if (titleauthor == null)
{
return(HttpNotFound());
}
return(View(titleauthor));
}
public ActionResult DeleteConfirmed(string au_id, string title_id)
{
titleauthor titleauthor = db.titleauthors.Find(au_id, title_id);
db.titleauthors.Remove(titleauthor);
try
{
db.SaveChanges();
}
catch (Exception e)
{
return(RedirectToAction("../Home/Error"));
}
return(RedirectToAction("Index"));
}
// GET: titleauthors/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string[] splitid = id.Split(',');
titleauthor titleauthor = db.titleauthor.Find(splitid[0], splitid[1]);
if (titleauthor == null)
{
return(HttpNotFound());
}
return(View(titleauthor));
}
// GET: titleauthors/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
titleauthor titleauthor = db.titleauthors.Find(id);
if (titleauthor == null)
{
return(HttpNotFound());
}
ViewBag.au_id = new SelectList(db.authors, "au_id", "au_lname", titleauthor.au_id);
ViewBag.title_id = new SelectList(db.titles, "title_id", "title1", titleauthor.title_id);
return(View(titleauthor));
}
// GET: titleauthors/Details/5
public ActionResult Details(string au_id, string title_id)
{
if (au_id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (title_id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
titleauthor titleauthor = db.titleauthors.Find(au_id, title_id);
if (titleauthor == null)
{
return(HttpNotFound());
}
ViewBag.au_id = new SelectList(db.titleauthors, "au_id", "au_id", titleauthor.au_id);
ViewBag.title_id = new SelectList(db.titleauthors, "title_id", "title_id", titleauthor.title_id);
return(View(titleauthor));
}