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;
}
}
}
}
public bool AddOrUpdate(ReleaseOrderMinibooking releaseDetailMinibooking)
{
bool isSaved = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
rdm = releaseDetailMinibooking;
if (releaseDetailMinibooking.ReleaseOrderMinibookingId == 0)
{
db.ReleaseOrderMinibooking.Add(releaseDetailMinibooking);
}
else
{
db.ReleaseOrderMinibooking.AddOrUpdate(releaseDetailMinibooking);
}
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message + " - " + ex.InnerException.Message;
isSaved = false;
}
}
return(isSaved);
}
private void btnComplete_Click(object sender, EventArgs e)
{
var relmbVW = new VW_ReleaseOrderMinibooking();
var relmb = new ReleaseOrderMinibooking();
VW_BookingMinibooking bk = (VW_BookingMinibooking)cboBooking.SelectedItem;
relmb.MinibookingId = bk.MiniBookingId;
relmb.ReleaseOrderId = RelOrderId;
relmb.CreatedAt = DateAndTime.Now;
if (relMbService.AddOrUpdate(relmb))
{
Close();
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("", "", this);
}
}
public bool Delete(int ReleaseDetailMiniboolingId)
{
bool isSaved = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
rdm = db.ReleaseOrderMinibooking.Find(ReleaseDetailMiniboolingId);
db.ReleaseOrderMinibooking.Remove(rdm);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message + " - " + ex.InnerException.Message;
isSaved = false;
}
}
return(isSaved);
}
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);
}
}
}
public bool AddOrUpdate(ReleaseOrderMinibooking releaseDetailMinibooking)
{
return(repository.AddOrUpdate(releaseDetailMinibooking));
}
