private void UpdateEvalData() { CodeCampEvalsODS cceODS = new CodeCampEvalsODS(); cceODS.UpdateAllCodeCampEvals(new Guid(GuidString), ConvertSelectedValueToInt32(RBLMetExpectations.SelectedValue), ConvertSelectedValueToInt32(RBLWillAttendAgain.SelectedValue), ConvertSelectedValueToInt32(RBLEnjoyedFreeFood.SelectedValue), ConvertSelectedValueToInt32(RBLSessionsVariedEnough.SelectedValue), ConvertSelectedValueToInt32(RBLEnoughSessionsMyLevel.SelectedValue), ConvertSelectedValueToInt32(RBLFoothillGoodVenue.SelectedValue), ConvertSelectedValueToInt32(RBLWishToldMoreFriends.SelectedValue), ConvertSelectedValueToInt32(RBLEventWellPlanned.SelectedValue), ConvertSelectedValueToInt32(RBLWirelessInternetImportant.SelectedValue), ConvertSelectedValueToInt32(RBLWiredInternetImportant.SelectedValue), ConvertSelectedValueToInt32(RBLLikedEmailUpdates.SelectedValue), ConvertSelectedValueToInt32(RBLLikedRSSUpdates.SelectedValue), ConvertSelectedValueToInt32(RadioButtonListSponsorship.SelectedValue), CheckBoxVistaFairOnly.Checked, CheckBoxCodeCampAndVistaFair.Checked, CheckBoxCodeCampOnly.Checked, TextBoxWhatEnjoyMost.Text, TextBoxWhatChanges.Text, TextBoxIfNotSatisfiedWhy.Text, TextBoxWhatFoothillCoursesAdded.Text, CheckBoxLongTermPlanning.Checked, CheckBoxWebSiteBackEnd.Checked, CheckBoxWebSiteCss.Checked, CheckBoxSessionReview.Checked, CheckBoxContributorSolicitation.Checked, CheckBoxActAsContributor.Checked, CheckBoxPreEventVolunteer.Checked, CheckBoxDayOfEventVolunteer.Checked, CheckBoxEventTearDown.Checked, CheckBoxAfterEventVolunteer.Checked, TextBoxContactEmail.Text, TextBoxPhoneNumber.Text, DateTime.Now); Label1.Text = "Evaluation Submitted. Thank you"; Label2.Text = "Evaluation Submitted. Thank you"; // ~/CodeCampEval.aspx?Return=MyEvals if (Request.QueryString["Return"] != null && Request.QueryString["Return"].Equals("MyEvals")) { Response.Redirect("~/MyEvals.aspx"); } else { Response.Redirect("~/CodeCampEvalsSuccess.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Context.User.Identity.IsAuthenticated) { Response.Redirect("~/Default.aspx", true); } if (!IsPostBack) { this.AddRadioButtonChoices(RBLMetExpectations); this.AddRadioButtonChoices(RBLWillAttendAgain); this.AddRadioButtonChoices(RBLEnjoyedFreeFood); this.AddRadioButtonChoices(RBLSessionsVariedEnough); this.AddRadioButtonChoices(RBLFoothillGoodVenue); this.AddRadioButtonChoices(RBLWishToldMoreFriends); this.AddRadioButtonChoices(RBLEventWellPlanned); this.AddRadioButtonChoices(RBLWirelessInternetImportant); this.AddRadioButtonChoices(RBLWiredInternetImportant); this.AddRadioButtonChoices(RBLLikedEmailUpdates); this.AddRadioButtonChoices(RBLLikedRSSUpdates); this.AddRadioButtonChoices(RBLEnoughSessionsMyLevel); if (Request.Params["PKID"] != null) { GuidString = Request.Params["PKID"]; string username = CodeCampSV.Utils.GetAttendeeUsernameByGUID(GuidString); if (!System.Web.Security.Roles.IsUserInRole(username, CodeCampSV.Utils.GetAdminRoleName())) { if (!string.IsNullOrEmpty(username)) { if (User.Identity.IsAuthenticated) { FormsAuthentication.SignOut(); } FormsAuthentication.SetAuthCookie(username, true); Response.Redirect("~/CodeCampEval.aspx", true); } } else { // user is admin so toss them out Response.Redirect("~/Default.aspx", true); } } else if (Context.User.Identity.IsAuthenticated) { GuidString = CodeCampSV.Utils.GetAttendeePKIDByUsername(User.Identity.Name); } if (!String.IsNullOrEmpty(GuidString)) { // Figure out if eval exists for this person. If not, add one. int num = 0; try { using (var sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["CodeCampSV06"].ConnectionString)) { sqlConnection.Open(); const string sqlSelect = "SELECT COUNT(*) FROM CodeCampEvals WHERE AttendeePKID=@AttendeePKID AND CodeCampYearId = @CodeCampYearId"; using (var sqlCommand = new SqlCommand(sqlSelect, sqlConnection)) { sqlCommand.Parameters.Add("@AttendeePKID", SqlDbType.UniqueIdentifier).Value = new Guid(GuidString); sqlCommand.Parameters.Add("@CodeCampYearId", SqlDbType.Int).Value = Utils.GetCurrentCodeCampYear(); num = (int)sqlCommand.ExecuteScalar(); } if (num == 0) { const string sqlInsert = "INSERT INTO CodeCampEvals (AttendeePKID,DateSubmitted,CodeCampYearId) Values (@AttendeePKID,@DateSubmitted,@CodeCampYearId)"; using (var sqlCommandInsert = new SqlCommand(sqlInsert, sqlConnection)) { sqlCommandInsert.Parameters.Add("@AttendeePKID", SqlDbType.UniqueIdentifier).Value = new Guid(GuidString); sqlCommandInsert.Parameters.Add("@DateSubmitted", SqlDbType.DateTime).Value = DateTime.Now; sqlCommandInsert.Parameters.Add("@CodeCampYearId", SqlDbType.Int).Value = Utils.GetCurrentCodeCampYear(); sqlCommandInsert.ExecuteScalar(); } } } } catch (Exception ee) { throw new ApplicationException(ee.ToString()); } } // Now, if we still don't have a guidString, then bail if (!String.IsNullOrEmpty(GuidString)) { ButtonUpdate1.Enabled = true; ButtonUpdate2.Enabled = true; CodeCampEvalsODS cceODS = new CodeCampEvalsODS(); List<CodeCampEvalsODS.DataObjectCodeCampEvals> li = cceODS.GetByPKID(new Guid(GuidString)); if (li.Count == 1) { CodeCampEvalsODS.DataObjectCodeCampEvals eval = li[0]; CheckBoxCodeCampOnly.Checked = eval.Attendedcconly; CheckBoxCodeCampAndVistaFair.Checked = eval.Attendedvistafairandcc; CheckBoxVistaFairOnly.Checked = eval.Attendedvistafaironly; RadioButtonListSponsorship.SelectedValue = eval.Rathernosponsorandnofreefood.ToString(); //CheckBoxNoCorpSponsors.Checked = eval.Rathernosponsorandnofreefood; CheckBoxVistaFairOnly.Checked = eval.Attendedvistafaironly; CheckBoxCodeCampAndVistaFair.Checked = eval.Attendedvistafairandcc; CheckBoxCodeCampOnly.Checked = eval.Attendedcconly; TextBoxWhatEnjoyMost.Text = eval.Bestpartofevent; TextBoxWhatChanges.Text = eval.Whatwouldyouchange; TextBoxIfNotSatisfiedWhy.Text = eval.Notsatisfiedwhy; TextBoxWhatFoothillCoursesAdded.Text = eval.Whatfoothillclassestoadd; CheckBoxLongTermPlanning.Checked = eval.Interesteinlongtermplanning; CheckBoxWebSiteBackEnd.Checked = eval.Interesteinwebbackend; CheckBoxWebSiteCss.Checked = eval.Interestedinwebfrontend; CheckBoxSessionReview.Checked = eval.Interesteinlongsessionreviewpanel; CheckBoxContributorSolicitation.Checked = eval.Interesteincontributorsolicitation; CheckBoxActAsContributor.Checked = eval.Interesteinbeingcontributor; CheckBoxPreEventVolunteer.Checked = eval.Interesteinbeforeevent; CheckBoxDayOfEventVolunteer.Checked = eval.Interesteindayofevent; CheckBoxEventTearDown.Checked = eval.Interesteineventteardown; CheckBoxAfterEventVolunteer.Checked = eval.Interesteinafterevent; this.SetSelectedValue(RBLMetExpectations, eval.Metexpectations); this.SetSelectedValue(RBLMetExpectations, eval.Metexpectations); this.SetSelectedValue(RBLWillAttendAgain, eval.Plantoattendagain); this.SetSelectedValue(RBLEnjoyedFreeFood, eval.Enjoyedfreefood); this.SetSelectedValue(RBLSessionsVariedEnough, eval.Sessionsvariedenough); this.SetSelectedValue(RBLEnoughSessionsMyLevel, eval.Enoughsessionsatmylevel); this.SetSelectedValue(RBLFoothillGoodVenue, eval.Foothillgoodvenue); this.SetSelectedValue(RBLWishToldMoreFriends, eval.Wishtoldmorefriends); this.SetSelectedValue(RBLEventWellPlanned, eval.Eventwellplanned); this.SetSelectedValue(RBLWirelessInternetImportant, eval.Wirelessaccessimportant); this.SetSelectedValue(RBLWiredInternetImportant, eval.Wiredaccessimportant); this.SetSelectedValue(RBLLikedEmailUpdates, eval.Likereceivingupdatebyemail); this.SetSelectedValue(RBLLikedRSSUpdates, eval.Likereceivingupdatebybyrssfeed); TextBoxContactEmail.Text = eval.Forvolunteeringbestwaytocontactemail; TextBoxPhoneNumber.Text = eval.Forvolunteeringbestwaytocontactphone; } } else { Response.Redirect("~/Default.aspx"); } } }