/// <summary> /// Current date packing details /// </summary> /// <returns></returns> public List <cstShipmentPackedTodayAndAvgTime> GetTotalShipmentPackedTime() { List <cstShipmentPackedTodayAndAvgTime> lsShipmentPacked = new List <cstShipmentPackedTodayAndAvgTime>(); try { String CurrentTime = DateTime.UtcNow.ToString(); var packingCount = from user in ent.Users join packing in ent.Packages on user.UserID equals packing.UserId where EntityFunctions.TruncateTime(packing.EndTime) == EntityFunctions.TruncateTime(DateTime.UtcNow) group packing by packing.UserId into Gpacking select new { userID = Gpacking.Key, TotalPacked = Gpacking.Count(i => i.PackingStatus == 0) }; foreach (var pckitem in packingCount) { cstShipmentPackedTodayAndAvgTime _cspck = new cstShipmentPackedTodayAndAvgTime(); _cspck.UserID = pckitem.userID; _cspck.Packed = Convert.ToInt32(pckitem.TotalPacked); lsShipmentPacked.Add(_cspck); } } catch (Exception) { } return(lsShipmentPacked); }
/// <summary> /// Current date packing details /// </summary> /// <returns></returns> public List <cstShipmentPackedTodayAndAvgTime> GetTotalShipmentPackedTime() { List <cstShipmentPackedTodayAndAvgTime> lsShipmentPacked = new List <cstShipmentPackedTodayAndAvgTime>(); try { var vs = Service.Get.GetTotalShipmentPackedTime(); foreach (var item in vs) { cstShipmentPackedTodayAndAvgTime _item = new cstShipmentPackedTodayAndAvgTime(); _item.Packed = item.Packed; _item.UserID = item.UserID; lsShipmentPacked.Add(_item); } } catch (Exception) { } return(lsShipmentPacked); }