Guest User

Untitled

a guest
Dec 15th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. List<WorkerMove> Rank = new List<WorkerMove>();
  2. var idRank = (from rank1 in context.Worker select rank1.codeWorker);
  3.  
  4. foreach (var read in idRank)
  5. {
  6. WorkerMove Rank3 = (from rank2 in context.WorkerMove
  7. where rank2.idWorker == read
  8. select rank2).FirstOrDefault();
  9.  
  10. if(Rank3 != null) Rank.Add(Rank3);
  11. }
  12.  
  13. var workerSurname = from worker in context.Worker
  14. join workMove in Rank on worker.codeWorker equals workMove.idWorker
  15. join workRank in context.Dol on workMove.idRank equals workRank.idDol
  16. select new
  17. {
  18. codeWork = worker.codeWorker,
  19. Fio = worker.Family+ " " + worker.Name.Remove(1) + "." + worker.Otch.Remove(1) + ".",
  20. Dol = workRank.Dol,
  21. };
Add Comment
Please, Sign In to add comment