How to show record by days wise.

Question

Hello .I have one question i have save record in table by datetime wise with multipleuser(Multiple same user id).How to show list total time calculate day wise .(For e.g User Total 10 time sleep and waakup in a day how to show total calculate total sleep time per days ).Please help me. Thanks

Sachin Singh · Accepted Answer

ConsoleTestAnythingEntities db = new ConsoleTestAnythingEntities();
var userGrp = db.tbl_UserSleepDetailMaster.Where(x => x.UserId == 1).GroupBy(x => x.UpdateDate).ToList();
int d3 = 0;
Information info = new Information();
foreach (var item in userGrp)
{
info.Day = (item.Key.Value).DayOfWeek.ToString();
foreach (var i in item)
{
d3 = d3 + (int)(i.SleepOffTime - i.SleepOnTime).Value.TotalMinutes;
}
}

Kiran Mohanty · Answer

select  id,  name , sleep    from     (   Select  Id,  Name ,  day  ,  sum ( day )  as   'sleep'    from  user_table   group   by  Id,  Name ,  day    order   by   day    )