private TransactionResponse sendInsertPromotionToDb(string spName, IDictionary<string, object> parameters) { //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(spName, parameters); TransactionResponse response = new TransactionResponse(); try { //call store to DB mathod and get reponse. storeToDb.instertNewRecord(); response.setSuccess(true); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setMessage(DBOperationErrorConstants.M_PROMOTION_REGISTER_OK); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_PROMOTION_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_APP_RATING_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }
/** * calls Store to DB utility for the current employee. */ public TransactionResponse AddHROfficerOrClerk(string SPName, string EmpID) { //Add List of Arguments for new employee IDictionary<string, object> paramater = new Dictionary<string, object>(); paramater.Add("@Emp_ID", EmpID); //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(SPName, paramater); TransactionResponse response = new TransactionResponse(); //call store to DB mathod and get reponse. try { storeToDb.instertNewRecord(); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setSuccess(true); response.setMessage(DBOperationErrorConstants.M_HR_OFFICER_REGISTER_OK); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_EID_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_EMP_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }
// Insert Inactive Employeee into DB public TransactionResponse storeInactiveEmployee() { //Add List of Arguments for new employee IDictionary<string, object> employeeArgumentaMap = new Dictionary<string, object>(); employeeArgumentaMap.Add("@EmpID", employee.EmpID); employeeArgumentaMap.Add("@FName", employee.FName); employeeArgumentaMap.Add("@MName", employee.MName); employeeArgumentaMap.Add("@LName", employee.LName); employeeArgumentaMap.Add("@Sex", employee.Sex); employeeArgumentaMap.Add("@JobTitle", employee.JobTitle); employeeArgumentaMap.Add("@branch", employee.Branch); employeeArgumentaMap.Add("@dateOfEmp", inactiveEmployee.DateOfEmployment); employeeArgumentaMap.Add("@dateOfTerm", inactiveEmployee.DateOfTermination); employeeArgumentaMap.Add("@majorCategory", inactiveEmployee.MajorCategory); employeeArgumentaMap.Add("@ReasonForleave", inactiveEmployee.ReasonForLeave); //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(DbAccessConstants.spAddInactiveEmployee, employeeArgumentaMap); TransactionResponse response = new TransactionResponse(); //call store to DB mathod and get reponse. try { storeToDb.instertNewRecord(); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setSuccess(true); response.setMessage(DBOperationErrorConstants.M_INACTIVE_EMPLOYEE_REGISTER_OK); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_EID_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_EMP_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_EVIL_ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_EVIL_ERROR); response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setSuccess(false); return response; } return response; }
/** * Add employee remark */ public TransactionResponse storeEmployeeremark(MembershipUser currentUser) { //get detail of the logged on user. Employee employee = EmployeeManager.getLoggedOnUser((Guid)currentUser.ProviderUserKey); if (employee == null) { return EmployeeManager.handleLoggedInUserCanNotBeIdentfied(); } //Add List of Arguments for new employee IDictionary<string, object> employeeRemarkMap = new Dictionary<string, object>(); employeeRemarkMap.Add("@EmpID", employeeRemark.EmployeeID); employeeRemarkMap.Add("@remarkRefNo", employeeRemark.RemarkReferanceNo); employeeRemarkMap.Add("@dateOfRemark", employeeRemark.DateOfRemark); employeeRemarkMap.Add("@remarkType", employeeRemark.RemarkType); employeeRemarkMap.Add("@penalityPerc", employeeRemark.PenaltyPerc); employeeRemarkMap.Add("@managerID", employeeRemark.ManagerID); employeeRemarkMap.Add("@managerPosition", employeeRemark.ManagerPosition); employeeRemarkMap.Add("@remarkReason", employeeRemark.RemarkReason); employeeRemarkMap.Add("@responsiblehrOfficerID", employee.EmpID); employeeRemarkMap.Add("@Branch", employeeRemark.Branch); //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(DbAccessConstants.spAddEmployeeRemark, employeeRemarkMap); TransactionResponse response = new TransactionResponse(); //call store to DB mathod and get reponse. try { storeToDb.instertNewRecord(); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setSuccess(true); response.setMessage(DBOperationErrorConstants.M_EMPLOYEE_REMARK_REGISTER_OK); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_REF_NO_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_EMP_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }
/** * Add promoted employee from other district */ public TransactionResponse storeEmployeefromOtherDistrictForPromotion(string minNumber, string districtID) { //Add List of Arguments for new employee IDictionary<string, object> employeeArgumentaMap = new Dictionary<string, object>(); employeeArgumentaMap.Add("@Minute_No", minNumber); employeeArgumentaMap.Add("@Emp_ID", employee.EmpID); employeeArgumentaMap.Add("@First_Name", employee.FName); employeeArgumentaMap.Add("@Middle_Name", employee.MName); employeeArgumentaMap.Add("@Last_Name", employee.LName); employeeArgumentaMap.Add("@Curr_Jtitle", employee.PrevJob); employeeArgumentaMap.Add("@Curr_JGrade", employee.PrevJobGrade); employeeArgumentaMap.Add("@Exp_JGrade", employee.JobGrade); employeeArgumentaMap.Add("@Salary", employee.Salary); employeeArgumentaMap.Add("@district", districtID); employeeArgumentaMap.Add("@status", "Active"); //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(DbAccessConstants.spAddPromotedEmployeefromOtherDistrict, employeeArgumentaMap); TransactionResponse response = new TransactionResponse(); //call store to DB mathod and get reponse. try { storeToDb.instertNewRecord(); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setSuccess(true); response.setMessage(DBOperationErrorConstants.M_EMPLOYEE_REGISTER_OK); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_EID_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_EMP_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }
/** * calls Store to DB utility for the current employee. */ public TransactionResponse storeEmployee() { //Add List of Arguments for new employee IDictionary<string, object> employeeArgumentaMap = new Dictionary<string, object>(); employeeArgumentaMap.Add("@Emp_ID", employee.EmpID); employeeArgumentaMap.Add("@UserId", employee.UserID); employeeArgumentaMap.Add("@First_Name", employee.FName); employeeArgumentaMap.Add("@Middle_Name", employee.MName); employeeArgumentaMap.Add("@Last_Name", employee.LName); employeeArgumentaMap.Add("@Sex", employee.Sex); employeeArgumentaMap.Add("@Prev_Job_Tittle", employee.PrevJob); employeeArgumentaMap.Add("@Job_Tittle", employee.JobTitle); employeeArgumentaMap.Add("@Grade", employee.JobGrade); employeeArgumentaMap.Add("@Salary", employee.Salary); employeeArgumentaMap.Add("@branch", employee.Branch); DateTime HDatefinal = DateTime.ParseExact(employee.Hdate, "dd/MM/yyyy", CultureInfo.InvariantCulture); employeeArgumentaMap.Add("@HDate", HDatefinal); employeeArgumentaMap.Add("@MajorCategory", employee.MajorCategory); employeeArgumentaMap.Add("@district", employee.District); //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(DbAccessConstants.spAddNewEmployee, employeeArgumentaMap); TransactionResponse response = new TransactionResponse(); //call store to DB mathod and get reponse. try { storeToDb.instertNewRecord(); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setSuccess(true); response.setMessage(DBOperationErrorConstants.M_EMPLOYEE_REGISTER_OK); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_EID_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_EMP_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }
public TransactionResponse addNewVacancy() { //Add List of Arguments for new employee IDictionary<string, object> vacancyParameters = new Dictionary<string, object>(); vacancyParameters.Add("@vacancy_No", vacancy.VacancyNo); vacancyParameters.Add("@Vancay_title", vacancy.VancayTitle); vacancyParameters.Add("@branch_id", vacancy.BranchId); vacancyParameters.Add("@vancy_deadline", vacancy.VancyDeadline); vacancyParameters.Add("@vacancy_for_JobGrade", vacancy.VacancyforJobGrade); vacancyParameters.Add("@vacancy_opened_for", vacancy.VacancyOpenedFor); vacancyParameters.Add("@vacancy_evaluation_form", vacancy.VacancyEvaluationForm); vacancyParameters.Add("@year_gen_required", vacancy.YearRequiredforGeneral); vacancyParameters.Add("@year_spec_required", vacancy.YearRequiredforSpec); vacancyParameters.Add("@general_wrk_expr_percent", vacancy.GeneralWrkExprPercent); vacancyParameters.Add("@specific_wrk_expr_percent", vacancy.SpecificWrkExprPercent); vacancyParameters.Add("@related_wrk_expr_percent", vacancy.RelatedWrkExprPercent); vacancyParameters.Add("@examination_percent", vacancy.ExaminationPercent); vacancyParameters.Add("@manager_Recom_percent", vacancy.ManagerRecPercent); vacancyParameters.Add("@interview_percent", vacancy.InterviewPercent); vacancyParameters.Add("@JobDescription", vacancy.JobDescription); vacancyParameters.Add("@JobRequirement", vacancy.JobRequirement); vacancyParameters.Add("@JobBenefit", vacancy.SalaryAndBenefit); vacancyParameters.Add("@districtId", PageAccessManager.getDistrictID()); //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(DbAccessConstants.spAddNewVacancy, vacancyParameters); TransactionResponse response = new TransactionResponse(); try { //call store to DB mathod and get reponse. storeToDb.instertNewRecord(); response.setSuccess(true); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setMessage(DBOperationErrorConstants.M_VACANCY_REGISTER_OK); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_VACANCY_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_VACANCY_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }
/** * Add Employee into training room */ public TransactionResponse AddEmployeeInTrainingRoom(string EmpID, string dueDate, string startDate, string endDate, string trainID) { //create parameters map to pass IDictionary<string, object> argumentsMap = new Dictionary<string, object>(); argumentsMap.Add("@Emp_ID", EmpID); argumentsMap.Add("@Training_ID", trainID); argumentsMap.Add("@DueDate", dueDate); argumentsMap.Add("@StartDate", startDate); argumentsMap.Add("@EndDate", endDate); //Pass Stored Procedure Name and parameter list. DBOperationsUtil storeToDb = new DBOperationsUtil(DbAccessConstants.spAddEmployeeIntoTrainingRoom, argumentsMap); //call sote to DB method. //bool response = storeToDb.instertNewRecord(); TransactionResponse response = new TransactionResponse(); //call store to DB mathod and get reponse. try { storeToDb.instertNewRecord(); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setSuccess(true); response.setMessage(DBOperationErrorConstants.M_TRANSACTION_SUCCESS); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setSuccess(false); response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_EID_KEY_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setSuccess(false); response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_UNKNOWN_ERROR_EMP_REGISTER); response.setErrorCode(DBOperationErrorConstants.E_UNKNOWN_ERROR_AT_DB_OOPERATION); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }
private TransactionResponse addNewNotification() { IDictionary<string, object> notificationParams = new Dictionary<string, object>(); notificationParams.Add("@taskReference", notification.TaskRreference); notificationParams.Add("@receiverEmpId", notification.Receiver); notificationParams.Add("@senderEmpId", notification.Sender); notificationParams.Add("@notificationIsFor", notification.NotificationIsFor); notificationParams.Add("@registeredDate", notification.RegisteredDate); notificationParams.Add("@disctrictId", PageAccessManager.getDistrictID()); TransactionResponse response = new TransactionResponse(); //call store to DB mathod and get reponse. try { //Pass Stored Procedure Name and parameter list. DBOperationsUtil dbOperation = new DBOperationsUtil(DbAccessConstants.spGetAddNewNotification, notificationParams); dbOperation.instertNewRecord(); response.setMessageType(TransactionResponse.SeverityLevel.SUCESS); response.setMessage(DBOperationErrorConstants.M_NOTIF_REGISTER_OK); response.setSuccess(true); } catch (SqlException ex) { //Determine if the cause was duplicate KEY. if (ex.ToString().Contains(DBOperationErrorConstants.PK_DUPLICATE_INDICATOR)) { response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_DUPLICATE_NOTIF_ERROR); response.setErrorCode(DBOperationErrorConstants.E_DUPLICATE_KEY_ERROR); } else { //Other SqlException is catched response.setMessageType(TransactionResponse.SeverityLevel.ERROR); response.setMessage(DBOperationErrorConstants.M_NOTIFY_REGISTERED_PROMOTION_FAILED); response.setErrorCode(DBOperationErrorConstants.E_PROMOTION_NOTIFICATION_FAILED); } } //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error catch (Exception ex) { //Write this exception to file for investigation of the issue later. logException(ex); LoggerManager.upDateWithGenericErrorMessage(response); } return response; }