public override void Add(VolumeEvtRate r) { string sql = String.Format("insert into {0}.VOLUME_EVT_RATE " + "(" + " CONTRACT_VOLUME_EVT_ID" + ", TIER " + ", ADJ " + ", ADJ_INHOUSE " + ", ADJ_OFFSHORE " + ", ADJ_SR" + ", ADJ_SR_INHOUSE " + ", ADJ_SR_OFFSHORE " + " ) " + "values " + " ( " + " :CONTRACT_VOLUME_EVT_ID" + ", :TIER" + ", :ADJ" + ", :ADJ_INHOUSE" + ", :ADJ_OFFSHORE" + ", :ADJ_SR" + ", :ADJ_SR_INHOUSE " + ", :ADJ_SR_OFFSHORE " + " ) " , SchemaName); try { List <OracleParameter> parameters = new List <OracleParameter>(); parameters.Add(OracleHelper.CreateParameter(":CONTRACT_VOLUME_EVT_ID", CheckNull(r.CONTRACT_VOLUME_EVT_ID), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":TIER", CheckNull(r.TIER), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":ADJ", CheckNull(r.ADJ), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":ADJ_INHOUSE", CheckNull(r.ADJ_INHOUSE), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":ADJ_OFFSHORE", CheckNull(r.ADJ_OFFSHORE), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":ADJ_SR", CheckNull(r.ADJ_SR), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":ADJ_SR_INHOUSE", CheckNull(r.ADJ_SR_INHOUSE), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":ADJ_SR_OFFSHORE", CheckNull(r.ADJ_SR_OFFSHORE), OracleType.Number, ParameterDirection.Input)); OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>()); r.Modified = false; } catch (OracleException ex) { throw ex; } catch (Exception x) { throw x; } }
protected override void RowConverter(VolumeEvtRate r, DataRow record) { try { r.ADJ = CastDbValueRow(record, "ADJ", true, "decimal"); r.ADJ_INHOUSE = CastDbValueRow(record, "ADJ_INHOUSE", true, "decimal"); r.ADJ_OFFSHORE = CastDbValueRow(record, "ADJ_OFFSHORE", true, "decimal"); r.ADJ_SR = CastDbValueRow(record, "ADJ_SR", true, "decimal"); r.ADJ_SR_INHOUSE = CastDbValueRow(record, "ADJ_SR_INHOUSE", true, "decimal"); r.ADJ_SR_OFFSHORE = CastDbValueRow(record, "ADJ_SR_OFFSHORE", true, "decimal"); r.CONTRACT_VOLUME_EVT_ID = CastDbValueRow(record, "CONTRACT_VOLUME_EVT_ID", true, "decimal"); r.TIER = CastDbValueRow(record, "TIER", true, "decimal"); r.Modified = false; } catch (Exception ex) { throw ex; } }
public override void Remove(VolumeEvtRate package) { string sql; try { sql = String.Format("DELETE FROM {0}.VOLUME_EVT_RATE WHERE " + " TIER = :TIER" + " and CONTRACT_VOLUME_EVT_ID = :CONTRACT_VOLUME_EVT_ID" , SchemaName); List <OracleParameter> parameters = new List <OracleParameter>(); parameters.Add(OracleHelper.CreateParameter(":TIER", package.TIER, OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":CONTRACT_VOLUME_EVT_ID", package.CONTRACT_VOLUME_EVT_ID, OracleType.Number, ParameterDirection.Input)); OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>()); package.Modified = false; } catch (OracleException ex) { throw ex; } }
public override VolumeEvtRate Get(VolumeEvtRate entity) { throw new NotImplementedException(); }