private void ReAssignFileData(List <RepAtt> listRepData) { foreach (var item in listRepData) { item.DayONly = item.TimeDay.Split('-')[0].Trim(); item.TimeONly = item.TimeDay.Split('-')[1].Trim(); var comTime = item.DayONly.Split(new[] { ' ' }, 2)[1] + " " + item.TimeONly; item.DayValidCom = Convert.ToDateTime(comTime); item.ValidDay = item.DayONly.Split(new[] { ' ' }, 2)[1]; } var groupReps = from res in listRepData group res by new { res.RepName, res.ValidDay } into gcs select new RepAttendance { RepName = gcs.Key.RepName, RepDeta = gcs.ToList() }; var orderListrep = new List <DeltoneCRM_DAL.LoginDAL.DisplayRepAttendance>(); foreach (var item in groupReps) { var key = item.RepName; var repDisplayAtten = new DeltoneCRM_DAL.LoginDAL.DisplayRepAttendance(); repDisplayAtten.RepName = key; if (item.RepDeta != null) { if (item.RepDeta.Count() > 0) { repDisplayAtten.StarDateTime = item.RepDeta[0].DayValidCom; } if (item.RepDeta.Count() > 1) { repDisplayAtten.EndDateTime = item.RepDeta[1].DayValidCom; } } orderListrep.Add(repDisplayAtten); } CalculateTimeHours(orderListrep); Session["attendanceLog"] = orderListrep; }
private void TestMe() { var listttt = TestFile(); var nameDaylist = GetDayNameList(); var yearNameList = GetYearNameList(); var listStarDateList = new List <RepStartAndEnd>(); var listEndDateList = new List <RepStartAndEnd>(); foreach (var item in listttt) { item.DayONly = item.TimeDay.Split('-')[0].Trim(); item.TimeONly = item.TimeDay.Split('-')[1].Trim(); var comTime = item.DayONly.Split(new[] { ' ' }, 2)[1] + " " + item.TimeONly; item.DayValidCom = Convert.ToDateTime(comTime); item.ValidDay = item.DayONly.Split(new[] { ' ' }, 2)[1]; // TimeSpan duration = DateTime.Parse(endTime).Subtract(DateTime.Parse(startTime)); } var listGroup = from res in listttt group res by new { res.RepName, res.ValidDay } into gcs select new RepAttendance() { RepName = gcs.Key.RepName, RepDeta = gcs.ToList() }; var listDisplayRepAttendance = new List <DeltoneCRM_DAL.LoginDAL.DisplayRepAttendance>(); foreach (var item in listGroup) { var key = item.RepName; var repDisplayAtten = new DeltoneCRM_DAL.LoginDAL.DisplayRepAttendance(); repDisplayAtten.RepName = key; if (item.RepDeta != null) { if (item.RepDeta.Count() > 0) { repDisplayAtten.StarDateTime = item.RepDeta[0].DayValidCom; } if (item.RepDeta.Count() > 1) { repDisplayAtten.EndDateTime = item.RepDeta[1].DayValidCom; } } listDisplayRepAttendance.Add(repDisplayAtten); } CalculateTimeHours(listDisplayRepAttendance); // Session["attendanceLog"] = listDisplayRepAttendance; // var gropList = listttt.GroupBy(p => p.RepName).ToList(); // var listFilterAtt = new List<RepAttendance>(); //foreach (var grItem in gropList) //{ // var key = grItem.Key; // var grItemSS = grItem.OrderBy(x => x.DayValidCom).ToList(); // // var counter = 0; // //for (var i=0;i < item in grItemSS) // // { // // //var aaa=item. // // var firstEele = grItemSS[0]; // // var objRe = new RepAttendance(); // // // objRe.RepName = key; // // } //} }