private void button6_Click(object sender, EventArgs e)
{
Masterlist ml = new Masterlist();
ml.MdiParent = this;
ml.StartPosition = FormStartPosition.Manual;
ml.Top = 0;
ml.Left = 0;
ml.Sconn = Sconn;
if (cf.isChildFormLoaded(ml.Name))
{
ml.Show();
}
}
public ActionResult Login(Masterlist lg)
{
string mainconn = @"Data Source=192.168.102.18;Initial Catalog=HRIS;Persist Security Info=True;User ID=panoramic;Password=GoLegal100;";
SqlConnection sqlconn = new SqlConnection(mainconn);
string sqlquery = " select Applicant_ExamNo, FirstName, LastName, JobTitle, MasterlistID, Applicant_TookExam from Masterlist where Applicant_ExamNo = @Applicant_ExamNo";
sqlconn.Open();
SqlCommand sqlcomm = new SqlCommand(sqlquery, sqlconn);
sqlcomm.Parameters.AddWithValue("@Applicant_ExamNo", lg.Applicant_ExamNo);
SqlDataAdapter SqlDa = new SqlDataAdapter(sqlcomm);
DataTable Logins = new DataTable();
SqlDa.Fill(Logins);
SqlDataReader sdr = sqlcomm.ExecuteReader();
if (sdr.Read())
{
for (int i = 0; i < Logins.Rows.Count; i++)
{
if (Logins.Rows[i][5].ToString() == "1")
{
TempData["Message"] = "You already have taken the Exam!";
return(View());
}
else
{
Session["Applicant_ExamNo"] = Logins.Rows[i][0];
Session["FirstName"] = Logins.Rows[i][1];
Session["LastName"] = Logins.Rows[i][2];
Session["JobTitle"] = Logins.Rows[i][3];
Session["MasterlistID"] = Logins.Rows[i][4];
}
}
return(RedirectToAction("IQtest", "Exam"));
}
else
{
TempData["Message"] = "Credentials are Invalid!";
}
sqlconn.Close();
return(View());
}
public ActionResult AddApplicant(Masterlist masterlist, WorkExperience workExperience, int?examno)
{
DataTable dtblApplicant = new DataTable();
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
string query = "SELECT Applicant_ExamNo from Masterlist ORDER BY Applicant_ExamNo desc";
SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon);
sqlDa.Fill(dtblApplicant);
}
if (dtblApplicant.Rows.Count > 0)
{
examno = Convert.ToInt32(dtblApplicant.Rows[0][0].ToString());
examno = examno + 1;
}
else
{
examno = 100001;
}
MasterListEntities Master = new MasterListEntities();
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
string query = " select * from Masterlist where Birthday = @Birthday AND LastName = @LastName AND FirstName = @FirstName";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@Birthday", masterlist.Birthday);
sqlCmd.Parameters.AddWithValue("@LastName", masterlist.LastName);
sqlCmd.Parameters.AddWithValue("@FirstName", masterlist.FirstName);
SqlDataReader sdr = sqlCmd.ExecuteReader();
if (sdr.Read())
{
TempData["error"] = "Applicant Already Applied!";
}
else
{
sdr.Close();
string querys = "INSERT INTO Masterlist(FirstName,MiddleName,LastName,Birthday,MaritalStatus,JobTitle,Street_Address1,Street_Address2,City,Province,ZipCode,ContactNumber,PersonalEmail,Applicant_AppliedDate,Applicant_ExamNo)" +
"VALUES(@FirstName,@MiddleName,@LastName,@Birthday,@MaritalStatus,@JobTitle,@Street_Address1,@Street_Address2,@City,@Province,@ZipCode,@ContactNumber,@PersonalEmail,@Applicant_AppliedDate,@Applicant_ExamNo)";
SqlCommand sqlCmds = new SqlCommand(querys, sqlCon);
sqlCmds.Parameters.AddWithValue("@FirstName", masterlist.FirstName);
sqlCmds.Parameters.AddWithValue("@MiddleName", masterlist.MiddleName);
sqlCmds.Parameters.AddWithValue("@LastName", masterlist.LastName);
sqlCmds.Parameters.AddWithValue("@Birthday", masterlist.Birthday);
sqlCmds.Parameters.AddWithValue("@MaritalStatus", masterlist.MaritalStatus);
sqlCmds.Parameters.AddWithValue("@JobTitle", masterlist.JobTitle);
sqlCmds.Parameters.AddWithValue("@Street_Address1", masterlist.Street_Address1);
sqlCmds.Parameters.AddWithValue("@Street_Address2", masterlist.Street_Address2);
sqlCmds.Parameters.AddWithValue("@City", masterlist.City);
sqlCmds.Parameters.AddWithValue("@Province", masterlist.Province);
sqlCmds.Parameters.AddWithValue("@ZipCode", masterlist.ZipCode);
sqlCmds.Parameters.AddWithValue("@ContactNumber", masterlist.ContactNumber);
sqlCmds.Parameters.AddWithValue("@PersonalEmail", masterlist.PersonalEmail);
sqlCmds.Parameters.AddWithValue("@Applicant_AppliedDate", masterlist.Applicant_AppliedDate);
sqlCmds.Parameters.AddWithValue("@Applicant_ExamNo", examno);
SqlDataReader sdrs = sqlCmds.ExecuteReader();
int masterlistID = Master.Masterlists.Max(item => item.MasterlistID);
sdrs.Close();
string queries = "INSERT INTO WorkExperience(MasterlistID,CompanyName,JobTitle,DateFrom,DateTo)" +
"VALUES(@MasterlistID,@CompanyName,@JobTitles,@DateFrom,@DateTo)";
SqlCommand sqlcommands = new SqlCommand(queries, sqlCon);
sqlcommands.Parameters.AddWithValue("@MasterlistID", masterlistID);
sqlcommands.Parameters.AddWithValue("@CompanyName", workExperience.CompanyName);
sqlcommands.Parameters.AddWithValue("@JobTitles", workExperience.JobTitle);
sqlcommands.Parameters.AddWithValue("@DateFrom", workExperience.DateFrom);
sqlcommands.Parameters.AddWithValue("@DateTo", workExperience.DateTo);
SqlDataReader sqldrs = sqlcommands.ExecuteReader();
TempData["success"] = "New Applicant: " + masterlist.FirstName + " " + masterlist.LastName + " Added!";
sqldrs.Close();
}
}
return(RedirectToAction("AddApplicant"));
}
public ActionResult EmployeesProfile()
{
string employeenumber = Session["employeenumber"].ToString();
ViewBag.empPicture = Session["picture"].ToString();
Masterlist masterlist = new Masterlist();
DataTable dtblEmployeeInfo = new DataTable();
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
string query = "SELECT EmployeeNumber,FirstName,LastName,PersonalEmail,Department,JobTitle,DateHired,ContactNumber,Street_Address1,Street_Address2,City," +
"Province,ZipCode,Birthday,Gender,MaritalStatus from Masterlist Where EmployeeNumber = @ID";
SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon);
sqlDa.SelectCommand.Parameters.AddWithValue("@ID", employeenumber);
sqlDa.Fill(dtblEmployeeInfo);
}
if (dtblEmployeeInfo.Rows.Count == 1)
{
ViewBag.empID = employeenumber;
ViewBag.firstName = dtblEmployeeInfo.Rows[0][1].ToString();
ViewBag.lastName = dtblEmployeeInfo.Rows[0][2].ToString();
ViewBag.eMail = dtblEmployeeInfo.Rows[0][3].ToString();
ViewBag.dept = dtblEmployeeInfo.Rows[0][4].ToString();
ViewBag.jobTitle = dtblEmployeeInfo.Rows[0][5].ToString();
ViewBag.dateHired = dtblEmployeeInfo.Rows[0][6].ToString();
ViewBag.contactNum = dtblEmployeeInfo.Rows[0][7].ToString();
ViewBag.street1 = dtblEmployeeInfo.Rows[0][8].ToString();
ViewBag.street2 = dtblEmployeeInfo.Rows[0][9].ToString();
ViewBag.city = dtblEmployeeInfo.Rows[0][10].ToString();
ViewBag.province = dtblEmployeeInfo.Rows[0][11].ToString();
ViewBag.zipcode = dtblEmployeeInfo.Rows[0][12].ToString();
ViewBag.bday = dtblEmployeeInfo.Rows[0][13].ToString();
ViewBag.gender = dtblEmployeeInfo.Rows[0][14].ToString();
ViewBag.maritalStatus = dtblEmployeeInfo.Rows[0][15].ToString();
return(View(masterlist));
}
EmpHistory empHistory = new EmpHistory();
DataTable dtblEmpHistory = new DataTable();
using (SqlConnection sqlConn = new SqlConnection(connectionString))
{
sqlConn.Open();
string qryEmpHistory = "SELECT DatePromoted,GrossPay,Allowance,EmploymentStatus from EmpHistory Where EmployeeNumber = @ID";
SqlDataAdapter sqlDa = new SqlDataAdapter(qryEmpHistory, sqlConn);
sqlDa.SelectCommand.Parameters.AddWithValue("@ID", employeenumber);
sqlDa.Fill(dtblEmpHistory);
}
if (dtblEmployeeInfo.Rows.Count == 1)
{
ViewBag.firstName = dtblEmployeeInfo.Rows[0][1].ToString();
ViewBag.lastName = dtblEmployeeInfo.Rows[0][2].ToString();
ViewBag.eMail = dtblEmployeeInfo.Rows[0][3].ToString();
ViewBag.dept = dtblEmployeeInfo.Rows[0][4].ToString();
ViewBag.jobTitle = dtblEmployeeInfo.Rows[0][5].ToString();
ViewBag.dateHired = dtblEmployeeInfo.Rows[0][6].ToString();
ViewBag.contactNum = dtblEmployeeInfo.Rows[0][7].ToString();
ViewBag.street1 = dtblEmployeeInfo.Rows[0][8].ToString();
ViewBag.street2 = dtblEmployeeInfo.Rows[0][9].ToString();
ViewBag.city = dtblEmployeeInfo.Rows[0][10].ToString();
ViewBag.province = dtblEmployeeInfo.Rows[0][11].ToString();
ViewBag.zipcode = dtblEmployeeInfo.Rows[0][12].ToString();
ViewBag.bday = dtblEmployeeInfo.Rows[0][13].ToString();
ViewBag.gender = dtblEmployeeInfo.Rows[0][14].ToString();
ViewBag.maritalStatus = dtblEmployeeInfo.Rows[0][15].ToString();
return(View(masterlist));
}
return(View());
}
