How to fetch Min key in Linq var datatype?

Question

0.00/5 (No votes)

See more:

I have declared following dictionary-

C#

 Dictionary<DateTime, List<Employee>> dictSource = new Dictionary<DateTime, List<Employee>>
{
{ DateTime.Now.AddDays(1), new List<Employee> { 1, "Programmers" }},
{ DateTime.Now.AddDays(3), new List<Employee> { 90, "Testers" }},
{ DateTime.Now.AddDays(2), new List<Employee> { 1, "Designers" }},
};

Then , I am extracting the records having minimum value of element at zero postion.

C#

int MinValue = dictSource.Min(pair => pair.Value.ElementAt(0));
var filteredresults = dictSource.Where(pair => pair.Value.ElementAt(0) == MinValue);

Above code returns 2 items-
1, "Programmers"
1, "Designers"

Question, I need to drill the 'filteredresults' collection so that it returns item with minimum date. So, I should get the '1, "Programmers"' as final value.

I have tried following but failing-

C#

filteredresults = filteredresults.ToDictionary(s => s.Key, s.Value);

Please help here?

Posted 14-Jun-15 20:44pm

Member 11765988

Add a Solution

Comments

Tomas Takac 15-Jun-15 3:23am

I'm confused. You have list of employees and you are inserting integers and strings there. Shouldn't these be properties of the Employee object instead?

2 solutions

Solution 1

Please check the below code :-

C#

Dictionary<datetime,>> dictSource = new Dictionary<datetime,>> 
{ 
    { DateTime.Now.AddDays(1), new List<employee>{ new Employee{ EmpID= 1, Designation= "Programmers" } }},
    { DateTime.Now.AddDays(3), new List<employee>{ new Employee{ EmpID= 90, Designation= "Testers" } }},
    { DateTime.Now.AddDays(2), new List<employee>{ new Employee{ EmpID= 1, Designation= "Designers" } }} 
};

int MinValue = dictSource.Min(Pair=>Pair.Value.ElementAt(0).EmpID);
DateTime Mindt= dictSource.Min(Pair => Pair.Key);


var filteredresults = dictSource.Where(Pair => Pair.Value.ElementAt(0).EmpID  == MinValue);
         

Response.Write(" Min Value = " + MinValue);
 

Response.Write("<br>" + "<br>" + " Filtered list having min value :-  ");


foreach (var item in filteredresults)
{ 
    Response.Write("<br>" + " Designation at MinValue= " + item.Value.ElementAt(0).Designation);
}

filteredresults = dictSource.Where(Pair => Pair.Key == Mindt);
         
Response.Write("<br>" + "<br>" + " Min Date = " + Mindt);


Response.Write("<br>" + "<br>" + " Filtered list having min date :-  ");

foreach (var item in filteredresults)
{
    Response.Write("<br>" + " Date at Min Date = " + item.Value.ElementAt(0).Designation );
}

Posted 15-Jun-15 0:54am

psima

Updated 15-Jun-15 0:55am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 11765988 · Accepted Answer · 2015-06-15T18:03:00

I have found the solution. It is-

C#

int MinValue = dictSource.Min(pair =&gt; pair.Value.ElementAt(0));
var filteredresults = dictSource.Where(pair =&gt; pair.Value.ElementAt(0) == MinValue);

filteredresults = filteredresults.OrderBy(p =&amp;gt; p.Key);
var finalResult = filteredresults.First();
lstvalueGet = finalResult.Value;