protected void UserSkillSearchButton_Click(object sender, EventArgs e)
{
UserBO ob = new UserBO();
ob.skillName = UserSkillSearch.Text;
clsBLL ob1 = new clsBLL();
UserSkillSearchResult.DataSource = ob1.SkillSearchTableBLL(ob);
UserSkillSearchResult.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try { UserID.Text = Session["User"].ToString(); }
catch { Response.Redirect("LoginPage.aspx"); }
string str = Session["User"].ToString();
UserBO ob4 = new UserBO();
ob4.userid = Session["User"].ToString();
clsBLL ob5 = new clsBLL();
int user1 = ob5.FindUserTypeBLL(ob4);
if (user1 == 1)
{
Session["User"] = null; Response.Redirect("LoginPage.aspx");
}
string name = ob5.firstnamerBLL(str);
UserName.Text = name;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["userdataConnectionString"].ConnectionString.ToString()))
{
SqlCommand cmd = new SqlCommand("select CourseCode,Status,Score from Scores where (UserID ='" + Session["User"].ToString() + "')", con);
con.Open();
CoursesAccepted.DataSource = cmd.ExecuteReader();
CoursesAccepted.DataBind();
}
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["userdataConnectionString"].ConnectionString.ToString()))
{
SqlCommand cmd = new SqlCommand("select SkillName from SkillSet", con);
con.Open();
UserSkillSearchResult.DataSource = cmd.ExecuteReader();
UserSkillSearchResult.DataBind();
}
}