Update the list object using linq

rahul ahuj

12y2.3kLINQ

I have list of object's and i want to update the the object's Break property where breakflag=1 with its next and previous record.

class EmployeeHour

{

int recordID{get;set;}

string Break{get;set;}

DateTime TimeIn {get;set;}

DateTime TimeOut {get;set;}

int BreakFlag{get;set;}

}

List listEH=(from item in employeeHoursList

where item.BreakFlag==1

select item).Foreach(itme=>item.Break=(employeeHoursList[i].Timeout-employeeHoursList[i].TimeIn).ToString()).ToList();

So here i just want set the break property with the Time diff. between TimeIn and TimeOut only for those objcet whoes breakflag is one. and TimeOut of that object where BeakFlag ==1 and TimeIn next to that object in the list.

Thanks

Rahul.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
OK, I'm clear now what's wanted :)

Here's some code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;

class EmployeeHour
{
public int recordID{get;set;}
public string Break{get;set;}
public DateTime TimeIn {get;set;}
public DateTime TimeOut {get;set;}
public int BreakFlag{get;set;}

public EmployeeHour(int id, string timeIn, string timeOut, int flag)
{
recordID = id;
string f = "yyyy/MM/dd H:mm:ss:ff";
TimeIn = DateTime.ParseExact(timeIn, f, null);
TimeOut = DateTime.ParseExact(timeOut, f, null);
BreakFlag = flag;
}

public override string ToString()
{
string f = "yyyy/MM/dd H:mm:ss:ff";
return String.Format("{0,8} | {1,-22}| {2,-22}| {3, -9}| {4}", recordID, TimeIn.ToString(f), TimeOut.ToString(f), BreakFlag, Break);
}
}

class Test
{
static void Main()
{
List employeeHoursList = new List
{
new EmployeeHour(1, "2014/01/01 9:00:00:00", "2014/01/01 11:30:05:00", 1),
new EmployeeHour(2, "2014/01/01 12:00:00:00", "2014/01/01 16:30:00:00", 1),
new EmployeeHour(3, "2014/01/01 16:45:00:00", "2014/01/01 19:30:00:00", 0),
new EmployeeHour(4, "2014/01/02 9:00:00:00", "2014/01/02 12:00:00:00", 1),
new EmployeeHour(5, "2014/01/02 12:05:00:00", "2014/01/02 13:00:00:00", 1),
new EmployeeHour(6, "2014/01/02 14:00:00:00", "2014/01/02 19:30:00:00", 0)
};

int count = employeeHoursList.Count;
List listEH = employeeHoursList.Select((item, i) =>
{
if (item.BreakFlag == 1 && i < count - 1)
{
int b = (int)(Math.Round((employeeHoursList[i+1].TimeIn - item.TimeOut).TotalMinutes));
item.Break = String.Format("Break {0}min", b);
}
else
{
item.Break = "";
}
return item;
}).ToList();

using(StreamWriter sw = new StreamWriter("rahul.txt"))
{
string heading = String.Format("{0,-9}| {1,-22}| {2,-22}| {3,-9}| {4}", "recordID", "TimeIn", "TimeOut", "BreakFlag", "Break");
sw.WriteLine(heading);
foreach(EmployeeHour eh in listEH) sw.WriteLine(eh.ToString());
}
}
}
rahul ahuj12y ago
Hi Here is some more explaination
recordID | TimeIn        |TimeOut            |BreakFlag | Break
    1 | 2014/01/01 9:00:00:00 | 2014/01/01 11:30:05:00 |1         |
    2 | 2014/01/01 12:00:00:00| 2014/01/01 16:30:00:00 |1           |
    3 | 2014/01/01 16:45:00:00| 2014/01/01 19:30:00:00 |0           |
    4 | 2014/01/02 9:00:00:00 | 2014/01/02 12:00:00:00 |1           |
    5 | 2014/01/02 12:05:00:00| 2014/01/02 13:00:00:00 |1           |
    6 | 2014/01/02 14:00:00:00| 2014/01/02 19:30:00:00 |0           |

I have above data in the list and want to calculate the break time. TimeOut of previous record and TimeIn of next record difference is
time for break.I want to use the LINQ to get following output. It is posible with linq or should i use For loop to get following data

recordID | TimeIn        |TimeOut            |BreakFlag | Break
    1 | 2014/01/01 9:00:00:00 | 2014/01/01 11:30:05:00 |1           | Break 30min
    2 | 2014/01/01 12:00:00:00| 2014/01/01 16:30:00:00 |1           | Break 15min
    3 | 2014/01/01 16:45:00:00| 2014/01/01 19:30:00:00 |0           |
    4 | 2014/01/02 9:00:00:00 | 2014/01/02 12:00:00:00 |1           | Break 5min
    5 | 2014/01/02 12:05:00:00| 2014/01/02 13:00:00:00 |1           | Break 60min
    6 | 2014/01/02 14:00:00:00| 2014/01/02 19:30:00:00 |0           |
Vulpes12y ago
Just to clarify, are you saying that you want the Break property of the (i)th element of the filtered list (where BreakFlag == 1) to be set to the difference (expressed as a string) between:

the TimeOut property of the (i+1)th element, and

the TimeIn property of the (i-1)th element?

If so, what do you want to do about the first and last elements of the filtered list, which won't have a previous and next element?