/// <summary> /// Pfarre suchen /// </summary> /// <param name="ps"></param> /// <returns></returns> protected Result <ENTITY> GetForGrid <ENTITY>(IQueryable <ENTITY> y, PfarreParams ps) where ENTITY : class, IView_Pfarre { return(base.GetForGrid <IView_Pfarre, ENTITY, PfarreParams>(y, ps, (pfarren) => { if (ps.Query != null) { if (ps.Query.DekanatId != default(int)) { pfarren = pfarren.Where(p => p.DekanatId.Value == ps.Query.DekanatId); } if (!string.IsNullOrWhiteSpace(ps.Query.Query)) { var q = ps.Query.Query.ToUpper(); // Func<IView_Pfarre, bool> qry_test = (p) => p.Pfarrname.ToUpper().Contains(q) || (p.Pfarrnummer.HasValue && p.Pfarrnummer.Value.ToString() == q); pfarren = pfarren.Where(p => p.Pfarrname.ToUpper().Contains(q) || (p.Pfarrnummer.HasValue && p.Pfarrnummer.Value.ToString().Contains(q))); //var pp = pfarren.Where(qry_test); //pfarren = pp.AsQueryable(); } } return pfarren; })); }
public Result <View_Pfarre_Export> GetForGridExport(PfarreParams ps) { var db = new SchulamtEntities(); // Beim Export wollen wir ALLE Seiten exportieren. ps.Count = int.MaxValue; ps.Page = 1; return(GetForGrid <View_Pfarre_Export>(db.View_Pfarre_Export.AsQueryable(), ps)); }
public Result <View_Pfarre> TestGetForGrid(PfarreParams ps) { var db = new SchulamtEntities(); var result = GetForGrid(db.View_Pfarre.AsQueryable <IView_Pfarre>(), ps); var convertedData = result.Data.Cast <View_Pfarre>(); var convertedResult = new Result <View_Pfarre>(ps); convertedResult.SetData(convertedData.AsQueryable()); convertedResult.Total = result.Total; convertedResult.Page = result.Page; convertedResult.OrderBy = result.OrderBy; convertedResult.Desc = result.Desc; convertedResult.Count = result.Count; return(convertedResult); }
public Result <View_Pfarre> GetForGrid(PfarreParams ps) { var db = new SchulamtEntities(); return(GetForGrid(db.View_Pfarre.AsQueryable(), ps)); }