private void RailList1_RequestRailListModse(bool ActiveUnits)
{
MdlLoadingSetting.waitForm.Show();
RailList1.TakeRailList(FetchRailList(ActiveUnits), true);
// Call CompareAgainstUnitSources()
MdlLoadingSetting.waitForm.Close();
}
private void BunifuToggleSwitch1_OnValuechange(object sender, EventArgs e)
{
MdlLoadingSetting.waitForm.Show();
try
{
RailList1.TakeRailList(FetchRailList(activeToggleSwitch.Value), true);
}
// Call CompareAgainstUnitSources(activeToggleSwitch.Value)
// Call CompareAgainstUnitSources()
catch (Exception ex)
{
string msg = ex.Message;
}
MdlLoadingSetting.waitForm.Close();
}
// Private Sub RailList1_ReleaseUnits(UnitList As String) Handles RailList1.ReleaseUnits
// Call FrmReleaseRailUnit.TakeUnitsToRelease(UnitList)
// End Sub
private void RailList1_UnitedSelected(bool Selected)
{
if (Selected)
{
manualReleaseBtn.Enabled = true;
btnEditUnit.Enabled = true;
btnAssociateBooking.Enabled = true;
}
else
{
manualReleaseBtn.Enabled = false;
btnEditUnit.Enabled = false;
btnAssociateBooking.Enabled = false;
}
RailList1.RequestSelectedUnitNumbers();
}
public void LoadForm(bool Refresh)
{
if (Refresh == true)
{
Show();
RailList1.TakeRailList(FetchRailList(true), true);
// Call CompareAgainstUnitSources(True)
RailList1.Select();
btnAssociateBooking.Enabled = false;
btnEditUnit.Enabled = false;
}
else
{
RailList1.RequestSelectedUnitNumbers();
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.frmAssignUnitToBooking, ParentForm);
}
// CarregaUnit()
}
private void btnEditUnit_Click(object sender, EventArgs e)
{
RailList1.RequestSelectedUnitNumbers();
if (SelectedUniSourceId.Count > 1)
{
var unitList = new List <VW_UnitSource>();
unitList = UnitSourceService.GetByUnitSourceListById(SelectedUniSourceId);
My.MyProject.Forms.FrmEditAddRailList.isMultiEdit = true;
My.MyProject.Forms.FrmEditAddRailList.isNewRecord = false;
My.MyProject.Forms.FrmEditAddRailList.LoadForm(unitList);
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmEditAddRailList, ParentForm);
}
else
{
var unit = UnitSourceService.GetVWById(SelectedUniSourceId[0]);
var unitList = new List <VW_UnitSource>();
unitList.Add(unit);
My.MyProject.Forms.FrmEditAddRailList.isMultiEdit = false;
My.MyProject.Forms.FrmEditAddRailList.isNewRecord = false;
My.MyProject.Forms.FrmEditAddRailList.LoadForm(unitList);
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmEditAddRailList, ParentForm);
}
}
public string FetchRailList(bool ActiveUnits)
{
short DayAmt = 0;
int RecCount = 0;
string BookingNumbers = "";
string Sql = "";
MdlContainerManagement.RailSight RailStructure;
int TotalRecords = 0;
string TempLine = "";
var UnitLineStatus = default(char);
if (ActiveUnits == true)
{
Sql = "Select * From VW_UnitSource Where Active = 1 and UnitStatus <> 'RELEASED' Order By UnitNumber";
}
else
{
Sql = "Select * From VW_UnitSource Where Active = 0 UnitStatus = 'RELEASED' Order By UnitNumber";
}
var DbObjDataTable = new DataTable();
var DbObjAdapter = new System.Data.SqlClient.SqlDataAdapter(Sql, DBConnect);
var DbObjCommand = new System.Data.SqlClient.SqlCommandBuilder(DbObjAdapter);
DbObjAdapter.Fill(DbObjDataTable);
TotalRecords = DbObjDataTable.Rows.Count;
if (TotalRecords > 0)
{
BookingInfo = new string[TotalRecords];
Refresh();
foreach (DataRow RailListRow in DbObjDataTable.Rows)
{
RailStructure.UnitNumber = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(RailListRow["OriginalUnitNumber"]), 16);
// .CustomerName = DoFunctions.PadToString(RailListRow("Consignee Name"), 50)
RailStructure.CustomerName = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(RailListRow["CustomerName"]), 50);
RailStructure.UnitStatus = RailList1.ConvertUnitStatus(Conversions.ToString(RailListRow["UnitStatus"]));
if (Information.IsDate(RailListRow["LastTraced"]) == true)
{
RailStructure.LastUpdate = MdlContainerManagement.DoFunctions.DateToNum(DateAndTime.DateValue(Conversions.ToString(RailListRow["LastTraced"])));
}
else
{
RailStructure.LastUpdate = MdlContainerManagement.DoFunctions.MKL(0);
}
if (!(Information.IsDBNull(RailListRow["CallDate"]) == true))
{
RailStructure.CallDate = MdlContainerManagement.DoFunctions.DateToNum(Conversions.ToDate(RailListRow["CallDate"]));
}
else
{
RailStructure.CallDate = MdlContainerManagement.DoFunctions.MKL(0);
}
RailStructure.ArrivalDate = MdlContainerManagement.DoFunctions.MKL(0);
if (Information.IsDate(RailListRow["BillDate"]) == true)
{
RailStructure.WayBillDate = MdlContainerManagement.DoFunctions.DateToNum(DateAndTime.DateValue(Conversions.ToString(RailListRow["BillDate"])));
}
else
{
RailStructure.WayBillDate = MdlContainerManagement.DoFunctions.MKL(0);
}
// .ShipperName = DoFunctions.PadToString(RailListRow("Shipper Name"), 35)
RailStructure.ShipperName = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(RailListRow["ShipperName"]), 35);
if (RailListRow.IsNull("OriginLocation") == true)
{
RailStructure.OriginLocation = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(' '), 35);
}
else
{
RailStructure.OriginLocation = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(RailListRow["OriginLocation"]), 35);
}
if (RailListRow.IsNull("UnitLine") == true)
{
RailStructure.SASC = MdlContainerManagement.DoFunctions.PadToString("", 4);
}
else
{
RailStructure.SASC = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(RailListRow["UnitLine"]), 4);
}
if (RailListRow.IsNull("ETADate") == true)
{
RailStructure.ETADate = MdlContainerManagement.DoFunctions.MKL(0);
RailStructure.ETADays = MdlContainerManagement.DoFunctions.MKI(0);
}
else
{
RailStructure.ETADate = MdlContainerManagement.DoFunctions.DateToNum(DateAndTime.DateValue(Conversions.ToString(RailListRow["ETADate"])));
DayAmt = (short)DateAndTime.DateDiff(DateInterval.Day, DateAndTime.Today.Date, DateAndTime.DateValue(Conversions.ToString(RailListRow["ETADate"])));
if (DayAmt > 0)
{
RailStructure.ETADays = MdlContainerManagement.DoFunctions.MKI(DayAmt);
}
else
{
RailStructure.ETADays = MdlContainerManagement.DoFunctions.MKI(0);
}
}
RailStructure.EquipType = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(RailListRow["UnitType"]), 6);
if (RailListRow.IsNull("TotalBilled") == true)
{
RailStructure.WgtMT = MdlContainerManagement.DoFunctions.MKS(0f);
}
else
{
RailStructure.WgtMT = MdlContainerManagement.DoFunctions.MKS(Conversions.ToSingle(RailListRow["TotalBilled"]));
}
RailStructure.Bags = MdlContainerManagement.DoFunctions.MKL(0);
if (RailListRow.IsNull("LastLocation") == true)
{
RailStructure.SightingLocation = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(' '), 13);
}
else
{
RailStructure.SightingLocation = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(RailListRow["LastLocation"]), 13);
}
RailStructure.CaargoDescription = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(' '), 15);
BookingInfo[RecCount] = "";
TempLine += Conversions.ToString('\0') + RailStructure.UnitNumber + RailStructure.CustomerName + Conversions.ToString(RailStructure.UnitStatus) + RailStructure.LastUpdate + RailStructure.SightingLocation + RailStructure.ETADate + RailStructure.ETADays + RailStructure.CallDate + RailStructure.ArrivalDate + RailStructure.WayBillDate + RailStructure.ShipperName + RailStructure.OriginLocation + RailStructure.SASC + RailStructure.EquipType + RailStructure.WgtMT + RailStructure.Bags + RailStructure.CaargoDescription + Conversions.ToString(UnitLineStatus) + MdlContainerManagement.DoFunctions.MKL(0) + MdlContainerManagement.DoFunctions.MKL(Conversions.ToInteger(RailListRow["UnitSourceId"]));
RecCount += 1;
}
}
deactivateBtns();
return(TempLine);
}
private void ExportCSVToolStripMenuItem_Click(object sender, EventArgs e)
{
RailList1.GetCSV();
}
private void btnAssociateBooking_Click(object sender, EventArgs e)
{
RailList1.RequestSelectedUnitNumbers();
var muRow = new VW_UnitSourceMiniUnit();
var mbMU = new DataTable();
var muRowList = new List <VW_UnitSourceMiniUnit>();
var multiMUList = new List <VW_UnitSourceMiniUnit>();
var muListToAssign = new List <VW_UnitSourceMiniUnit>();
string diffCargosList = "";
string diffCustomerList = "";
var SelectedUs = UnitSourceService.GetByUnitSourceListById(SelectedUniSourceId);
if (hasSameCargoTypes(SelectedUs, ref diffCargosList) == false)
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Can not proceed:", "It Seems like different cargo types has been selected. Please, select only one type of cargo type to continue." + Constants.vbNewLine + "Units:" + Constants.vbNewLine + diffCargosList, this);
return;
}
else if (hasSameCustomers(SelectedUs, ref diffCustomerList) == false)
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Can not proceed:", "It Seems like different Customers has been selected. Please, select the same customer name to continue." + Constants.vbNewLine + "Units:" + Constants.vbNewLine + diffCustomerList, this);
return;
}
{
var withBlock = My.MyProject.Forms.frmMiniUnitToAssign;
// Lopp through selected Unit sources
for (int i = 0, loopTo = SelectedUniSourceId.Count - 1; i <= loopTo; i++)
{
// Get All MiniUnits from unitID
muRowList = VW_UnitSOurceMiniUnitService.GetByUnitSourceById(SelectedUniSourceId[i]);
// If more than one mu, send them to Form where user will pick the mini unit
if (muRowList.Count > 1)
{
foreach (var mu in muRowList)
{
multiMUList.Add(mu);
}
withBlock.VWUnitSourceMiniUnitBindingSource.DataSource = multiMUList;
}
// If theres only one MU, send it straigt to Form where mini unit will be asn to minibooking
else if (muRowList.Count == 1)
{
muListToAssign.Add(muRowList[0]);
My.MyProject.Forms.frmAssignUnitToBooking.dgvMiniUnit.DataSource = muListToAssign;
}
// If there's no mini unit, give the option to edit unit source, and repeat process
else if (My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("There is not Mini Unit for this Unit.", "Create Mini Unit ?", My.Resources.Resources.caution, this) == DialogResult.Yes)
{
// FrmEditAddRailList.
var unit = UnitSourceService.GetVWById(SelectedUniSourceId[i]);
var unitList = new List <VW_UnitSource>();
unitList.Add(unit);
My.MyProject.Forms.FrmEditAddRailList.isNewRecord = false;
My.MyProject.Forms.FrmEditAddRailList.isMultiEdit = false;
My.MyProject.Forms.FrmEditAddRailList.LoadForm(unitList);
RailList1.RequestSelectedUnitNumbers();
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmEditAddRailList, My.MyProject.Forms.FrmParentScreen);
muRowList = VW_UnitSOurceMiniUnitService.GetByUnitSourceById(SelectedUniSourceId[i]);
if (muRowList.Count > 1)
{
foreach (var mu in muRowList)
{
multiMUList.Add(mu);
}
withBlock.VWUnitSourceMiniUnitBindingSource.DataSource = multiMUList;
}
else if (muRowList.Count == 1)
{
muListToAssign.Add(muRowList[0]);
My.MyProject.Forms.frmAssignUnitToBooking.dgvMiniUnit.DataSource = muListToAssign;
}
}
}
if (My.MyProject.Forms.frmMiniUnitToAssign.VWUnitSourceMiniUnitBindingSource.Count > 1)
{
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.frmMiniUnitToAssign, this);
}
else if (Convert.ToInt32(((List <object>)My.MyProject.Forms.frmAssignUnitToBooking.dgvMiniUnit.DataSource).Count) > 0)
{
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.frmAssignUnitToBooking, this);
}
else
{
RailList1.TakeRailList(FetchRailList(true), true);
}
}
}
private void btnAddManyUnita_Click(object sender, EventArgs e)
{
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmAddMultipleUnits, this);
RailList1.TakeRailList(FetchRailList(true), true);
}
