Output:

28

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

29

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

30

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

System Complaints.aspx: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="System Complaints.aspx.cs" MasterPageFile="~/DSRPMaster.Master" Inherits="CKT_COLLEGE__Computer_Science_.System_Complaints" %>

<span class="login100-form-title"> System Complaints

<span class="focus-input100">

<span class="focus-input100">

Admin: Check Complaints

31

runat="server"

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

System Complaints.aspx.cs: using CKT_COLLEGE__Computer_Science_.DAL; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace CKT_COLLEGE__Computer_Science_ { public partial class System_Complaints : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Session["LoginUser"] == null || string.IsNullOrEmpty(Session["LoginUser"].ToString())) Response.Redirect("Login.aspx", false); if (Session["LoginUserRole"] != null) if (!(Session["LoginUserRole"].ToString() == "User")) { Admin_section1.Visible = true; } else { Admin_section1.Visible = false; } } protected void btn_Sc_form_Click(object sender, EventArgs e) { DataConnection dc = new DataConnection(); if (dc.CreateTickets(Convert.ToInt32(Session["LoginId"]), txtPCno.Text,txtTicketDescription.Text)) { string display = "Success Message"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } else { string display = "Error Message"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } txtPCno.Text = ""; txtTicketDescription.Text = ""; } } }

32

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Output:

Header_footer.Master: <%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Header_footer.master.cs" Inherits="DSRP.Header_footer" %>

Complaint Register.aspx <%@ Page Title="" Language="C#" MasterPageFile="~/Header_footer.Master" AutoEventWireup="true" CodeBehind="Complaint Register.aspx.cs" Inherits="DSRP.Complaint_Register" %>

System Complaint Register
34

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM


" SelectCommand="SELECT * FROM [TTickets]">

Complaint Register.aspx.cs: using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace DSRP { public partial class Complaint_Register : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btn_del_id_Click(object sender, EventArgs e) { try { 35

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

using (SqlConnection con = new SqlConnection("Data Source=LUCIFER\\SQLEXPRESS;Initial Catalog=DSRPENTERPRISES;Integrated Security=True;")) { con.Open(); using (SqlCommand command = new SqlCommand("DELETE FROM TTickets WHERE ID=" + txt_IDNumber.Text, con)) { command.ExecuteNonQuery(); string display = "Success Message"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } con.Close(); } } catch { string display = "Something Is wrong"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } } } }

36

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Output:

37

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Add_Users.aspx: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Add_User.aspx.cs" MasterPageFile="~/Header_footer.Master" Inherits="CKT_COLLEGE__Computer_Science_.Add_User" %>

Add User

Date of Birth

Date of Joining

38

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

<select name="gender"> GENDER Male Female Other

<script src="vendor adduser/jquery/jquery.min.js"> <script src="vendor adduser/select2/select2.min.js"> <script src="vendor adduser/datepicker/moment.min.js"> <script src="vendor adduser/datepicker/daterangepicker.js"> <script src="jsadduser/global.js">

39

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM



Add_Users.aspx.cs: using CKT_COLLEGE__Computer_Science_.DAL; using CKT_COLLEGE__Computer_Science_.Entity; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace CKT_COLLEGE__Computer_Science_ { public partial class Add_User : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Session["LoginUser"] == null || string.IsNullOrEmpty(Session["LoginUser"].ToString()) || Session["LoginUserRole"].ToString() == "User") Response.Redirect("Login.aspx", false); } protected void btn_adduser_Click(object sender, EventArgs e) { EmployeeEntity employee = new EmployeeEntity(); DataConnection dc = new DataConnection(); employee.FullName = fname.Text; employee.EmailID = Email_ID.Text; employee.Password = Password.Text; employee.DOJ = Convert.ToDateTime(DOJ.Text); employee.DOB = Convert.ToDateTime(DOB.Text); if (Session["LoginUserRole"].ToString() == "Super Admin") employee.UserRoleID = 2; else employee.UserRoleID = 3; if (dc.CreateUser(employee)) { string display = "Success Message"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } else { 40

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

string display = "Error Message"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } } } }

Output:

41

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Log_out.aspx: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Log_out.aspx.cs" Inherits="CKT_COLLEGE__Computer_Science_.Log_out" %>

Log_out.aspx.cs: using CKT_COLLEGE__Computer_Science_.DAL; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace CKT_COLLEGE__Computer_Science_ { public partial class Log_out : System.Web.UI.Page 42

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

{ protected void Page_Load(object sender, EventArgs e) { if (Session["LoginUser"] == null || string.IsNullOrEmpty(Session["LoginUser"].ToString())) Response.Redirect("Login.aspx", false); } protected void btn_logout_Click(object sender, EventArgs e) { DataConnection dc = new DataConnection(); if (dc.UserLogout(Convert.ToInt32(Session["LoginId"]), txtWorkSummury.Text)) { Session.Clear(); Session.Abandon(); Session["LoginUser"] = null; Session["LoginId"] = null; Session["LoginUserRole"] = null; Response.Redirect("Login.aspx", false); } else { string display = "Error Message"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } } } }

Output:

43

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

DataConnection.cs: using CKT_COLLEGE__Computer_Science_.Entity; using System; using System.Collections.Generic; using System.Configuration; using System.Data.SqlClient; using System.Linq; using System.Web; namespace CKT_COLLEGE__Computer_Science_.DAL { public class DataConnection { public EmployeeEntity IsUserAutherised(string username, string password) { EmployeeEntity loginemployee = new EmployeeEntity(); try { //Get connection string from web.config file string strcon = ConfigurationManager.ConnectionStrings["DSRPEnterprise"].ConnectionString; //create new sqlconnection and connection to database by using connection string from web.config file SqlConnection con = new SqlConnection(strcon); con.Open(); SqlCommand cmd = new SqlCommand("UserLogin", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@EmailID", username)); cmd.Parameters.Add(new SqlParameter("@Password", password)); using (var reader = cmd.ExecuteReader()) //error occurs here { while (reader.Read()) { loginemployee.ID = Convert.ToInt32(reader["ID"]); loginemployee.EmailID = reader["EmailID"].ToString(); loginemployee.FullName = reader["FullName"].ToString(); loginemployee.UserRole = reader["UserRole"].ToString(); loginemployee.DOB = Convert.ToDateTime(reader["DOB"]); loginemployee.DOJ = Convert.ToDateTime(reader["DOJ"]); } } con.Close(); return loginemployee; } catch (Exception) { return loginemployee; } }

44

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

public bool CreateUser(EmployeeEntity employee) { try { //Get connection string from web.config file string strcon = ConfigurationManager.ConnectionStrings["DSRPEnterprise"].ConnectionString; //create new sqlconnection and connection to database by using connection string from web.config file SqlConnection con = new SqlConnection(strcon); con.Open(); SqlCommand cmd = new SqlCommand("CreateEmployee", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@EmailID", employee.EmailID)); cmd.Parameters.Add(new SqlParameter("@Password", employee.Password)); cmd.Parameters.Add(new SqlParameter("@UserRoleID", employee.UserRoleID)); cmd.Parameters.Add(new SqlParameter("@FullName", employee.FullName)); cmd.Parameters.Add(new SqlParameter("@DOJ", employee.DOJ)); cmd.Parameters.Add(new SqlParameter("@DOB", employee.DOB)); cmd.ExecuteNonQuery(); con.Close(); return true; } catch (Exception) { return false; } } public List<EmployeeEntity> GetAllUser() { List<EmployeeEntity> lstemployee = new List<EmployeeEntity>(); try { //Get connection string from web.config file string strcon = ConfigurationManager.ConnectionStrings["DSRPEnterprise"].ConnectionString; //create new sqlconnection and connection to database by using connection string from web.config file SqlConnection con = new SqlConnection(strcon); con.Open(); SqlCommand cmd = new SqlCommand("GetAllUser", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; using (var reader = cmd.ExecuteReader()) //error occurs here { while (reader.Read()) { EmployeeEntity employee = new EmployeeEntity(); employee.ID = Convert.ToInt32(reader["ID"]); employee.EmailID = reader["EmailID"].ToString(); employee.FullName = reader["FullName"].ToString(); employee.DOB = Convert.ToDateTime(reader["DOB"]); 45

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

employee.DOJ = Convert.ToDateTime(reader["DOJ"]); lstemployee.Add(employee); } } con.Close(); return lstemployee; } catch (Exception ex) { return lstemployee; } }

public bool UserLogout(int Eid, string WorkSummury) { try { //Get connection string from web.config file string strcon = ConfigurationManager.ConnectionStrings["DSRPEnterprise"].ConnectionString; //create new sqlconnection and connection to database by using connection string from web.config file SqlConnection con = new SqlConnection(strcon); con.Open(); SqlCommand cmd = new SqlCommand("UserLogOut", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Eid", Eid)); cmd.Parameters.Add(new SqlParameter("@WorkSummury", WorkSummury)); cmd.ExecuteNonQuery(); con.Close(); return true; } catch (Exception ex) { return false; } }

public bool CreateTickets(int Eid, string PCNo, string Ticket) { try { //Get connection string from web.config file string strcon = ConfigurationManager.ConnectionStrings["DSRPEnterprise"].ConnectionString; //create new sqlconnection and connection to database by using connection string from web.config file SqlConnection con = new SqlConnection(strcon); con.Open(); 46

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

SqlCommand cmd = new SqlCommand("CreateTickets", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Eid", Eid)); cmd.Parameters.Add(new SqlParameter("@PCno", PCNo)); cmd.Parameters.Add(new SqlParameter("@Ticket", Ticket)); cmd.ExecuteNonQuery(); con.Close(); return true; } catch (Exception ex) { return false; } } } }

Entity AttendanceEntity.cs: using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace CKT_COLLEGE__Computer_Science_.Entity { public class AttendanceEntity { public int ID { get; set; } public int EmployeeID { get; set; } public DateTime SignIn { get; set; } public DateTime SignOut { get; set; } public string WorkSummury { get; set; } public string EMP_Name { get; set; } } }

EmployeeEntity.cs: using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace CKT_COLLEGE__Computer_Science_.Entity 47

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

{ public class EmployeeEntity { public int ID { get; set; } public string EmailID { get; set; } public string Password { get; set; } public string UserRole { get; set; } public int UserRoleID { get; set; } public string FullName { get; set; } public DateTime DOJ { get; set; } public DateTime DOB { get; set; } } }

TicketsEntity.cs: using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace CKT_COLLEGE__Computer_Science_ { public class TicketsEntity { public int ID { get; set; } public int EmployeeID { get; set; } public string Ticket { get; set; } } }

UserRoleEntity.cs: using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace CKT_COLLEGE__Computer_Science_.Entity { public class UserRoleEntity { public int ID { get; set; } public string UserRole { get; set; } } }

48

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Chapter 4 System Implementation

49

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

System Implementation 1. Install Visual Studio 2015 and Microsoft SQL Server 2014 2. Copy the project file and exported db file. 3. Import the db file in SQL Server 2014. 4. Open the .sln extention file in Visual Studio 2015 5. Change the Data String with your own (in Dal folder DataConnection.cs) 6. And run the project file in any of the browser

50

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Chapter 5 Result

51

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Results SR. PRE TEST CASE ID OBJECTIVE No CONDITIONS

1

Click on login button to Admin_Login_ authenticate 01 user and take it into the portal

2

Open System Complaint Admin_Login_ page and click 02 on Admin: Check Complaints

3

Test that weather the Admin_Login_ registered 03 complaint entry is deleted or not

4

Check the Admin_Login_ attendance of 04 particular employee

5

Admin_Login_ 05

6

Click on login button to Employee_Log authenticate in_01 user and take it into the

Add a new Employee

STEPS

TEST CASE DATA

EXPECTED ACTUALL RESULT RESULT

User(Super Enter User(Super Admin) get authenticate Admin) get successfull admin User ID: entered into y entered Login page ID and [email protected] the portal into the must be open Password Pass: pass Attendance portal And click on Time IN Attendance login entered Time IN entered All Click on All System Complaint Registered Admin: Registered Complaint register will System Check System Page must be generated in grid complaints Complaints complaints open view Should be link are listed listed Admin: Check Complaints Enter page must be Complaint Complaint Complaint open and ID which ID: 12 ID: 12 Complaint should be Complaint ID: 12 Entry Entry is which is deleted, should be Deleted registered Click on Deleted should be Delete button solved Select Name: Rohit Particular employee Particular Dilip Sawant Employee Attendance name , From Employee From Date: Attendance Register page date & to Attendance 15/09/2018 Details must be open date and Details are To Date: should be click on listed 13/10/2018 listed search Name: harshadasawant Email ID: [email protected] Employee om details must Employee Add Enter Pass: 1234 be added details are Employee Employee DOB: 2018-10and its added and page must be Details 11 Account its Account open DOJ: 2018-10must be Is created 12 created Gender: Female Phone:98765432 12 Enter Employee Employee ID: authenticate get entered get Login page [email protected] User ID and into the successfull must be open om Password portal y entered Pass: 1234 And click on Attendance into the 52

STATUS (PASS /FAIL)

PASS

PASS

PASS

PASS

PASS

PASS

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

portal

login

7

Enter PC System Number Register Your Employee_Log Complaint Enter Detail System in_02 Page must be info about Complaint Open your complaint

8

Click on Log Out button and then Enter The Work Description and click on Log Out

Employee_Log Log Out of in_03 the portal

Any of the page

53

Time IN entered

portal Attendance Time IN entered

System System Complaint Complaint PC No.: 1 details details are System Issue: should be PASS registered Software Issue registered into into database database User is User Must logged out Be logged and out and Attendance Attendance Time Out Time Out is entered Work must be into the Description: PASS entered into database Testing the portal the database with work with work details details And And redirected to redirected Login Page to Login Page

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Chapter 6 Conclusion

54

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Conclusion  System helps to keep all the data about Enterprises and Employee to be stored in computer and there is no need to do paper work.  Data is going to be preserved carefully for longer period hence proper backup is required otherwise there is chance of losing entries.  There are also chances that calculation error can occur which can cause huge problem.  Easy to get Information by Time.  This information can be modified, deleted, Update as required.  More Comfortable for Company to get information about their office profile and employee work.

55

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Chapter 7 Future Enhancements

56

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Future Enhancements  The project contain a main module named as Employee Attendance right now in this project it is automated via login and logout we can move a step forward towards QR code scanning attendance.  Employee Salary Generations as per there working hours and days  Invoice generation.  Applying for leave, requesting for appointment letter etc.  Updating employee details (Admin).  Improvements in Attendance Register.  Improvements in designs.  Storing Detail info about employee

57

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Chapter 8 References

58

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

References

Requirements: DSRP ENTERPRISES

Enterprises Official Website: http://dsrpjobs.com/

Web Application guidance: https://www.w3schools.com/ https://www.aspsnippets.com/ https://stackoverflow.com/ https://docs.microsoft.com/en-us/dotnet/

59

DSRP ENTERPRISES OFFICE MANAGEMENT SYSTEM

Plagiarism report

60