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();
}
