This Office Automation System Final Year ASP.net Project provides all account management details in office, attendance details for employees, employee management details, Resource allocation in new positions, login and registration process. Main aim of developing this project is to automate all employee details in offices without writing daily records on attendance and leaves. This application database stored in SQL and front end coded with HTML and ASP.net. Find the below SQL database tables:

[cc lang=”sql”]create database OfficeAutomation

use OfficeAutomation

create table logindetails (username varchar(100),password varchar(50))

select * from logindetails

create table employeedetails (employeetype varchar(100),employeename varchar(100),employeeid varchar(100) primary key,address varchar(500),qualification varchar(100),age char(2),sex varchar(50),experience varchar(50),phoneno char(10))

select * from employeedetails

create table employeeattendance(employeeid varchar(100),date varchar(20),Attendance char(1))

select * from employeeattendance

create table employeesalary(employeeid varchar(100),date varchar(20),accountno varchar(100),salary varchar(50),)

select * from employeesalary

create table resourceallocation (employeeid varchar(100),designation varchar(100),allocateddept varchar(100),allocatedproject varchar(100))
[/cc]

Account Management ASP.Net Source Code for OAS Project Below:

[cc lang=”asp”]protected void Page_Load(object sender, EventArgs e)
{
string strdrp1 = “select employeeid from employeedetails”;
ds = odb.Display(strdrp1);
DropDownList1.DataTextField = “employeeid”;
DropDownList1.DataValueField = “employeeid”;
DropDownList1.DataSource=ds;

DropDownList2.DataTextField = “employeeid”;
DropDownList2.DataValueField = “employeeid”;
DropDownList2.DataSource = ds;

}

protected void Button2_Click(object sender, EventArgs e)
{
Clear();
}
public void Clear()
{
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
TextBox4.Text = string.Empty;

}
protected void Button3_Click(object sender, EventArgs e)
{
string strgrid = “select * from employeesalary where employeeid='”+DropDownList1.SelectedValue.ToString()+”‘”;
ds = odb.Display(strgrid);
GridView1.DataSource = ds;
GridView1.DataBind();
Clear();
}
protected void Button1_Click(object sender, EventArgs e)
{
strempid=DropDownList1.SelectedValue.ToString();
strdate=TextBox2.Text;
strsal=TextBox3.Text;
straccno=TextBox4.Text;
string strinsert = “insert into employeesalary values(‘”+strempid+”‘,'”+strdate+”‘,'”+straccno+”‘,'”+strsal+”‘)”;
i=odb.InsertEditDelete(strinsert);
if (i > 0)
{
Response.Write(““);
}
else
{
Response.Write(““);
}
Clear();
}[/cc]

Download Office Automation System ASP.Net & SQL Project with Source Code.