public DataTable GetAllKarGList()
{
List <KarG> result = new List <KarG>();
using (hadafDBEntities DC = conn.GetContext())
{
IEnumerable <KarG> pl =
from r in DC.KarGs
orderby r.id
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}
public DataTable Getstatus()
{
List <enter> result = new List <enter>();
using (hadafDBEntities DC = conn.GetContext())
{
IEnumerable <enter> pl =
from r in DC.enters
where r.Status == 0
orderby r.id
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}
public DataTable GetStdList(string reshte)
{
List <Student> result = new List <Student>();
using (hadafDBEntities pb = conn.GetContext())
{
IEnumerable <Student> pl =
from r in pb.Students
where
r.Reshte == reshte
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}
public DataTable GetLinkUrl(Int64 StdID)
{
List <Counter> result = new List <Counter>();
using (hadafDBEntities pb = conn.GetContext())
{
IEnumerable <Counter> pl =
from r in pb.Counters
where
r.stdid == StdID
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}