public static void GrabarMatriculaUpdate(ref MatriculaDto mat, ref OracleConnection con, ref OracleTransaction tran)
{
var cmdPro = new OracleCommand("PRC_MATRICULA_UPDATE");
cmdPro.CommandType = CommandType.StoredProcedure;
cmdPro.Connection = con;
cmdPro.Parameters.Add(CreateParameter("iMTRID", mat.MtrId));//NUMBER
cmdPro.Parameters.Add(CreateParameter("iMTRDESCRIPCION", mat.MtrDescripcion, 45));//NUMBER
cmdPro.Transaction = tran;
cmdPro.ExecuteNonQuery();//EJECUTO CONSULTA
}
internal override DtoBase PopulateDto(OracleDataReader reader)
{
var matricula = new MatriculaDto();
//
if (!reader.IsDBNull(_mtrId)) { matricula.MtrId = reader.GetInt32(_mtrId); }
//
if (!reader.IsDBNull(_mtrDescripcion)) {matricula.MtrDescripcion = reader.GetString(_mtrDescripcion); }
//
if (!reader.IsDBNull(_mttId)) { matricula.MtrTipo.MttId = reader.GetInt32(_mttId); }
if (!reader.IsDBNull(_mttDescripcion)) { matricula.MtrTipo.MttDescripcion = reader.GetString(_mttDescripcion); }
// IsNew
matricula.IsNew = false;
return matricula;
}
public static void GrabarMatriculaInsert(ref MatriculaDto mat, ref OracleConnection con, ref OracleTransaction tran)
{
#region INSERT Matricula del profesional -------------------------------------------------------------------
var cmdMat = new OracleCommand("PRC_MATRICULA_INSERT");
cmdMat.CommandType = CommandType.StoredProcedure;
cmdMat.Connection = con;
cmdMat.Parameters.Add(CreateParameter("iMTRDESCRIPCION", mat.MtrDescripcion, 45));//VARCHAR
cmdMat.Parameters.Add(CreateParameter("iMTR_MTTID", mat.MtrTipo.MttId));//NUMBER
cmdMat.Parameters.Add(CrearParametroSalida("oMTRID", OracleDbType.Int32));//NUMBER
cmdMat.Transaction = tran;
cmdMat.ExecuteNonQuery();
var varMtrId = cmdMat.Parameters["oMTRID"].Value;
mat.MtrId = Convert.ToInt16(varMtrId.ToString());
#endregion
}
