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 btnAddBooking_Click(object sender, EventArgs e)
{
ReleaseOrder SelectedRelDetail = (ReleaseOrder)dgvReleaseDetail.CurrentRow.DataBoundItem;
My.MyProject.Forms.FrmAddEditReleaseMb.LoadForm(ReleaseDetMinibooking, SelectedRelDetail.ReleaseOrderId);
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmAddEditReleaseMb, this);
ReleaseDetMinibooking = ReleaseOrderMinibookingService.GetAllVWByRelOrderId(SelectedRelDetail.ReleaseOrderId);
dgvBookingRelease.DataSource = null;
dgvBookingRelease.DataSource = ReleaseDetMinibooking;
}
private void dgvReleaseDetail_SelectionChanged(object sender, EventArgs e)
{
if (dgvReleaseDetail.Rows.Count > 0)
{
try
{
relOrder = (ReleaseOrder)dgvReleaseDetail.CurrentRow.DataBoundItem;
ReleaseDetMinibooking = ReleaseOrderMinibookingService.GetAllVWByRelOrderId(relOrder.ReleaseOrderId);
dgvBookingRelease.DataSource = null;
dgvBookingRelease.DataSource = ReleaseDetMinibooking;
}
catch (Exception ex)
{
}
}
}
public void PopulateInfo(VW_Release rel)
{
LoadForm();
firstLoad = true;
Release = rel;
ReleaseId = rel.ReleaseId;
RelReq = InboundRequestService.GetVWById(rel.InboundRequestId);
lblReleaseType.Text = rel.ReleaseType;
tbReleaseNumber.Text = rel.ReleaseNumber;
lblReqRelease.Text = RelReq.TotalQtyAccptOfRequest.ToString();
RelOrderList = ReleaseOrderService.GetAllByReleaseId(rel.ReleaseId);
dgvReleaseDetail.DataSource = RelOrderList;
if (dgvReleaseDetail.Rows.Count > 0)
{
ReleaseOrder relOrder = (ReleaseOrder)dgvReleaseDetail.Rows[0].DataBoundItem;
ReleaseDetMinibooking = ReleaseOrderMinibookingService.GetAllVWByRelOrderId(relOrder.ReleaseOrderId);
dgvBookingRelease.DataSource = null;
dgvBookingRelease.DataSource = ReleaseDetMinibooking;
}
// UpdateBookingCbo()
firstLoad = false;
CalculateQtys();
CheckButtons();
}
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);
}
}
}
