void AddNewPublisher() { try { SqlConnection con = new SqlConnection(strcon); if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("Insert Into dbo.publisher_master_tbl(publisher_id, publisher_name) values(@publisher_id, @publisher_name)", con); cmd.Parameters.AddWithValue("@publisher_id", TextBox_PublisherId.Text.Trim()); cmd.Parameters.AddWithValue("@publisher_name", TextBox_PublisherName.Text.Trim()); cmd.ExecuteNonQuery(); con.Close(); Response.Write("<script>alert('Author added Successfully');</script>"); ClearForm(); PublisherTable.DataBind(); } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } }
void DeletePublisherById() { try { SqlConnection con = new SqlConnection(strcon); if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("Delete from dbo.publisher_master_tbl Where publisher_id='" + TextBox_PublisherId.Text.Trim() + "'", con); int result = cmd.ExecuteNonQuery(); con.Close(); if (result > 0) { Response.Write("<script>alert('Publisher Deleted Successfully');</script>"); ClearForm(); PublisherTable.DataBind(); } else { Response.Write("<script>alert('Publisher Id does not Exist');</scriot>"); } } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } }
void UpdatePublisherById() { try { SqlConnection con = new SqlConnection(strcon); if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("Update dbo.publisher_master_tbl Set publisher_name=@publisher_name Where publisher_id='" + TextBox_PublisherId.Text.Trim() + "'", con); cmd.Parameters.AddWithValue("@publisher_name", TextBox_PublisherName.Text.Trim()); int result = cmd.ExecuteNonQuery(); con.Close(); if (result > 0) { Response.Write("<script>alert('Publisher Updated Successfully');</script>"); PublisherTable.DataBind(); } else { Response.Write("<script>alert('Publisher Id does not Exist');</script>"); } } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } }
public ActionResult Remove(int id) { PublisherTable publisher = db.PublisherTables.Find(id); db.PublisherTables.Remove(publisher); db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public ActionResult Edit(int id) { if (ModelState.IsValid) { PublisherTable publisher = db.PublisherTables.Find(id); if (TryUpdateModel(publisher, "", new string[] { "PublisherName", "P_Email", "P_PhoneNumber", "P_Address" })) { db.SaveChanges(); return(RedirectToAction("Index", "Home")); } } return(RedirectToAction("Index", "Home")); }
public ActionResult Create(PublisherViewModel viewModel) { if (ModelState.IsValid) { PublisherTable publisher = new PublisherTable(); publisher.PublisherName = viewModel.PublisherName1; publisher.P_Address = viewModel.PublichserAddress1; publisher.P_Email = viewModel.PublisherEmail1; publisher.P_PhoneNumber = viewModel.PublisherPhoneNumber1; db.PublisherTables.Add(publisher); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } else { return(RedirectToAction("About", "Home")); } }
public ActionResult Edit(int?id) { if (Convert.ToBoolean(Session["IsAdmin"]) == true) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PublisherTable publisher = db.PublisherTables.Find(id); if (publisher == null) { return(HttpNotFound()); } return(View(publisher)); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Detail(int?id) { if (Session["UserID"] != null) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PublisherTable publisher = db.PublisherTables.Find(id); if (publisher == null) { return(HttpNotFound()); } return(View(publisher)); } else { return(RedirectToAction("Index", "Home")); } }
protected void Page_Load(object sender, EventArgs e) { PublisherTable.DataBind(); }