protected void BtnSubmitNewSkill_Click(object sender, EventArgs e)
{
Debug.WriteLine("Entering BtnSubmitNewSkill_Click");
int test = 0;
int result;
expertObj = (Expert)Session["expertProfileObj"];
if (string.IsNullOrWhiteSpace(txtAddNewSkill.Text)==false)
{
//search expert's skillset to see if the skill added already exsists
//search all skill to see if the skill added exsists
//if not to both, add a new skill
foreach (Tuple<int,String> skill in expertObj.AllExpertSkills)//test if skill added is already in Expert's Skill Set
{
if(skill.Item2.Equals(txtAddNewSkill.Text, StringComparison.OrdinalIgnoreCase))
{
test = -1;
break;
}
}
if (test != -1)
{
List<Skills> allSkills = DbMethods.GetSkills();
foreach (Skills skill in allSkills)//handle adding the skill
{
if (skill.SkillName.Equals(txtAddNewSkill.Text, StringComparison.OrdinalIgnoreCase))
{
result = DbMethods.AddSkillToUser(expertObj.tuID, skill.SkillID);//adding excisting skill to expert
if (result != -1)
{
lblAddSkillTest.Text = "Success! New Skill was added to Skills and Expert_Skills Tables.";
test = -2;
break;
}
else
lblAddSkillTest.Text = "Error: Process did not execute successfully. :(";
break;
}
}
if(test != -2)
{
result = DbMethods.AddNewSkillToUser(expertObj.tuID, txtAddNewSkill.Text);//adding brandnew skill
if (result != -1)
lblAddSkillTest.Text = "Success! New Skill was added to Skills and Expert_Skills Tables.";
else
lblAddSkillTest.Text = "Error: Process did not execute successfully. :(";
}
sm.storeExpertDataInSession();//now get the whole expert object
FillControls();
}
else
lblAddSkillTest.Text = "Cannot add this skill. you already have this skill in your skill set.";
}//end if statement for textBoxes
else
lblAddSkillTest.Text = "Error: Invalid input.";
}//end add new skill
protected void BtnSubmitNewSkill_Click(object sender, EventArgs e)
{
Expert tempExpert = new Expert {
tuID = (string)Session["TU_ID"]
};
int test = 0;
int result;
if (string.IsNullOrWhiteSpace(txtAddNewSkill.Text) == false)
{
//search expert's skillset to see if the skill added already exsists
//search all skill to see if the skill added exsists
//if not to both, add a new skill
foreach (Tuple <int, String> skill in tempExpert.AllExpertSkills)//test if skill added is already in Expert's Skill Set
{
if (skill.Item2.Equals(txtAddNewSkill.Text, StringComparison.OrdinalIgnoreCase))
{
test = -1;
break;
}
}
if (test != -1)
{
List <Skills> allSkills = db.GetSkills();
foreach (Skills skill in allSkills)//handle adding the skill
{
if (skill.SkillName.Equals(txtAddNewSkill.Text, StringComparison.OrdinalIgnoreCase))
{
result = db.AddSkillToUser(tempExpert.tuID, skill.SkillID);//adding existing skill to expert
if (result != -1)
{
lblAddSkillTest.Text = "Success! New Skill was added to Skills and Expert_Skills Tables.";
test = -2;
break;
}
else
{
lblAddSkillTest.Text = "Error: Process did not execute successfully. :(";
}
break;
}
}
if (test != -2)
{
result = db.AddNewSkillToUser(tempExpert.tuID, txtAddNewSkill.Text);//adding brandnew skill
if (result != -1)
{
lblAddSkillTest.Text = "Success! New Skill was added to Skills and Expert_Skills Tables.";
}
else
{
lblAddSkillTest.Text = "Error: Process did not execute successfully. :(";
}
}
//sm.storeExpertDataInSession();//now get the whole expert object
gvDeleteSkills.DataSource = db.GetExpertsSkills(tempExpert.tuID);
gvDeleteSkills.DataBind();
}
else
{
lblAddSkillTest.Text = "Cannot add this skill. you already have this skill in your skill set.";
}
}//end if statement for textBoxes
else
{
lblAddSkillTest.Text = "Error: Invalid input.";
}
}
