public static CursoEntity CursoDCConvertirCursoBE(CursoDC oCursoDC) { try { CursoEntity oCursoBE = new CursoEntity(); oCursoBE.CursoId = oCursoDC.CursoId; oCursoBE.CursoNombre = oCursoDC.Nombre; oCursoBE.CursoControl = oCursoDC.CursoControl; oCursoBE.CursoCreditos = oCursoDC.CursoCreditos; oCursoBE.CursoVerificacion = oCursoDC.CursoVerificacion; return oCursoBE; } catch (Exception ex) { throw ex; } }
public List<CursoEntity> ListarCursosPorCarreraPorNivelPorPeriodoActual(int? carreraId, int? nivel) { List<CursoEntity> lista = new List<CursoEntity>(); SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SSIA2013"].ToString()); SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "[SIGERCOV].[ListarCursoXCarreraXNivelXPeriodoActual]"; cmd.CommandType = CommandType.StoredProcedure; CursoEntity item = null; SQLHelper.AddParam(ref cmd, "@CarreraId", ParameterDirection.Input, SqlDbType.Int, carreraId); SQLHelper.AddParam(ref cmd, "@Nivel", ParameterDirection.Input, SqlDbType.Int, nivel); try { cn.Open(); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { item = new CursoEntity(); item.CursoId = dr.GetInt32(dr.GetOrdinal("CursoId")); item.CursoNombre = dr.GetString(dr.GetOrdinal("Nombre")).ToString(); item.CursoControl = Convert.ToBoolean(dr.GetInt32(dr.GetOrdinal("EsControl"))); item.CursoVerificacion = Convert.ToBoolean(dr.GetInt32(dr.GetOrdinal("EsVerificacion"))); item.CursoCreditos = dr.GetInt32(dr.GetOrdinal("Creditos")); 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 List<CursoEntity> ListarCursosPorTipoCursoCarreraId(int? CarreraId, int? TipoCurso) { List<CursoEntity> lista = new List<CursoEntity>(); SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SSIA2013"].ToString()); SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "[SIGERCOV].[uspListarCursosPorTipoCursoCarreraId]"; cmd.CommandType = CommandType.StoredProcedure; CursoEntity item = null; SQLHelper.AddParam(ref cmd, "@CarreraId", ParameterDirection.Input, SqlDbType.Int, CarreraId); SQLHelper.AddParam(ref cmd, "@TipoCurso", ParameterDirection.Input, SqlDbType.Int, TipoCurso); try { cn.Open(); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { item = new CursoEntity(); item.CursoId = dr.GetInt32(dr.GetOrdinal("CursoId")); item.CursoNombre = dr.GetString(dr.GetOrdinal("CursoNombre")).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; }