private void GetResponse(int responseID) { try { response = ResponsesDB.GetResponse(responseID); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
private int GetLastResponseID(int respondentID) { try { return(ResponsesDB.GetLastResponseID(respondentID)); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); return(0); } }
private void btnDelete_Click(object sender, EventArgs e) { if (ResponsesDB.DeleteResponse(Convert.ToInt32(txtResponseID.Text))) { MessageBox.Show("Response has been deleted.", "DELETED!"); } else { MessageBox.Show("Response could not be deleted.", "ERROR!"); return; } }
private void btnSubmit_Click(object sender, EventArgs e) { if (ValidateData()) { this.PutRespondent(respondent); try { if (!RespondentsDB.AddRespondent(respondent)) { MessageBox.Show("This email already exists. Submitting new answers.", "Database Message"); this.DialogResult = DialogResult.OK; int respondentID = RespondentsDB.GetRespondentID(respondent.EmailAddress); PutResponse(response, respondentID); if (!ResponsesDB.AddResponse(response)) { MessageBox.Show("There was some database error.", "ERROR!"); } else { MessageBox.Show("Responses submitted! Thank you!", "YAY!"); this.DialogResult = DialogResult.OK; ClearDataForm(); } } else { int respondentID = GetLastRespondentID(); PutResponse(response, respondentID); if (!ResponsesDB.AddResponse(response)) { MessageBox.Show("There was some database error.", "ERROR!"); } else { MessageBox.Show("Responses submitted! Thank you!", "YAY!"); this.DialogResult = DialogResult.OK; ClearDataForm(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } }