public static PeriodoEntity PeriodoDCConvertirPeriodoBE(PeriodoDC oPeriodoDC)
{
try
{
PeriodoEntity oPeriodoBE = new PeriodoEntity();
oPeriodoBE.PeriodoId = oPeriodoDC.PeriodoId;
oPeriodoBE.PeriodoNombre = oPeriodoDC.Descripcion;
return oPeriodoBE;
}
catch (Exception ex)
{
throw ex;
}
}
public static PeriodoDC PeriodoBEConvertirPeriodoDC(PeriodoEntity oPeriodoBE)
{
try
{
PeriodoDC oPeriodoDC = new PeriodoDC();
oPeriodoDC.PeriodoId = oPeriodoBE.PeriodoId;
oPeriodoDC.Descripcion = oPeriodoBE.PeriodoNombre;
return oPeriodoDC;
}
catch (Exception ex)
{
throw ex;
}
}
public List<PeriodoEntity> ListarPeriodoPorCarreraId(int CarreraId)
{
List<PeriodoEntity> lista = new List<PeriodoEntity>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SSIA2013"].ToString());
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "[SIGERCOV].[uspListarPeriodosXCarreraId]";
cmd.CommandType = CommandType.StoredProcedure;
PeriodoEntity 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 PeriodoEntity();
item.PeriodoId = dr.GetInt32(dr.GetOrdinal("PeriodoId"));
item.PeriodoNombre = dr.GetString(dr.GetOrdinal("PeriodoNombre")).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;
}
public PeriodoEntity ObtenerPeriodoActual()
{
List<PeriodoEntity> lista = new List<PeriodoEntity>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SSIA2013"].ToString());
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "[SIGERCOV].[DevolverPeriodoActual]";
cmd.CommandType = CommandType.StoredProcedure;
PeriodoEntity item = null;
try
{
cn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
item = new PeriodoEntity();
item.PeriodoNombre = dr.GetString(dr.GetOrdinal("DescripcionPeriodo")).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.First();
}