public static IEnumerable <ElemiMunka> GetPage(ODataQueryOptions <ElemiMunka> queryOptions)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
if (queryOptions.Filter != null)
{
var micsoda = mirtuszDC.VELEMIMUNKAINMLISTs.Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
});
var a = queryOptions.ApplyTo(micsoda);
}
return(mirtuszDC.VELEMIMUNKAINMLISTs.Skip(queryOptions.Skip == null ? 0 : queryOptions.Skip.Value).Take(queryOptions.Top.Value).Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
}).ToArray());
}
}
internal static IEnumerable<VELEMIMUNKAINMLIST> GetDbPage(ODataQueryOptions<VELEMIMUNKAINMLIST> queryOptions)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
if (queryOptions.Filter != null)
{
IQueryable query = queryOptions.ApplyTo(mirtuszDC.VELEMIMUNKAINMLISTs);
var a = query.Provider.Execute< IEnumerable<VELEMIMUNKAINMLIST>>(query.Expression);
return a.ToArray();
// return a.Skip(queryOptions.Skip == null ? 0 : queryOptions.Skip.Value).Take(queryOptions.Top.Value).ToArray();
}
return mirtuszDC.VELEMIMUNKAINMLISTs.Skip(queryOptions.Skip == null ? 0 : queryOptions.Skip.Value).Take(queryOptions.Top.Value).ToArray();
}
}
internal static IEnumerable <VELEMIMUNKAINMLIST> GetDbPage(ODataQueryOptions <VELEMIMUNKAINMLIST> queryOptions)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
if (queryOptions.Filter != null)
{
IQueryable query = queryOptions.ApplyTo(mirtuszDC.VELEMIMUNKAINMLISTs);
var a = query.Provider.Execute <IEnumerable <VELEMIMUNKAINMLIST> >(query.Expression);
return(a.ToArray());
// return a.Skip(queryOptions.Skip == null ? 0 : queryOptions.Skip.Value).Take(queryOptions.Top.Value).ToArray();
}
return(mirtuszDC.VELEMIMUNKAINMLISTs.Skip(queryOptions.Skip == null ? 0 : queryOptions.Skip.Value).Take(queryOptions.Top.Value).ToArray());
}
}
internal static IEnumerable <ElemiMunka> GetPage(int skip, int top)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
return(mirtuszDC.VELEMIMUNKAINMLISTs.Skip(skip).Take(top).Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
}).ToArray());
}
}
internal static int GetCount(ODataQueryOptions<VELEMIMUNKAINMLIST> queryOptions)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
if (queryOptions.Filter != null)
{
ODataQuerySettings settings = new ODataQuerySettings()
{
PageSize = 1000000
};
IQueryable query = queryOptions.ApplyTo(mirtuszDC.VELEMIMUNKAINMLISTs, settings);
return query.Cast<VELEMIMUNKAINMLIST>().Count();
}
return mirtuszDC.VELEMIMUNKAINMLISTs.Count();
}
}
internal static int GetCount(ODataQueryOptions <VELEMIMUNKAINMLIST> queryOptions)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
if (queryOptions.Filter != null)
{
ODataQuerySettings settings = new ODataQuerySettings()
{
PageSize = 1000000
};
IQueryable query = queryOptions.ApplyTo(mirtuszDC.VELEMIMUNKAINMLISTs, settings);
return(query.Cast <VELEMIMUNKAINMLIST>().Count());
}
return(mirtuszDC.VELEMIMUNKAINMLISTs.Count());
}
}
internal static IEnumerable<ElemiMunka> GetPage(int skip, int top)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
return mirtuszDC.VELEMIMUNKAINMLISTs.Skip(skip).Take(top).Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
}).ToArray();
}
}
public static IEnumerable<ElemiMunka> GetPage(ODataQueryOptions<ElemiMunka> queryOptions)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
if (queryOptions.Filter != null)
{
var micsoda = mirtuszDC.VELEMIMUNKAINMLISTs.Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
});
var a = queryOptions.ApplyTo(micsoda);
}
return mirtuszDC.VELEMIMUNKAINMLISTs.Skip(queryOptions.Skip == null ? 0 : queryOptions.Skip.Value).Take(queryOptions.Top.Value).Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
}).ToArray();
}
}