public static IEnumerable GetStatusTable()
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
return mirtuszDC.KOMUNKASTATUSZs.ToList();
}
}
private object GetData()
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
return mirtuszDC.VELEMIMUNKAINMLISTs.AsQueryable();
}
}
public static IEnumerable GetCustomers()
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
return mirtuszDC.VELEMIMUNKAINMLISTs.Take(1000).ToArray();
}
//return from customer in DB.Customers select customer;
}
public static IEnumerable<VELEMIMUNKAINMLIST> GetPage(ODataQueryOptions<VELEMIMUNKAINMLIST> queryOptions)
{
using (MIRTUSZContext.MIRTUSZDataContext mirtuszDC = new MIRTUSZContext.MIRTUSZDataContext())
{
mirtuszDC.Connection.Open();
if (queryOptions.Filter != null)
{
return (IEnumerable<VELEMIMUNKAINMLIST>)queryOptions.ApplyTo(mirtuszDC.VELEMIMUNKAINMLIST).GetEnumerator();
//db.TimelineItems.Where(tl => tl.ProductID == SelectedPID).Select(tl => new TimelineItem { Description = tl.Description, Title = tl.Title }).AsEnumerable<TimelineItem>();
}
return mirtuszDC.VELEMIMUNKAINMLIST.Skip(queryOptions.Skip == null ? 0 : queryOptions.Skip.Value).Take(queryOptions.Top.Value).Select(dbe => new VELEMIMUNKAINMLIST()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
});
//return a;
}
}
