protected void Button1_Click(object sender, EventArgs e) { string storedProcedureName = "dbo.pInsLoginRequest"; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@Name", TextBoxName.Text); parameters.Add("@EmailAddress", TextBoxEmailAddress.Text); parameters.Add("@LoginName", TextBoxLoginName.Text); parameters.Add("@NewOrReactivate", TextBoxNewOrReactivate.Text); parameters.Add("@ReasonForAccess", TextBoxReason.Text); parameters.Add("@DateNeededBy", TextBoxDateNeededBy.Text); var error = StoredProcedureExecutor.Execute(storedProcedureName, parameters); if (!String.IsNullOrEmpty(error)) { Response.Write("An error occured while adding the login request to the database. Exception is: " + error); } }
protected void ButtonRegister_Click(object sender, EventArgs e) { string error = ""; LabelStatus.Text = ""; bool registrationAttempted = false; foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[0].FindControl("chkCtrl") as CheckBox); if (chkRow.Checked) { registrationAttempted = true; string storedProcedureName = "dbo.pInsClassStudents"; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@ClassID", row.Cells[1].Text); parameters.Add("@StudentID", Session["StudentID"].ToString()); error = StoredProcedureExecutor.Execute(storedProcedureName, parameters); if (!String.IsNullOrEmpty(error)) { LabelStatus.Text = error; } } } } if (String.IsNullOrEmpty(error) && registrationAttempted) { LabelStatus.Text = " Successfully registered!"; } GridView1.DataBind(); }