private void bindAccessorProcessor(GridViewRowEventArgs e, DropDownList selectDropDown, GridView selectGV) { //get processor and check name string[] splitter = new string[] { PageConstants.GREATER_GREATER_THAN }; string[] VacancyInfoTosplit = (selectDropDown.SelectedValue).Split(splitter, StringSplitOptions.RemoveEmptyEntries); currentVacancyNo = VacancyInfoTosplit[0].Trim(); currentVacancyDate = VacancyInfoTosplit[1].Trim(); resposibleHROfficer = VacancyInfoTosplit[3].Trim(); Vacancy vacancy = new Vacancy(); vacancy.VacancyNo = currentVacancyNo; vacancy.PostedDate = currentVacancyDate; VacancyRegistrationAndEvaluationManager vacancyRegEvaluationManager = new VacancyRegistrationAndEvaluationManager(vacancy); TransactionResponse response = new TransactionResponse(); response = vacancyRegEvaluationManager.getVacancyDetail(vacancy); DataTable employeeData = (DataTable)response.Data; Employee employee = new Employee(); //get list of Employee using Employee manager. if (employeeData != null && employeeData.Rows.Count > 0) { // Display processor and checker in the gridview footer if (e.Row.RowType == DataControlRowType.Footer) { //get processor First name & Middle Name employee.EmpID = employeeData.Rows[0]["responsible_processor_EID"].ToString(); EmployeeManager employeeManager = new EmployeeManager(employee); List<Employee> listOfEmployee = employeeManager.getEmployeeDetial(); string fullName = null; foreach (Employee emply in listOfEmployee) { fullName = emply.FName + " " + emply.MName; } e.Row.Cells[2].Text = "Processed by :"; e.Row.Cells[2].Font.Bold = true; e.Row.Cells[3].Text = fullName; e.Row.Cells[3].Font.Bold = true; //get checkor First name & Middle Name employee.EmpID = employeeData.Rows[0]["reponsible_accessor_EID"].ToString(); employeeManager = new EmployeeManager(employee); listOfEmployee = employeeManager.getEmployeeDetial(); fullName = null; foreach (Employee emply in listOfEmployee) { fullName = emply.FName + " " + emply.MName; } e.Row.Cells[7].Text = "Assessed by :"; e.Row.Cells[7].Font.Bold = true; e.Row.Cells[8].Text = fullName; e.Row.Cells[8].Font.Bold = true; } } else { selectGV.ShowFooter = false; } }
private void BindFirstPhaseReport(int isfromAll, DropDownList selectDropDown) { lblVacancyPhase1.Visible = false; lblVacancyPhase1.Visible = false; string[] splitter = new string[] { PageConstants.GREATER_GREATER_THAN }; string[] VacancyInfoTosplit = (selectDropDown.SelectedValue).Split(splitter, StringSplitOptions.RemoveEmptyEntries); currentVacancyNo = VacancyInfoTosplit[0].Trim(); currentVacancyDate = VacancyInfoTosplit[1].Trim(); resposibleHROfficer = VacancyInfoTosplit[3].Trim(); Vacancy vacancy = new Vacancy(); vacancy.VacancyNo = currentVacancyNo; vacancy.PostedDate = currentVacancyDate; //get recently selected employee getRecentlySelectedLateralPenalityEmployee(vacancy, isfromAll); //get and display the vacancy to user. getVacancyReportAndDisplayToUser(vacancy, PageConstants.REPORT_PHASE1, isfromAll); VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager(); TransactionResponse response = new TransactionResponse(); //get vacancy detail response = manager.getVacancyDetail(vacancy); DataTable dataTable = (DataTable)response.Data; string postDate = ""; try { postDate = String.Format("{0:MMM d, yyyy}", Convert.ToDateTime(dataTable.Rows[0]["posted_date"])); } catch (Exception) { } VacDetailPanel.Visible = true; lblVacancyPost.Text = dataTable.Rows[0]["Vancay_title"].ToString() + " ( JG - " + dataTable.Rows[0]["vacancy_for_JobGrade"].ToString() + " )"; lblVacancyNum.Text = dataTable.Rows[0]["vacancy_No"].ToString() + " dated " + postDate; //lblJobDes.Text = "Specification: "; lblJobReq.Text = dataTable.Rows[0]["JobDescription"].ToString() + " " + dataTable.Rows[0]["JobRequirement"].ToString() + ". "; VacDetailAllForstPhasePanel.Visible = true; lblAll1stVacancyPost.Text = dataTable.Rows[0]["Vancay_title"].ToString() + " ( JG - " + dataTable.Rows[0]["vacancy_for_JobGrade"].ToString() + " )"; lblAll1stVacancyNum.Text = dataTable.Rows[0]["vacancy_No"].ToString() + " dated " + postDate; //lblJobDes.Text = "Specification: "; lblAll1stJobReq.Text = dataTable.Rows[0]["JobDescription"].ToString() + " " + dataTable.Rows[0]["JobRequirement"].ToString() + ". "; }
protected void btnGenerateFinalReport_Click(object sender, EventArgs e) { if (DropDownListFinalResult.SelectedValue == "-1") { lblVacancyFinal.Visible = true; return; } lblVacancyFinal.Visible = false; string[] splitter = new string[] { PageConstants.GREATER_GREATER_THAN }; VacancyInfoTosplit = (DropDownListFinalResult.SelectedValue).Split(splitter, StringSplitOptions.RemoveEmptyEntries); currentVacancyNo = VacancyInfoTosplit[0].Trim(); currentVacancyDate = VacancyInfoTosplit[1].Trim(); Vacancy vacancy = new Vacancy(); vacancy.VacancyNo = currentVacancyNo; vacancy.PostedDate = currentVacancyDate; //get and display the vacancy to user. int isfromAll = 0; getVacancyReportAndDisplayToUser(vacancy, PageConstants.REPORT_PHASE2, isfromAll); VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager(); TransactionResponse response = new TransactionResponse(); //get vacancy detail response = manager.getVacancyDetail(vacancy); DataTable dataTable = (DataTable)response.Data; string postDate = ""; try { postDate = String.Format("{0:MMM d, yyyy}", Convert.ToDateTime(dataTable.Rows[0]["posted_date"])); } catch (Exception) { } VacDetailFinalPanel.Visible = true; lblfinalVacancyPost.Text = dataTable.Rows[0]["Vancay_title"].ToString() + " ( JG - " + dataTable.Rows[0]["vacancy_for_JobGrade"].ToString() + " )"; lblfinalVacancyNum.Text = dataTable.Rows[0]["vacancy_No"].ToString() + " dated " + postDate; lblfinalJobReq.Text = dataTable.Rows[0]["JobDescription"].ToString() + " " + dataTable.Rows[0]["JobRequirement"].ToString() + ". "; }
private string getDetailOfSelectedVacancy(Vacancy vacancy) { VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager(); TransactionResponse response = new TransactionResponse(); //get vacancy detail response = manager.getVacancyDetail(vacancy); DataTable dataTable = (DataTable)response.Data; return (dataTable.Rows[0]["vacancy_evaluation_form"].ToString().Trim()); }
private void populateEmployeeData(Vacancy vacancy) { vacancy.ResponsibleProcessorEID = loggedInEmpID; VacancyRegistrationAndEvaluationManager vacancyRegEvaluationManager = new VacancyRegistrationAndEvaluationManager(vacancy); List<string> empID = vacancyRegEvaluationManager.getListEmpIDForProcessorSecondPhase(evalutedEmpID); if (empID.Count != 0 && empID != null) { Employee emply = new Employee(); emply.EmpID = empID[0]; EmployeeManager EmployeeManager = new EmployeeManager(emply); Employee employee = EmployeeManager.detailOfEmployeToBeEvaluated(vacancy.VacancyNo, VacancyDate); if (employee != null) { //Get the current vacancy detail //Check vacancy status [if status = 7 interview only else if status = 8 exam only, else if status = 9 exam & interview] TransactionResponse response = new TransactionResponse(); response = vacancyRegEvaluationManager.getVacancyDetail(vacancy); DataTable vacancyDetail = (DataTable)response.Data; string formtype = vacancyDetail.Rows[0]["vacancy_evaluation_form"].ToString(); vacancyStatus = vacancyDetail.Rows[0]["status"].ToString(); if (formtype == "2") { if (vacancyStatus == "7") { ExamPanelforForm2.Visible = false; InterviewPanelforForm2.Visible = true; } else if (vacancyStatus == "8") { ExamPanelforForm2.Visible = true; InterviewPanelforForm2.Visible = false; } else if (vacancyStatus == "9") { ExamPanelforForm2.Visible = true; InterviewPanelforForm2.Visible = true; } } if (checkAlreadyEvaluatedApplicantAndDisplayForUpdate(employee, vacancy)) { return; } displayApplcantDetailEvaluationForm(employee); } else { UserDetialPanel.Visible = false; PanelApplicantmsg.Visible = true; ApplErrorDiv.Visible = true; lblApplicantErrormsg.Text = DBOperationErrorConstants.M_NO_EMPLOYEE_REGISTERED_FOR_PROCESSOR_SECOND_PHASE; } } else { UserDetialPanel.Visible = false; PanelApplicantmsg.Visible = true; ApplErrorDiv.Visible = true; lblApplicantErrormsg.Text = DBOperationErrorConstants.M_NO_EMPLOYEE_REGISTERED_FOR_PROCESSOR_SECOND_PHASE; } }
protected void btnConfirmComplete_Click(object sender, EventArgs e) { string temp = DropDownVacancyProfList.SelectedValue; if (temp == "-1") { lblDropVacancyList.Visible = true; return; } string[] splitter = new string[] { PageConstants.GREATER_GREATER_THAN }; VacancyInfoTosplit = (temp).Split(splitter, StringSplitOptions.RemoveEmptyEntries); vacancyNo = VacancyInfoTosplit[0].Trim(); VacancyDate = VacancyInfoTosplit[1].Trim(); //Update vacancy Profile arrived date. Vacancy vacancy = new Vacancy(); vacancy.VacancyNo = vacancyNo; vacancy.PostedDate = VacancyDate; TransactionResponse response = new TransactionResponse(); VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager(vacancy); response = manager.updateProfileArrivedDateAndVacancyStatus(); PanelConfirmVacancyComplete.Visible = false; displayMessageToTheUser(response); if (response.isSuccessful()) { //REGISTER NOTIFICATION for HR Manager //check the vacancy status whether its re-advertise or Normal response = manager.getVacancyDetail(vacancy); DataTable dataTable = (DataTable)response.Data; string vacStatus = null; string repHROfficerProcessor = null; string repHROfficerCheckor = null; NotificationManager notificationManager = new NotificationManager(vacancy); TransactionResponse notificationResponse = null; if (dataTable != null && dataTable.Rows.Count > 0) { vacStatus = dataTable.Rows[0]["status"].ToString(); repHROfficerProcessor = dataTable.Rows[0]["responsible_processor_EID"].ToString(); repHROfficerCheckor = dataTable.Rows[0]["reponsible_accessor_EID"].ToString(); if (vacStatus.Trim() == "11") { if (repHROfficerCheckor != null || repHROfficerProcessor != null) { } else { notificationResponse = notificationManager.addNotification(Membership.GetUser(), "6"); } } else { notificationResponse = notificationManager.addNotification(Membership.GetUser(), "6"); } } if (!notificationResponse.isSuccessful()) { WarnDIV.Visible = true; lblWarningMsg.Text = notificationResponse.getMessage() + notificationResponse.getErrorCode(); } DropDownVacancyProfList.ClearSelection(); } else { msgPanel.Visible = true; InfoDIV.Visible = true; lblInformationMsg.Text = response.getMessage(); DropDownVacancyProfList.ClearSelection(); } }
protected void AssignedVacDV_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { int updateAccProc = 0; string oldProcessor = null; string oldAccessor = null; int ProcAccUpdateStatus = 0; try { string vacancyTitle = e.NewValues["[Vacancy Title]"].ToString().Trim(); string branchID = e.NewValues["branch_id"].ToString().Trim(); string deadLine = e.NewValues["[Vacancy Deadline]"].ToString().Trim(); string jGrade = e.NewValues["[Job Grade]"].ToString().Trim(); string vacancyStatus = e.NewValues["status"].ToString().Trim(); string year4Gen = e.NewValues["[Year required for General]"].ToString().Trim(); string year4Spec = e.NewValues["[Year required for Specific]"].ToString().Trim(); string genPerc = e.NewValues["[General Work Exp Percentage]"].ToString().Trim(); string specPerc = e.NewValues["[Specific Work Exp Percentage]"].ToString().Trim(); string RelPer = e.NewValues["[Related Work Exp Percentage]"].ToString().Trim(); string examPer = e.NewValues["[Examination Percentage]"].ToString().Trim(); string mangRec = e.NewValues["[Manageral Rec Percentage]"].ToString().Trim(); string interviewPer = e.NewValues["[Interview Percentage]"].ToString().Trim(); string jobDes = e.NewValues["[Job Description]"].ToString().Trim(); string jobReq = e.NewValues["[Job Requirement]"].ToString().Trim(); string benefit = e.NewValues["[Job Benefit]"].ToString().Trim(); string appCompDate = e.NewValues["[Applicant Registration Complete Date]"].ToString().Trim(); string profArrive = e.NewValues["[Profile Arrived Date]"].ToString().Trim(); string procSDate = e.NewValues["[Processor Start Date]"].ToString().Trim(); string procEDate = e.NewValues["[Processor End Date]"].ToString().Trim(); string accesSDate = e.NewValues["[Accessor Start Date]"].ToString().Trim(); string accesEDate = e.NewValues["[Accessor End Date]"].ToString().Trim(); string procID = e.NewValues["[Processor ID]"].ToString().Trim(); string accesID = e.NewValues["[Accessor ID]"].ToString().Trim(); if (vacStatusCanEditted == "Vacancy Checking Done" || vacStatusCanEditted == "Vacancy Evalution1 Done" || vacStatusCanEditted == "Vacancy Evalution2 Done") { updateAccProc = 0; } else { updateAccProc = 1; } Vacancy vacancy = new Vacancy(); vacancy.VancayTitle = vacancyTitle; vacancy.BranchId = branchID; vacancy.VancyDeadline = deadLine; vacancy.VacancyforJobGrade = jGrade; vacancy.Status = vacancyStatus; vacancy.YearRequiredforGeneral = year4Gen; vacancy.YearRequiredforSpec = year4Spec; vacancy.GeneralWrkExprPercent = genPerc; vacancy.SpecificWrkExprPercent = specPerc; vacancy.RelatedWrkExprPercent = RelPer; vacancy.ExaminationPercent = examPer; vacancy.ManagerRecPercent = mangRec; vacancy.InterviewPercent = interviewPer; vacancy.ApplicantComplete = appCompDate; vacancy.ProfileArrivedDate = profArrive; vacancy.ProcessorStartDate = procSDate; vacancy.ProcessorEndDate = procEDate; vacancy.AccessorStartDate = accesSDate; vacancy.AccessorEndDate = accesEDate; vacancy.ResponsibleProcessorEID = procID; vacancy.ResponsibleAccessorEID = accesID; vacancy.JobDescription = jobDes; vacancy.JobRequirement = jobReq; vacancy.SalaryAndBenefit = benefit; vacancy.VacancyNo = vacancyNoforGV; vacancy.PostedDate = postDate; VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager(); TransactionResponse response = new TransactionResponse(); //get the current Processor and Checker response = manager.getVacancyDetail(vacancy); DataTable dataTable = (DataTable)response.Data; if (dataTable != null && dataTable.Rows.Count > 0) { oldProcessor = dataTable.Rows[0]["responsible_processor_EID"].ToString().Trim(); oldAccessor = dataTable.Rows[0]["reponsible_accessor_EID"].ToString().Trim(); if (procID == oldProcessor && accesID == oldAccessor) { ProcAccUpdateStatus = 1; } else if (procID != oldProcessor && accesID == oldAccessor) { ProcAccUpdateStatus = 2; } else if (procID == oldProcessor && accesID != oldAccessor) { ProcAccUpdateStatus = 3; } else if (procID != oldProcessor && accesID != oldAccessor) { ProcAccUpdateStatus = 4; } } response = manager.updateVacancyDetailAssignedtoHROfficer(vacancy, updateAccProc, ProcAccUpdateStatus, oldProcessor, oldAccessor); if (response.isSuccessful()) { AssignedVacDV.ChangeMode(DetailsViewMode.ReadOnly); BindAssignedVacToDetailView(); msgPanel.Visible = true; SucessDIV.Visible = true; lblSuccessMessage.Text = response.getMessage(); } else { msgPanel.Visible = true; ErroroDIV.Visible = true; lblErrorMsg.Text = response.getMessage(); } } catch (Exception ex) { msgPanel.Visible = true; lblErrorMsg.Text = ex.StackTrace.ToString(); } }
protected void btnConfirmComplete_Click(object sender, EventArgs e) { lblCompleteVacancy.Visible = false; string[] splitter = new string[] { PageConstants.GREATER_GREATER_THAN }; string[] VacancyInfoTosplit = (DropDownListCompVacancy.SelectedItem.Text).Split(splitter, StringSplitOptions.RemoveEmptyEntries); string vacancyNo = VacancyInfoTosplit[0].Trim(); string VacancyDate = VacancyInfoTosplit[1].Trim(); //Update vacancy Profile arrived date. Vacancy vacancy = new Vacancy(); vacancy.VacancyNo = vacancyNo; vacancy.PostedDate = VacancyDate; TransactionResponse response = new TransactionResponse(); VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager(vacancy); response = manager.getVacancyDetail(vacancy); DataTable dataTable = (DataTable)response.Data; string vacStatus = null; string respProcessor = null; string respAccessor = null; if (dataTable != null && dataTable.Rows.Count > 0) { vacStatus = dataTable.Rows[0]["status"].ToString().Trim(); respProcessor = dataTable.Rows[0]["responsible_processor_EID"].ToString().Trim(); respAccessor = dataTable.Rows[0]["reponsible_accessor_EID"].ToString().Trim(); } vacancy.ResponsibleProcessorEID = respProcessor; vacancy.ResponsibleAccessorEID = respAccessor; if (vacStatus == "11" && respAccessor != null && respProcessor != null && respAccessor != "" && respProcessor != "") { //Change the status of the vacancy into 3 ==> assigned to HR Officer //notifiy Re-advertise vacancy re-assigned to HR Officer //update vacancy status to 'assigned for Evaluation' STAUS CODE = 3 . vacancy.Status = VacancyConstants.VACANCY_ASSIGNED_TO_HR_OFFICERS; VacancyRegistrationAndEvaluationManager vacancyRegistrationManager = new VacancyRegistrationAndEvaluationManager(vacancy); response = vacancyRegistrationManager.updateVacancyStatusToAssgnedFromReAdvertise(); //Notification for HR Officer goes here. NotificationManager notificationManager = new NotificationManager(vacancy); TransactionResponse notificationResponse = notificationManager.addNotificationForVacancyAssignement(Membership.GetUser(), true); if (notificationResponse.isSuccessful()) { } else { WarnDIV.Visible = true; lblWarningMsg.Text = notificationResponse.getMessage() + notificationResponse.getErrorCode(); } } else { response = manager.getApplicantRegistrationComplete(); if (response.isSuccessful()) { response = manager.updateApplicantRegisterationCompleteDate(); if (response.isSuccessful()) { msgPanel.Visible = true; SucessDIV.Visible = true; lblSuccessMessage.Text = response.getMessage(); PanelCompleteApplicant.Visible = true; btnCompAppReg.Visible = true; DropDownListCompVacancy.ClearSelection(); //Register Notification here if its required } else { msgPanel.Visible = true; ErroroDIV.Visible = true; lblErrorMsg.Text = response.getMessage() + response.getErrorCode(); } } else { clearMsgPanel(); msgPanel.Visible = true; InfoDIV.Visible = true; lblInformationMsg.Text = response.getMessage(); } } populateVacancyList(); populateVacancyForRegComplete(); PanelConfirmVacancyComplete.Visible = false; DropDownListCompVacancy.ClearSelection(); }