private void BunifuButton2_Click(object sender, EventArgs e)
{
// My.MyProject.Forms.FrmParentScreen.showLOadForm();
listReport = MinibookingService.GetJointBooking(true).Where(b => b.MiniBookingId != 0).ToList();
VWBookingMinibookingBindingSource.DataSource = listReport;
// My.MyProject.Forms.FrmParentScreen.HideLoadForm();
}
private void ReplaceExportBookingNumber()
{
var RelOrderMbService = new ReleaseOrderMinibookingService();
var RelOrderMbList = ReleaseOrderMinibookingService.GetAllByReleaseOrderId(OrderList[0].ReleaseOrderId);
ReleaseOrderMinibooking FirstRelOrderMb = (ReleaseOrderMinibooking)RelOrderMbList.Where(r => r.AssignmentOrder == 1);
if (!Information.IsNothing(FirstRelOrderMb))
{
// Delete first ReleaseMb and add new one
if (RelOrderMbService.Delete(FirstRelOrderMb.ReleaseOrderMinibookingId))
{
var newRelMb = new ReleaseOrderMinibooking();
try
{
newRelMb.ReleaseOrderId = OrderList[0].ReleaseOrderId;
newRelMb.MinibookingId = MinibookingService.GetByBookingAndMbOrder(Strings.Trim(cboBooking.Text), 1).MiniBookingId;
newRelMb.CreatedAt = DateAndTime.Now;
newRelMb.QtyRequested = inRequest.QtyRequested;
newRelMb.AssignmentOrder = 1;
RelOrderMbService.AddOrUpdate(newRelMb);
}
catch (Exception ex)
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Something went wrong.", "Could not change EXPORT Release: " + Constants.vbNewLine + ex.Message, this);
cboBooking.SelectedText = rel.ReleaseNumber;
}
}
}
}
private void FrmBookingReport_Load(object sender, EventArgs e)
{
listReport = MinibookingService.GetJointBooking(true).Where(b => b.MiniBookingId != 0).ToList();
VWBookingMinibookingBindingSource.DataSource = listReport;
cbSearchDate.Checked = false;
dtpFrom.Visible = false;
dtpTo.Visible = false;
}
public void populateGrid(List <VW_Booking> bkList)
{
var bookings = new List <string>();
var MiniBkList = new List <VW_BookingMinibooking>();
foreach (var bk in bkList)
{
bookings.Add(bk.BookingNumber);
}
MiniBkList = MinibookingService.GetJointBookingByBookingList(bookings);
VWBookingMinibookingBindingSource.DataSource = MiniBkList;
}
private void FrmAssignStorageExtra_Load(object sender, EventArgs e)
{
var allBookings = MinibookingService.GetJointBooking(true);
{
var withBlock = bookingComboBox;
withBlock.DataSource = allBookings;
withBlock.DisplayMember = "BookingNumber";
withBlock.ValueMember = "MinibookingId";
}
typeBunifuDropdown3.SelectedIndex = 0;
}
private void populateBookings()
{
string conditionBooking = "";
var vwMB = new MinibookingService();
{
var withBlock = bookingComboBox;
withBlock.DataSource = MinibookingService.GetJointBooking(bookingActivBookingBunifuToggleSwitch2.Value);
withBlock.DisplayMember = "MinibookingNumber";
withBlock.SelectedValue = "MiniBookingId";
withBlock.SelectedIndex = 0;
withBlock.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
withBlock.AutoCompleteSource = AutoCompleteSource.ListItems;
SelectedMBObj = (VW_BookingMinibooking)withBlock.SelectedItem;
}
}
private void FrmEDIManagement_Load(object sender, EventArgs e)
{
companies = dbCeres.getTableInfo("VW_CompanyCompanyType", "CompanyCode", "where [EDIRequired] = 1 order by CompanyCode");
// statusOutDropdown.SelectedIndex = 0
STATUSDropdown1.SelectedIndex = 0;
var vwMB = new MinibookingService();
bookingComboBox.DataSource = MinibookingService.GetJointBooking(bookingActivBookingBunifuToggleSwitch2.Value);
bookingComboBox.SelectedIndex = 0;
bookingComboBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
bookingComboBox.AutoCompleteSource = AutoCompleteSource.ListItems;
cboSSLine.DataSource = CompanyService.GetAllByCompanyTypeId((int)MdlEnum.CompanyType.Steamship_Line, new WTCCeresEntities());
cboSSLine.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cboSSLine.AutoCompleteSource = AutoCompleteSource.ListItems;
firstLoad = false;
}
/* TODO ERROR: Skipped EndRegionDirectiveTrivia */
/* TODO ERROR: Skipped RegionDirectiveTrivia */
private void LoadGridMiniBooking(string BookingNumber)
{
VW_UnitSourceMiniUnit muRow = (VW_UnitSourceMiniUnit)dgvMiniUnit.Rows[0].DataBoundItem;
SelectedCargosList.Clear();
if (muRow.CargoTypeCode.Equals("BAG"))
{
SelectedCargosList.Add("BAG");
}
else
{
SelectedCargosList.Add("BLK");
SelectedCargosList.Add("BGR");
}
VWBookingMinibooking.DataSource = MinibookingService.GetJointBookingToAsnByFilter(muRow.CustomerName, SelectedCargosList, txtBookingNumber.Text);
shouldNotAssignList.Clear();
checkAsnButton();
}
public void LoadForm(List <VW_ReleaseOrderMinibooking> ReleaseDetMinibooking, int ReleaseOrderId)
{
{
var withBlock = cboBooking;
BkMbList = MinibookingService.GetJointBooking(true);
withBlock.DataSource = BkMbList;
withBlock.DisplayMember = "MinibookingNumber";
withBlock.ValueMember = "MinibookingId";
}
RelOrderId = ReleaseOrderId;
BkMbList = MinibookingService.GetJointBooking(true);
var mbIdAssignedList = new List <int>();
mbIdAssignedList = (from r in ReleaseDetMinibooking
select r.MinibookingId).ToList();
BkMbList = BkMbList.Where(b => !mbIdAssignedList.Contains(b.MiniBookingId)).ToList();
cboBooking.DataSource = BkMbList;
}
private void btnComplete_Click(object sender, EventArgs e)
{
VW_BookingMinibooking mb;
var mbService = new MinibookingService();
if (GoodToGo())
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(cboCarrierOut.SelectedValue, 0, false)))
{
var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Warning:", "There is not carrier selected. If you proceed, the carrier out information will be removed from the selected bookings." + Constants.vbNewLine + " Would you like to proceed?", My.Resources.Resources.warning, this);
if (result == DialogResult.Yes)
{
foreach (DataGridViewRow row in dgvBookings.Rows)
{
if (row.Cells[0].Equals("✔"))
{
mb = (VW_BookingMinibooking)row.DataBoundItem;
mbService.UpdateCarrierOut(mb.MiniBookingId, Conversions.ToInteger(cboCarrierOut.SelectedValue));
}
}
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success!", "Carrier out updated with success", this);
Close();
}
}
else
{
foreach (DataGridViewRow row in dgvBookings.Rows)
{
if (row.Cells[0].Value.Equals("✔"))
{
mb = (VW_BookingMinibooking)row.DataBoundItem;
EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, mb.MinibookingNumber, "UPDATE", "CARRIER BOOKING ASSIGNMENT", "Assigned " + cboCarrierOut.Text + " to Booking " + mb.MinibookingNumber);
mbService.UpdateCarrierOut(mb.MiniBookingId, Conversions.ToInteger(cboCarrierOut.SelectedValue));
}
}
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success!", "Carrier out updated with success", this);
Close();
}
}
}
// Private Function PopulateCustomerBookings() As String
// Dim ThisBooking As DataRow
// Dim SQL As String = ""
// Dim ThisCustomer As String = ""
// Dim TempLine As String = ""
// SQL = "Select * From [Container Bookings] Order By [Customer Name]"
// Dim DbObjDataTable As New System.Data.DataTable
// Dim DbObjAdapter = New System.Data.SqlClient.SqlDataAdapter(SQL, DBConnect)
// Dim DbObjCommand = New System.Data.SqlClient.SqlCommandBuilder(DbObjAdapter)
// DbObjAdapter.Fill(DbObjDataTable)
// ComboCustomerAssign.Items.Clear()
// ' ComboBookingAssign.Items.Clear()
// For Each ThisBooking In DbObjDataTable.Rows
// If IsDBNull(ThisBooking("Customer Name")) = False AndAlso RTrim(ThisBooking("Customer Name")) <> "" Then
// ThisCustomer = RTrim(ThisBooking("Customer Name"))
// If NewCustomer(ThisCustomer) = True Then
// ComboCustomerAssign.Items.Add(ThisCustomer)
// End If
// TempLine += DoFunctions.PadToString(ThisBooking("Customer Name"), 50) + DoFunctions.PadToString(ThisBooking("Booking Number"), 20)
// End If
// Next
// 'DBConnect.Close()
// Return TempLine
// End Function
// Private Function NewCustomer(ThisCustomer As String) As Boolean
// Dim x As Int32 = 0
// With ComboCustomerAssign
// For x = 0 To .Items.Count - 1
// If ThisCustomer = .Items(x).ToString Then
// Return False
// End If
// Next x
// End With
// Return True
// End Function
// Private Sub ComboCustomerAssign_SelectedIndexChanged(sender As Object, e As EventArgs)
// Call PopulateAllCustomerBookings(ComboCustomerAssign.SelectedItem)
// If Not IsNothing(typeBunifuDropdown3.Text) And Not IsNothing(selectectedBooking) And Not IsNothing(ComboCustomerAssign.Text) Then
// TouchAssignExtra.Enabled = True
// Else
// TouchAssignExtra.Enabled = False
// End If
// End Sub
private void PopulateAllCustomerBookings(string ThisCustomer)
{
int x = 0;
// ComboBookingAssign.Items.Clear()
// For x = 1 To Len(AllCustomerBookings) Step 70
// If ThisCustomer = RTrim(Mid(AllCustomerBookings, x, 50)) Then
// ComboBookingAssign.Items.Add(RTrim(Mid(AllCustomerBookings, x + 50, 20)))
// End If
// Next x
var vwMB = new MinibookingService();
// bookingComboBox.DataSource = vwMB.GetJointBookingByCustomer(ThisCustomer)
// bookingComboBox.SelectedIndex = 0
// bookingComboBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend
// bookingComboBox.AutoCompleteSource = AutoCompleteSource.ListItems
}
private void frmcfialabel_load(object sender, EventArgs e)
{
tooltip.SetToolTip(pasteBunifuButton, "Paste");
tooltip.SetToolTip(addBttn, "Add Label");
MdlOptionsManagement.getCFIALabelFunctionalities(this);
{
var withBlock = cboBooking;
withBlock.DataSource = MinibookingService.GetJointBooking(tgActiveBooking.Value);
withBlock.DisplayMember = "BookingNumber";
withBlock.ValueMember = "MinibookingId";
}
cboBooking.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cboBooking.AutoCompleteSource = AutoCompleteSource.ListItems;
// tbCustomer.DroppedDown = True
fromdatetimepicker.Value = DateAndTime.Now;
todatetimepicker.Value = DateAndTime.Now;
sampletitlecombobox.SelectedIndex = 1;
resizeCagoLabels(1);
}
private void btnComplete_Click(object sender, EventArgs e)
{
if (GoodToGo())
{
var relOrderService = new ReleaseOrderService();
var relService = new ReleaseService();
bool isInserted;
int relReqId;
if (isNewRequest)
{
inRequest = new InboundRequest();
inRequest.RequestStatusId = (int)MdlEnum.RequestStatus.PENDING_REPLY;
inRequest.DateRequested = DateAndTime.Now;
inRequest.IsOpenRequest = true;
}
inRequest.ShippingLineId = Conversions.ToInteger(cboSSLine.SelectedValue);
inRequest.QtyRequested = (int)Math.Round(nudQtyCans.Value);
inRequest.ContainerSizeId = Conversions.ToInteger(cboCanSize.SelectedValue);
inRequest.ContainerState = Conversions.ToString(cboCanState.SelectedItem);
inRequest.BookingTypeId = Conversions.ToInteger(cboReleaseType.SelectedValue);
isInserted = inReqServ.AddOrUpdate(inRequest);
relReqId = inReqServ.GetLastInboundRequestId();
if (isInserted)
{
if (isExportRelease)
{
if (isNewRequest)
{
rel = new Release();
isChangeOfExportBooking = false;
relOrder = new ReleaseOrder();
}
rel.ReleaseNumber = Strings.Trim(cboBooking.Text);
if (relService.AddOrUpdate(rel))
{
relOrder.ReleaseId = relService.GetLastReleaseId();
relOrder.DateAccepted = default;
relOrder.CreatedAt = DateAndTime.Now;
relOrder.InboundRequestId = inReqServ.GetLastInboundRequestId();
relOrder.QtyAccepted = 0;
if (relOrderService.AddOrUpdate(relOrder))
{
if (isChangeOfExportBooking)
{
ReplaceExportBookingNumber();
}
else
{
var newRelMb = new ReleaseOrderMinibooking();
var relOrdService = new ReleaseOrderMinibookingService();
newRelMb.ReleaseOrderId = relOrderService.GetLastReleaseOrderId();
newRelMb.MinibookingId = MinibookingService.GetByBookingAndMbOrder(Strings.Trim(cboBooking.Text), 1).MiniBookingId;
newRelMb.CreatedAt = DateAndTime.Now;
newRelMb.QtyRequested = inRequest.QtyRequested;
newRelMb.AssignmentOrder = 1;
relOrdService.AddOrUpdate(newRelMb);
}
Close();
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Booking export not saved", "Something went wrong and the export booking request was not saved." + Constants.vbNewLine + "Please try again.", this);
}
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Booking export not saved", "Something went wrong and the export booking request was not saved." + Constants.vbNewLine + "Please try again.", this);
}
}
else
{
Close();
}
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Request not saved", "Something went wrong and the request was not saved." + Constants.vbNewLine + "Please try again.", this);
}
}
}
private void tgActiveBooking_OnValuechange(object sender, EventArgs e)
{
cboBooking.DataSource = MinibookingService.GetJointBooking(tgActiveBooking.Value);
}
private void activeToggleSwitch_OnValuechange(object sender, EventArgs e)
{
listReport = MinibookingService.GetJointBooking(activeToggleSwitch.Value).Where(b => b.MiniBookingId != 0).ToList();
VWBookingMinibookingBindingSource.DataSource = listReport;
}
