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