protected void lnkBtnSubmit_Click(object sender, EventArgs e) { if (hfCategoryId.Value.ToString() == null) { lblError.Text = "Please accept the waiver agreement"; return; } else { try { SqlConnClass objSqlConnClass = new SqlConnClass(); BackofficeClass objBackOfficeClass = new BackofficeClass(); PALClass objPALClass; objPALClass = new PALClass(objSqlConnClass.OpenConnection()); objBackOfficeClass = new BackofficeClass(objSqlConnClass.sqlConnection); DataSet DS1 = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName()); if (DS1 != null) { if (DS1.Tables[0].Rows.Count > 0) { DataSet DS = objPALClass.PAL_INSERTMULTIPLE_PalStarts(DS1.Tables[0].Rows[0]["USER_ID"].ToString(), hfCategoryId.Value, DateTime.Now.ToString("MM/dd/yyyy"), "1"); objSqlConnClass.CloseConnection(); objBackOfficeClass = null; objPALClass = null; BLL.UserLib oUserLib = new BLL.UserLib(); oUserLib.UpdateUserStratificationStep(new Guid(DS1.Tables[0].Rows[0]["USER_ID"].ToString()), "4"); oUserLib = null; DS = null; Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep5.aspx?id=" + Request.QueryString["id"].ToString() + "&c=" + Request.QueryString["c"].ToString() + "&sc=" + Request.QueryString["sc"].ToString()); } } objSqlConnClass.CloseConnection(); objBackOfficeClass = null; objPALClass = null; } catch { } } }