public MonGroupDTO getMonGroupById(int id)
{
var query = from mg in db.Monitoring_MonGroupInfo
join mp in db.Monitoring_MonPointInfo on mg.ID equals mp.MonGroupID into mps
where mg.ID == id
select new { grp = mg, ptn = mps };
var item = query.FirstOrDefault();
MonGroupDTO res = Mapper.Map <MonGroupDTO>(item.grp);
res.MonPoints = Mapper.Map <List <MonPointDTO> >(item.ptn);
return(res);
}
public MonProjectDTO getMonProjectById(int id)
{
var query = from mpp in db.Monitoring_MonProjectInfo
join mg in db.Monitoring_MonGroupInfo on mpp.ID equals mg.MonProjectID
join mp in db.Monitoring_MonPointInfo on mg.ID equals mp.MonGroupID into mps
where mpp.ID == id
select new { prj = mpp, grp = mg, ptn = mps };
var item = query.ToList();
if (item.Count == 0)
{
return(null);
}
MonProjectDTO res = Mapper.Map <MonProjectDTO>(item[0].prj);
res.MonGroups = new List <MonGroupDTO>();
foreach (var tmp in item)
{
MonGroupDTO mg = Mapper.Map <MonGroupDTO>(tmp.grp);
mg.MonPoints = Mapper.Map <List <MonPointDTO> >(tmp.ptn);
res.MonGroups.Add(mg);
}
return(res);
}