public ParticipeOperacion getparticipebytipo(Int32 id_solicitud, string tipo)
{
try
{
using (SqlConnection sqlConn = new SqlConnection(this.strConn))
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(strConn, sqlConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_r_participebytipo";
cmd.Parameters.AddWithValue("@id_solicitud", id_solicitud);
cmd.Parameters.AddWithValue("@tipo", tipo);
SqlDataReader reader = cmd.ExecuteReader();
ParticipeOperacion mcorreo = new ParticipeOperacion();
while (reader.Read())
{
mcorreo.Participe = new PersonaDAC().getpersonabyrut(Convert.ToDouble(reader["rut"].ToString()));
mcorreo.Tipo = reader["tipo"].ToString();
}
return(mcorreo);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <ParticipeOperacion> getparticipe(Int32 id_solicitud)
{
try
{
using (SqlConnection sqlConn = new SqlConnection(this.strConn))
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(strConn, sqlConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_r_participe";
cmd.Parameters.AddWithValue("@id_solicitud", id_solicitud);
SqlDataReader reader = cmd.ExecuteReader();
List <ParticipeOperacion> lparticpe = new List <ParticipeOperacion>();
while (reader.Read())
{
ParticipeOperacion mparticipe = new ParticipeOperacion();
mparticipe.Participe = new PersonaDAC().getpersonabyrut(Convert.ToDouble(reader["rut"].ToString()));
mparticipe.Tipo = reader["tipo"].ToString();
lparticpe.Add(mparticipe);
mparticipe = null;
}
return(lparticpe);
}
}
catch (Exception ex)
{
throw ex;
}
}
