/// <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);
}
}
