private void populateReport() { bool isMulti; DateTime startRangeTime; DateTime endRangeTime; DateTime gateDate; int totalQty = 0; loadsNum = 0; singleEmpty = 0; emptyNumb = 0; singleLoad = 0; foreach (var item in reportList) { try { startRangeTime = (DateTime)item.GateDateTime; startRangeTime = startRangeTime.AddMinutes(-140); endRangeTime = (DateTime)item.GateDateTime; endRangeTime = startRangeTime.AddMinutes(140d); gateDate = (DateTime)item.GateDateTime; // gateDate = Convert.ToDateTime(gateDate.ToShortDateString + " " + "23:59:59") isMulti = ContainersInOutDrayageService.isMultiDrayage(item.truckDriverId, gateDate, item.drayageType); } catch { isMulti = false; } if (item.drayageType.Equals("Empty")) { if (isMulti) { item.rateType = "Multi Empty"; emptyNumb += 1; } else { item.rateType = "Single Empty"; singleEmpty += 1; } } else if (isMulti) { item.rateType = "Multi Load"; loadsNum += 1; } else { item.rateType = "Single Load"; singleLoad += 1; } string pick = item.pickUpCode.Trim(); string drop = item.dropOffCode.Trim(); if (pick.Equals("") | pick.Equals("N/A") | pick.Equals("0")) { item.pickUpCode = "UNKNOWN"; } if (drop.Equals("") | drop.Equals("N/A") | drop.Equals("0")) { item.dropOffCode = "UNKNOWN"; } totalQty += 1; } totalMultiLoadLabel.Text = loadsNum.ToString(); totalSingleLoadLabel.Text = singleLoad.ToString(); totalMultiEptyLabel.Text = emptyNumb.ToString(); totalSingleEptyLabel.Text = singleEmpty.ToString(); lblqtyEmpty.Text = (emptyNumb + singleEmpty).ToString(); lblqtyLoads.Text = (singleLoad + loadsNum).ToString(); totalQtyLbl.Text = totalQty.ToString(); }