public static bool RegistrarCurriculaBase(CurriculaBase Base) { using (var cn = new InnovaEntities()) { try { if (Base.IdCurriculaBase > 0) { var baseEdit = cn.CurriculaBase.FirstOrDefault(b => b.IdCurriculaBase == Base.IdCurriculaBase); if (baseEdit != null) { baseEdit.Año = Base.Año; baseEdit.NumeroResolucion = Base.NumeroResolucion; baseEdit.Descripcion = Base.Descripcion; baseEdit.Vigencia = Base.Vigencia; cn.SaveChanges(); } } else { cn.CurriculaBase.Add(Base); cn.SaveChanges(); } return(true); } catch (Exception) { return(false); } } }
public static bool RegistrarPlanByIdGrado(int idCurriculaBase, int idAreaCurricular, int IdGrado, decimal Horas) { using (var cn = new InnovaEntities()) { try { var PlanEdit = (from c in cn.PlanEstudiosBase where c.IdCurriculaBase == idCurriculaBase && c.IdAreaCurricular == idAreaCurricular && c.IdGrado == IdGrado select c).FirstOrDefault(); if (PlanEdit != null) { PlanEdit.Horas = Horas; cn.SaveChanges(); } else { cn.PlanEstudiosBase.Add(new PlanEstudiosBase { IdCurriculaBase = idCurriculaBase, IdAreaCurricular = idAreaCurricular, IdGrado = IdGrado, Horas = Horas }); cn.SaveChanges(); } return(true); } catch (Exception) { return(false); } } }
public static bool RegistrarCurriculaBase(CurriculaBase Base) { using (var cn = new InnovaEntities()) { try { if (Base.IdCurriculaBase > 0) { var baseEdit = cn.CurriculaBase.FirstOrDefault(b => b.IdCurriculaBase == Base.IdCurriculaBase); if (baseEdit != null) { baseEdit.Año = Base.Año; baseEdit.NumeroResolucion = Base.NumeroResolucion; baseEdit.Descripcion = Base.Descripcion; if (Convert.ToBoolean(Base.Vigencia)) { cn.CurriculaBase.ToList().ForEach(s => s.Vigencia = false); baseEdit.Vigencia = Base.Vigencia; } else { baseEdit.Vigencia = Base.Vigencia; } cn.SaveChanges(); } } else { // se valida que una resolución no se registre dos veces. var baseEdit = cn.CurriculaBase.FirstOrDefault(b => b.NumeroResolucion.Trim() == Base.NumeroResolucion.Trim()); if (baseEdit != null) { return(false); } else { if (Convert.ToBoolean(Base.Vigencia)) { cn.CurriculaBase.ToList().ForEach(s => s.Vigencia = false); } cn.CurriculaBase.Add(Base); cn.SaveChanges(); } } return(true); } catch (Exception) { return(false); } } }
public static bool RegistrarCompetenciaArea(CurriculaBaseCompetencia BaseCompetencia) { using (var cn = new InnovaEntities()) { try { var ragistroValidacion = cn.CurriculaBaseCompetencia.FirstOrDefault( c => c.IdAreaCurricular == BaseCompetencia.IdAreaCurricular && c.IdCompetencia == BaseCompetencia.IdCompetencia && c.IdCurriculaBase == BaseCompetencia.IdCurriculaBase); if (ragistroValidacion != null) { return(false); } else { cn.CurriculaBaseCompetencia.Add(BaseCompetencia); cn.SaveChanges(); return(true); } } catch (Exception) { return(false); } } }
public static bool RegistrarCompetenciaArea(CurriculaBaseCompetencia BaseCompetencia) { using (var cn = new InnovaEntities()) { try { cn.CurriculaBaseCompetencia.Add(BaseCompetencia); cn.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public static bool EliminarCompetenciaCapadidadArea(int idCurriculaBaseCompetencia) { using (var cn = new InnovaEntities()) { try { var baseCompetencia = cn.CurriculaBaseCompetencia.FirstOrDefault(c => c.IdCurriculaBaseCompetencia == idCurriculaBaseCompetencia); if (baseCompetencia != null) { cn.CurriculaBaseCompetencia.Remove(baseCompetencia); cn.SaveChanges(); } return(true); } catch (Exception) { return(false); } } }