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