public void Guardar(Notificacion obj)
{
OracleCommand cmd = null;
string sql = string.Empty;
if (obj.EsNuevo)
{
Pista p = PistaMgr.Instance.Info("DALSisFalla", obj.GetEstadoString());
obj.SecLog = (long)p.PK_SecLog;
sql = "INSERT INTO {0} ({1},{2},{3},{4},{5},{6})" +
"VALUES(:{1},:{2},:{3},:{4},:{5},:{6})";
}
else
{
sql = "UPDATE {0} SET " +
"{3}=:{3} ," +
"{4}=:{4} ," +
"{5}=:{5} ," +
"{6}=:{6} WHERE " +
"{1}=:{1} AND " +
"{2}=:{2}";
}
sql = string.Format(sql, Notificacion.NOMBRE_TABLA, Notificacion.C_PK_COD_FALLA,
Notificacion.C_PK_COD_PERSONA,
Notificacion.C_D_COD_ESTADO_NOTIFICACION,
Notificacion.C_D_COD_ESTADO,
Notificacion.C_SEC_LOG,
Notificacion.C_SINC_VER);
cmd = CrearCommand();
cmd.CommandText = sql;
cmd.BindByName = true;
cmd.Parameters.Add(Notificacion.C_PK_COD_FALLA, OracleDbType.Int32, obj.PkCodFalla, System.Data.ParameterDirection.Input);
cmd.Parameters.Add(Notificacion.C_PK_COD_PERSONA, OracleDbType.Int64, obj.PkCodPersona, System.Data.ParameterDirection.Input);
cmd.Parameters.Add(Notificacion.C_D_COD_ESTADO_NOTIFICACION, OracleDbType.Int64, obj.DCodEstadoNotificacion, System.Data.ParameterDirection.Input);
cmd.Parameters.Add(Notificacion.C_D_COD_ESTADO, OracleDbType.Varchar2, obj.DCodEstado, System.Data.ParameterDirection.Input);
cmd.Parameters.Add(Notificacion.C_SEC_LOG, OracleDbType.Int64, obj.SecLog, System.Data.ParameterDirection.Input);
cmd.Parameters.Add(Notificacion.C_SINC_VER, OracleDbType.Int64, obj.SincVer, System.Data.ParameterDirection.Input);
if (Actualizar(cmd))
{
obj.EsNuevo = false;
}
}