private void LoadSkill() { try { _obj_smhr_employee = new SMHR_EMPLOYEE(); _obj_smhr_employee.EMP_ID = Convert.ToInt32(Request.QueryString["ID"]); _obj_smhr_employee.Mode = 1; DataTable dt1 = BLL.get_EmpESS(_obj_smhr_employee); if (dt1.Rows.Count != 0) { _lbl_Emp_Id = Convert.ToString(dt1.Rows[0]["EMP_APPLICANT_ID"]); } _obj_smhr_applicant = new SMHR_APPLICANT(); _obj_smhr_applicant.APPSKL_APPLICANT_ID = Convert.ToInt32(_lbl_Emp_Id); _obj_smhr_applicant.OPERATION = operation.Check; DataTable dt = BLL.get_ApplicantSkills(_obj_smhr_applicant); RG_Skills.DataSource = dt; RG_Skills.DataBind(); ViewState["dt_Skill"] = dt; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Skills", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void createColumns() { try { dt_Skill = new DataTable(); dt_Skill.Columns.Clear(); dt_Skill.Rows.Clear(); dt_Skill.Columns.Add("APPSKL_ID"); dt_Skill.Columns.Add("APPSKL_SKILL_ID"); dt_Skill.Columns.Add("APPSKL_SKILL_NAME"); dt_Skill.Columns.Add("APPSKL_LASTUSED"); dt_Skill.Columns.Add("APPSKL_EXPERT"); dt_Skill.Columns.Add("APPSKL_EXPERT_NAME"); dt_Skill.Columns.Add("APPSKL_RANDID"); dt_Skill.PrimaryKey = new DataColumn[] { dt_Skill.Columns["APPSKL_SKILL_ID"] }; RG_Skills.DataSource = dt_Skill; RG_Skills.DataBind(); ViewState["dt_Skill"] = dt_Skill; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmEmpSkills", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); //return false; } }
private void LoadSkill() { try { getEmployee(); _obj_smhr_applicant = new SMHR_APPLICANT(); int I_ = Convert.ToInt32(ViewState["ddlIndex"]); if (I_ != 0) { _obj_smhr_applicant.APPSKL_APPLICANT_ID = Convert.ToInt32(I_); } else { _obj_smhr_applicant.APPSKL_APPLICANT_ID = Convert.ToInt32(ViewState["APP_ID"]);// Convert.ToInt32(HF_APID.Value); //Convert.ToInt32(_lbl_App_ID); } _obj_smhr_applicant.OPERATION = operation.Check; DataTable dt = BLL.get_ApplicantSkills(_obj_smhr_applicant); RG_Skills.DataSource = dt; ViewState["dt_Skill"] = dt; RG_Skills.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmEmpSkills", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Skill_Add_Click(object sender, EventArgs e) { try { getEmployee(); if (Check_Combo(RG_Skills, "lbl_Skill_ID", rcb_Skill)) { if (Mode == 0) { btn_Skill_Add.Enabled = false; dt_Skill = (DataTable)ViewState["dt_Skill"]; if (dt_Skill.Columns.Count > 7) { DataRow dr1 = dt_Skill.NewRow(); //dr1[0] = "0"; dr1[2] = rcb_Skill.SelectedValue; dr1[3] = rcb_ExpertLevel.SelectedValue; dr1[4] = rcb_ExpertLevel.SelectedItem.Text; dr1[5] = rcb_Skill.SelectedItem.Text; dr1[6] = rcb_YearLastUsed.SelectedItem.Text; //dr1[7] = lbl_Rand.Text + "-" + dt_Skill.Rows.Count; dt_Skill.Rows.Add(dr1); } else { DataRow dr = dt_Skill.NewRow(); dr[0] = "0"; dr[1] = rcb_Skill.SelectedValue; dr[2] = rcb_Skill.SelectedItem.Text; dr[3] = rcb_YearLastUsed.SelectedItem.Text; dr[4] = rcb_ExpertLevel.SelectedValue; dr[5] = rcb_ExpertLevel.SelectedItem.Text; //dr[6] = lbl_Rand.Text + "-" + dt_Skill.Rows.Count; dt_Skill.Rows.Add(dr); } RG_Skills.DataSource = dt_Skill; RG_Skills.DataBind(); clearSkillFields(); Mode = 0; btn_Skill_Add.Enabled = true; } else if (Mode == 2) { btn_Skill_Add.Enabled = false; _obj_smhr_applicant = new SMHR_APPLICANT(); bool status = false; _obj_smhr_applicant.OPERATION = operation.Insert; _obj_smhr_applicant.APPLICANT_ID = Convert.ToInt32(ViewState["APP_ID"]); //Convert.ToInt32(HF_APID.Value); //Convert.ToInt32(_lbl_App_ID); _obj_smhr_applicant.APPSKL_SKILL_ID = Convert.ToInt32(rcb_Skill.SelectedItem.Value); _obj_smhr_applicant.APPSKL_LASTUSED = Convert.ToInt32(rcb_YearLastUsed.SelectedItem.Text); _obj_smhr_applicant.APPSKL_EXPERT = Convert.ToInt32(rcb_ExpertLevel.SelectedValue); _obj_smhr_applicant.APPSKL_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); _obj_smhr_applicant.APPSKL_CREATEDDATE = DateTime.Now; status = BLL.set_ApplicantSkills(_obj_smhr_applicant);//no organisation column has found Mode = 2; clearSkillFields(); LoadSkill(); btn_Skill_Add.Enabled = true; } } else { BLL.ShowMessage(this, "This Skill Set has already been added"); rcb_Skill.Focus(); return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmEmpSkills", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Skill_Correct_Click(object sender, EventArgs e) { try { getEmployee(); if (Mode == 1) { dt_Skill = (DataTable)ViewState["dt_Skill"]; DataRow dr; //DataRow dr1 = dt_Skill.Rows.Find(rcb_Skill.SelectedValue); int RowIndex = 0; if (dt_Skill.Columns.Count > 7) { for (int index = 0; index < dt_Skill.Rows.Count; index++) { //if (dt_Skill.Rows[index].Equals(dr1)) //RowIndex = index; if (dt_Skill.Rows[index][2].ToString() == rcb_Skill.SelectedValue) { RowIndex = index; } } dr = dt_Skill.Rows[RowIndex]; dr.BeginEdit(); //dr[0] = "0"; dr[2] = rcb_Skill.SelectedValue; dr[5] = rcb_Skill.SelectedItem.Text; dr[6] = rcb_YearLastUsed.SelectedItem.Text; dr[3] = rcb_ExpertLevel.SelectedValue; dr[4] = rcb_ExpertLevel.SelectedItem.Text; dr.EndEdit(); } else { for (int index = 0; index < dt_Skill.Rows.Count; index++) { //if (dt_Skill.Rows[index].Equals(dr1)) //RowIndex = index; if (dt_Skill.Rows[index][1].ToString() == rcb_Skill.SelectedValue) { RowIndex = index; } } dr = dt_Skill.Rows[RowIndex]; dr.BeginEdit(); //dr[0] = "0"; dr[1] = rcb_Skill.SelectedValue; dr[2] = rcb_Skill.SelectedItem.Text; dr[3] = rcb_YearLastUsed.SelectedItem.Text; dr[4] = rcb_ExpertLevel.SelectedValue; dr[5] = rcb_ExpertLevel.SelectedItem.Text; dr.EndEdit(); } Mode = 0; RG_Skills.DataSource = dt_Skill; RG_Skills.DataBind(); clearSkillFields(); btn_Skill_Add.Visible = true; btn_Skill_Correct.Visible = false; rcb_Skill.Enabled = true; } else { _obj_smhr_applicant = new SMHR_APPLICANT(); bool status = false; _obj_smhr_applicant.OPERATION = operation.Update; string lbl = _lbl_ID; _obj_smhr_applicant.APPSKL_ID = Convert.ToInt32(_lbl_ID); _obj_smhr_applicant.APPLICANT_ID = Convert.ToInt32(ViewState["APP_ID"]); //Convert.ToInt32(HF_APID.Value); //Convert.ToInt32(_lbl_App_ID); _obj_smhr_applicant.APPSKL_SKILL_ID = Convert.ToInt32(rcb_Skill.SelectedItem.Value); _obj_smhr_applicant.APPSKL_LASTUSED = Convert.ToInt32(rcb_YearLastUsed.SelectedItem.Text); _obj_smhr_applicant.APPSKL_EXPERT = Convert.ToInt32(rcb_ExpertLevel.SelectedValue); _obj_smhr_applicant.APPSKL_LASTMDFBY = 1; _obj_smhr_applicant.APPSKL_LASTMDFDATE = DateTime.Now; status = BLL.set_ApplicantSkills(_obj_smhr_applicant); Mode = 2; LoadSkill(); clearSkillFields(); rcb_Skill.Enabled = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmEmpSkills", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }