Payroll Management System asp.net project with source code

Payroll Management System asp.net project with source code Part

Step #1:

Open Visual Studio 2010

click on --> file menu

select--> New---select --->website

select empty web application

give project name as "PayrollMgtProject"

Step #2: Add a webpage that name is "Default.aspx" and write following html code

<title>Payroll Management system</title>

<style>

#headder

{

<%-- background-image:url(Imgs/FMS2.png);--%>

background-repeat:no-repeat;

height:100%;

background-position: center;

background-size: cover;

background

}

</style>

</head>

<body>

<div>

<a class="navbar-brand js-scroll-trigger" href="#page-top">Payroll Management system</a>

</button>

<%-- <li class="nav-item mx-0 mx-lg-1"><a class="nav-link py-3 px-0 px-lg-3 rounded js-scroll-trigger" href="#portfolio">Portfolio</a></li>--%>

<li class="nav-item mx-0 mx-lg-1"><a class="nav-link py-3 px-0 px-lg-3 rounded js-scroll-trigger" href="#about">About</a></li>

<li class="nav-item mx-0 mx-lg-1"><a class="nav-link py-3 px-0 px-lg-3 rounded js-scroll-trigger" href="#contact">Contact</a></li>

<li class="nav-item mx-0 mx-lg-1"><a class="nav-link py-3 px-0 px-lg-3 rounded js-scroll-trigger" href="signin.aspx">SignIn</a></li>

<li class="nav-item mx-0 mx-lg-1"><a class="nav-link py-3 px-0 px-lg-3 rounded js-scroll-trigger" href="signup.aspx">SignUp</a></li>

</ul>

</div>

</nav>

<%--<img class="masthead-avatar mb-5" src=" " alt="..." />--%>

<%--<h1 class="masthead-heading text-uppercase mb-0">Faculty Management System</h1>--%>

</div>

<p class="masthead-subheading font-weight-light mb-0" style="color:Yellow">This System Should Keep track of Manager & Employee records</p>

</div>

</header>

<h2 class="page-section-heading text-center text-uppercase text-white">About</h2>

</div>

<div class="col-lg-4 ml-auto"><p class="lead"> Payroll Management system helps the faculty to communicate easily with students, to give students access to class documents, and for the convenience and transparency of the online gradebook. ... Generate flexible and reliable reports to manage faculty and staff effectively.</p></div>

<div class="col-lg-4 mr-auto"><p class="lead"> TO Manage faculty data, track their acticities and monitor

performance via a centralized faculty management system software

which stores all the information in a single database.

with the help of smart tools you get enhanced connectivity, accelerated progress and ensured compliance.</p></div>

</div>

</a>

</div>

</section>

<h2 class="page-section-heading text-center text-uppercase text-secondary mb-0">Contact Me</h2>

</div>

<asp:TextBox ID="name" class="form-control" placeholder="Please enter your name." runat="server"></asp:TextBox>

</div>

<label>Email Address</label>

<asp:TextBox ID="email" class="form-control" placeholder="Please enter your Email Address" runat="server"></asp:TextBox>

</div>

<label>Phone Number</label>

<asp:TextBox ID="phone" class="form-control" placeholder="Please enter your Phone Number" runat="server"></asp:TextBox>

</div>

<label>Message</label>

<asp:TextBox ID="message" class="form-control" placeholder="your Message" runat="server" TextMode="MultiLine"></asp:TextBox>

</div>

<br />

<%--<div class="form-group"><button class="btn btn-primary btn-xl" id="sendMessageButton" type="submit">Send</button>--%>

<asp:Button ID="sendMessageButton" runat="server" class="btn btn-primary btn-xl" Text="Send" OnClick="sendMessageButton_Click"></asp:Button>

</div>

</form>

</div>

</section>

<h4 class="text-uppercase mb-4">Location</h4>

772 4th block Bangalore

<br />

Karnataka India, 560041

</p>

</div>

<h4 class="text-uppercase mb-4">Around the Web</h4>

</div>

<h4 class="text-uppercase mb-4">About Payroll Management system</h4>

FMS This System Should Keep track of Payroll Management system records, created by

<a href="http://www.youtube.com/coderbaba">Payroll Management system.com</a>

</p>

</div>

</footer>

<small>

document.write(new Date().getFullYear());

</script>

</small>

</div>

</div>

</button>

<h2 class="portfolio-modal-title text-secondary text-uppercase mb-0" id="portfolioModal1Label">Log Cabin</h2>

</div>

<p class="mb-5"> Lorem your text here</p>

Close Window

</button>

</div>

</button>

<h2 class="portfolio-modal-title text-secondary text-uppercase mb-0" id="portfolioModal2Label">Tasty Cake</h2>

</div>

Close Window

</button>

</div>

</button>

<h2 class="portfolio-modal-title text-secondary text-uppercase mb-0" id="portfolioModal3Label">Circus Tent</h2>

</div>

Close Window

</button>

</div>

</button>

<h2 class="portfolio-modal-title text-secondary text-uppercase mb-0" id="portfolioModal4Label">Controller</h2>

</div>

Close Window

</button>

</div>

</button>

<h2 class="portfolio-modal-title text-secondary text-uppercase mb-0" id="portfolioModal5Label">Locked Safe</h2>

</div>

Close Window

</button>

</div>

</button>

<h2 class="portfolio-modal-title text-secondary text-uppercase mb-0" id="portfolioModal6Label">Submarine</h2>

</div>

Close Window

</button>

</div>

</div>

</form>

</body>

</html>

---------------------------------------------------------

Step 3#:
create a new page signin.aspx

<title>signin</title>

</head>

<div>

<a class="navbar-brand" href="Default.aspx">Faculty Management System</a>

Home

<span class="sr-only">(current)</span>

</a>

</li>

<%--<li class="nav-item"><a class="nav-link" href="#!">About</a></li>

<li class="nav-item"><a class="nav-link" href="#!">Services</a></li>

<li class="nav-item"><a class="nav-link" href="#!">Contact</a></li>--%>

</ul>

</div>

</nav>

<br />

<asp:Panel ID="pnl_warning" runat="server" Visible="false">

<asp:Label ID="lbl_warning" runat="server" Text="Label" CssClass="col-form-label text-center"></asp:Label>

</div>

</asp:Panel>

<br />

</div>

<h4 class="card-title">Secure Login</h4>

<tr>

<td>Email ID:</td>

<td>

<asp:TextBox ID="txtEmail" CssClass="form-control" runat="server" autofocus="" placeholder="Enter Email"></asp:TextBox>

<asp:RequiredFieldValidator ID="rqr_emil" runat="server" ErrorMessage="Enter Email" ControlToValidate="txtEmail" Display="Dynamic" ForeColor="Red"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<td>Password:</td>

<td>

<asp:TextBox ID="txtPassword" CssClass="form-control" runat="server" placeholder="Enter password" TextMode="Password" onfocus="showPass()"></asp:TextBox>

<asp:RequiredFieldValidator ID="rqr_pass" runat="server" ErrorMessage="Enter password" ControlToValidate="txtPassword" Display="Dynamic" ForeColor="Red"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<asp:CheckBox ID="chk_remember" runat="server" CssClass="form-check-input remembermecustom" />

Remember Password</label>

</div>

<asp:CheckBox ID="CheckBox2" runat="server" CssClass="form-check-input remembermecustom" />

Keep last ID & Password

</label>

</div>

</td>

</tr>

<tr>

<asp:Button ID="btnlogin" CssClass=" btn btn-success btn-block" runat="server" Text="Login"

onclick="btnlogin_Click" /></td>

<%--<td> <asp:Button ID="btncancel" CssClass=" btn btn-danger" runat="server"

Text="Cancel" onclick="btncancel_Click" /></td>--%>

</tr>

</table>

</div>

<div class="card-footer"><a class="btn btn-link" href="signup.aspx">New Account SignUp!</a></div>

</div>

</div>

<br />

</footer>

</div>

</form>

function showPass() {

var cookies = document.cookie;

var allcookie = cookies.split(";");

for (ctr = 0; ctr < allcookie.length; ctr++) {

var dt = allcookie[ctr];

var str = dt.split("=");

if (str[0].trim() == document.getElementById("txtEmail").value.trim()) {

document.getElementById("txtPassword").value = str[1];

break;

}

function showBoth() {

var cookies = document.cookie;

var allcookie = cookies.split(";");

for (c = 0; c < allcookie.length; c++) {

var a = allcookie[c];

var v = a.split("=");

if (v[0].trim() == "erplastid")

document.getElementById("txtEmail").value = v[1];

if (v[0].trim() == "erplastpass") {

document.getElementById("txtPassword").value = v[1];

break; }

}

</script>

</body>

</html>

-------------------------------------------------------

Step 4#:

Write Following C# code Signin.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

public partial class signin : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

public string GetConnectionString()

{

return System.Configuration.ConfigurationManager.ConnectionStrings["PMS"].ConnectionString;

}

protected void btnlogin_Click(object sender, EventArgs e)

{

if (IsFormValid())

{

using (SqlConnection con = new SqlConnection(GetConnectionString()))

{

SqlCommand cmd = new SqlCommand("usp_UsersCheckLoginDetails", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@UserName", txtEmail.Text.Trim());

cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());

try

{

if (con.State == ConnectionState.Closed)

{

con.Open();

}

SqlDataReader dr = cmd.ExecuteReader();

if (dr.HasRows)

{

while (dr.Read())

{

if (chk_remember.Checked)

{

HttpCookie co = new HttpCookie(txtEmail.Text, txtPassword.Text);

co.Expires = DateTime.Now.AddMonths(1);

Response.Cookies.Add(co);

}

if (CheckBox2.Checked)

{

HttpCookie co1 = new HttpCookie("erplastid", txtEmail.Text);

co1.Expires = DateTime.Now.AddMonths(1);

Response.Cookies.Add(co1);

HttpCookie co2 = new HttpCookie("erplastpass", txtPassword.Text);

co2.Expires = DateTime.Now.AddMonths(1);

Response.Cookies.Add(co2);

}

Response.Write("<script>alert('" + dr.GetValue(0).ToString() + "')</script>");

Session["UserName"] = dr.GetValue(0).ToString();

Session["UserEmail"] = dr.GetValue(1).ToString();

Session["UserType"] = dr.GetValue(3).ToString();

}

if (Session["UserType"].ToString() == "Admin")

{

Response.Redirect("Admin/Home.aspx");

}

else if (Session["UserType"].ToString() == "Manager")

{

Response.Redirect("Manager/Home.aspx");

}

else if (Session["UserType"].ToString() == "Employee")

{

Response.Redirect("Employee/Home.aspx");

}

else

{

Response.Redirect("~/logout.aspx");

}

else

{

Response.Write("<script>alert('Invalid UserID or Password...Try again')</script>");

txtEmail.Text = string.Empty;

txtPassword.Text = string.Empty;

pnl_warning.Visible = true;

lbl_warning.Text = "Use correct email and password</br>";

}

catch (Exception ex)

{

pnl_warning.Visible = true;

lbl_warning.Text = "Something went wrong! Contact your devloper </br>" + ex.Message;

}

finally

{

con.Close();

}

else

{

pnl_warning.Visible = true;

lbl_warning.Text = "Please fill all the requirements";

}

private bool IsFormValid()

{

if (txtEmail.Text == string.Empty)

{

Response.Write("<script>alert('UserID is required')</script>");

txtEmail.Text = string.Empty;

txtEmail.Focus();

return false;

}

if (txtPassword.Text == string.Empty)

{

Response.Write("<script>alert('UserID is required')</script>");

txtPassword.Text = string.Empty;

txtPassword.Focus();

return false;

}

return true;

}

------------------------

Step #5:

create following folder

1-Admin

2-assests

3-css

4-Employee

5-Imgs

6-js

7-Manager

Download All Folder from here

Step #6:

create a master page inside admin folder named "AdminMasterPage.master" add following html

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="AdminMasterPage.master.cs" Inherits="Admin_AdminMasterPage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<asp:ContentPlaceHolder id="head" runat="server">

</asp:ContentPlaceHolder>

</head>

<body>

<div>

<a class="navbar-brand" href="Home.aspx">Payroll Management system</a>

Home

<span class="sr-only">(current)</span>

</a>

</li>

<li class="nav-item"><a class="nav-link" href="AddEmployee.aspx">Add Employee</a></li>

<li class="nav-item"><a class="nav-link" href="#">Setting</a></li>

<asp:Label ID="lb1" CssClass="glyphicon glyphicon-user" runat="server" Text="" style="text-transform:uppercase;color:Yellow;" font-bold="true"></asp:Label>

</a>

</li>

<li class="nav-item"><a class="nav-link" href="../logout.aspx">Logout</a></li>

</ul>

</div>

</nav>

<asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">

</asp:ContentPlaceHolder>

</div>

<br />

</div>

</footer>

</div>

</form>

</body>

</html>

------------------------

Step #7:
write following code in web.config file

</connectionStrings>

Step #8:

Add New Employee add a new webpage in admin folder named as (AddEmployee.aspx)

-----------------------------------

<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/AdminMasterPage.master" AutoEventWireup="true" CodeFile="AddEmployee.aspx.cs" Inherits="Admin_AddEmployee" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

<title>Employee Registration</title>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

</cc1:ToolkitScriptManager>

<div class="panel-heading"> <h2>Add Employee</h2> </div>

<tr>

</tr>

<tr>

<td>Designation</td>

<td>

<asp:DropDownList ID="ddlDesignation" CssClass=" form-control" runat="server">

</asp:DropDownList>

</td>

</tr>

<tr>

<td>UserName</td>

</tr>

<tr>

<td>Password</td>

</tr>

<tr>

<td>FatherName</td>

</tr>

<tr>

<cc1:CalendarExtender ID="TextBox6_CalendarExtender" runat="server"

Enabled="True" TargetControlID="TextBox6" Format="dd-MM-yyyy">

</cc1:CalendarExtender>

</td>

</tr>

<tr>

<td>Address</td>

</tr>

<tr>

<td>MobileNo</td>

</tr>

<tr>

<td>Email</td>

</tr>

<tr>

<td>Basic Salary</td>

</tr>

<tr>

</td>

</tr>

<tr>

<asp:Button ID="Button2" CssClass="btn btn-danger" runat="server" style="margin-left: 16px" Text="Cancel" Width="71px" onclick="Button2_Click" Height="38px" />

</td>

</tr>

</table>

</div>

<asp:GridView ID="GridView1" CssClass=" table table-hover" runat="server" EmptyDataText="Record Not found">

</asp:GridView>

</div>

</asp:Content>

Step #9:

write C# code:"AddEmployee.aspx.cs"

--------------------------------------------------

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

public partial class Admin_AddEmployee : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if(!this.IsPostBack) { BindDesignation(); BindGrid(); }

}

private void BindDesignation()

{

SqlConnection con = new SqlConnection(GetConnectionString());

SqlCommand cmd = new SqlCommand("select distinct ID,Designation from tblDesignation with(nolock) where Designation!=''", con);

SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

ddlDesignation.DataSource = dt;

ddlDesignation.DataTextField = "Designation";

ddlDesignation.DataValueField = "ID";

ddlDesignation.DataBind();

}

//--------------------Resuable method-------------------

public string GetConnectionString()

{

return System.Configuration.ConfigurationManager.ConnectionStrings["PMS"].ConnectionString;

}

private Boolean InsertUpdateData(SqlCommand cmd)

{

SqlConnection con = new SqlConnection(GetConnectionString());

cmd.CommandType = CommandType.StoredProcedure;

cmd.Connection = con;

try

{

con.Open();

cmd.ExecuteNonQuery();

return true;

}

catch (Exception ex)

{

Response.Write(ex.Message);

return false;

}

finally

{

con.Close();

con.Dispose();

}

//------------------

protected void Button1_Click(object sender, EventArgs e)

{

if (TextBox1.Text != string.Empty && TextBox3.Text != string.Empty && TextBox4.Text != string.Empty && TextBox8.Text != string.Empty)

{

if(IsRecordExixt()) {

Response.Write("<script>alert('Record already exist try again');</script>");

}

else {

SqlCommand cmd = new SqlCommand("spInsertEmp");

cmd.Parameters.AddWithValue("@Name", TextBox1.Text);

cmd.Parameters.AddWithValue("@Designation", ddlDesignation.SelectedValue);

cmd.Parameters.AddWithValue("@Username", TextBox3.Text);

cmd.Parameters.AddWithValue("@Password", TextBox4.Text);

cmd.Parameters.AddWithValue("@Fathername", TextBox5.Text);

cmd.Parameters.AddWithValue("@DOB", TextBox6.Text);

cmd.Parameters.AddWithValue("@Address", TextBox7.Text);

cmd.Parameters.AddWithValue("@MobileNo", TextBox8.Text);

cmd.Parameters.AddWithValue("@Email", TextBox9.Text);

cmd.Parameters.AddWithValue("@BasicSalary", Convert.ToDouble(TextBox10.Text));

cmd.Parameters.AddWithValue("@DOJ", DateTime.Now);

if (Convert.ToInt32(InsertUpdateData(cmd)) >= 1) {

Response.Write("<script>alert('Save successfull');</script>"); clr(); BindGrid();

}

else { Response.Write("<script>alert('operation fail error');</script>"); }

}

else { Response.Write("<script>alert('Validation error');</script>"); }

}

private bool IsRecordExixt()

{

try

{ SqlConnection con = new SqlConnection(GetConnectionString());

if (con.State == ConnectionState.Closed) { con.Open(); }

SqlCommand cmd = new SqlCommand("select Name,Designation,Username,Password,MobileNo,Email from dbo.addemployee where Name@Name and Designation=@Designation and Username=@Username and Password=@Password and MobileNo=@MobileNo and Email=@Email ", con);

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("@Name", TextBox1.Text);

cmd.Parameters.AddWithValue("@Designation", ddlDesignation.SelectedValue);

cmd.Parameters.AddWithValue("@Username", TextBox3.Text);

cmd.Parameters.AddWithValue("@Password", TextBox4.Text);

cmd.Parameters.AddWithValue("@MobileNo", TextBox8.Text);

cmd.Parameters.AddWithValue("@Email", TextBox9.Text);

SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable();

da.Fill(dt); con.Close();

if (dt.Rows.Count >= 1) { return true; } else { return false; }

}

catch (Exception ex)

{

Response.Write("<script>alert('exception error "+ex.Message+"');</script>");

return false;

}

protected void Button2_Click(object sender, EventArgs e)

{

}

private void clr()

{

TextBox1.Text = string.Empty; TextBox3.Text = string.Empty;

TextBox4.Text = string.Empty; TextBox5.Text = string.Empty;

TextBox6.Text = string.Empty; TextBox8.Text = string.Empty;

TextBox7.Text = string.Empty; TextBox9.Text = string.Empty;

TextBox10.Text = string.Empty; TextBox11.Text = string.Empty;

ddlDesignation.SelectedIndex = -1;

}

private void BindGrid()

{

SqlConnection con = new SqlConnection(GetConnectionString());

SqlCommand cmd = new SqlCommand("select * from dbo.addemployee", con);

SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

GridView1.DataSource = dt; GridView1.DataBind();

} else { GridView1.DataSource = null; GridView1.DataBind();

}

Thursday, 17 June 2021

Payroll Management System asp.net project with source code

Payroll Management System asp.net project with source code

3 comments:

Popular Posts

Search This Blog

Youtube Channel

Recent

Popular

Comments

Follow Us

Tags

About Me

Blog Archive

Report Abuse