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