protected void Handle_Click(object sender, EventArgs e) { mSurveyData = (Review_Data)Session["survey"]; RadioButtonList rbl = (RadioButtonList)sender; String RadioButtonListID = rbl.ID; // Comfort, Noise, etc... int a = 0; String selection = rbl.SelectedItem.Text; // Poor, Fair, etc.. Survey_Criteria criteria = StringToEnum(RadioButtonListID); Qualifier q = StringToQualifier(selection); try { mSurveyData.Add(criteria, q); } catch (Exception ex) {; } ListItem li = FlightSelection.SelectedItem; String msg = ""; if (li != null) { msg = li.Text; mLastError = msg; } Session["survey"] = mSurveyData; if (mSurveyData.Count == 5) // we are ready to submit our data { Session[SURVEY_READY_FOR_SUBMISSION] = true; } else { Session[SURVEY_READY_FOR_SUBMISSION] = false; } }
protected void Handle_Rating(object sender, EventArgs e) { RadioButtonList rbl = (RadioButtonList)sender; String Criteria = rbl.ID; String Qualifier = rbl.SelectedItem.Text; ListItem li = ListBox_Flights.SelectedItem; if (li != null) { String flight_caption = li.Text; char[] separator = { '|' }; String[] elements = flight_caption.Split(separator); String flight_number = elements[0]; String airline = elements[1]; Survey_Criteria criteria = StringToEnum(Criteria); Qualifier qual = StringToQualifier(Qualifier); mReviews = (Dictionary <Survey_Criteria, Qualifier>)Session["review"]; mReviews.Add(criteria, qual); if (mReviews.Count == 5) { String query = "INSERT INTO SURVEY"; int friendliness = (int)mReviews[Survey_Criteria.R_friendly]; int space = (int)mReviews[Survey_Criteria.R_space]; int comfort = (int)mReviews[Survey_Criteria.R_comfort]; int cleanliness = (int)mReviews[Survey_Criteria.R_cleanliness]; int noise = (int)mReviews[Survey_Criteria.R_noise]; query += "(flight_number, airline_code, friendliness, space, confort, cleanliness, noise)"; query += " values(" + flight_number + ", " + s(airline) + ", " + friendliness + ", " + space + ", " + comfort + ", " + cleanliness + ", " + noise + ")"; mConnection = (MySqlConnection)Session["cnx"]; MySqlCommand cmd = new MySqlCommand(query, mConnection); cmd.ExecuteNonQuery(); } int c = 5; } int a = 2; return; }
public Survey_Criteria StringToEnum(String review) { Survey_Criteria sc = Survey_Criteria.R_cleanliness; switch (review) { case "R_Comfort": { sc = Survey_Criteria.R_comfort; } break; case "R_Cleanliness": { sc = Survey_Criteria.R_cleanliness; } break; case "R_Friendliness": { sc = Survey_Criteria.R_friendly; } break; case "R_Space": { sc = Survey_Criteria.R_space; } break; case "R_Noise": { sc = Survey_Criteria.R_noise; } break; default: break; } return(sc); }