public string UpdateAcreagePercent(AcreagePercentBO objPercent) { string returnResult = string.Empty; using (cnn = new OracleConnection(con)) { using (cmd = new OracleCommand(proc, cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "USP_MST_UPD_ACREAGEPERC"; cmd.Connection.Open(); cmd.Parameters.Add("percentID_", objPercent.PercentID); cmd.Parameters.Add("percent_", objPercent.Percent); cmd.Parameters.Add("updatedBy_", objPercent.UpdatedBy); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { returnResult = cmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } cmd.Connection.Close(); } } return(returnResult); }
public AcreagePercentBO GetAcreagePercentID(int percentID) { AcreagePercentBO objPercent = null; using (cnn = new OracleConnection(con)) { using (cmd = new OracleCommand(proc, cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "USP_MST_GET_ACREAGEPERCBYID"; cmd.Parameters.Add("percentID_", percentID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objPercent = new AcreagePercentBO(); if (!dr.IsDBNull(dr.GetOrdinal("PercentID"))) { objPercent.PercentID = dr.GetInt32(dr.GetOrdinal("PercentID")); } if (!dr.IsDBNull(dr.GetOrdinal("Percent"))) { objPercent.Percent = dr.GetString(dr.GetOrdinal("Percent")); } } dr.Close(); } catch (Exception ex) { throw ex; } } } return(objPercent); }