// To delete any previous data in database related to student and call SaveUserInputRec() for each expertise domain protected void btnNext_Click(object sender, EventArgs e) { BusinessLayer.DataServices m = new BusinessLayer.DataServices(); int User_ID = (int)Session["UserID"]; m.DeleteUserInputRec(User_ID); for (int i = 0; i < 4; i++) { if (i == 0) { SaveUserInputRec("Programing", m); } else if (i == 1) { SaveUserInputRec("Tool", m); } else if (i == 2) { SaveUserInputRec("Mathmetic", m); } else if (i == 3) { SaveUserInputRec("ResearchExp", m); } } Session["CallFromResult"] = "NotModify"; Response.Redirect("~/Result.aspx"); }
/// <summary> /// To save user profile to application database /// </summary> void SaveUserInputRec(string TblName, BusinessLayer.DataServices m) { if (Session[TblName] != null) { DataTable dt = (DataTable)Session[TblName]; int User_ID = (int)Session["UserID"]; foreach (DataRow dr in dt.Rows) { if (dr["NotAvailable"].ToString() == "0") { int AcademicInfo_ID = int.Parse(dr["AcademicInfo_ID"].ToString()); int Level = 1; if (dr["intermediate"].ToString() == "1") { Level = 3; } else if (dr["Expert"].ToString() == "1") { Level = 4; } else if (dr["Available"].ToString() == "1") { Level = 2; } m.InsertUserInputRec(User_ID, AcademicInfo_ID, Level); } } } }
// To reset all options to default state - "No Experience" protected void btnReset_Click(object sender, EventArgs e) { BusinessLayer.DataServices m = new BusinessLayer.DataServices(); DataTable dtb = m.GetProgAcademicInfo(); grdPrograming.DataSource = dtb; grdPrograming.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { BusinessLayer.DataServices m = new BusinessLayer.DataServices(); grdTools.DataSource = m.GetToolAcademicInfo(); grdTools.DataBind(); if (Session["Tool"] != null && !IsPostBack) { LoadSelectedState(); } }
public static string[] GetCustomers(string prefix) { List <string> customers = new List <string>(); BusinessLayer.DataServices m = new BusinessLayer.DataServices(); DataTable dt = m.GetResearchAcademicAssociatedInfo1(prefix); foreach (DataRow dr in dt.Rows) { customers.Add(string.Format("{0}", dr["Sug_Word"])); } return(customers.ToArray()); }
// Reset to default options protected void btnReset_Click(object sender, EventArgs e) { BusinessLayer.DataServices m = new BusinessLayer.DataServices(); DataTable dtMath = m.GetMathAcademicInfo(); grdMath.DataSource = dtMath; grdMath.DataBind(); DataTable dtResearch = m.GetResAcademicInfo(); grdResearch.DataSource = dtResearch; grdResearch.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { BusinessLayer.DataServices m = new BusinessLayer.DataServices(); DataTable dtb = m.GetProgAcademicInfo(); grdPrograming.DataSource = dtb; grdPrograming.DataBind(); if (Session["Programing"] != null && !IsPostBack) { LoadSelectedState(); } }
protected void Page_Load(object sender, EventArgs e) { BusinessLayer.DataServices m = new BusinessLayer.DataServices(); DataTable dtMath = m.GetMathAcademicInfo(); grdMath.DataSource = dtMath; grdMath.DataBind(); DataTable dtResearch = m.GetResAcademicInfo(); grdResearch.DataSource = dtResearch; grdResearch.DataBind(); if (!IsPostBack) { if (Session["Mathmetic"] != null) { LoadMathsSelState(); } if (Session["ResearchExp"] != null) { LoadResSelState(); } } }
// To reset all options to default settings protected void btnReset_Click(object sender, EventArgs e) { BusinessLayer.DataServices m = new BusinessLayer.DataServices(); grdTools.DataSource = m.GetToolAcademicInfo(); grdTools.DataBind(); }