public bvAuftragsBestand GetBrunvollViewData(string filter, int toSkip, int toTake)
{
System.Data.Objects.ObjectQuery<vwBrunvollAuftragsbestand> p;
if (filter == string.Empty || filter == null)
{
p = db.vwBrunvollAuftragsbestand
.OrderBy("it.created desc");
}
else
{
p = db.vwBrunvollAuftragsbestand
.Where(filter)
.OrderBy("it.created desc");
}
RecordCount = p.Count();
var res = new bvAuftragsBestand(p.Skip(toSkip).Take(toTake), db);
return res;
}
public bvAuftragsBestand GetLikeTest2(string filter, int toSkip, int toTake)
{
//string f = string.Empty;
//StringBuilder sb = new StringBuilder();
//foreach (var e in filter)
//{
// sb.Append("it.");
// sb.Append(e.Key);
// sb.Append(" like ");
// sb.Append("'");
// sb.Append(e.Value);
// sb.Append("'");
// sb.Append(" and ");
//}
//f = sb.ToString();
//if (f.EndsWith(" and "))
// f = f.Remove(f.LastIndexOf(" and "), 5);
System.Data.Objects.ObjectQuery <vwBrunvollAuftragsbestand> p;
if (filter == string.Empty)
{
p = db.vwBrunvollAuftragsbestand
.OrderBy("it.projektnummer desc");
}
else
{
p = db.vwBrunvollAuftragsbestand
.Where(filter)
.OrderBy("it.projektnummer desc");
}
RecordCount = p.Count();
var res = new bvAuftragsBestand(p.Skip(toSkip).Take(toTake), db);
return(res);
}
