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