public ActionResult DeleteConfirmed(int id) { tblauthors tblauthors = db.tblauthors.Find(id); db.tblauthors.Remove(tblauthors); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,AuthorName,creationDate,UpdationDate")] tblauthors tblauthors) { if (ModelState.IsValid) { db.Entry(tblauthors).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblauthors)); }
public ActionResult Create([Bind(Include = "id,AuthorName,creationDate,UpdationDate")] tblauthors tblauthors) { if (ModelState.IsValid) { db.tblauthors.Add(tblauthors); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblauthors)); }
// GET: Admin/tblauthors/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblauthors tblauthors = db.tblauthors.Find(id); if (tblauthors == null) { return(HttpNotFound()); } return(View(tblauthors)); }
public ActionResult Create(tblauthors authors) { string mainconn = ConfigurationManager.ConnectionStrings["Model1"].ConnectionString; SqlConnection sqlcon = new SqlConnection(mainconn); string sqlquery = "insert into [dbo].[tblauthors] (AuthorName) values (@AuthorName)"; SqlCommand sqlcomm = new SqlCommand(sqlquery, sqlcon); sqlcon.Open(); sqlcomm.Parameters.AddWithValue("@AuthorName", authors.AuthorName); sqlcomm.ExecuteNonQuery(); sqlcon.Close(); return(RedirectToAction("Index")); }