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;
// // }
//}
}
