public BusinessEntity.ContactoBE getContacto(string idInversion)
{
BusinessEntity.ContactoBE oContactoBE = new BusinessEntity.ContactoBE();
IDataReader dr = null;
try
{
using (DbCommand cmd = dbAdeudosInversiones.GetStoredProcCommand(GetNameStoreProcedure.uspGetContacto))
{
cmd.CommandTimeout = 0;
dbAdeudosInversiones.AddInParameter(cmd, "idInversion", DbType.String, idInversion);
dr = dbAdeudosInversiones.ExecuteReader(cmd);
while (dr.Read())
{
oContactoBE = ContactoP.getContacto(dr);
}
}
}
catch (Exception)
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
throw;
}
return(oContactoBE);
}
public void updateContato(BusinessEntity.ContactoBE pContactoBE)
{
using (DbCommand cmd = dbAdeudosInversiones.GetStoredProcCommand(GetNameStoreProcedure.uspUpdateContacto))
{
//cmd.CommandTimeout = 0;
dbAdeudosInversiones.AddInParameter(cmd, "idInversion", DbType.String, pContactoBE.idInversion);
dbAdeudosInversiones.AddInParameter(cmd, "funcionario", DbType.String, pContactoBE.funcionario);
dbAdeudosInversiones.AddInParameter(cmd, "telefono", DbType.String, pContactoBE.telefono);
dbAdeudosInversiones.AddInParameter(cmd, "anexo", DbType.String, pContactoBE.anexo);
dbAdeudosInversiones.AddInParameter(cmd, "correo", DbType.String, pContactoBE.correo);
dbAdeudosInversiones.AddInParameter(cmd, "celular", DbType.String, pContactoBE.celular);
if (pContactoBE.cumpleanos == DateTime.MinValue)
{
dbAdeudosInversiones.AddInParameter(cmd, "cumpleanos", DbType.DateTime, DBNull.Value);
}
else
{
dbAdeudosInversiones.AddInParameter(cmd, "cumpleanos", DbType.DateTime, pContactoBE.cumpleanos);
}
dbAdeudosInversiones.AddInParameter(cmd, "cuentaBancoID", DbType.Int32, pContactoBE.cuentaBancoID);
dbAdeudosInversiones.ExecuteNonQuery(cmd);
}
}
public void updateContato(BusinessEntity.ContactoBE pContactoBE)
{
oContactoDA.updateContato(pContactoBE);
}
public void insertContato(BusinessEntity.ContactoBE pContactoBE)
{
oContactoDA.insertContato(pContactoBE);
}
