private static List <SZAservice> _getActZirSarfasls(DbAtiran2Entities context,
Expression <Func <act_zirsarfasls, bool> > where = null)
{
IQueryable <act_zirsarfasls> result = context.Set <act_zirsarfasls>().AsNoTracking();
if (where != null)
{
result = result.Where(where);
}
//var x = (from read in context.act_zirsarfasls
// select new
// {
// ALi=read.zirsarfasls.sarfasls.rdf,
// }).ToList();
int Row = 2;
return(result.ToList().OrderBy(r => r.date).Select(a => new SZAservice()
{
Arow = Row++,
AID = a.rdf,
AZirSarfaslID = a.rdf_zirsarfasls,
Adate = a.date,
Abed = a.bed,
Abes = a.bes,
Abed_bes = (a.bed - a.bes) > 0?"بد": (a.bed - a.bes) == 0?"--":"بس",
Adescription = a.dis,
Akind = a.kind,
AkindName = KindName.FirstOrDefault(k => k.Key == a.kind).Value,
Asanadno = a.sanadno,
Auser = a.user
}).ToList());
}
private static List <SarfaslService> _getSarfaslses(DbAtiran2Entities context,
Expression <Func <sarfasls, bool> > where = null)
{
IQueryable <sarfasls> result = context.Set <sarfasls>().AsNoTracking();
if (where != null)
{
result = result.Where(where);
}
int Row = 1;
return(result.ToList().Select(s => new SarfaslService()
{
row = Row++,
ID = s.rdf,
GroupSarfaslID = s.GroupSarfaslID,
Name = s.name
}).ToList());
}
private static List <GroupSarfaslServes> _getGroupSarfaslses(DbAtiran2Entities context,
Expression <Func <GroupSarfasl, bool> > where = null)
{
IQueryable <GroupSarfasl> result = context.Set <GroupSarfasl>().AsNoTracking();
if (where != null)
{
result = result.Where(where);
}
int Row = 1;
return(result.ToList().Select(g => new GroupSarfaslServes()
{
row = Row++,
ID = g.GroupSarfaslID,
Name = g.GroupSarfaslName,
Active = g.Active
}).ToList());
}
private static List <ZirSarfaslService> _getZirSarfasls(DbAtiran2Entities context,
Expression <Func <zirsarfasls, bool> > where = null)
{
IQueryable <zirsarfasls> result = context.Set <zirsarfasls>().AsNoTracking();
if (where != null)
{
result = result.Where(where);
}
int Row = 1;
return(result.ToList().Select(z => new ZirSarfaslService()
{
row = Row++,
ID = z.rdf,
SarfaslID = z.rdf_sarfasl,
Name = z.name,
has_dar = z.has_dar,
Active = z.Active
}).ToList());
}
