public ActionResult details(int id)
{
List <Details> data = new List <Details>();
//List<User> u = e.Users.Join()
//var details = (from a in e.Users
// join c in e.Daily_times on a.Id equals c.Id /*join n in e.Break_Times on a.Id equals n.Id*/
// select new
// {
// ID = a.Id,
// Name = a.Name,
// Email = a.Email,
// Active = a.Active,
// StartTime = c.start_time,
// Day = c.Day,
// Contact = a.Contact,
// //BreakStart = n.startTime,
// // breakStop = n.endTime,
// Status = c.Status,
// end_time = c.end_time
// }
// ).ToList();
var query = e.show_data();
foreach (var i in query)
{
if (i.Day == DateTime.Now.DayOfWeek.ToString())
{
Details d = new Details();
d.Id = i.Id;
d.Name = i.Name;
d.start_time = i.start_time;
d.check = (int)id;
d.end_time = i.end_time;
d.startTime = i.startTime;
d.endTime = i.endTime;
//d.Active = i.Active;
// d.Contact = i.Contact;
d.dailytimestatus = i.Status;
d.Month = i.Month;
d.Day = i.Day;
d.Status = i.Status;
if (d.startTime == null)
{
d.breakcheck = 0;
}
else if (i.check == 1)
{
d.breakcheck = 2;
}
else
{
d.breakcheck = 1;
}
//d.startTime = i.BreakStart;
//d.endTime = i.breakStop;
data.Add(d);
}
}
return(View(data));
//var details1 = (from t in e.Users
// join q in e.Break_Times on t.Id equals q.Id
// select new
// {
// start = q.startTime,
// end = q.endTime,
// day = q.Day
// }
// ).ToList();
//foreach (var i in details1)
//{
//}
}
