rssreport = _service.GetRouteSectorStatusByNewRoute_Id(route).Where(x => x.RouteSectorStatusDate == dt).ToList(); foreach (var rssr in rssreport) { var emp = _service.GetAllEmployee().Where(x => x.Id == rssr.Employee_Id).FirstOrDefault(); dataset.RouteStw.Rows.Add( rssr.RouteSectorName, emp.Name, emp.Id, emp.CellNo, rssr.SectorName ); var rtpnt = _service.GetRoutePointStatusByNewRoute_Id(route).Where(x => x.RouteSector_Id == rssr.RouteSector_Id && x.Date == dt && x.NewRoute_Id==route).ToList(); foreach (var rps in rtpnt) { var emp1 = _service.GetAllEmployee().Where(x => x.Id == rps.Employee_Id).FirstOrDefault(); dataset.RoutePoint.Rows.Add( rps.AddRoutePointName, emp1.Name, emp1.Id, emp1.CellNo, rps.SectorName ); } }
RSname empid cellNo sector sss 12 mmm dd fff 13 mmm ff eee 14 mmm gg AND Point pntName empid cellno sector www 43 vvv 1 wer 22 rrr 1 ttt 12 ggg 1
RSname empid cellNo sector sss 12 mmm dd pntName empid cellno sector www 43 vvv 1 wer 22 rrr 1 ttt 12 ggg 1