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