public T Single(Expression <Func <T, bool> > predicate) { using (innovaEntities context = new innovaEntities()) { return(context.Set <T>().FirstOrDefault(predicate)); } }
public List <T> Filter(Expression <Func <T, bool> > predicate) { using (innovaEntities context = new innovaEntities()) { return((List <T>)context.Set <T>().Where(predicate).ToList()); } }
public List <T> GetAll() { using (innovaEntities context = new innovaEntities()) { return((List <T>)context.Set <T>().ToList()); } }
public void Delete(T entity) { using (innovaEntities context = new innovaEntities()) { context.Entry(entity).State = EntityState.Deleted; context.SaveChanges(); } }
public void Create(T entity) { using (innovaEntities context = new innovaEntities()) { context.Set <T>().Add(entity); context.SaveChanges(); } }
public void Delete(Expression <Func <T, bool> > predicate) { using (innovaEntities context = new innovaEntities()) { var entities = context.Set <T>().Where(predicate).ToList(); entities.ForEach(x => context.Entry(x).State = EntityState.Deleted); context.SaveChanges(); } }
public List <GrillaSolAdquisicion> lGrillaSolAdquisicion() { List <GrillaSolAdquisicion> lGrilla = new List <GrillaSolAdquisicion>(); using (innovaEntities context = new innovaEntities()) { var query = (from oSol in context.GD_SolAdquisicion join oEmp in context.GD_Empleado on oSol.CodSolicitante equals oEmp.CodEmpleado join oArea in context.GD_Area on oEmp.CodArea equals oArea.CodArea join oEstado in context.GD_Estado on oSol.CodEstado equals oEstado.CodEstado select new { Codigo = oSol.CodSolAdquisicion, CodSolicitante = oSol.CodSolicitante, Solicitante = oEmp.ApePaterno + " " + oEmp.ApeMaterno + " " + oEmp.Nombres, CodArea = oEmp.CodArea, Area = oArea.DescArea, FechaEmision = oSol.FechaEmision, CodEstado = oSol.CodEstado, Estado = oEstado.DescEstado }).ToList(); foreach (var oCampos in query) { GrillaSolAdquisicion oGrilla = new GrillaSolAdquisicion(); oGrilla.Codigo = oCampos.Codigo; oGrilla.CodSolicitante = oCampos.CodSolicitante; oGrilla.Solicitante = oCampos.Solicitante; oGrilla.CodArea = oCampos.CodArea; oGrilla.Area = oCampos.Area; oGrilla.FechaEmision = oCampos.FechaEmision; oGrilla.CodEstado = oCampos.CodEstado; oGrilla.Estado = oCampos.Estado; lGrilla.Add(oGrilla); } } return(lGrilla); }
public List <T> Filter(Expression <Func <T, bool> > predicate, List <Expression <Func <T, object> > > includes) { List <string> includelist = new List <string>(); foreach (var item in includes) { MemberExpression body = item.Body as MemberExpression; if (body == null) { throw new ArgumentException("The body must be a member expression"); } includelist.Add(body.Member.Name); } using (innovaEntities context = new innovaEntities()) { DbQuery <T> query = context.Set <T>(); includelist.ForEach(x => query = query.Include(x)); return((List <T>)query.Where(predicate).ToList()); } }