/// <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));
}
