public override void Update(TatCompMethod package)
{
try
{
string sql = String.Format("update {0}.TAT_COMP_METHOD set "
+ " DESCR = :DESCR "
+ " ,SHORT_DESCR = :SHORT_DESCR"
+ " ,LONG_DESCR = :LONG_DESCR "
+ " ,SHOW_TAT_COLUMN_ON_INVOICE = :SHOW_TAT_COLUMN_ON_INVOICE "
+ "where TAT_COMP_METHOD = :TAT_COMP_METHOD"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":DESCR", package.DESCR, OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":SHORT_DESCR", package.SHORT_DESCR, OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":LONG_DESCR", package.LONG_DESCR, OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":SHOW_TAT_COLUMN_ON_INVOICE", (package.SHOW_TAT_COLUMN_ON_INVOICE)?'Y':'N', OracleType.Char, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":TAT_COMP_METHOD", package.TAT_COMP_METHOD, OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
}
catch (OracleException ex)
{
throw ex;
//throw ex;
}
}
void SetSchedItemDetails()
{
if (selectedTatSched == null)
{
selectedTatCompMethod = null;
TatRates = null;
}
else
{
foreach (TatCompMethod tatCompMethod in TatCompMethods)
{
if (selectedTatSched.TAT_COMP_METHOD == tatCompMethod.TAT_COMP_METHOD)
{
SelectedTatCompMethod = tatCompMethod;
break;
}
}
TatRates = TatRateTarget.GetTatRates(SelectedTatSched.TAT_SCHED_ID);
if (TatRates.Count > 0)
{
SelectedTatRate = TatRates[0];
}
ThisView.SetHeader(SelectedTatCompMethod.SHORT_DESCR);
}
}
protected override void RowConverter(TatCompMethod r, DataRow record)
{
try
{
r.SHOW_TAT_COLUMN_ON_INVOICE = CastDbValueRow(record, "SHOW_TAT_COLUMN_ON_INVOICE", true, "Bool");
r.SHORT_DESCR = CastDbValueRow(record, "SHORT_DESCR");
r.LONG_DESCR = CastDbValueRow(record, "LONG_DESCR");
r.DESCR = CastDbValueRow(record, "DESCR");
r.TAT_COMP_METHOD = CastDbValueRow(record, "TAT_COMP_METHOD");
}
catch (Exception ex)
{
throw ex;
}
}
public override void Remove(TatCompMethod package)
{
try
{
string sql = String.Format("DELETE FROM {0}.TAT_COMP_METHOD WHERE TAT_COMP_METHOD = :TAT_COMP_METHOD", SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":TAT_COMP_METHOD", package.TAT_COMP_METHOD, OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
}
catch (OracleException ex)
{
throw ex;
//throw ex;
}
}
public override void Add(TatCompMethod r)
{
string sql = String.Format("insert into {0}.TAT_COMP_METHOD"
+ "("
+ " TAT_COMP_METHOD"
+ ", DESCR"
+ ", SHORT_DESCR"
+ ", LONG_DESCR"
+ ", SHOW_TAT_COLUMN_ON_INVOICE"
+ " ) "
+ "values "
+ " ( "
+ ", :TAT_COMP_METHOD"
+ ", :DESCR"
+ ", :SHORT_DESCR"
+ ", :LONG_DESCR"
+ ", :SHOW_TAT_COLUMN_ON_INVOICE"
+ " ) "
, SchemaName);
try
{
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":NEWID", OracleType.Number, ParameterDirection.InputOutput));
parameters.Add(OracleHelper.CreateParameter(":DESCR", CheckNull(r.DESCR), OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":SHORT_DESCR", CheckNull(r.SHORT_DESCR), OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":LONG_DESCR", CheckNull(r.LONG_DESCR), OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":SHOW_TAT_COLUMN_ON_INVOICE", (r.SHOW_TAT_COLUMN_ON_INVOICE)?'Y':'N', OracleType.Char, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
}
catch (OracleException ex)
{
throw ex;
}
catch (Exception x)
{
throw x;
}
}
public override TatCompMethod Get(TatCompMethod entity)
{
throw new NotImplementedException();
}
