public static OutcomeDC OutcomeBEConvertirOutcomeDC(OutcomeEntity oOutcomeBE)
{
try
{
OutcomeDC oOutcomeDC = new OutcomeDC();
oOutcomeDC.OutcomeId = oOutcomeBE.OutcomeId;
oOutcomeDC.OutcomeNombre = oOutcomeBE.OutcomeNombre;
oOutcomeDC.OutcomeDescripcion = oOutcomeBE.OutcomeDescripcion;
return oOutcomeDC;
}
catch (Exception ex)
{
throw ex;
}
}
public static OutcomeEntity OutcomeDCConvertirOutcomeBE(OutcomeDC oOutcomeDC)
{
try
{
OutcomeEntity oOutcomeBE = new OutcomeEntity();
oOutcomeBE.OutcomeId = oOutcomeDC.OutcomeId;
oOutcomeBE.OutcomeNombre = oOutcomeDC.OutcomeNombre;
return oOutcomeBE;
}
catch (Exception ex)
{
throw ex;
}
}
public List<OutcomeEntity> ListarOutcomePorCarreraId(int CarreraId)
{
List<OutcomeEntity> lista = new List<OutcomeEntity>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SSIA2013"].ToString());
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "[SIGERCOV].[uspListarOutcomePorCarreraId]";
cmd.CommandType = CommandType.StoredProcedure;
OutcomeEntity item = null;
SQLHelper.AddParam(ref cmd, "@CarreraId", ParameterDirection.Input, SqlDbType.Int, CarreraId);
try
{
cn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
item = new OutcomeEntity();
item.OutcomeId = dr.GetInt32(dr.GetOrdinal("OutcomeId"));
item.OutcomeNombre = dr.GetString(dr.GetOrdinal("OutcomeNombre")).ToString();
item.OutcomeDescripcion = dr.GetString(dr.GetOrdinal("OutcomeDescripcion")).ToString();
lista.Add(item);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
cn.Dispose();
cmd.Dispose();
cn = null;
cmd = null;
}
return lista;
}