Major Project Report ON Career Coach: Ayush Gautam (7085007) Lalita Kumari (7085023) Manjusha Thakur (7085026)

MAJOR PROJECT REPORT
ON
CAREER COACH
A Report Submitted in Partial Fulfillment

Of the Requirement for the Diploma of
Diploma in INFORMATION TECHNOLOGY

By
Ayush Gautam(7085007)
Lalita Kumari(7085023)
Manjusha Thakur(7085026)
DEPARTMENT OF CE/IT
GREEN HILLS POLYTECHNIC

KUMARHATTI, GANDHIGRAM, SOLAN
MAY, 2011.
1
CERTIFICATE
This is to certify that the MAJOR PROJECT entitled CAREER COACH submitted by
Mamjusha Thakur having Roll Number 7085026 for the partial fulfillment of the requirements
of Diploma in Information Technology of Green Hills Polytechnic, Solan, embodies the
bonafide work done by him/her under my / our supervision.
Date: Er.PriyankaSharma
Lecturer
Information Technology& Computer Engineering
Green Hills Polytechnic
Solan - 173229
Er. Gaurav Gupta

(HOD)
Department of Computer Engineering & Information Technology
Green Hills Polytechnic
Solan - 173229
2
ACKNOWLEDGEMENT
My journey towards achieving my destination for the design and development of CAREER
COACH has finally come to a fruitful culmination.
My efforts and wholehearted co-corporation of each and everyone has ended on a successful
note. During this journey, I faced numerous unforeseen problems and unknown challenges.
However, at these junctures, a few enterprising people stepped in and guide me in a right
direction.
I would like to extend my sincere acknowledgement to those who have supported and
encouraged me during this tough journey. Many people met me during this endeavor and
enriched me with their support and knowledge both personally and professionally that Resulted
in the project being better that it could possibly have been without them.
I express my sincere gratitude to Mr.S.K Malik And Er. Gaurav Gupta (HOD) and my
Internal Guide Er.Priyanka Sharma who assisting me throughout this project. I thank him for
providing me the reinforcement, confidence and most importantly the track for the project
whenever I needed it.
At last but not the least, I pay my due regards to my parents and Friends, because every time they
encourage, and support me when I need or require.
Manjusha Thakur
3
TABLE OF CONTENT
Top
ic
Introduction
 Introduction
 Objective
 Inputs of project
 Outputs of project
Requirements
 Hardware Requirements
 Software requirements
 Platform
Problem Definition
Input-Output report
 Outputs
 Coding
Conclusion
Bibliography
4
INTRODUCTION
 Career Coach is a window based GUI (Graphical User Interface) application to manage
the processes of a Consultant Company who assist students for foreign education
processes.
 The application has three types of users; Administrator, Consultant & Clerk. All the users
of the system have assigned different rights according to their User Type(s).
 Administrator can create new users (Consultant as well as Clerk). Administrator is

allowed to manage concerned colleges of different countries & courses provided by the
relative colleges & the minimum requirements for the course.
 Administrator can also manage cases’ information, students’ information & case updates.
 Administrator can generate the report for viewing the status of applied cases.
 Consultant have all rights same as Administrator but not allowed to manage Users.
 Clerk can only to manage course requirements, manage case documents & case updates.
All the users allowed changing their login password.
5
OBJECTIVE
The objective of the system would be:
1. To reduce the paper work involved in managing the Education Consultant Company data.
2. To provide interface to manage all the information about Course(s) provided by the
relative Colleges & the minimum requirements for taking admission.
3. To provide a proper interface to manage new Cases & Student Information.
4. To provide the interface to manage case documents & timely case updates.
5. To centralize all the data of an Education Consultant Company.
6
TECHNOLOGIES TO BE USED
 Dot Net
It consists of two parts
 CLR stands for Common language runtime, which is run time environment to
execute the Dot Net programs.
 Dot Net API (Application Programming Interface) that consists of inbuilt
classes used in Dot Net programs.
 VC#.Net
 Dot Net is Platform Dependent, Secure, Object Oriented, component oriented,
Scalable, and Robust Programming Language
 ADO.Net
 ADO.Net (Active X data objects) is an API, which is used for the
communication of Dot Net programs with different databases.
 Windows.Net
 The Windows Forms classes contained in the .NET Framework are designed
to be used for Window based GUI development.
 SQL Server
 SQL Server is used as database, used to store data. It is RDBMS.
 Others
 UML
7
SYSTEM OUT LINE VIEW
After firming the requirements of the system, the summary chart or data flow diagram (DFD) of the
proposed system is prepared. This gives the brief of the system with respect to the inputs being
considered, the outputs reports, the data being transformed and the main processed involved in the
system.
The Inputs required for this system are:
a) Login.
b) Software Information.
c) Software final Cost Information.
d) Software’s manual and tutorial information.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
SOFTWARE/HARDWARE REQUTREMENTS
SOFTWARE REQUIREMENTS
 Framework
o .Net Framework 3.5
 Environment
o Microsoft Visual C# 2008 Express
22
 Database
o SQL Server 2005 Express Edition
 Operating System
o Windows Vista/XP SP2
HARDWARE REQUIREMENTS
 Intel P4 processor with minimum 2.0Ghz Speed
 RAM: Minimum 512MB
 Hard Disk: Minimum 20GB
23
PROBLEM DEFINATION
This was a preliminary investigation done with a view to have a “feel” of the working of the
proposed system. This phase has been identified the end-user directly involved in the system
who were the managers, assistant officer and database administrator, and the development
department. By understanding the working of database, its flow and also after conducting
meetings and interviews with the concerned persons of the department, a clear idea about the
working was obtained. A flexible approach is adapted towards people who are interviewed. Short
hand written notes are prepared based on the response of the employees. The interviews are
preferably conducted at the work place of the person being interviewed. Detailed investigation is
done in order to define the scope of the problem .The interview is concluded with a quick resume
of the ground covered during the interview .The Questionnaire technique is combined with
interviews to get the best result. Proper care has been taken in the design of such questionnaires
so that the persons answering these questions dose not feel hesitant. An explanatory note that
serves to gain cooperation and avoid misunderstanding by setting out the purpose of the exercise
clearly accomplishes each questionnaire.
Observation technique is also used for fact finding. The work described at the time of interview
is observed personally ads it reduces the chances of misunderstanding and omissions. Some
important things observed are like the flow of information through the system and important data
transactions, the data being maintained and the frequency of their updating.
By the end of this phase, idea as to how the information enters the system, how it is stored, how
it is processed, how information changes affects the working of the system and finally the output
format required by the end-user was collected.
24
CODING
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace CareerCoach
{
public partial class frmMain : Form
{
public frmMain()
{
InitializeComponent();
}
public static int intUserID;

public static string strUserType = "";
public static string strUserName = "";
private void frmMain_FormClosing(object sender, FormClosingEventArgs

e)
{
try
{
Application.ExitThread();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Alpha Net Tech. Pvt.
Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmMain_Load(object sender, EventArgs e)

{
try
{
if (strUserType == "Administrator")
{
}
else if (strUserType == "Consultant")
{
menuItemAdmin.Enabled = false;
}
else if (strUserType == "Clerk")
{
menuItemAdmin.Enabled = false;
menuItemManage.Enabled = false;
menuItemManageCase.Enabled = false;
}
25
}
{
}
}
private void menuItemColleges_Click(object sender, EventArgs e)

{
try
{
frmManageColleges frmManageColleges = new frmManageColleges();
frmManageColleges.MdiParent = this;
frmManageColleges.Show();
}
{
}
}
private void menuItemCourses_Click(object sender, EventArgs e)

{
try
{
frmManageCourses frmManageCourses = new frmManageCourses();
frmManageCourses.MdiParent = this;
frmManageCourses.Show();
}
{
}
}
private void menuItemStudent_Click(object sender, EventArgs e)

{
try
{
frmManageStudents frmManageStudents = new frmManageStudents();
frmManageStudents.MdiParent = this;
frmManageStudents.Show();
}
{
}
}
private void menuItemExit_Click(object sender, EventArgs e)

{
try
{
26
}
{
}
}
private void menuItemManageCourseRequirement_Click(object sender,

EventArgs e)
{
try
{
frmManageCourseRequirement frmManageCourseRequirement = new
frmManageCourseRequirement();
frmManageCourseRequirement.MdiParent = this;
frmManageCourseRequirement.Show();
}
{
}
}
private void menuItemManageCase_Click(object sender, EventArgs e)

{
try
{
frmManageCase frmManageCase = new frmManageCase();
frmManageCase.MdiParent = this;
frmManageCase.Show();
}
{
}
}
private void menuItemCaseDocuments_Click(object sender, EventArgs e)

{
try
{
frmManageCaseDocuments frmManageCaseDocuments = new
frmManageCaseDocuments();
frmManageCaseDocuments.MdiParent = this;
frmManageCaseDocuments.Show();
}
{
}
}
27
private void menuItemCaseUpdates_Click(object sender, EventArgs e)
{
try
{
frmManageCaseState frmManageCaseState = new
frmManageCaseState();
frmManageCaseState.MdiParent = this;
frmManageCaseState.Show();
}
{
}
}
private void menuItemCasesStatusReport_Click(object sender, EventArgs

e)
{
try
{
frmViewCaseStatusReport frmViewCaseStatusReport = new
frmViewCaseStatusReport();
frmViewCaseStatusReport.MdiParent = this;
frmViewCaseStatusReport.Show();
}
{
}
}
private void menuItemChangePassword_Click(object sender, EventArgs e)

{
try
{
frmChangePassword frmChangePassword = new frmChangePassword();
frmChangePassword.MdiParent = this;
frmChangePassword.Show();
}
{
}
}
private void menuItemManageUsers_Click(object sender, EventArgs e)

{
try
{
frmManageUsers frmManageUsers = new frmManageUsers();
frmManageUsers.MdiParent = this;
frmManageUsers.Show();
}
28
{
}
}
private void menuItemManage_Click(object sender, EventArgs e)

{
}
}
}
{
public partial class frmLogin : Form
{
SqlConnection conCareerCoach = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ConnectionSt
ring.ToString());
SqlCommand cmdLogin;
SqlDataReader dtrLogin;
public frmLogin()
{
}
private void btnCancel_Click(object sender, EventArgs e)

{
try
{
}
{
}
}
private void btnLogin_Click(object sender, EventArgs e)

{
try
{
if (txtUserName.Text == "")
{
MessageBox.Show("Enter User Name", "Alpha Net Tech. Pvt.
txtUserName.Focus();
}
else if (txtPassword.Text == "")
{
MessageBox.Show("Enter Password", "Alpha Net Tech. Pvt.
29
txtPassword.Focus();
}
else
{
string strQry = "SELECT Emp_Id, User_Type FROM
UserMaster WHERE (User_Name = @User_Name) AND (Password = @Password)";
cmdLogin = new SqlCommand(strQry, conCareerCoach);
cmdLogin.Parameters.Add("@User_Name", SqlDbType.VarChar,
50).Value = txtUserName.Text;
cmdLogin.Parameters.Add("@Password", SqlDbType.VarChar,
50).Value = txtPassword.Text;
if (conCareerCoach.State == ConnectionState.Closed)
{ conCareerCoach.Open(); }
dtrLogin = cmdLogin.ExecuteReader();
if (dtrLogin.HasRows)
{
dtrLogin.Read();
frmMain.intUserID =
Convert.ToInt32(dtrLogin["Emp_Id"].ToString());
frmMain.strUserType =
dtrLogin["User_Type"].ToString();
frmMain.strUserName = txtUserName.Text;
frmMain frmMain1 = new frmMain();

frmMain1.Show();
this.Hide();
}
else
{
MessageBox.Show("User Name or Password doesn't
exists", "Alpha Net Tech. Pvt. Ltd: Message Service", MessageBoxButtons.OK,
MessageBoxIcon.Error);
txtPassword.Text = "";
txtUserName.Text = "";
}
dtrLogin.Close();
dtrLogin.Dispose();
conCareerCoach.Close();
cmdLogin.Dispose();
}
}
{
}
}
private void frmLogin_Load(object sender, EventArgs e)

{
try
{
txtPassword.Text = "";
txtUserName.Text = "";
}
30
{
}
private void txtPassword_TextChanged(object sender, EventArgs e)

{
}
}
}
{
public partial class frmChangePassword : Form
{
public frmChangePassword()
{
}
SqlConnection conCareerCoach = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ConnectionSt
ring.ToString());
SqlCommand cmdChangePassword;
string strQry = "";
private void btnCancel_Click(object sender, EventArgs e)

{
try
{
this.Close();
}
{
}
private void frmChangePassword_Load(object sender, EventArgs e)

{
try
{
strQry = "SELECT First_Name + ' ' + Last_Name AS UserName
FROM UserDetail WHERE (Emp_ID = @Emp_ID)";
cmdChangePassword = new SqlCommand(strQry, conCareerCoach);
cmdChangePassword.Parameters.Add("@Emp_Id",
SqlDbType.Int).Value =frmMain.intUserID;
31
lblUserName.Text =
cmdChangePassword.ExecuteScalar().ToString();
cmdChangePassword.Dispose();
txtOldPassword.Focus();
}
{
}
private void btnUpdate_Click(object sender, EventArgs e)

{
try
{
if (txtOldPassword.Text == "")
{
MessageBox.Show("Enter Old Password", "Alpha Net Tech.
Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (txtNewPassword.Text == "")
{
MessageBox.Show("Enter New Password", "Alpha Net Tech.
txtNewPassword.Focus();
}
else if (txtConfirmPassword.Text == "")
{
MessageBox.Show("Enter Confirm Password", "Alpha Net Tech.
txtConfirmPassword.Focus();
}
else
{
strQry = "SELECT COUNT(*) AS Expr1 FROM
UserMaster WHERE (Password = @Password) and (Emp_Id = @Emp_Id)";
cmdChangePassword = new SqlCommand(strQry,
conCareerCoach);
cmdChangePassword.Parameters.Add("@Password",
SqlDbType.VarChar, 50).Value = txtOldPassword.Text;
SqlDbType.Int).Value = frmMain.intUserID;
int intCount =
Convert.ToInt32(cmdChangePassword.ExecuteScalar().ToString());
if (intCount <= 0)
{
32
MessageBox.Show("Please enter correct Old Password",
"Alpha Net Tech. Pvt. Ltd: Message Service", MessageBoxButtons.OK,
txtConfirmPassword.Text = "";
txtNewPassword.Text = "";
txtOldPassword.Text = "";
}
else
{
if (txtNewPassword.Text != txtConfirmPassword.Text)
{
MessageBox.Show("Please Confirm Password Again",
txtConfirmPassword.Text = "";
txtConfirmPassword.Focus();
}
else
{
strQry = "UPDATE UserMaster SET
Password = @Password WHERE (Emp_Id = @Emp_Id)";
cmdChangePassword = new SqlCommand(strQry,
conCareerCoach);
cmdChangePassword.Parameters.Add("@Password",
SqlDbType.VarChar, 50).Value = txtNewPassword.Text;
SqlDbType.Int).Value = frmMain.intUserID;
if (conCareerCoach.State ==
ConnectionState.Closed) { conCareerCoach.Open(); }
cmdChangePassword.ExecuteNonQuery();
MessageBox.Show("Password Changed Successfully",

MessageBoxIcon.Information);
this.Close();
}
}
}
}
{
}
}
}
}
33
OUTPUT SCREENS
34
Admin login
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
Consultant Login
62
63
64
65
66
67
68
69
70
71
72
73
74
75
Clerk login
76
77
78
79
80
81
82
83
84
85
CONCLUSION
In the concluding section it reduce the paper work involved in managing the Education
Consultant Company data.It provide a user friendly environment to manage all the information
of concerned College(s) in different countries.To provide interface to manage all the information
about Course(s) provided by the relative Colleges & the minimum requirements for taking
admission.To provide a proper interface to manage new Cases & Student Information.To provide
the interface to manage case documents & timely case updates.To centralize all the data of an
Education Consultant Company.
86
BIBLIOGRAPHY
 Books
 Beginning C# 3.0: An Introduction to Object Oriented Programming by Jack Purdum
 Beginning SQL Server 2005 Programming by Robert Vieira
 Programming In C# by Balagurusamy, Publisher: Mcgraw Hill Education (india) Ltd.
 Programming C# 3.0 by Jesse Liberty, Donald Xie Fifth Edition
 SQL Server 2005 Bible by Paul Nielsen
 Microsoft SQL Server 2005: A Beginner''s Guide: A Beginner's Guide (Beginner's Guide
(Osborne Mcgraw Hill)) by Dusan Petkovic
 Websites
 http://msdn.microsoft.com/en-us/vstudio/default.aspx
 http://msdn.microsoft.com/en-us/netframework/default.aspx
 http://msdn.microsoft.com/en-us/sqlserver/default.aspx
 http://msdn.microsoft.com/en-us/vcsharp/default.aspx
 http://www.microsoft.com/sql/default.mspx
 http://www.sql-server-performance.com/
 http://www.sqlservercentral.com/
 http://databases.about.com/
87

Major Project Report ON Career Coach: Ayush Gautam (7085007) Lalita Kumari (7085023) Manjusha Thakur (7085026)

Uploaded by

Copyright:

Available Formats

Major Project Report ON Career Coach: Ayush Gautam (7085007) Lalita Kumari (7085023) Manjusha Thakur (7085026)

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Major Project Report ON Career Coach: Ayush Gautam (7085007) Lalita Kumari (7085023) Manjusha Thakur (7085026)

Uploaded by

Copyright:

Available Formats

MAJOR PROJECT REPORT

A Report Submitted in Partial Fulfillment

Diploma in INFORMATION TECHNOLOGY

GREEN HILLS POLYTECHNIC

Er. Gaurav Gupta

 Administrator can create new users (Consultant as well as Clerk). Administrator is

3. To provide a proper interface to manage new Cases & Student Information.

5. To centralize all the data of an Education Consultant Company.

 RAM: Minimum 512MB

 Hard Disk: Minimum 20GB

public static int intUserID;

private void frmMain_FormClosing(object sender, FormClosingEventArgs

private void frmMain_Load(object sender, EventArgs e)

private void menuItemColleges_Click(object sender, EventArgs e)

private void menuItemCourses_Click(object sender, EventArgs e)

private void menuItemStudent_Click(object sender, EventArgs e)

private void menuItemExit_Click(object sender, EventArgs e)

private void menuItemManageCourseRequirement_Click(object sender,

private void menuItemManageCase_Click(object sender, EventArgs e)

private void menuItemCaseDocuments_Click(object sender, EventArgs e)

private void menuItemCasesStatusReport_Click(object sender, EventArgs

private void menuItemChangePassword_Click(object sender, EventArgs e)

private void menuItemManageUsers_Click(object sender, EventArgs e)

private void menuItemManage_Click(object sender, EventArgs e)

private void btnCancel_Click(object sender, EventArgs e)

private void btnLogin_Click(object sender, EventArgs e)

frmMain frmMain1 = new frmMain();

private void frmLogin_Load(object sender, EventArgs e)

private void txtPassword_TextChanged(object sender, EventArgs e)

private void btnCancel_Click(object sender, EventArgs e)

private void frmChangePassword_Load(object sender, EventArgs e)

private void btnUpdate_Click(object sender, EventArgs e)

MessageBox.Show("Password Changed Successfully",

You might also like