How do I group by to get certain results from a list

Question

1.00/5 (1 vote)

See more:

Let's say i have this

Id    Day      Time
1     Sun   8am to 4pm
1     Sun   5pm to 9pm
1     Mon   8m  to 6pm
1     Tue   8m  to 6pm
2     Sun   8am to 4pm
2     Mon   8am to 4pm

I want to make an api response in .net framework ,the expected result is this when i choose id=1

{
"Tables": [
 {
"hours":							
[
{
 "days": "Sun"
  "time": [
              "8am to 4pm",
              "5pm to 9pm"
           ]
}
{
  "day": Mon - Tue
  "time":[ 8am to 6pm]
}
{
 "day": "wednesday-sat" 
  "time": [
		closed
         ]
}	
]
}
]
}

What I have tried:

I have this TableList class:

public class TableList  //api response class
{
    public List<Table> Table { get; set; }
}

and this is the table class

public class Table  //api response class
{
    public List<Hours> hours { get; set; }
    public Table (List<Hours> _hours)
    {
      this.hours = _hours;
    }
}

public class Hours      //api response class
{
    public string days { get; set; }
    public <string> time { get; set; }

    public Hours(string days, <string> time)
    {
        this.days = days;
        this.time = time;
    }
}

TableList tableList = new TableList ();

TableList.Table= new List<Table>();

List<TableValue> tableValue= service.getTime(1);  //table value has the data from SQL

foreach (TableValues tv in tableValues) //Tablevalues has the values of the record
{
     List<string> hourtime= new List<string>
     {
                        new string(tv.hours.ToCharArray())
     };
 List<Hours> hours = new List<Hours>
 {
    new Hours(tv.days, hourtime)
  };
  TableList.Table.Add(new Table(hours))
}

But what i'm currently getting is

{
"Tables": [
 {
"hours":							
[
{
 "days": "Sun"
  "time": 
              ["8am to 4pm"]
      
}
] 
}, 
{
"hours":							
[
{
 "days": "Sun"
  "time": 
              ["5pm to 9pm"]
}
] 
}, 
{
"hours":							
[
{
  "day": Mon
  "time": [8am to 6pm]
}
] 
}, 
{
"hours":							
[
{
  "day": Tue
  "time":[ 8am to 6pm]
}
] 
} 

]
}

i want to get the Hours Id=1 once and inside it are the days and timing. I don't want new array for each new timing of the same Id. I also don't want sunday to come in two records. Also want if more than one day has the same time then there is no need to show in new array i want it like the expected result i showed u above above. and i want to implement "closed" as well

Posted 15-Apr-20 4:18am

Member 14800672

Updated 15-Apr-20 21:46pm

v9

Add a Solution

2 solutions

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)

F-ES Sitecore · Answer 1 · 2020-04-15T04:44:00

I'll assume the numerous typos in the code you posted that will stop it from compiling are not the issue.

What you need to do is check if the day already exists and if so add the time to it and if not add it with a single time

C#

foreach (TableValue tv in tableValue)
{
    // see if the day already exists in the collection
    Hours existingDay = tableList.Table.Count == 0 ? null : tableList.Table.First().hours.FirstOrDefault(h => h.days == tv.days);

    // if not we'll add it
    if (existingDay == null)
    {
        List<Hours> hours = new List<Hours>
        {
            new Hours(tv.days, new List<string>{tv.time })
        };

        tableList.Table.Add(new Table(hours));
    }
    else
    {
        // the day already exists so we just need to add the time
        existingDay.time.Add(tv.time);
    }
}

Maciej Los · Answer 2 · 2020-04-15T21:46:00

It's impossible to achieve json you expected due to tons of reason...

1.
The most important is that, that the input data does not contain corresponding values for such of output:

"day": "wednesday-sat" 
  "time": [
		closed
         ]

2.
In your project classes are badly designed, becuase they don't match to your json structure.

Take a look at here: Instantly parse JSON in any language | quicktype[^] to find out how your json string should look like and how to prepare corresponding classes.
Note: there you'll find only the part of your job. Feel free to improve that.

How do I group by to get certain results from a list

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0