protected void IsObsolete_CheckedChanged(Object sender, EventArgs e) { string message = string.Empty; try { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; string VulnerabilityID = ((Literal)gr.FindControl("litVulnerabilityID")).Text; int VulnerabilityID_ = Convert.ToInt32(VulnerabilityID); VulnerabilityBLL VulnerabilityBLLObj = new VulnerabilityBLL(); message = VulnerabilityBLLObj.Obsoletevulnerability(VulnerabilityID_, Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } BindGrid(); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Edit,delete and soft delete the data. /// </summary> #region for Grid data(Edit Delete and absoult record) protected void dv_Details_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["VulnerabilityID"] = e.CommandArgument; int reasonID = Convert.ToInt32(ViewState["VulnerabilityID"]); GetVulnerabiltyDetails(); SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { VulnerabilityBLL VulnerabilityBLLObj = new VulnerabilityBLL(); message = VulnerabilityBLLObj.Deletevulnerability(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } SetUpdateMode(true); ClearFields(); BindGrid(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
//to get record for the grid for update private void GetVulnerabiltyDetails() { VulnerabilityBLLObj = new VulnerabilityBLL(); int VulnerabilityID = 0; if (ViewState["VulnerabilityID"] != null) { VulnerabilityID = Convert.ToInt32(ViewState["VulnerabilityID"]); } VulnerabilityBOObj = new VulnerabilityBO(); VulnerabilityBOObj = VulnerabilityBLLObj.GetVulnerablitybyID(VulnerabilityID); txtVulnerability.Text = VulnerabilityBOObj.VulnerabilityType; }
private string Insert() { string message = string.Empty; try { string uID = Session["USER_ID"].ToString(); VulnerabilityBOObj = new VulnerabilityBO(); VulnerabilityBOObj.VulnerabilityType = txtVulnerability.Text.ToString(); VulnerabilityBOObj.CreatedBy = Convert.ToInt32(uID);; VulnerabilityBLLObj = new VulnerabilityBLL(); message = VulnerabilityBLLObj.insert(VulnerabilityBOObj); } catch (Exception ex) { throw ex; } finally { VulnerabilityBLLObj = null; } return(message); }
/// <summary> /// Save, clear, update the data. /// </summary> #region for Save, clear, update(Insert) the Record protected void btnSave_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; if (ViewState["VulnerabilityID"].ToString() == "0") { message = Insert(); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearFields(); BindGrid(); } } else { string uID = Session["USER_ID"].ToString(); int reasonid = Convert.ToInt32(ViewState["VulnerabilityID"]); VulnerabilityBOObj = new VulnerabilityBO(); VulnerabilityBOObj.VulnerabilityType = txtVulnerability.Text.ToString(); VulnerabilityBOObj.CreatedBy = Convert.ToInt32(uID); VulnerabilityBLLObj = new VulnerabilityBLL(); message = VulnerabilityBLLObj.Update(VulnerabilityBOObj, reasonid); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearFields(); BindGrid(); SetUpdateMode(false); } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> #region for Bind data from database Table private void BindGrid() { VulnerabilityBLLObj = new VulnerabilityBLL(); dv_Details.DataSource = VulnerabilityBLLObj.GetALLVulnerability(); dv_Details.DataBind(); }