public Boolean Guardar(clsAcademico a) { try { using (RecursosHumanosEntities ent = new RecursosHumanosEntities()) { Academico aca = new Academico () { IdAcademico =a.IdAcademico, IdPersona = a.IdPersona, IdTitulo =a.IdTitulo, IdEmpresa = a.IdEmpresa, IdUniversidad =a.IdUniversidad, IdEstado = a.IdEstado, }; ent.AddToAcademico (aca); ent.SaveChanges(); } return true; } catch (Exception) { return false; } }
public List<clsAcademico>ConsultaAcademico() { try { List<clsAcademico> Lista = new List<clsAcademico>(); RecursosHumanosEntities ent = new RecursosHumanosEntities(); var con = from w in ent.Academico select w; foreach (var item in con) { clsAcademico clas = new clsAcademico(); clas .IdAcademico =item .IdAcademico ; clas.IdPersona = item.IdPersona; clas.IdTitulo = item.IdTitulo; clas.IdEmpresa = item.IdEmpresa; clas.IdUniversidad =item.IdUniversidad ; clas.IdEstado = item.IdEstado; Lista.Add(clas); } return Lista; } catch (Exception) { return null; } }
public Boolean Eliminar(clsAcademico acad) { try { using (RecursosHumanosEntities ent = new RecursosHumanosEntities()) { var x = (from q in ent.Academico where q.IdPersona == acad.IdPersona select q).First(); ent.DeleteObject(x); ent.SaveChanges(); } return true; } catch (Exception) { return false; } }
public void Modificar(clsAcademico ac) { using (RecursosHumanosEntities ent = new RecursosHumanosEntities()) { var x = (from q in ent.Academico where q.IdPersona == ac.IdPersona select q).First(); x.IdAcademico = ac.IdAcademico; x.IdPersona = ac.IdPersona; x.IdTitulo =ac.IdTitulo; x.IdEmpresa = ac.IdEmpresa; x.IdUniversidad = ac.IdUniversidad; x.IdEstado = ac.IdEstado; ent.SaveChanges(); } }