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