/// <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); } } } }