PDF Watermark in MVC

Hello friends

In this example, we will learn how to add watermark to existing pdf file in Asp.net MVC.

To download this example Click here

Steps:
1.Add an empty MVC Project.
2.Add reference of itextsharp.dll assembly.
3.Add PdfWaterMark controller.
4.Create View For Index Action.
5.Following is the code in PdfWaterMarkController.

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Web;
	using System.Web.Mvc;
	using BlogMVC.Models;
	using System.IO;
	using iTextSharp.text.pdf;
	using iTextSharp.text;
	namespace BlogMVC.Controllers
	{
	public class PdfWaterMarkController : Controller
	{
	//
	// GET: /PdfWaterMark/
	public ActionResult Index()
	{
	return View();
	}
	[HttpPost]
	public FileResult Index(WatermarkViewModel model)
	{
	if (System.IO.File.Exists(Server.MapPath("~/Download/") + model.OutputFileName))
	System.IO.File.Delete(Server.MapPath("~/Download/") + model.OutputFileName);
	model.SourceFile.SaveAs(Server.MapPath("~/Download/") + Path.GetFileName(model.SourceFile.FileName));
	string startFile = Server.MapPath("~/Download/") + Path.GetFileName(model.SourceFile.FileName);
	string watermarkedFile = Server.MapPath("~/Download/") + model.OutputFileName;
	// Creating watermark on a separate layer
	// Creating iTextSharp.text.pdf.PdfReader object to read the Existing PDF Document produced by 1 no.
	PdfReader reader1 = new PdfReader(startFile);
	FileStream fs2 = new FileStream(watermarkedFile, FileMode.OpenOrCreate, FileAccess.Write, FileShare.None);
	// Creating iTextSharp.text.pdf.PdfStamper object to write Data from iTextSharp.text.pdf.PdfReader object to FileStream object
	PdfStamper stamper = new PdfStamper(reader1, fs2);
	// Getting total number of pages of the Existing Document
	int pageCount = reader1.NumberOfPages;
	// Create New Layer for Watermark
	PdfLayer layer = new PdfLayer("WatermarkLayer", stamper.Writer);
	// Loop through each Page
	for (int i = 1; i <= pageCount; i++)
	{
	// Getting the Page Size
	Rectangle rect = reader1.GetPageSize(i);
	// Get the ContentByte object
	PdfContentByte cb = stamper.GetUnderContent(i);
	// Tell the cb that the next commands should be "bound" to this new layer
	cb.BeginLayer(layer);
	cb.SetFontAndSize(BaseFont.CreateFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED), 35);
	PdfGState gState = new PdfGState();
	gState.FillOpacity = 0.2f;
	cb.SetGState(gState);
	cb.SetColorFill(BaseColor.BLACK);
	cb.BeginText();
	cb.ShowTextAligned(PdfContentByte.ALIGN_CENTER, model.WaterMarkText, rect.Width / 2, rect.Height / 2, 45f);
	cb.EndText();
	// Close the layer
	cb.EndLayer();
	}
	stamper.Close();
	fs2.Close();
	// Removing the layer created above
	// 1. First we bind a reader to the watermarked file
	// 2. Then strip out a branch of things
	// 3. Finally use a simple stamper to write out the edited reader
	PdfReader reader2 = new PdfReader(watermarkedFile);
	// NOTE: This will destroy all layers in the Document, only use if you don't have any addtional layers
	// Remove the OCG group completely from the Document: reader2.Catalog.Remove(PdfName.OCPROPERTIES);
	// Clean up the reader, optional
	reader2.RemoveUnusedObjects();
	// Placeholder variables
	PRStream stream;
	string content;
	PdfDictionary page;
	PdfArray contentArray;
	// Get the number of pages
	int pageCount2 = reader2.NumberOfPages;
	// Loop through each page
	for (int i = 1; i <= pageCount2; i++)
	{
	// Get the page
	page = reader2.GetPageN(i);
	// Get the raw content
	contentArray = page.GetAsArray(PdfName.CONTENTS);
	if (contentArray != null)
	{
	// Loop through content
	for (int j = 0; j < contentArray.Size; j++)
	{
	stream = (PRStream)contentArray.GetAsStream(j);
	// Convert to a String, NOTE: you might need a different encoding here
	content = System.Text.Encoding.ASCII.GetString(PdfReader.GetStreamBytes(stream));
	//Look for the OCG token in the stream as well as our watermarked text
	if (content.IndexOf("/OC") >= 0 && content.IndexOf(model.WaterMarkText) >= 0)
	{
	//Remove it by giving it zero length and zero data
	stream.Put(PdfName.LENGTH, new PdfNumber(0));
	stream.SetData(new byte[0]);
	}
	}
	}
	}
	return File("~/Download/" + model.OutputFileName, System.Net.Mime.MediaTypeNames.Application.Octet, Path.GetFileName("~/Download/" + model.OutputFileName));
	}
	}
	}

view raw PdfWaterMarkController.cs hosted with ❤ by GitHub

6.Following is the code in Index.cshtml.

	@model BlogMVC.Models.WatermarkViewModel
	@{
	ViewBag.Title = "Index";
	}
	<h2>Index</h2>
	@using (Html.BeginForm("Index", "PdfWaterMark", FormMethod.Post, new { enctype = "multipart/form-data" }))
	{
	<label>Source Pdf File:</label>
	<input type="file" name="SourceFile" /><br /><br />
	<label>Watermark Text:</label>
	@Html.TextBoxFor(m => m.WaterMarkText)<br /><br />
	<label>Output File Name:</label>
	@Html.TextBoxFor(m => m.OutputFileName)
	<br /><br />
	<button type="submit">Download Watermark Pdf</button>
	}

view raw Index.cshtml hosted with ❤ by GitHub

7.Add WaterMark class file in Models Folder with the following code.

	public class WatermarkViewModel
	{
	public HttpPostedFileBase SourceFile { get; set; }
	public string WaterMarkText { get; set; }
	public string OutputFileName { get; set; }
	}

view raw Watermark.cs hosted with ❤ by GitHub

8.Add Download folder in your solution to save and create the output file.
9.Following is the screen shots for your help.

If you have any queries regarding this example post ur comment or send mail to ranjeetpatil4545@gmail.com

Thank You

DetailsView CRUD Operations

Hello friends

In this example, we will learn how to perform “CRUD Operations on Detailsview”

In this example, I am using Employee Table

Table script:

	CREATE TABLE tbl_Employee
	(
	EmpId INT Primary key IDENTITY (100, 1) NOT NULL,
	EmpName VARCHAR (50) NOT NULL,
	EmpDesig VARCHAR (50) NOT NULL,
	EmpSalary MONEY NOT NULL
	);

view raw tbl_Employee.sql hosted with ❤ by GitHub

Source Code:

	<html xmlns="http://www.w3.org/1999/xhtml">
	<head runat="server">
	<title>DetailsView CRUD Operations</title>
	</head>
	<body>
	<form id="form1" runat="server">
	<div align="center">
	<asp:DetailsView ID="Detailsview1" runat="server"
	OnItemUpdating="Detailsview1_ItemUpdating" AutoGenerateRows="False"
	OnPageIndexChanging="Detailsview1_PageIndexChanging" AllowPaging="True"
	OnItemDeleting="Detailsview1_ItemDeleting"
	OnItemInserting="Detailsview1_ItemInserting"
	OnModeChanging="Detailsview1_ModeChanging" DataKeyNames="EmpId"
	OnDataBound="Detailsview1_DataBound" CellPadding="4"
	ForeColor="#333333" GridLines="None">
	<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
	<CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
	<EditRowStyle BackColor="#999999" />
	<FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />
	<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
	<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
	<PagerStyle BackColor="#284775" ForeColor="White"
	HorizontalAlign="Center" />
	<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
	<Fields>
	<asp:BoundField ReadOnly="true" HeaderText="Employee Id"
	DataField="EmpId" />
	<asp:BoundField HeaderText="Employee Name" DataField="EmpName" />
	<asp:BoundField HeaderText="Employee Designation"
	DataField="EmpDesig" />
	<asp:BoundField HeaderText="Employee Salary" DataField="EmpSalary"
	DataFormatString="{0:c}" />
	<asp:CommandField ButtonType="Button" ShowEditButton="true"
	ShowInsertButton="true" ShowDeleteButton="true"/>
	</Fields>
	</asp:DetailsView>
	</div>
	</form>
	</body>
	</html>

view raw detailsviewcrud.aspx hosted with ❤ by GitHub

C# Code:

	using System;
	using System.Data;
	using System.Data.SqlClient;
	using System.Web.UI.WebControls;
	public partial class DetailsViewCRUD : System.Web.UI.Page
	{
	SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial
	Catalog=Ranjeet;Integrated Security=True;Connect
	Timeout=30;Encrypt=False;TrustServerCertificate=False");
	protected void Page_Load(object sender, EventArgs e)
	{
	if (!IsPostBack)
	data();
	}
	void data()
	{
	string query = "select EmpId,EmpName,EmpDesig,EmpSalary from
	tbl_Employee";
	SqlDataAdapter da = new SqlDataAdapter(query,con);
	DataSet ds = new DataSet();
	da.Fill(ds);
	Detailsview1.DataSource = ds.Tables[0];
	Detailsview1.DataBind();
	}
	protected void Detailsview1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
	{
	try
	{
	string Id = e.Keys["EmpId"].ToString();
	string txtName = ((TextBox)Detailsview1.Rows[1].Cells[1].Controls[0]).Text.Trim();
	string txtDesig =
	((TextBox)Detailsview1.Rows[2].Cells[1].Controls[0]).Text.Trim();
	string txtSalary =
	((TextBox)Detailsview1.Rows[3].Cells[1].Controls[0]).Text.Trim();
	string query = string.Format("Update tbl_Employee set
	EmpName='{0}',EmpDesig='{1}',EmpSalary='{2}' where EmpId={3}",
	txtName, txtDesig, txtSalary, Id);
	con.Open();
	SqlCommand cmd = new SqlCommand();
	cmd.CommandText = query;
	cmd.Connection = con;
	int count = cmd.ExecuteNonQuery();
	if (count > 0)
	{
	Response.Write("<script type='text/javascript'>alert('Record Updated Successfully')</script>");
	Detailsview1.ChangeMode(DetailsViewMode.ReadOnly);
	data();
	}
	else
	{
	Response.Write("<script type='text/javascript'>alert('Something Went Wrong')</script>");
	}
	}
	catch (Exception ex)
	{
	Response.Write(ex.Message);
	}
	finally
	{
	con.Close();
	}
	}
	protected void Detailsview1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
	{
	Detailsview1.PageIndex = e.NewPageIndex;
	data();
	}
	protected void Detailsview1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e)
	{
	try
	{
	string Id = e.Keys["EmpId"].ToString();
	con.Open();
	string query = string.Format("delete from tbl_Employee where EmpId={0}", Id);
	SqlCommand cmd = new SqlCommand();
	cmd.CommandText = query;
	cmd.Connection = con;
	int count = cmd.ExecuteNonQuery();
	if (count > 0)
	{
	Response.Write("<script type='text/javascript'>alert('Record
	Deleted Successfully')</script>");
	data();
	}
	else
	{
	Response.Write("<script type='text/javascript'>alert('Something Went Wrong')</script>");
	}
	}
	catch (Exception ee)
	{
	Response.Write(ee.Message);
	}
	finally
	{
	con.Close();
	}
	}
	protected void Detailsview1_ModeChanging(object sender, DetailsViewModeEventArgs e)
	{
	if (e.NewMode == DetailsViewMode.Edit)
	{
	Detailsview1.ChangeMode(DetailsViewMode.Edit);
	data();
	}
	else if (e.NewMode == DetailsViewMode.Insert)
	{
	Detailsview1.ChangeMode(DetailsViewMode.Insert);
	}
	else if (e.NewMode == DetailsViewMode.ReadOnly)
	{
	Detailsview1.ChangeMode(DetailsViewMode.ReadOnly);
	data();
	}
	}
	protected void Detailsview1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
	{
	try
	{
	string txtName = ((TextBox)Detailsview1.Rows[1].Cells[1].Controls[0]).Text.Trim();
	string txtDesig = ((TextBox)Detailsview1.Rows[2].Cells[1].Controls[0]).Text.Trim();
	string txtSalary = ((TextBox)Detailsview1.Rows[3].Cells[1].Controls[0]).Text.Trim();
	string query =string.Format("insert into tbl_Employee
	values('{0}','{1}','{2}')",txtName,txtDesig,txtSalary);
	con.Open();
	SqlCommand cmd = new SqlCommand();
	cmd.CommandText = query;
	cmd.Connection = con;
	int count = cmd.ExecuteNonQuery();
	if (count > 0)
	{
	Response.Write("<script type='text/javascript'>alert('Record Inserted Successfully')</script>");
	Detailsview1.ChangeMode(DetailsViewMode.ReadOnly);
	data();
	}
	else
	{
	Response.Write("<script type='text/javascript'>alert('Something Went Wrong')</script>");
	}
	}
	catch (Exception ee)
	{
	Response.Write(ee.Message);
	}
	finally
	{
	con.Close();
	}
	}
	protected void Detailsview1_DataBound(object sender, EventArgs e)
	{
	if (Detailsview1.CurrentMode == DetailsViewMode.Insert)
	((TextBox)Detailsview1.Rows[0].Cells[1].Controls[0]).Enabled = false;
	}
	}
	}

view raw detailsviewcrud.aspx.cs hosted with ❤ by GitHub

Detailsview1_DataBound : In this event when the details view is in 

Insert mode then I'm making EmpId textbox as disable this is why because 

in database i made EmpId column as identity means autoincrement. 

therefore there is no need to give Empid database will automatically get 

it so sending empid is useless.

Detailsview in Readonly Mode:

Detailsview in Edit Mode :

DetailsView in Insert Mode:

If you have any queries regarding this example or Detailsview control post ur comment or send mail to

ranjeetpatil4545@gmail.com

Thank You