public ElemiMunka()
{
DataSetMirtusz DB = new DataSetMirtusz();
using (DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter ta = new DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter() )
{
ta.FillBy( DB.V_ELEMI_MUNKA_IN_M_LIST, 10);
}
foreach (var item in DB.V_ELEMI_MUNKA_IN_M_LIST.AsQueryable() )
{
;
}
}
public ElemiMunka()
{
DataSetMirtusz DB = new DataSetMirtusz();
using (DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter ta = new DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter())
{
ta.FillBy(DB.V_ELEMI_MUNKA_IN_M_LIST, 10);
}
foreach (var item in DB.V_ELEMI_MUNKA_IN_M_LIST.AsQueryable())
{
;
}
}
public static int GetElemiMunkakCount()
{
return(200);
DataSetMirtusz DB = new DataSetMirtusz();
using (DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter ta = new DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter())
{
ta.FillBy(DB.V_ELEMI_MUNKA_IN_M_LIST, 10000 + 1);
}
return(DB.V_ELEMI_MUNKA_IN_M_LIST.Count());
}
public static IQueryable <ElemiMunka> GetElemiMunkak(int skip, int take)
{
DataSetMirtusz DB = new DataSetMirtusz();
using (DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter ta = new DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter())
{
ta.FillBy(DB.V_ELEMI_MUNKA_IN_M_LIST, 200 + 1);
}
var page = DB.V_ELEMI_MUNKA_IN_M_LIST.OrderBy(em => em.AZONOSITO).Skip(skip).Take(take);
return(page.Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG = dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
}
).AsQueryable());
}
public static int GetElemiMunkakCount()
{
return 200;
DataSetMirtusz DB = new DataSetMirtusz();
using (DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter ta = new DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter())
{
ta.FillBy(DB.V_ELEMI_MUNKA_IN_M_LIST, 10000 + 1);
}
return DB.V_ELEMI_MUNKA_IN_M_LIST.Count();
}
public static IQueryable<ElemiMunka> GetElemiMunkak( int skip, int take )
{
DataSetMirtusz DB = new DataSetMirtusz();
using (DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter ta = new DataSetMirtuszTableAdapters.V_ELEMI_MUNKA_IN_M_LISTTableAdapter())
{
ta.FillBy(DB.V_ELEMI_MUNKA_IN_M_LIST, 200+1);
}
var page = DB.V_ELEMI_MUNKA_IN_M_LIST.OrderBy(em => em.AZONOSITO).Skip(skip).Take(take);
return page.Select(dbe => new ElemiMunka()
{
AZONOSITO = dbe.AZONOSITO,
CIM = dbe.CIM,
MAIN = dbe.MAIN,
KESZULTSEG =dbe.KESZULTSEG,
PRIORITAS = dbe.PRIORITAS
}
).AsQueryable();
}
