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