public override void Add(ContractTatSched r) { string sql = String.Format("insert into {0}.CONTRACT_TAT_SCHED " + "(" + " CONTRACT_ID" + ", TAT_SCHED_ID " + ", BEGIN_ON" + ", END_AFTER " + ", AUTO_CHG " + " ) " + "values " + " ( " + " :CONTRACT_ID" + ", :TAT_SCHED_ID" + ", :BEGIN_ON" + ", :END_AFTER " + ", :AUTO_CHG " + " ) " , SchemaName); try { List <OracleParameter> parameters = new List <OracleParameter>(); parameters.Add(OracleHelper.CreateParameter(":CONTRACT_ID", CheckNull(r.CONTRACT_ID), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":TAT_SCHED_ID", CheckNull(r.TAT_SCHED_ID), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":BEGIN_ON", CheckNull(r.BEGIN_ON), OracleType.DateTime, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":END_AFTER", CheckNull(r.END_AFTER), OracleType.DateTime, ParameterDirection.Input)); if (r.AUTO_CHG != null) { parameters.Add(OracleHelper.CreateParameter(":AUTO_CHG", (r.AUTO_CHG)?'Y':'N', OracleType.Char, ParameterDirection.Input)); } else { parameters.Add(OracleHelper.CreateParameter(":AUTO_CHG", DBNull.Value, OracleType.Char, ParameterDirection.Input)); } OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>()); r.bWasAdded = r.Modified = false; } catch (OracleException ex) { throw ex; } catch (Exception x) { throw x; } }
protected override void RowConverter(ContractTatSched r, DataRow record) { try { r.CONTRACT_ID = CastDbValueRow(record, "CONTRACT_ID", true, "decimal"); r.TAT_SCHED_ID = CastDbValueRow(record, "TAT_SCHED_ID", true, "decimal"); r.BEGIN_ON = CastDbValueRow(record, "BEGIN_ON", true, "DateTime"); r.END_AFTER = CastDbValueRow(record, "END_AFTER", true, "DateTime"); r.AUTO_CHG = CastDbValueRow(record, "AUTO_CHG", true, "Bool"); r.Modified = false; } catch (Exception ex) { throw ex; } }
/// <summary> /// Special note on this. The keys are /// CONTRACT_ID /// TAT_SCHED_ID /// BEGIN_ON /// /// The fields TAT_SCHED_ID and BEGIN_ON are editable and represent a condition /// where they keys may collide - Current software checks this condition and /// displays a warning to avoid it. /// </summary> /// <param name="r"></param> public override void Update(ContractTatSched r) { try { string sql = String.Format("update {0}.CONTRACT_TAT_SCHED set " //+ " CONTRACT_ID = :CONTRACT_ID " //+ " TAT_SCHED_ID = :TAT_SCHED_ID " //+ " ,BEGIN_ON = :BEGIN_ON " + " END_AFTER = :END_AFTER " + " ,AUTO_CHG = :AUTO_CHG " + " where " + " CONTRACT_ID = :CONTRACT_ID AND" + " TAT_SCHED_ID = :TAT_SCHED_ID AND" + " BEGIN_ON = :BEGIN_ON" , SchemaName); List <OracleParameter> parameters = new List <OracleParameter>(); parameters.Add(OracleHelper.CreateParameter(":TAT_SCHED_ID", CheckNull(r.TAT_SCHED_ID), OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":BEGIN_ON", CheckNull(r.BEGIN_ON), OracleType.DateTime, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":END_AFTER", CheckNull(r.END_AFTER), OracleType.DateTime, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":CONTRACT_ID", CheckNull(r.CONTRACT_ID), OracleType.Number, ParameterDirection.Input)); if (r.AUTO_CHG != null) { parameters.Add(OracleHelper.CreateParameter(":AUTO_CHG", (r.AUTO_CHG) ? 'Y' : 'N', OracleType.Char, ParameterDirection.Input)); } else { parameters.Add(OracleHelper.CreateParameter(":AUTO_CHG", 'N', OracleType.Char, 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; } }
public override void Remove(ContractTatSched package) { string sql; try { sql = String.Format("DELETE FROM {0}.CONTRACT_TAT_SCHED WHERE " + " CONTRACT_ID = :CONTRACT_ID" + " and TAT_SCHED_ID = :TAT_SCHED_ID" + " and BEGIN_ON = :BEGIN_ON" , SchemaName); List <OracleParameter> parameters = new List <OracleParameter>(); parameters.Add(OracleHelper.CreateParameter(":CONTRACT_ID", package.CONTRACT_ID, OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":TAT_SCHED_ID", package.TAT_SCHED_ID, OracleType.Number, ParameterDirection.Input)); parameters.Add(OracleHelper.CreateParameter(":BEGIN_ON", package.BEGIN_ON, OracleType.DateTime, ParameterDirection.Input)); OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>()); package.Modified = false; } catch (OracleException ex) { throw ex; } }
public override ContractTatSched Get(ContractTatSched entity) { throw new NotImplementedException(); }