private void RichTextBox1_TextChanged(object sender, EventArgs e) { string[] containerList; containerList = RichTextBox1.Text.Split(Conversions.ToChar(Constants.vbLf)); cleanDataGrids(); titleLabel.Text = "Block Container"; foreach (var cont in containerList) { string condition = "where [Container Number] = '" + cont + "'"; // if container number is valid, add it to the valid containers list if (MdlContainerManagement.ValidateContainer(cont) & db.isOnDatabase("[Blocked Containers]", condition) == false) { goodContDataGrid.Rows.Add(cont); } // if already on database, show ** and add to the not valid containers list else if (db.isOnDatabase("[Blocked Containers]", condition) == true) { badContDataGrid.Rows.Add("* " + cont + " *"); warningLabel.Visible = true; } else { // otherwise just add to the not valid containers list with no ** badContDataGrid.Rows.Add(cont); } } }
private void containerBunifuTextBox_TextChanged(object sender, EventArgs e) { availablePictureBox.Visible = true; if (string.IsNullOrEmpty(containerBunifuTextBox.Text)) { availablePictureBox.Visible = false; } else if (MdlContainerManagement.ValidateContainer(containerBunifuTextBox.Text)) { availablePictureBox.Image = My.Resources.Resources.icon_available; } else { availablePictureBox.Image = My.Resources.Resources.icon_not_available; } }
private void assignBunifuButton1_Click(object sender, EventArgs e) { cleanDataGrids(); MdlContainerManagement.checkContainersAdded(); }
private void RailList1_ExportRailListCSVs(short RecLgt, string RailList) { int x = 0; string ETADays = ""; string CSVLine = ""; string ThisCSVFile = ""; string TempLine = ""; var NumCount = new string[5]; string LastTrace = ""; string BillDate = ""; string ETADate = ""; string UnitStatus = ""; float WeightMT; System.IO.StreamWriter file; ThisCSVFile = System.IO.Path.GetTempPath() + "RailList-" + DateTime.Today.ToString("dd-MMM-yyyy") + "-" + Strings.Format(DateAndTime.TimeOfDay, "hhmmss") + ".CSV"; if (System.IO.File.Exists(ThisCSVFile) == true) { System.IO.File.Delete(ThisCSVFile); } file = My.MyProject.Computer.FileSystem.OpenTextFileWriter(ThisCSVFile, true); file.WriteLine("Unit #" + Conversions.ToString(',') + "Customer" + Conversions.ToString(',') + "Status" + Conversions.ToString(',') + "Last Trace" + Conversions.ToString(',') + "Location" + Conversions.ToString(',') + "ETA Date" + Conversions.ToString(',') + "Days" + Conversions.ToString(',') + "Call Date" + Conversions.ToString(',') + "Arrival Date" + Conversions.ToString(',') + "Bill Date" + Conversions.ToString(',') + "Shipper" + Conversions.ToString(',') + "Origin" + Conversions.ToString(',') + "Carrier" + Conversions.ToString(',') + "Type" + Conversions.ToString(',') + "Wgt MT" + Conversions.ToString(',') + "Bags" + Conversions.ToString(',') + "Commodity" + Conversions.ToString(',') + "Track" + Conversions.ToString(',') + "Notes"); var loopTo = Strings.Len(RailList); for (x = 1; RecLgt >= 0 ? x <= loopTo : x >= loopTo; x += RecLgt) { CSVLine = Strings.Mid(RailList, x, RecLgt); UnitStatus = GiveUnitStatus(Conversions.ToChar(Strings.Mid(CSVLine, 62, 1))); if ((Strings.Mid(CSVLine, 63, 4) ?? "") == (MdlContainerManagement.DoFunctions.MKL(0) ?? "")) { LastTrace = ""; } else { LastTrace = MdlContainerManagement.DoFunctions.NumToDate(Strings.Mid(CSVLine, 63, 4)); } if ((Strings.Mid(CSVLine, 80, 4) ?? "") == (MdlContainerManagement.DoFunctions.MKL(0) ?? "")) { ETADate = ""; } else { ETADate = MdlContainerManagement.DoFunctions.NumToDate(Strings.Mid(CSVLine, 80, 4)); } if ((Strings.Mid(CSVLine, 84, 2) ?? "") == (MdlContainerManagement.DoFunctions.MKI(0) ?? "")) { ETADays = ""; } else { ETADays = MdlContainerManagement.DoFunctions.CVI(Strings.Mid(CSVLine, 84, 2)).ToString(); } if ((Strings.Mid(CSVLine, 94, 4) ?? "") == (MdlContainerManagement.DoFunctions.MKL(0) ?? "")) { BillDate = ""; } else { BillDate = MdlContainerManagement.DoFunctions.NumToDate(Strings.Mid(CSVLine, 94, 4)); } if ((Strings.Mid(CSVLine, 163, 4) ?? "") == (MdlContainerManagement.DoFunctions.MKL(0) ?? "")) { WeightMT = 0f; } else { WeightMT = MdlContainerManagement.DoFunctions.CVL(Strings.Mid(CSVLine, 163, 4)); } TempLine = Strings.RTrim(Strings.Mid(CSVLine, 2, 10)) + Conversions.ToString(',') + Strings.RTrim(Strings.Mid(CSVLine, 12, 50)) + Conversions.ToString(',') + UnitStatus + Conversions.ToString(',') + LastTrace + Conversions.ToString(',') + MdlContainerManagement.StripCommas(Strings.RTrim(Strings.Mid(CSVLine, 67, 13))) + Conversions.ToString(',') + ETADate + Conversions.ToString(',') + ETADays + Conversions.ToString(',') + "" + Conversions.ToString(',') + "" + Conversions.ToString(',') + BillDate + Conversions.ToString(',') + Strings.RTrim(Strings.Mid(CSVLine, 98, 35)) + Conversions.ToString(',') + MdlContainerManagement.StripCommas(Strings.RTrim(Strings.Mid(CSVLine, 133, 35))) + Conversions.ToString(',') + Strings.RTrim(Strings.Mid(CSVLine, 168, 4)) + Conversions.ToString(',') + Strings.RTrim(Strings.Mid(CSVLine, 172, 6)) + Conversions.ToString(',') + MdlContainerManagement.DoFunctions.CVS(Strings.Mid(CSVLine, 178, 4)).ToString() + Conversions.ToString(',') + "" + Conversions.ToString(',') + MdlContainerManagement.StripCommas(Strings.RTrim(Strings.Mid(CSVLine, 186, 15))); // RTrim(Mid(CSVLine, 157, 6)) + Chr(44) + CStr(WeightMT) + Chr(44) + "" + Chr(44) + StripCommas(RTrim(Mid(CSVLine, 171, 13))) + Chr(44) + StripCommas(RTrim(Mid(CSVLine, 184, 15))) file.WriteLine(TempLine); } file.Close(); Process.Start("EXCEL.EXE", ThisCSVFile); }
private void FrmAddEditOutGate_Load(object sender, EventArgs e) { companies = db.getTableInfo("VW_CompanyCompanyType", "*", "order by CompanyName"); var truckDrivers = db.getTableInfo("[Truck Drivers]", "*", "order by [Truck Number]"); // Dim ssLineCeres As DataTable = db.getTableInfo("[Containers In-Out]", "*", "order by [Truck Number]") fromComboBox.Items.Clear(); toBunifuDropdown.Items.Clear(); carrierBunifuDropdown.Items.Clear(); shippingLineBunifuDropdown.Items.Clear(); truckNumberBunifuDropdown1.Items.Clear(); fromComboBox.Items.Add("N/A"); toBunifuDropdown.Items.Add("N/A"); carrierBunifuDropdown.Items.Add("N/A"); shippingLineBunifuDropdown.Items.Add("N/A"); truckNumberBunifuDropdown1.Items.Add("N/A"); foreach (DataRow company in companies.Rows) { if (company["DescCompanyType"].Equals("Container Terminal")) { fromComboBox.Items.Add(Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")"); toBunifuDropdown.Items.Add(Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")"); } else if (company["DescCompanyType"].Equals("Drayage Provider")) { carrierBunifuDropdown.Items.Add((Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")").ToUpper()); } else if (company["DescCompanyType"].Equals("Steamship Line")) { shippingLineBunifuDropdown.Items.Add((Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")").ToUpper()); } } foreach (DataRow truckDriver in truckDrivers.Rows) { truckNumberBunifuDropdown1.Items.Add(Strings.Trim(Conversions.ToString(truckDriver["Truck Number"]))); } cleanFields(); if (My.MyProject.Forms.FrmInOutGate.isNewRecord == false) { titleLabel.Text = "Edit Record - Out Gate"; for (int i = 0, loopTo = My.MyProject.Forms.FrmInOutGate.OutGateDataGridView.Rows.Count - 1; i <= loopTo; i++) { if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(My.MyProject.Forms.FrmInOutGate.OutGateDataGridView.Rows[i].Cells[1].Value, true, false))) { recordID = Conversions.ToInteger(My.MyProject.Forms.FrmInOutGate.OutGateDataGridView.Rows[i].Cells[0].Value); break; } } } // ediPanel.Hide() else { titleLabel.Text = "Create New Record - Out Gate"; for (int i = 0, loopTo1 = My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows.Count - 1; i <= loopTo1; i++) { if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows[i].Cells[1].Value, true, false))) { recordID = Conversions.ToInteger(My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows[i].Cells[0].Value); break; } } // ediPanel.Show() } MdlContainerManagement.populateOutGateInfo(this, recordID); fromComboBox.DropDownHeight = Height - 100; toBunifuDropdown.DropDownHeight = Height - 100; carrierBunifuDropdown.DropDownHeight = Height - 100; shippingLineBunifuDropdown.DropDownHeight = Height - 100; truckNumberBunifuDropdown1.DropDownHeight = Height - 100; }
private void saveBunifuButton_Click(object sender, EventArgs e) { string actionTaken = ""; int lastEDIRecordAdded; DataRow dataRows; string gateAction; // recordID = inGateUniqueIDList(0) if (My.MyProject.Forms.FrmInOutGate.isNewRecord) { actionTaken = "Create"; } else { actionTaken = "Update"; } gateAction = "OUT-GATE"; // Save Outgate info MdlContainerManagement.saveOutGate(recordID, this); // Save Log EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, recordID.ToString(), actionTaken, gateAction, ""); string ssLineCode; ssLineCode = Strings.Trim(shippingLineBunifuDropdown.SelectedItem.ToString().Split('(')[0]); if (sendEDIBunifuToggleSwitch.Value == true) { EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, recordID.ToString(), actionTaken, gateAction, "Requested EDI to be sent"); db.AddEDILog(recordID, "OUT-GATE", gateAction); lastEDIRecordAdded = db.getLadstEDIadded(); if (My.MyProject.Forms.FrmChangeEDI.changeEDIRadioButton.Checked) { DateTime modDateTime; DateTime modDateTimeSTR; modDateTimeSTR = Conversions.ToDate(My.MyProject.Forms.FrmChangeEDI.EDIDateTimePicker.Value.ToShortDateString() + " " + My.MyProject.Forms.FrmChangeEDI.EdiTimePicker.Value.ToShortTimeString()); modDateTime = Convert.ToDateTime(modDateTimeSTR); db.saveEDIModifiedRecord(lastEDIRecordAdded, modDateTime); // db.UpdatePreSendStatus(recordID, True) db.pushEDIRequest(recordID, false, true, lastEDIRecordAdded, modDateTime); } else { DateTime gateDateTime; DateTime gateDateTimeTR; gateDateTimeTR = Conversions.ToDate(dateDateTimePicker.Value.ToShortDateString() + " " + timeDateTimePicker.Value.ToShortTimeString()); gateDateTime = Convert.ToDateTime(gateDateTimeTR); // db.UpdatePreSendStatus(recordID, True) db.pushEDIRequest(recordID, false, true, lastEDIRecordAdded, gateDateTime); } } cleanFields(); for (int i = 0, loopTo = My.MyProject.Forms.FrmInOutGate.OutGateDataGridView.Rows.Count - 1; i <= loopTo; i++) { My.MyProject.Forms.FrmInOutGate.OutGateDataGridView.Rows[i].Cells[1].Value = false; } My.MyProject.Forms.FrmInOutGate.isRefresh = true; My.MyProject.Forms.FrmInOutGate.tabinoutGate.SelectedIndex = 1; My.MyProject.Forms.FrmInOutGate.getInOutContainers(); My.MyProject.Forms.FrmInOutGate.checkButtons(); Close(); }
// Dim inGateUniqueIDList() As Integer private void FrmAddEditInGate_Load(object sender, EventArgs e) { // inGateUniqueIDList = FrmInOutGate.containersIDIn companies = db.getTableInfo("VW_CompanyCompanyType", "*", "order by CompanyName"); var truckDrivers = db.getTableInfo("[Truck Drivers]", "*", "order by [Truck Number]"); // Dim ssLineCeres As DataTable = db.getTableInfo("[Containers In-Out]", "*", "order by [Truck Number]") fromComboBox.Items.Clear(); toBunifuDropdown.Items.Clear(); carrierBunifuDropdown.Items.Clear(); shippingLineBunifuDropdown.Items.Clear(); truckNumberBunifuDropdown1.Items.Clear(); fromComboBox.Items.Add("N/A"); toBunifuDropdown.Items.Add("N/A"); carrierBunifuDropdown.Items.Add("N/A"); shippingLineBunifuDropdown.Items.Add("N/A"); truckNumberBunifuDropdown1.Items.Add("N/A"); foreach (DataRow company in companies.Rows) { if (company["DescCompanyType"].Equals("Container Terminal")) { fromComboBox.Items.Add(Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")"); toBunifuDropdown.Items.Add(Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")"); } else if (company["DescCompanyType"].Equals("Drayage Provider")) { carrierBunifuDropdown.Items.Add((Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")").ToUpper()); } else if (company["DescCompanyType"].Equals("Steamship Line")) { shippingLineBunifuDropdown.Items.Add((Strings.Trim(Conversions.ToString(company["Companycode"])) + " (" + Strings.Trim(Conversions.ToString(company["CompanyName"])) + ")").ToUpper()); } } foreach (DataRow truckDriver in truckDrivers.Rows) { truckNumberBunifuDropdown1.Items.Add(Strings.Trim(Conversions.ToString(truckDriver["Truck Number"]))); } cleanFields(); if (My.MyProject.Forms.FrmInOutGate.isNewRecord == false) { int recordID = 0; int focusedRow = 0; focusedRow = My.MyProject.Forms.FrmInOutGate.InGateDataGridView.CurrentRow.Index; recordID = Conversions.ToInteger(My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows[focusedRow].Cells[0].Value); titleLabel.Text = "Edit Record - In Gate"; saveBunifuButton.Text = "UPDATE"; MdlContainerManagement.populateInGateInfo(this, recordID); } // ediPanel.Hide() else { titleLabel.Text = "Create New Record - In Gate"; // ediPanel.Show() saveBunifuButton.Text = "SAVE"; } fromComboBox.DropDownHeight = Height - 100; toBunifuDropdown.DropDownHeight = Height - 100; carrierBunifuDropdown.DropDownHeight = Height - 100; shippingLineBunifuDropdown.DropDownHeight = Height - 100; truckNumberBunifuDropdown1.DropDownHeight = Height - 100; }
private void saveBunifuButton_Click(object sender, EventArgs e) { string actionTaken = ""; int lastEDIRecordAdded; DataRow dataRows; string gateAction; var recordID = default(int); if (My.MyProject.Forms.FrmInOutGate.isNewRecord) { MdlContainerManagement.saveInGate(0, this); recordID = MdlContainerManagement.lastrecordID; actionTaken = "CREATE"; gateAction = "IN-GATE"; } else { for (int i = 0, loopTo = My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows.Count - 1; i <= loopTo; i++) { if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows[i].Cells[1].Value, true, false))) { recordID = Conversions.ToInteger(My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows[i].Cells[0].Value); break; } } MdlContainerManagement.saveInGate(recordID, this); actionTaken = "UPDATE"; gateAction = "IN-GATE"; } EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, recordID.ToString(), actionTaken, gateAction, ""); // ' To send EDI -- program only allow specific ss lines string ssLineCode; ssLineCode = Strings.Trim(shippingLineBunifuDropdown.SelectedItem.ToString().Split('(')[0]); if (sendEDIBunifuToggleSwitch.Value == true) { EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, recordID.ToString(), actionTaken, gateAction, "Requested EDI to be sent"); db.AddEDILog(recordID, "IN-GATE", gateAction); lastEDIRecordAdded = db.getLadstEDIadded(); if (My.MyProject.Forms.FrmChangeEDI.changeEDIRadioButton.Checked) { DateTime modDateTime; DateTime modDateTimeSTR; modDateTimeSTR = Conversions.ToDate(My.MyProject.Forms.FrmChangeEDI.EDIDateTimePicker.Value.ToShortDateString() + " " + My.MyProject.Forms.FrmChangeEDI.EdiTimePicker.Value.ToShortTimeString()); modDateTime = Convert.ToDateTime(modDateTimeSTR); db.saveEDIModifiedRecord(lastEDIRecordAdded, modDateTime); db.pushEDIRequest(recordID, true, false, lastEDIRecordAdded, modDateTime); } else { DateTime gateDateTime; DateTime gateDateTimeTR; gateDateTimeTR = Conversions.ToDate(dateDateTimePicker.Value.ToShortDateString() + " " + timeDateTimePicker.Value.ToShortTimeString()); gateDateTime = Convert.ToDateTime(gateDateTimeTR); db.pushEDIRequest(recordID, true, false, lastEDIRecordAdded, gateDateTime); } } My.MyProject.Forms.FrmInOutGate.isRefresh = true; My.MyProject.Forms.FrmInOutGate.getInOutContainers(); cleanFields(); for (int i = 0, loopTo1 = My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows.Count - 1; i <= loopTo1; i++) { My.MyProject.Forms.FrmInOutGate.InGateDataGridView.Rows[i].Cells[1].Value = false; } My.MyProject.Forms.FrmInOutGate.checkButtons(); Close(); }