/// <summary> /// to fetch details /// </summary> /// <returns></returns> public FenceDescriptionList GetFence() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GET_FENCE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); FenceDescriptionBO objUser = null; FenceDescriptionList Users = new FenceDescriptionList(); while (dr.Read()) { objUser = new FenceDescriptionBO(); objUser.FenceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FENCEID"))); objUser.FenceDescription = dr.GetString(dr.GetOrdinal("FENCEDESCRIPTION")); Users.Add(objUser); } dr.Close(); return(Users); }
/// <summary> /// To fetch details /// </summary> private void GetVulnerabiltyDetails() { FenceDescriptionBLLObj = new FenceDescriptionBLL(); int FenceID = 0; if (ViewState["FenceID"] != null) { FenceID = Convert.ToInt32(ViewState["FenceID"]); } FenceDescriptionBOObj = new FenceDescriptionBO(); FenceDescriptionBOObj = FenceDescriptionBLLObj.GetFencebyID(FenceID); txtFenceDescription.Text = FenceDescriptionBOObj.FenceDescription; ConcernIDTextBox.Text = FenceDescriptionBOObj.FenceID.ToString(); }
public string Update(FenceDescriptionBO FenceDescriptionBOobj, int FenceID) { FenceDescriptionDAL FenceDescriptionDALObj = new FenceDescriptionDAL(); try { return FenceDescriptionDALObj.Update(FenceDescriptionBOobj, FenceID); } catch (Exception ex) { throw ex; } finally { FenceDescriptionDALObj = null; } }
/// <summary> /// To Insert /// </summary> /// <param name="FenceDescriptionBOobj"></param> /// <returns></returns> public string insert(FenceDescriptionBO FenceDescriptionBOobj) { FenceDescriptionDAL FenceDescriptionDALObj = new FenceDescriptionDAL(); try { return FenceDescriptionDALObj.insert(FenceDescriptionBOobj); } catch (Exception ex) { throw ex; } finally { FenceDescriptionDALObj = null; } }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = string.Empty; string AlertMessage = string.Empty; if (ConcernIDTextBox.Text == string.Empty) { FenceDescriptionBOObj = new FenceDescriptionBO(); FenceDescriptionBOObj.FenceDescription = txtFenceDescription.Text.ToString(); FenceDescriptionBOObj.Createdby = Convert.ToInt32(Session["USER_ID"].ToString()); FenceDescriptionBLLObj = new FenceDescriptionBLL(); message = FenceDescriptionBLLObj.insert(FenceDescriptionBOObj); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearFields(); BindGrid(true, true); } //BindGrid(true, true); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Fence description details added successfully');", true); // ClearFields(); } else { int reasonid = Convert.ToInt32(ViewState["FenceID"]); FenceDescriptionBOObj = new FenceDescriptionBO(); FenceDescriptionBOObj.FenceDescription = txtFenceDescription.Text.ToString(); FenceDescriptionBOObj.Createdby = Convert.ToInt32(Session["USER_ID"].ToString()); FenceDescriptionBLLObj = new FenceDescriptionBLL(); message = FenceDescriptionBLLObj.Update(FenceDescriptionBOObj, reasonid); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; BindGrid(true, true); ClearFields(); } } //BindGrid(true, true); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Fence description details updated successfully');", true); //ClearFields(); AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); SetUpdateMode(false); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Insert() { try { FenceDescriptionBOObj = new FenceDescriptionBO(); FenceDescriptionBOObj.FenceDescription = txtFenceDescription.Text.ToString(); FenceDescriptionBOObj.Createdby = 1; FenceDescriptionBLLObj = new FenceDescriptionBLL(); FenceDescriptionBLLObj.insert(FenceDescriptionBOObj); } catch (Exception ex) { throw ex; } finally { FenceDescriptionBLLObj = null; } }
/// <summary> /// To update details to database /// </summary> /// <param name="FenceDescriptionBOobj"></param> /// <param name="FenceID"></param> /// <returns></returns> public string Update(FenceDescriptionBO FenceDescriptionBOobj, int FenceID) { string returnResult = string.Empty; OracleConnection conn = new OracleConnection(AppConfiguration.ConnectionString); conn.Open(); OracleCommand dCmd = new OracleCommand("USP_MST_UPD_FENCE", conn); dCmd.CommandType = CommandType.StoredProcedure; try { dCmd.Parameters.Add("p_FENCEID", FenceID); dCmd.Parameters.Add("p_FENCEDESCRIPTION", FenceDescriptionBOobj.FenceDescription); dCmd.Parameters.Add("p_UPDATEDBY", FenceDescriptionBOobj.Createdby); dCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dCmd.ExecuteNonQuery(); if (dCmd.Parameters["errorMessage_"].Value != null) { returnResult = dCmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } } catch (Exception ex) { throw ex; } finally { dCmd.Dispose(); conn.Close(); conn.Dispose(); } return(returnResult); }
/// <summary> /// to get details by ID /// </summary> /// <param name="FenceID"></param> /// <returns></returns> public FenceDescriptionBO GetFencebyID(int FenceID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_FENCEBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("p_fenceid", FenceID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); FenceDescriptionBO FenceDescriptionBOobj = null; FenceDescriptionList Users = new FenceDescriptionList(); FenceDescriptionBOobj = new FenceDescriptionBO(); while (dr.Read()) { if (ColumnExists(dr, "FENCEDESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("FENCEDESCRIPTION"))) { FenceDescriptionBOobj.FenceDescription = dr.GetString(dr.GetOrdinal("FENCEDESCRIPTION")); } if (ColumnExists(dr, "FENCEID") && !dr.IsDBNull(dr.GetOrdinal("FENCEID"))) { FenceDescriptionBOobj.FenceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FENCEID"))); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { FenceDescriptionBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } } dr.Close(); return(FenceDescriptionBOobj); }