/// <summary> /// Gets the skill details. /// </summary> /// <param name="employeeID">The employee ID.</param> /// <returns></returns> private BusinessEntities.RaveHRCollection GetSkillDetails(int employeeID) { Rave.HR.BusinessLayer.Employee.SkillsDetails objSkillsDetailsBAL; BusinessEntities.SkillsDetails objSkillsDetails; // Initialise Collection class object BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection(); try { objSkillsDetailsBAL = new Rave.HR.BusinessLayer.Employee.SkillsDetails(); objSkillsDetails = new BusinessEntities.SkillsDetails(); objSkillsDetails.EMPId = employeeID; raveHRCollection = objSkillsDetailsBAL.GetSkillsDetails(objSkillsDetails); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetSkillDetails", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER); LogErrorMessage(objEx); } return(raveHRCollection); }
/// <summary> /// Deletes the skills details. /// </summary> /// <param name="objDeleteSkillsDetails">The object delete skills details.</param> public void DeleteSkillsDetails(BusinessEntities.SkillsDetails objDeleteSkillsDetails) { objDA = new DataAccessClass(); sqlParam = new SqlParameter[2]; try { objDA.OpenConnection(DBConstants.GetDBConnectionString()); sqlParam[0] = new SqlParameter(SPParameter.SkillsId, SqlDbType.Int); if (objDeleteSkillsDetails.SkillsId == 0) { sqlParam[0].Value = DBNull.Value; } else { sqlParam[0].Value = objDeleteSkillsDetails.SkillsId; } sqlParam[1] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int); if (objDeleteSkillsDetails.EMPId == 0) { sqlParam[1].Value = DBNull.Value; } else { sqlParam[1].Value = objDeleteSkillsDetails.EMPId; } objDA.ExecuteNonQuerySP(SPNames.Employee_DeleteSkillsDetails, sqlParam); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, DELETESKILLSDETAILS, EventIDConstants.RAVE_EMP_SKILL_SEARCH_DATA_ACCESS_LAYER); } finally { objDA.CloseConncetion(); } }
/// <summary> /// Handles the Click event of the btnAdd control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnAdd_Click(object sender, EventArgs e) { try { if (ValidateControls()) { BusinessEntities.SkillsDetails objSkillsDetails = new BusinessEntities.SkillsDetails(); if (gvSkills.Rows[0].Cells[0].Text == NO_RECORDS_FOUND_MESSAGE) { SkillDetailsCollection.Clear(); } objSkillsDetails.SkillName = ddlSkills.SelectedItem.Text; objSkillsDetails.Experience = txtYearsOfExperience.Text; objSkillsDetails.ProficiencyLevel = ddlProficiencyLevel.SelectedItem.Text; objSkillsDetails.LastUsedDate = Convert.ToDateTime(txtLastUsedDate.Text); objSkillsDetails.Mode = 1; objSkillsDetails.Proficiency = int.Parse(ddlProficiencyLevel.SelectedValue); objSkillsDetails.Skill = int.Parse(ddlSkills.SelectedValue); objSkillsDetails.SkillType = int.Parse(ddlSkillsType.SelectedValue); SkillDetailsCollection.Add(objSkillsDetails); this.BindGrid(); this.ClearControls(); if (gvSkills.Rows.Count != 0) { btnSave.Visible = true; } } } catch (RaveHRException ex) { LogErrorMessage(ex); } catch (Exception ex) { RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "btnAddRow_Click", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER); LogErrorMessage(objEx); } }
/// <summary> /// Adds the skills details. /// </summary> /// <param name="objAddSkillsDetails">The object add skills details.</param> public void AddSkillsDetails(BusinessEntities.SkillsDetails objAddSkillsDetails) { objDA = new DataAccessClass(); sqlParam = new SqlParameter[8]; try { objDA.OpenConnection(DBConstants.GetDBConnectionString()); sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int); sqlParam[0].Value = objAddSkillsDetails.EMPId; sqlParam[1] = new SqlParameter(SPParameter.Skill, SqlDbType.Int); if (objAddSkillsDetails.Skill == 0) { sqlParam[1].Value = DBNull.Value; } else { sqlParam[1].Value = objAddSkillsDetails.Skill; } sqlParam[2] = new SqlParameter(SPParameter.Proficiency, SqlDbType.Int); if (objAddSkillsDetails.Proficiency == 0) { sqlParam[2].Value = DBNull.Value; } else { sqlParam[2].Value = objAddSkillsDetails.Proficiency; } sqlParam[3] = new SqlParameter(SPParameter.LastUsedDate, SqlDbType.Int); if (objAddSkillsDetails.LastUsed == 0) { sqlParam[3].Value = DBNull.Value; } else { sqlParam[3].Value = objAddSkillsDetails.LastUsed; } sqlParam[4] = new SqlParameter(SPParameter.SkillVersion, SqlDbType.NVarChar, 50); if ( objAddSkillsDetails.SkillVersion == null || objAddSkillsDetails.SkillVersion == string.Empty || objAddSkillsDetails.SkillVersion == " " || objAddSkillsDetails.SkillVersion == "&nbsp;" ) { sqlParam[4].Value = DBNull.Value; } else { sqlParam[4].Value = objAddSkillsDetails.SkillVersion; } sqlParam[5] = new SqlParameter(SPParameter.ExperienceInYear, SqlDbType.Int); sqlParam[5].Value = objAddSkillsDetails.Year; sqlParam[6] = new SqlParameter(SPParameter.ExperienceInMonth, SqlDbType.Int); sqlParam[6].Value = objAddSkillsDetails.Month; sqlParam[7] = new SqlParameter(SPParameter.SkillName, SqlDbType.NVarChar, 50); if (objAddSkillsDetails.SkillName == null) { sqlParam[7].Value = DBNull.Value; } else { sqlParam[7].Value = objAddSkillsDetails.SkillName; } objDA.ExecuteNonQuerySP(SPNames.Employee_AddSkillsDetails, sqlParam); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, ADDSKILLSDETAILS, EventIDConstants.RAVE_EMP_SKILL_SEARCH_DATA_ACCESS_LAYER); } finally { objDA.CloseConncetion(); } }
/// <summary> /// Gets the skills details. /// </summary> /// <param name="objGetSkillsDetails">The object get skills details.</param> /// <returns></returns> public BusinessEntities.RaveHRCollection GetSkillsDetails(BusinessEntities.SkillsDetails objGetSkillsDetails) { //Initialise Data Access Class object objDA = new DataAccessClass(); //Initialise SqlParameter Class object sqlParam = new SqlParameter[1]; //Initialise Collection class object raveHRCollection = new BusinessEntities.RaveHRCollection(); try { //Open the connection to DB objDA.OpenConnection(DBConstants.GetDBConnectionString()); //Check each parameters nullibality and add values to sqlParam object accordingly sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int); if (objGetSkillsDetails.EMPId == 0) { sqlParam[0].Value = DBNull.Value; } else { sqlParam[0].Value = objGetSkillsDetails.EMPId; } objDataReader = objDA.ExecuteReaderSP(SPNames.Employee_GetSkillsDetails, sqlParam); while (objDataReader.Read()) { //Initialise the Business Entity object objSkillsDetails = new BusinessEntities.SkillsDetails(); objSkillsDetails.SkillsId = Convert.ToInt32(objDataReader[DbTableColumn.SId].ToString()); objSkillsDetails.EMPId = Convert.ToInt32(objDataReader[DbTableColumn.EMPId].ToString()); objSkillsDetails.Skill = Convert.ToInt32(objDataReader[DbTableColumn.SkillId].ToString()); objSkillsDetails.SkillVersion = objDataReader[DbTableColumn.SkillVersion].ToString(); objSkillsDetails.SkillName = objDataReader[DbTableColumn.Skill].ToString(); objSkillsDetails.Month = Convert.ToInt32(objDataReader[DbTableColumn.ExperienceInMonth].ToString()); objSkillsDetails.Year = Convert.ToInt32(objDataReader[DbTableColumn.ExperienceInYear].ToString()); objSkillsDetails.Proficiency = Convert.ToInt32(objDataReader[DbTableColumn.ProficiencyLevel].ToString()); objSkillsDetails.ProficiencyLevel = objDataReader[DbTableColumn.Proficiency].ToString(); objSkillsDetails.LastUsed = Convert.ToInt32(objDataReader[DbTableColumn.LastUsedDate].ToString()); // Add the object to Collection raveHRCollection.Add(objSkillsDetails); } } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, GETSKILLSDETAILS, EventIDConstants.RAVE_EMP_SKILL_SEARCH_DATA_ACCESS_LAYER); } finally { if (objDataReader != null) { objDataReader.Close(); } objDA.CloseConncetion(); } return(raveHRCollection); }
/// <summary> /// Handles the RowDeleting event of the gvSkills control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.Web.UI.WebControls.GridViewDeleteEventArgs"/> instance containing the event data.</param> protected void gvSkills_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int deleteRowIndex = 0; int rowIndex = -1; BusinessEntities.SkillsDetails objSkillsDetails = new BusinessEntities.SkillsDetails(); deleteRowIndex = e.RowIndex; objSkillsDetails = (BusinessEntities.SkillsDetails)SkillDetailsCollection.Item(deleteRowIndex); objSkillsDetails.Mode = 3; if (ViewState[SKILLDETAILSDELETE] != null) { BusinessEntities.RaveHRCollection objDeleteSkillDetailsCollection = (BusinessEntities.RaveHRCollection)ViewState[SKILLDETAILSDELETE]; objDeleteSkillDetailsCollection.Add(objSkillsDetails); ViewState[SKILLDETAILSDELETE] = objDeleteSkillDetailsCollection; } else { BusinessEntities.RaveHRCollection objDeleteSkillDetailsCollection1 = new BusinessEntities.RaveHRCollection(); objDeleteSkillDetailsCollection1.Add(objSkillsDetails); ViewState[SKILLDETAILSDELETE] = objDeleteSkillDetailsCollection1; } SkillDetailsCollection.RemoveAt(deleteRowIndex); ViewState[DELETEROWINDEX] = deleteRowIndex; BindGrid(); if (ViewState[ROWINDEX] != null) { rowIndex = Convert.ToInt32(ViewState[ROWINDEX].ToString()); //Check edit index with deleted index if edit index is //greater than or equal to delete index then rowindex decremented. if (rowIndex != -1 && deleteRowIndex <= rowIndex) { rowIndex--; //store the rowindex in viewstate. ViewState[ROWINDEX] = rowIndex; } ImageButton ibtnDelete = (ImageButton)gvSkills.Rows[rowIndex].FindControl(IBTNDELETE); ibtnDelete.Enabled = false; //Disabling all the edit buttons. for (int i = 0; i < gvSkills.Rows.Count; i++) { if (rowIndex != i) { ImageButton ibtnEdit = (ImageButton)gvSkills.Rows[i].FindControl(IBTNEDIT); ibtnEdit.Enabled = false; } } } } catch (RaveHRException ex) { LogErrorMessage(ex); } catch (Exception ex) { RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "gvSkills_RowDeleting", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER); LogErrorMessage(objEx); } }
/// <summary> /// Handles the Click event of the btnSave control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnSave_Click(object sender, EventArgs e) { Rave.HR.BusinessLayer.Employee.SkillsDetails objSkillsDetailsBAL; Rave.HR.BusinessLayer.Employee.Employee objEmployeeSkillsBAL; BusinessEntities.SkillsDetails objSkillsDetails; BusinessEntities.RaveHRCollection objSaveSkillsDetailsCollection = new BusinessEntities.RaveHRCollection(); try { objSkillsDetailsBAL = new Rave.HR.BusinessLayer.Employee.SkillsDetails(); objEmployeeSkillsBAL = new Rave.HR.BusinessLayer.Employee.Employee(); if (gvSkills.Rows[0].Cells[0].Text != NO_RECORDS_FOUND_MESSAGE) { for (int i = 0; i < gvSkills.Rows.Count; i++) { objSkillsDetails = new BusinessEntities.SkillsDetails(); Label SkillValue = (Label)gvSkills.Rows[i].FindControl(SKILL); Label ProficiencyValue = (Label)gvSkills.Rows[i].FindControl(PROFICIENCY); Label SkillId = (Label)gvSkills.Rows[i].FindControl(SKILLID); Label Mode = (Label)gvSkills.Rows[i].FindControl(MODE); objSkillsDetails.SkillsId = int.Parse(SkillId.Text); objSkillsDetails.EMPId = int.Parse(EMPId.Value); objSkillsDetails.SkillName = gvSkills.Rows[i].Cells[0].Text; objSkillsDetails.Experience = gvSkills.Rows[i].Cells[1].Text; objSkillsDetails.ProficiencyLevel = gvSkills.Rows[i].Cells[2].Text; objSkillsDetails.LastUsedDate = Convert.ToDateTime(gvSkills.Rows[i].Cells[3].Text); objSkillsDetails.Mode = int.Parse(Mode.Text); objSkillsDetails.Skill = int.Parse(SkillValue.Text); objSkillsDetails.Proficiency = int.Parse(ProficiencyValue.Text); objSaveSkillsDetailsCollection.Add(objSkillsDetails); } } BusinessEntities.RaveHRCollection objDeleteSkillsDetailsCollection = (BusinessEntities.RaveHRCollection)ViewState[SKILLDETAILSDELETE]; if (objDeleteSkillsDetailsCollection != null) { BusinessEntities.SkillsDetails obj = null; for (int i = 0; i < objDeleteSkillsDetailsCollection.Count; i++) { objSkillsDetails = new BusinessEntities.SkillsDetails(); obj = (BusinessEntities.SkillsDetails)objDeleteSkillsDetailsCollection.Item(i); objSkillsDetails.SkillsId = obj.SkillsId; objSkillsDetails.EMPId = obj.EMPId; objSkillsDetails.Skill = obj.Skill; objSkillsDetails.Experience = obj.Experience; objSkillsDetails.Proficiency = obj.Proficiency; objSkillsDetails.Mode = obj.Mode; objSkillsDetails.Skill = obj.Skill; objSkillsDetails.Proficiency = obj.Proficiency; objSaveSkillsDetailsCollection.Add(objSkillsDetails); } } objSkillsDetailsBAL.Manipulation(objSaveSkillsDetailsCollection); if (ViewState.Count > 0) { ViewState.Clear(); } if (EMPId.Value != string.Empty) { int empID = Convert.ToInt32(EMPId.Value); //Refresh the grip after saving this.PopulateGrid(empID); } if (gvSkills.Rows.Count == 0) { btnSave.Visible = false; } objEmployeeSkillsBAL.SendMailApprovalOfSkillsRating(employee); lblMessage.Text = "Skills details saved successfully."; } catch (RaveHRException ex) { LogErrorMessage(ex); } catch (Exception ex) { RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "btnSave_Click", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER); LogErrorMessage(objEx); } }
/// <summary> /// Handles the Click event of the btnUpdate control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnUpdate_Click(object sender, EventArgs e) { try { if (ValidateControls()) { int rowIndex = 0; int deleteRowIndex = -1; if (ViewState[DELETEROWINDEX] != null) { deleteRowIndex = Convert.ToInt32(ViewState[DELETEROWINDEX].ToString()); } //Update the grid view according the row, which is selected for editing. if (ViewState[ROWINDEX] != null) { rowIndex = Convert.ToInt32(ViewState[ROWINDEX].ToString()); if (deleteRowIndex != -1 && deleteRowIndex < rowIndex) { rowIndex--; } Label SkillValue = (Label)gvSkills.Rows[rowIndex].FindControl(SKILL); Label ProficiencyValue = (Label)gvSkills.Rows[rowIndex].FindControl(PROFICIENCY); Label SkillId = (Label)gvSkills.Rows[rowIndex].FindControl(SKILLID); Label Mode = (Label)gvSkills.Rows[rowIndex].FindControl(MODE); SkillValue.Text = ddlSkills.SelectedValue; ProficiencyValue.Text = ddlProficiencyLevel.SelectedValue; gvSkills.Rows[rowIndex].Cells[0].Text = ddlSkills.SelectedItem.Text; gvSkills.Rows[rowIndex].Cells[1].Text = txtYearsOfExperience.Text; gvSkills.Rows[rowIndex].Cells[2].Text = ddlProficiencyLevel.SelectedItem.Text; gvSkills.Rows[rowIndex].Cells[3].Text = txtLastUsedDate.Text; if (int.Parse(SkillId.Text) == 0) { Mode.Text = "1"; } else { Mode.Text = "2"; } ImageButton ibtnDelete = (ImageButton)gvSkills.Rows[rowIndex].FindControl(IBTNDELETE); ibtnDelete.Enabled = true; ViewState[ROWINDEX] = null; ViewState[DELETEROWINDEX] = null; } for (int i = 0; i < SkillDetailsCollection.Count; i++) { BusinessEntities.SkillsDetails objSkillsDetails = new BusinessEntities.SkillsDetails(); objSkillsDetails = (BusinessEntities.SkillsDetails)SkillDetailsCollection.Item(i); Label SkillId = (Label)gvSkills.Rows[rowIndex].FindControl(SKILLID); Label Mode = (Label)gvSkills.Rows[rowIndex].FindControl(MODE); objSkillsDetails.SkillsId = int.Parse(SkillId.Text); objSkillsDetails.EMPId = int.Parse(EMPId.Value); objSkillsDetails.SkillName = gvSkills.Rows[i].Cells[0].Text; objSkillsDetails.Experience = gvSkills.Rows[i].Cells[1].Text; objSkillsDetails.ProficiencyLevel = gvSkills.Rows[i].Cells[2].Text; objSkillsDetails.LastUsedDate = Convert.ToDateTime(gvSkills.Rows[i].Cells[3].Text); objSkillsDetails.Mode = int.Parse(Mode.Text); } //Clear all the fields after inserting row into gridview this.ClearControls(); btnAddRow.Visible = true; btnUpdate.Visible = false; btnCancelRow.Visible = false; //Enabling all the edit buttons. for (int i = 0; i < gvSkills.Rows.Count; i++) { ImageButton ibtnEdit = (ImageButton)gvSkills.Rows[i].FindControl(IBTNEDIT); ibtnEdit.Enabled = true; } } } catch (RaveHRException ex) { LogErrorMessage(ex); } catch (Exception ex) { RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "btnUpdate_Click", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER); LogErrorMessage(objEx); } }