public ActionResult DeleteConfirmed(string id) { publishers publishers = db.publishers.Find(id); db.publishers.Remove(publishers); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "pub_id,pub_name,city,state,country")] publishers publishers) { if (ModelState.IsValid) { db.Entry(publishers).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.pub_id = new SelectList(db.pub_info, "pub_id", "pr_info", publishers.pub_id); return(View(publishers)); }
// GET: publishers/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } publishers publishers = db.publishers.Find(id); if (publishers == null) { return(HttpNotFound()); } return(View(publishers)); }
// GET: publishers/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } publishers publishers = db.publishers.Find(id); if (publishers == null) { return(HttpNotFound()); } ViewBag.pub_id = new SelectList(db.pub_info, "pub_id", "pr_info", publishers.pub_id); return(View(publishers)); }
public ActionResult DeleteConfirmed(string id) { var constring = System.Configuration.ConfigurationManager.ConnectionStrings["pubsEntities"].ConnectionString; if (constring.ToLower().StartsWith("metadata=")) { System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder efBuilder = new System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder(constring); constring = efBuilder.ProviderConnectionString; } var con = new SqlConnection(constring); con.Open(); string query = "SELECT COUNT(*) FROM employee"; var cmd = new SqlCommand(query, con); int rowsAmount = (int)cmd.ExecuteScalar(); employee employee; for (int i = 0; i < rowsAmount; i++) { employee = db.employee.FirstOrDefault(m => m.pub_id == id); if (employee == null) { } else { db.employee.Remove(employee); db.SaveChanges(); } } query = "SELECT COUNT(*) FROM pub_info"; cmd = new SqlCommand(query, con); rowsAmount = (int)cmd.ExecuteScalar(); pub_info pub_Info; for (int i = 0; i < rowsAmount; i++) { pub_Info = db.pub_info.FirstOrDefault(m => m.pub_id == id); if (pub_Info == null) { } else { db.pub_info.Remove(pub_Info); db.SaveChanges(); } } query = "SELECT COUNT(*) FROM titles"; cmd = new SqlCommand(query, con); rowsAmount = (int)cmd.ExecuteScalar(); titles titles; for (int i = 0; i < rowsAmount; i++) { titles = db.titles.FirstOrDefault(m => m.pub_id == id); if (titles == null) { } else { db.titles.Remove(titles); db.SaveChanges(); } } publishers publishers = db.publishers.Find(id); db.publishers.Remove(publishers); db.SaveChanges(); return(RedirectToAction("Index")); }