private void BunifuButton2_Click(object sender, EventArgs e)
{
string code = Conversions.ToString(cboTruckingCompany.SelectedValue);
reportList.Clear();
VW_CompanyCompanyType c = (VW_CompanyCompanyType)cboTruckingCompany.SelectedItem;
if (!SelectedCarrierCodeList.Contains(Strings.Trim(Conversions.ToString(c.CompanyCode))))
{
SelectedCarrierCodeList.Add(Strings.Trim(Conversions.ToString(c.CompanyCode)));
}
if (!firstLoad)
{
MdlLoadingSetting.waitForm.Show();
if (!Information.IsNothing(cboTruckingCompany.SelectedValue) & goodToGo())
{
if (!fromDatePicker.CustomFormat.Equals(""))
{
TEFDT = dbCeres.getTableInfo("TEF_Rate", "*", "where FromDate <= '" + Conversions.ToString(fromDatePicker.Value.Date) + "' and (ToDate is null or ToDate <='" + Conversions.ToString(toIDatePicker.Value.Date) + "')");
FSC_Rate = dbCeres.getTableInfo("FSC_Rate", "*", " where From_Date <= '" + Conversions.ToString(fromDatePicker.Value.Date) + "' And (To_Date >= '" + Conversions.ToString(toIDatePicker.Value.Date) + "' or To_Date is null) order by From_Date");
populateServices();
}
drayageRates = dbCeres.getTableInfo("DrayageSchemeRate", "*", " where TruckingCompany = '" + Strings.Trim(Conversions.ToString(cboTruckingCompany.SelectedValue)) + "' order by FromDate");
var endDate = Convert.ToDateTime(toIDatePicker.Value.Date.ToShortDateString() + " 23:59:59".ToString());
var StartDate = Convert.ToDateTime(fromDatePicker.Value.Date.ToShortDateString() + " 00:00:00".ToString());
reportList = ContainersInOutDrayageService.GetByDrayageRates(Strings.Trim(Conversions.ToString(cboBookingNumber.SelectedItem)), Strings.Trim(cboPickUp.Text), Strings.Trim(cboDropOff.Text), Strings.Trim(cboDriverId.Text), StartDate, endDate, SelectedCarrierCodeList, streetTurnToggleSwitch.Value, btnRemoveDate.Visible);
dgvTest.DataSource = reportList;
}
populateReport();
filterReportTable();
populateReport();
updateRatesReport();
}
if (dgvTest.Rows.Count > 0)
{
printButton.Enabled = true;
}
else
{
printButton.Enabled = false;
}
foreach (DataGridViewColumn column in dgvTest.Columns)
{
column.SortMode = DataGridViewColumnSortMode.Automatic;
}
MdlLoadingSetting.waitForm.Close();
}
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();
}
