7. Find Employees in Period - [несъответствие на отговор-а с условието]

tiapko 31 Точки

7. Find Employees in Period - [несъответствие на отговор-а с условието]

Здравейте,

В условието на задача: 7. Find Employees in Period (Find the first 30 employees who have projects started in the time period 2001 - 2003 (inclusive).) и резултатите, които джъдж-а приема има някъкво несъответствие. Неразбиране на условието или неправилен тест е причината?

P.S. (не намерих друг начин за репорт на проблеми с задача в judje)

Guy Gilbert Jo
--Half-Finger Gloves 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Racing Socks 11/22/2005 12:00:00 AM
--Women's Tights 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Road Bottle Cage 2/21/2004 12:00:00 AM
Roberto Tamburello Terri
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--HL Road Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Rob Walters Roberto
--Road-150 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Pedal 5/16/2005 4:34:00 PM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Thierry D'Hers Ovidiu
--Road-350-W 6/1/2003 12:00:00 AM
--Road-350 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Mountain Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
JoLynn Dobney Peter
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Ruth Ellerbrock Andrew
--Cycling Cap 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400-W 2/22/2006 12:00:00 AM
--Touring-3000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Water Bottle 6/1/2003 12:00:00 AM
Gail Erickson Roberto
--LL Road Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Hitch Rack - 4-Bike 6/1/2003 12:00:00 AM
Barry Johnson Andrew
--Full-Finger Gloves 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-500 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Women's Mountain Shorts 6/1/2003 12:00:00 AM
--Mountain Bottle Cage 6/1/2003 12:00:00 AM
Jossef Goldberg Roberto
--LL Touring Frame 5/16/2005 4:34:00 PM
--Touring Pedal 5/16/2005 4:34:00 PM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Bike Wash 8/1/2005 12:00:00 AM
Terri Duffy Ken
--Road-450 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Front Wheel 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--LL Road Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Sidney Higa Andrew
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Touring Handlebars 5/16/2005 4:34:00 PM
--Rear Derailleur 6/1/2003 12:00:00 AM
Taylor Maxwell Peter
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
Jeffrey Ford Andrew
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-2000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Jo Brown Peter
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Dual-Beam 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Rear Derailleur 6/1/2003 12:00:00 AM
Doris Hartwig Andrew
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Dual-Beam 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Rear Derailleur 6/1/2003 12:00:00 AM
John Campbell Peter
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-2000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Diane Glimp Andrew
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Steven Selikoff Michael
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
Peter Krebs James
--LL Touring Frame 5/16/2005 4:34:00 PM
--Road-650 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Bike Wash 8/1/2005 12:00:00 AM
Stuart Munson Lori
--LL Mountain Frame 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Road-450 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Front Wheel 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Mountain Pump 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Greg Alderson Lori
--LL Road Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-550-W 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Rear Wheel 5/16/2005 4:34:00 PM
--Hitch Rack - 4-Bike 6/1/2003 12:00:00 AM
David Johnson Jack
--LL Touring Frame 5/16/2005 4:34:00 PM
--Road-650 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Front Wheel 5/16/2005 4:34:00 PM
--Bike Wash 8/1/2005 12:00:00 AM
Zheng Mu Peter
--Long-Sleeve Logo Jersey 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-750 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-Panniers 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Ivo Salmre Eric
--HL Mountain Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-150 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Patch kit 6/1/2003 12:00:00 AM
Paul Komosinski David
--Road-250 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-550 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Cable Lock 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Kendall Keil Taylor
--HL Touring Frame 5/16/2005 4:34:00 PM
--Road-350-W 6/1/2003 12:00:00 AM
--Road-350 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Minipump 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Paula Barreto de Mattos Laura
--Road-250 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--HL Road Rear Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Cable Lock 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Alejandro McGuel Brenda
--Long-Sleeve Logo Jersey 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-750 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--ML Mountain Front Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-Panniers 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Garrett Young Jack
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--HL Mountain Front Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Jian Shuo Wang Cynthia
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Touring Handlebars 5/16/2005 4:34:00 PM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM

Тагове:

24/02/2017 19:24:51 Databases Advanced - Entity Framework

Maria_ls 383 Точки

Best Answer

Здравей, в условието се казва да намерим първите 30 човека, които имат проекти започващи в дадения период и за всеки от тях да извадим всички проекти, които има. Но за тях вече няма ограничение. А и ограничението е в StartDate, не в EndDate

Find the first 30 employees who have projects started in the time period 2001 - 2003 (inclusive). Print each employee's first name, last name and manager’s first name and each of their projects' name, start date, end date.

27/02/2017 20:18:07

tiapko 31 Точки

Да, така се връзва отговора, но малко логиката, на подобна заявка не ми се връзва :)

27/02/2017 21:25:55

Maria_ls 383 Точки

На тоя дето е мислил задачата явно му се вързва, все пак целта е да измислим заявка, която да се вързва с описанието, а не да търсим логиката в нея или що така са го измислили

27/02/2017 22:00:53

sktomov 49 Точки

Здравей,

Повечето проекти нямат крайна дата - NULL, затова принтира само началната дата на проекта.

Поздрави

27/02/2017 20:03:42

tiapko 31 Точки

Критерия за показване е StartDate, това че няма крайна дата, не означава, че проект, който е започнал извън заложения интервал трябва да се показва. Това е моята логика.

27/02/2017 21:23:17

kdamyanov 1 Точки

Здравейте,

може ли някой да сподели решението на задачата.

02/03/2017 19:15:14

tiapko 31 Точки

https://github.com/tiapko/Introduction-to-Entity-Framework/blob/master/IntroductiontoEntityFramework/07.%20Find%20Employees%20in%20Period.cs

02/03/2017 20:20:29

DDaskalov 10 Точки

Решението е супер. кратко и много ясно. Много ми помогна, за да схвана логиката...

04/03/2017 23:08:03

MartinRusanov 95 Точки

Защо не не ми тръгва решението на задачата която tiapko https://github.com/tiapko/Introduction-to-Entity-Framework/blob/master/IntroductiontoEntityFramework/07.%20Find%20Employees%20in%20Period.cs ми дава грешки при pp.Name и pp.StartDate и EndDate?

13/03/2017 23:30:28

MartinRusanov 95 Точки

Даже няма Manager name. Какво in the name of God става тук. Нали използвате SoftUni база данни??

14/03/2017 02:15:31

tiapko 31 Точки

При създаване на модел от вече готова база при self reference (референция към същата таблица) EF ги кръщава по някаква негова си логика, аз съм прекръстил полето(както и навигационното) като "public virtual Employee Manager { get; set; }", като най-вероятно твоето поле се казва "public virtual Employee Employee1 { get; set; }".

Виж моделът, който е използван и прецени дали да промениш твоя модел или да използваш този:

https://github.com/tiapko/Introduction-to-Entity-Framework/blob/master/IntroductiontoEntityFramework/Models/Softuni/Employee.cs

а тук са всички модели:

https://github.com/tiapko/Introduction-to-Entity-Framework/tree/master/IntroductiontoEntityFramework/Models/Softuni

14/03/2017 12:53:29 14/03/2017 12:54:13