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