private void dgvRequests_SelectionChanged(object sender, EventArgs e)
{
if (dgvRequests.Rows.Count > 0 && firstLoad == false)
{
SelectedInboundrequest = (VW_InboundRequest)dgvRequests.CurrentRow.DataBoundItem;
var list = ReleaseOrderService.GetAllVWByInboundRequestId(SelectedInboundrequest.InboundRequestId);
ReleaseOrderList = new SortableBindingList <VW_ReleaseOrder>(list);
VWReleaseOrderBindingSource.DataSource = ReleaseOrderList;
}
CheckButtons();
}
private void bdnSaveRelease_Click(object sender, EventArgs e)
{
{
var withBlock = My.MyProject.Forms.FrmUpdateReqStatus;
withBlock.RelOrderList = ReleaseOrderService.GetAllVWByReleaseId(ReleaseId);
withBlock.cboRelOrder.DataSource = withBlock.RelOrderList;
withBlock.ReleaseList = ReleaseService.GetAllVWByInboundReqId(RelReq.InboundRequestId);
withBlock.VWReleaseBindingSource.DataSource = withBlock.ReleaseList;
}
Close();
}
private void cboReleaseType_SelectedIndexChanged(object sender, EventArgs e)
{
if (!firstLoad && !cboReleaseType.Text.Equals("REPO") && !cboReleaseType.Text.Equals(""))
{
// If user is changing from REPO to EXPORT, check if release Order already exists
if (!isNewRequest && inRequest.BookingTypeId == (int)MdlEnum.BookingType.REPO)
{
bool existPreviousReleaseOrders;
existPreviousReleaseOrders = ReleaseOrderService.GetAllVWByInboundRequestId(inRequest.InboundRequestId).Count > 0;
// Stop user from changing release type, if there are repo releases under this request
if (existPreviousReleaseOrders)
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Operation not allowed.", "Can not change REPO to EXPORT release." + Constants.vbNewLine + "It seems like REPO release(s) already exist under this request." + Constants.vbNewLine + " To proceed, delete the release(s) of this request or create a new request.", this);
cboReleaseType.SelectedItem = "REPO";
}
else
{
if (cboReleaseType.Text.Equals("IMPORT"))
{
cboBooking.DataSource = BookingList.Where(b => b.BookingTypeId == (int)MdlEnum.BookingType.IMPORT).ToList();
}
else
{
cboBooking.DataSource = BookingList.Where(b => b.BookingTypeId != (int)MdlEnum.BookingType.IMPORT).ToList();
}
isExportRelease = true;
pnlBooking.Show();
}
}
else
{
if (cboReleaseType.Text.Equals("IMPORT"))
{
cboBooking.DataSource = BookingList.Where(b => b.BookingTypeId == (int)MdlEnum.BookingType.IMPORT).ToList();
}
else
{
cboBooking.DataSource = BookingList.Where(b => b.BookingTypeId != (int)MdlEnum.BookingType.IMPORT).ToList();
}
isExportRelease = true;
pnlBooking.Show();
}
}
else
{
isExportRelease = false;
pnlBooking.Hide();
}
}
public void PopulateInfo(VW_InboundRequest req)
{
LoadForm();
firstLoad = true;
btnManageBal.Enabled = true;
RelReq = req;
cbStatus.SelectedValue = req.RequestStatusId;
lblSSLineName.Text = req.SSLineCode;
lblRelType.Text = req.ReleaseType;
lblSize.Text = req.ContainerSizeName;
lblReqDate.Text = req.DateRequested.ToString("dd-MMMd-yyyy");
fu = InboundFollowUpService.GetByOpenInboundRequestId(req.InboundRequestId);
ReleaseList = ReleaseService.GetAllVWByInboundReqId(RelReq.InboundRequestId);
if (!Information.IsNothing(fu))
{
followUpQty = RelReq.TotalQtyAccptOfRequest - SumAddedLocations;
var newRel = new VW_Release();
newRel.ReleaseNumber = "FOLLOW UP";
newRel.TotalQtyAccepted = followUpQty;
pnlFollowUp.Show();
ReleaseList.Add(newRel);
}
var inReqDeclinedList = ReleaseList.Where(r => r.InboundReqDeclinedQtyId != 0).ToList();
if (inReqDeclinedList.Count > 0)
{
InReqDeclined = InboundReqDeclinedQtyService.GetById(inReqDeclinedList[0].InboundReqDeclinedQtyId);
var newRel = new VW_Release();
newRel.ReleaseNumber = InReqDeclined.DeclineStatus;
newRel.TotalQtyAccepted = InReqDeclined.QtyDeclined;
ReleaseList.Add(newRel);
btnManageBal.Enabled = false;
}
VWReleaseBindingSource.DataSource = null;
VWReleaseBindingSource.DataSource = ReleaseList;
dgvRelease.DataSource = null;
dgvRelease.DataSource = VWReleaseBindingSource.DataSource;
if (!Information.IsNothing(dgvRelease.CurrentRow) && dgvRelease.Rows.Count > 0 && InReqDeclined.InboundReqDeclinedQtyId == 0)
{
VW_Release focusedRel = (VW_Release)dgvRelease.CurrentRow.DataBoundItem;
RelOrderList = ReleaseOrderService.GetAllVWByReleaseId(focusedRel.ReleaseId);
cboRelOrder.DataSource = RelOrderList;
cboRelOrder.DisplayMember = "RelOrder";
cboRelOrder.ValueMember = "ReleaseOrderId";
}
firstLoad = false;
CalculateQtys();
}
private void btnDeleteRelease_Click(object sender, EventArgs e)
{
var relService = new ReleaseOrderService();
var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Are you sure of this?", "Release Order: " + SelectedReleaseOrder.ReleaseNumber + " - " + SelectedReleaseOrder.RelOrder + Constants.vbNewLine + "Are you sure you want to delete this release? This can not be undone", My.Resources.Resources.warning, this);
if (result == DialogResult.Yes)
{
if (relService.Delete(SelectedReleaseOrder.ReleaseOrderId))
{
var list = ReleaseOrderService.GetAllVWByReleaseId(SelectedReleaseOrder.ReleaseId);
ReleaseOrderList = new SortableBindingList <VW_ReleaseOrder>(list);
VWReleaseOrderBindingSource.DataSource = ReleaseOrderList;
Close();
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Release Order not deleted.", "Something went wrong and the release order was not deleted. Please try again.", this);
}
}
}
private void cboBooking_SelectedIndexChanged(object sender, EventArgs e)
{
// Check if old release number is being changed
if (!firstLoad && !isNewRequest && Information.IsNothing(rel.ReleaseNumber) && !((rel.ReleaseNumber ?? "") == (cboBooking.Text ?? "")) && Convert.ToInt32(cboBooking.SelectedValue) != 0)
{
bool existPrevConfReleaseOrders;
OrderList = ReleaseOrderService.GetAllVWByInboundRequestId(inRequest.InboundRequestId);
if (OrderList.Count > 0)
{
existPrevConfReleaseOrders = OrderList.Where(o => o.QtyAcceptedInOrder > 0).Count() > 0;
if (existPrevConfReleaseOrders)
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Operation not allowed.", "Can not change the EXPORT Release Number." + Constants.vbNewLine + "It seems like there are confirmed containers under this release number." + Constants.vbNewLine + "Create a new request to proceed.", this);
cboBooking.SelectedText = rel.ReleaseNumber;
isChangeOfExportBooking = false;
}
else
{
isChangeOfExportBooking = true;
}
}
}
}
private void PopulateRelOrder()
{
if (!Information.IsNothing(dgvRelease.CurrentRow) && !firstLoad)
{
var relNumb = dgvRelease.CurrentCell.Value;
if (!Information.IsNothing(relNumb) && !relNumb.Equals("WRITE OFF") && !relNumb.Equals("DECLINED") && !relNumb.Equals("FOLLOW UP"))
{
SelectedRelease = (VW_Release)dgvRelease.CurrentRow.DataBoundItem;
RelOrderList = ReleaseOrderService.GetAllVWByReleaseId(SelectedRelease.ReleaseId).Where(r => !(r.ReleaseNumber == "WRITE OFF") && !(r.ReleaseNumber == "DECLINED")).ToList();
cboRelOrder.DataSource = RelOrderList;
cboRelOrder.DisplayMember = "RelOrder";
cboRelOrder.ValueMember = "ReleaseOrderId";
}
else
{
cboRelOrder.DataSource = null;
}
}
else
{
cboRelOrder.DataSource = null;
}
}
public void LoadInfo(VW_InboundRequest inReq)
{
loadForm();
firstLoad = true;
inRequest = InboundRequestService.GetById(inReq.InboundRequestId);
cboSSLine.SelectedValue = inRequest.ShippingLineId;
nudQtyCans.Value = inRequest.QtyRequested;
cboReleaseType.SelectedValue = inRequest.BookingTypeId;
cboCanState.SelectedItem = inRequest.ContainerState;
cboCanSize.SelectedValue = inRequest.ContainerSizeId;
lblTitle.Text = "Update Request";
if (!inReq.ReleaseType.Equals("REPO"))
{
relOrder = ReleaseOrderService.GetAllByInboundRequestId(inReq.InboundRequestId).ToList()[0];
rel = ReleaseService.GetByReleaseId(relOrder.ReleaseId);
// RelOrderMbList = ReleaseOrderMinibookingService.GetAllByReleaseOrderId(relOrder.ReleaseOrderId)
// relOrderMb = RelOrderMbList.Where(Function(r) r.AssignmentOrder = 1).ToList(0)
cboBooking.SelectedText = rel.ReleaseNumber;
}
firstLoad = false;
}
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);
}
}
}
