public void FillControls() { DataSet dsAllExpertDeleteSkills = DbMethods.GetExpertsSkills(studentObj.tuid); //bind Experts Skills to Delete Gridview if (vlad.IsDataSetEmpty(dsAllExpertDeleteSkills) == false) lblDeleteTest.Text = "your DataSet is EMPTY."; else { gvDeleteSkills.DataSource = dsAllExpertDeleteSkills.Tables[0]; gvDeleteSkills.DataBind();//bind lblDeleteTest.Text = "your method returned data! :)"; } }//end fill controls
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."; } }