protected void txtAddSkill_TextChanged(object sender, EventArgs e)
{
objEmployee.AddEmpSkill(Convert.ToInt32(Session["EmployeeID"]), txtAddSkill.Text);
BindData();
txtAddSkill.Text = "";
panelAddSkill.Visible = false;
}
protected void txtAddSkill_TextChanged(object sender, EventArgs e)
{
try
{
var DC = new DataClassesDataContext();
tblSkill SkillID = (from ob in DC.tblSkills
where ob.SkillName == txtAddSkill.Text
select ob).Single();
int Skill = (from ob in DC.tblEmpXSkills
join obj in DC.tblSkills
on ob.SkillID equals obj.SkillID
where ob.EmpID == Convert.ToInt32(Session["EmpID"]) && ob.SkillID == SkillID.SkillID
select ob).Count();
if (Skill > 0)
{
erroSkill.Text = "Skill already exist!!";
erroSkill.Visible = true;
}
else
{
erroSkill.Visible = false;
objEmployee.AddEmpSkill(Convert.ToInt32(Session["EmpID"]), txtAddSkill.Text);
txtAddSkill.Text = "";
panelAddSkill.Visible = false;
BindData();
//Employee Appraisal
int cnt = (from obj in DC.tblEmpAppraisals
where obj.EmpID == Convert.ToInt32(Session["EmpID"])
select obj).Count();
if (cnt > 0)
{
tblEmpAppraisal data = (from obj in DC.tblEmpAppraisals
where obj.EmpID == Convert.ToInt32(Session["EmpID"])
select obj).SingleOrDefault();
data.Skills = data.Skills.Value + 1;
DC.SubmitChanges();
}
else
{
tblEmployee EmpData = (from obj in DC.tblEmployees
where obj.EmpID == Convert.ToInt32(Session["EmpID"])
select obj).First();
tblEmpAppraisal EmpAppraisal = new tblEmpAppraisal();
EmpAppraisal.EmpID = EmpData.EmpID;
EmpAppraisal.Skills = Convert.ToDecimal(1.0);
EmpAppraisal.Quality = Convert.ToDecimal(0.0);
EmpAppraisal.Avialibility = Convert.ToDecimal(0.0);
EmpAppraisal.Deadlines = Convert.ToDecimal(0.0);
EmpAppraisal.Communication = Convert.ToDecimal(0.0);
EmpAppraisal.Cooperation = Convert.ToDecimal(0.0);
EmpAppraisal.ClientFeedback = Convert.ToDecimal(0.0);
EmpAppraisal.CreatedBy = Convert.ToInt32(Session["EmpID"]);
EmpAppraisal.CreatedOn = DateTime.Now;
DC.tblEmpAppraisals.InsertOnSubmit(EmpAppraisal);
}
DC.SubmitChanges();
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["EmpID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
