protected void grdViewRoles_RowCommand(object sender, GridViewCommandEventArgs e) { int ddl = ddlSearch.SelectedValue.Length; int txt = txtSearch.Text.Length; if (e.CommandName == "InsertRow") { DataAccessLayer DAL = new DataAccessLayer(); string RoleName = ((TextBox)grdViewRoles.FooterRow.FindControl("txtInsertRoleName")).Text; string Party = ((TextBox)grdViewRoles.FooterRow.FindControl("txtInsertParty")).Text; string RoleYear = ((TextBox)grdViewRoles.FooterRow.FindControl("txtInsertYear")).Text; string ManifestoName = ((TextBox)grdViewRoles.FooterRow.FindControl("txtInsertManifestorName")).Text; string ManifestoShortDesc = ((TextBox)grdViewRoles.FooterRow.FindControl("txtInsertManifestoShortDesc")).Text; string ManifestoLongDesc = ((TextBox)grdViewRoles.FooterRow.FindControl("txtInsertManifestoLongDesc")).Text; string Candidate_Name = ((DropDownList)grdViewRoles.FooterRow.FindControl("ddlInsertCandidateName")).SelectedValue; string RoleStatus = ((DropDownList)grdViewRoles.FooterRow.FindControl("ddlInsertStatus")).SelectedValue; try { if (((FileUpload)grdViewRoles.FooterRow.FindControl("fuInsertRoleImage")).HasFile) { string RoleImages = ((FileUpload)grdViewRoles.FooterRow.FindControl("fuInsertRoleImage")).FileName; ((FileUpload)grdViewRoles.FooterRow.FindControl("fuInsertRoleImage")).PostedFile.SaveAs(Server.MapPath(".") + "/images/" + RoleImages); String pathRoleImages = "/images/" + RoleImages.ToString(); lblException.Visible = false; lblErrorMessage.Visible = true; lblErrorMessage.Text = "Role has been created for <b>" + Party + "</b> & role name <b>" + RoleName + "</b>"; lblErrorMessage.ForeColor = System.Drawing.Color.Green; DataAccessLayer.InsertRole(RoleName, Party, RoleYear, pathRoleImages, ManifestoName, ManifestoShortDesc, ManifestoLongDesc, Candidate_Name, RoleStatus); GridBind(); } } catch (Exception ex) { lblException.Visible = true; lblException.Text = "Record Insert Exception: " + ex.Message; lblException.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "EditRow") { try { lblException.Visible = false; lblErrorMessage.Visible = false; if (ddl != 0 && txt != 0) { int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; grdViewRoles.EditIndex = rowIndex; GridSearch(); } else { int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; grdViewRoles.EditIndex = rowIndex; ////Get the value from the row. ////string Candidate_Name = ((Label)grdViewRoles.Rows[rowIndex].FindControl("lblCandidateName")).Text; //string Candidate_Name = ((DropDownList)grdViewRoles.Rows[rowIndex].FindControl("ddlDisplayCandidateName")).SelectedValue; //DropDownList candidateDDL = grdViewRoles.Rows[rowIndex].FindControl("ddlEditCandidateName") as DropDownList; //candidateDDL.SelectedValue = Candidate_Name; GridBind(); } } catch (Exception ex) { lblException.Visible = true; lblException.Text = "Edit record Exception: " + ex.Message; lblException.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "DeleteRow") { try { lblException.Visible = false; lblErrorMessage.Visible = false; if (ddl != 0 && txt != 0) { DataAccessLayer.DeleteRole(Convert.ToInt32(e.CommandArgument)); GridSearch(); } else { DataAccessLayer.DeleteRole(Convert.ToInt32(e.CommandArgument)); GridBind(); } } catch (Exception ex) { lblException.Visible = true; lblException.Text = "Delete Record Exception: " + ex.Message; lblException.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "CancelUpdate") { try { lblException.Visible = false; lblErrorMessage.Visible = false; if (ddl != 0 && txt != 0) { grdViewRoles.EditIndex = -1; GridSearch(); lblSearchError.Visible = false; } else { grdViewRoles.EditIndex = -1; GridBind(); lblSearchError.Visible = false; } } catch (Exception ex) { lblException.Visible = true; lblException.Text = "Cancel Row Exception: " + ex.Message; lblException.ForeColor = System.Drawing.Color.Red; } } else if (e.CommandName == "UpdateRow") { try { lblException.Visible = false; lblErrorMessage.Visible = false; int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; int RoleID = Convert.ToInt32(e.CommandArgument); string RoleName = ((TextBox)grdViewRoles.Rows[rowIndex].FindControl("txtEditRoleName")).Text; string Party = ((TextBox)grdViewRoles.Rows[rowIndex].FindControl("txtEditParty")).Text; string RoleYear = ((TextBox)grdViewRoles.Rows[rowIndex].FindControl("txtEditYear")).Text; string ManifestoName = ((TextBox)grdViewRoles.Rows[rowIndex].FindControl("txtEditManifestorName")).Text; string ManifestoShortDesc = ((TextBox)grdViewRoles.Rows[rowIndex].FindControl("txtEditManifestorShortDesc")).Text; string ManifestoLongDesc = ((TextBox)grdViewRoles.Rows[rowIndex].FindControl("txtEditManifestorLongDesc")).Text; string RoleStatus = ((DropDownList)grdViewRoles.Rows[rowIndex].FindControl("ddlEditStatus")).SelectedValue; string Candidate_Name = ((DropDownList)grdViewRoles.Rows[rowIndex].FindControl("ddlEditCandidateName")).SelectedValue; // DataAccessLayer.UpdateRole(RoleID, RoleName, Party, RoleYear, ManifestoName, ManifestoShortDesc, Candidate_Name, ManifestoLongDesc, RoleStatus); //lblErrorMessage.Visible = true; //lblErrorMessage.Text = "Role has been updated for <b>" + Party + "</b> & role name <b>" + RoleName + "</b>"; //lblErrorMessage.ForeColor = System.Drawing.Color.Green; //if (ddl != 0 && txt != 0) //{ // grdViewRoles.EditIndex = -1; // GridSearch(); // lblSearchError.Visible = false; //} //else //{ // grdViewRoles.EditIndex = -1; // GridBind(); // lblSearchError.Visible = false; //} GridViewRow row = (GridViewRow)grdViewRoles.Rows[rowIndex]; Label id = (Label)row.FindControl("lbleditRoleID"); FileUpload fu = (FileUpload)row.FindControl("fuEditRoleImage"); int res = 1; try { if (fu.HasFile) { string file = System.IO.Path.Combine(Server.MapPath("/images/"), fu.FileName); fu.SaveAs(file); string imageValue = "/images/" + fu.FileName; res = DataAccessLayer.UpdateImage(RoleID, imageValue.ToString()); } } catch (Exception ex) { lblException.Visible = true; lblException.Text = "Image Upload Exception: " + ex.Message; lblException.ForeColor = System.Drawing.Color.Red; } lblException.Visible = false; lblErrorMessage.Visible = true; lblErrorMessage.Text = "Record has been updated for <b>" + Party + "</b> & role name <b>" + RoleName + "</b>"; lblErrorMessage.ForeColor = System.Drawing.Color.Green; DataAccessLayer.UpdateRole(RoleID, RoleName, Party, RoleYear, ManifestoName, ManifestoShortDesc, ManifestoLongDesc, Candidate_Name, RoleStatus); grdViewRoles.EditIndex = -1; GridBind(); lblSearchError.Visible = false; } catch (Exception ex) { lblException.Visible = true; lblException.Text = "Update Record Exception: " + ex.Message; lblException.ForeColor = System.Drawing.Color.Red; } } }