private void setBoreholeGeologyTop(BoreholeDTO b)
{
double top = b.Top;
foreach (BoreholeGeologyDTO bg in b.Geologies)
{
bg.Top = top;
top = bg.Base;
}
}
public List <BoreholeDTO> getBoreholeByIds([FromUri] string project, [FromUri] int[] ids)
{
if (ids.Length == 0)
{
List <Borehole> bs = getAllByProject <Borehole>(project);
return(BoreholeDTO.transferList(bs));
}
else
{
List <Borehole> bs = getObjectByIds <Borehole>(project, ids);
return(BoreholeDTO.transferList(bs));
}
}
public BoreholeDTO getBoreholeById(int id)
{
var query = from b in db.Geology_Boreholes
join g in db.Geology_BoreholeStrataInfo on new { c1 = (int?)b.StratumSection, c2 = (int?)b.SectionSequence }
equals new { c1 = (int?)g.StratumSectionID, c2 = (int?)g.SectionSequenceBorhole } into bg
where b.ID == id
select new { Borehole = b, Geologies = bg };
var item = query.FirstOrDefault();
BoreholeDTO res = Mapper.Map <BoreholeDTO>(item.Borehole);
res.Geologies = Mapper.Map <List <BoreholeGeologyDTO> >(item.Geologies);
setBoreholeGeologyTop(res);
return(res);
}
public List <BoreholeDTO> getAllBoreholeByProject()
{
var query = from b in db.Geology_Boreholes
join g in db.Geology_BoreholeStrataInfo on new { c1 = (int?)b.StratumSection, c2 = (int?)b.SectionSequence }
equals new { c1 = (int?)g.StratumSectionID, c2 = (int?)g.SectionSequenceBorhole } into bg
select new { Borehole = b, Geologies = bg };
var tmps = query.ToList();
List <BoreholeDTO> res = new List <BoreholeDTO>();
foreach (var tmp in tmps)
{
BoreholeDTO b = Mapper.Map <BoreholeDTO>(tmp.Borehole);
b.Geologies = Mapper.Map <List <BoreholeGeologyDTO> >(tmp.Geologies);
setBoreholeGeologyTop(b);
res.Add(b);
}
return(res);
}
public List <BoreholeDTO> getAllBoreholeByObjs(string filter)
{
string sql = DGObjectsFilter.GetDGObjectsSQL("Geology_Boreholes", filter);
var result = ((IObjectContextAdapter)db).ObjectContext.ExecuteStoreQuery <Geology_Boreholes>(sql).ToList();
var query = from b in result
join g in db.Geology_BoreholeStrataInfo on new { c1 = (int?)b.StratumSection, c2 = (int?)b.SectionSequence }
equals new { c1 = (int?)g.StratumSectionID, c2 = (int?)g.SectionSequenceBorhole } into bg
select new { Borehole = b, Geologies = bg };
var tmps = query.ToList();
List <BoreholeDTO> res = new List <BoreholeDTO>();
foreach (var tmp in tmps)
{
BoreholeDTO b = Mapper.Map <BoreholeDTO>(tmp.Borehole);
b.Geologies = Mapper.Map <List <BoreholeGeologyDTO> >(tmp.Geologies);
setBoreholeGeologyTop(b);
res.Add(b);
}
return(res);
}
