protected void gvPolls_RowCommand(object sender, GridViewCommandEventArgs e) { int ddl = ddlSearch.SelectedValue.Length; int txt = txtSearch.Text.Length; if (e.CommandName == "InsertRow") { try { DataAccessLayer DAL = new DataAccessLayer(); string PollType = ((TextBox)gvPolls.FooterRow.FindControl("txtPollTypeFooter")).Text; string PollName = ((TextBox)gvPolls.FooterRow.FindControl("txtPollNameFooter")).Text; string PollQuestion = ((TextBox)gvPolls.FooterRow.FindControl("txtPollQuesFooter")).Text; string PollDescription = ((TextBox)gvPolls.FooterRow.FindControl("txtPollDescFooter")).Text; string PollRole = ((DropDownList)gvPolls.FooterRow.FindControl("ddlPollRoleFooter")).SelectedValue; string PollStatus = ((DropDownList)gvPolls.FooterRow.FindControl("ddlInsertStatusFooter")).SelectedValue; DAL.InsertPoll(PollType, PollName, PollQuestion, PollDescription, PollRole, PollStatus); GridBind(); lblErrorMessage.Visible = true; lblErrorMessage.Text = "New Poll title <b>" + PollName + "</b> has been created with Type as <b>" + PollType + ")</b>"; lblErrorMessage.ForeColor = System.Drawing.Color.Green; } catch (Exception ex) { lblErrorMessage.Visible = true; lblErrorMessage.Text = "Insert Exception: " + ex.Message; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "EditRow") { try { lblErrorMessage.Visible = false; lblException.Visible = false; if (ddl != 0 && txt != 0) { int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; gvPolls.EditIndex = rowIndex; GridSearch(); } else { int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; gvPolls.EditIndex = rowIndex; GridBind(); } } catch (Exception ex) { lblErrorMessage.Visible = true; lblErrorMessage.Text = " Edit Exception: " + ex.Message; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "DeleteRow") { try { lblException.Visible = false; lblErrorMessage.Visible = false; if (ddl != 0 && txt != 0) { DataAccessLayer.DeletePoll(Convert.ToInt32(e.CommandArgument)); GridSearch(); } else { DataAccessLayer.DeletePoll(Convert.ToInt32(e.CommandArgument)); GridBind(); } } catch (Exception ex) { lblErrorMessage.Visible = true; lblErrorMessage.Text = "Delete Exception: " + ex.Message; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "CancelUpdate") { try { lblException.Visible = false; lblErrorMessage.Visible = false; if (ddl != 0 && txt != 0) { gvPolls.EditIndex = -1; GridSearch(); } else { gvPolls.EditIndex = -1; GridBind(); } } catch (Exception ex) { lblException.Visible = true; lblException.Text = "Cancel Exception: " + ex.Message; lblException.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "UpdateRow") { try { lblException.Visible = false; lblErrorMessage.Visible = false; DataAccessLayer DAL = new DataAccessLayer(); int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; int PollID = Convert.ToInt32(e.CommandArgument); string PollType = ((TextBox)gvPolls.Rows[rowIndex].FindControl("txtPollType")).Text; string PollName = ((TextBox)gvPolls.Rows[rowIndex].FindControl("txtPollName")).Text; string PollQuestion = ((TextBox)gvPolls.Rows[rowIndex].FindControl("txtPollQues")).Text; string PollDescription = ((TextBox)gvPolls.Rows[rowIndex].FindControl("txtPollDesc")).Text; string PollStatus = ((DropDownList)gvPolls.Rows[rowIndex].FindControl("ddlEditStatus")).SelectedValue; string PollRole = ((DropDownList)gvPolls.Rows[rowIndex].FindControl("ddlEditPollRole")).SelectedValue; lblErrorMessage.Visible = true; lblErrorMessage.Text = "Poll-Name <b>" + PollName + "</b> and Poll-Type <b>" + PollType + "</b> has been updated"; lblErrorMessage.ForeColor = System.Drawing.Color.Green; DAL.UpdatePoll(PollID, PollType, PollName, PollQuestion, PollDescription, PollRole, PollStatus); lblSearchError.Visible = false; if (ddl != 0 && txt != 0) { gvPolls.EditIndex = -1; GridSearch(); } else { gvPolls.EditIndex = -1; GridBind(); } } catch (Exception ex) { lblErrorMessage.Visible = true; lblErrorMessage.Text = "Update Exception: " + ex.Message; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } } }