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); }