public void loadForm(bool isDeleteMB)
{
shouldRemoveRow = isDeleteMB;
btnSaveMb.Enabled = false;
dgvMiniBks.Rows.Clear();
{
var withBlock = My.MyProject.Forms.FrmEditAddBooking;
if (isDeleteMB == false)
{
tempDeletedMBDT = new List <Minibooking>(withBlock.originalMBTable);
}
totalContInBkg = (int)Math.Round(withBlock.totalContainersNumericUpDown.Value);
containerToAsn = totalContInBkg - getTotalTempMBNumb();
lblContInMb.Text = withBlock.getTotalContInMB().ToString();
lbltotalNumber.Text = totalContInBkg.ToString();
lblTotaltoBeAsgn.Text = containerToAsn.ToString();
// Dim cmdtyList As List(Of VW_MinibookingCommodity) = FrmEditAddBooking.MbCmdtyList
int NumbOfCanMb = 0;
foreach (var mb in tempDeletedMBDT)
{
// NumbOfCanMb = tempDeletedMBDT.Where(Function(m) m.MiniBookingId = mb.MiniBookingId).ToList(0).NumberOfContainer
dgvMiniBks.Rows.Add(withBlock.bkgNumbTextBox1.Text + MdlBookingManagement.digitToLetter(mb.MiniBookingOrder), mb.NumberOfContainer);
}
}
}
public void loadForm(bool isDeleteMU)
{
numbTotalBefore = 0m;
shouldRemoveRow = isDeleteMU;
btnUpdateMu.Enabled = false;
dgvMiniUnits.Rows.Clear();
string cmdtyCode;
string gradeCode;
string custName;
{
var withBlock = My.MyProject.Forms.FrmEditAddRailList;
if (isDeleteMU == false)
{
tempDt = withBlock.miniUnitDT;
}
else
{
tempDt = tempDeletedMUDT;
}
// Populate dgv
string totalbStr;
foreach (var mu in tempDt)
{
if (withBlock.cboCargoType.Text.Equals("BULK"))
{
mu.TotalBilled = Convert.ToDecimal(mu.TotalBilled);
}
// totalbStr = FormatNumber(mu.TotalBilled.ToString, 3)
else
{
mu.TotalBilled = Convert.ToInt32(mu.TotalBilled);
// totalbStr = FormatNumber(mu.TotalBilled.ToString, 0)
}
cmdtyCode = CommodityService.GetById(mu.CommodityId).CommodityCode;
gradeCode = GradeService.GetById(mu.GradeId).GradeCode;
custName = CompanyService.GetVWById(mu.CustomerId).CompanyName;
dgvMiniUnits.Rows.Add(withBlock.txtUnitNumber.Text + "(" + MdlBookingManagement.digitToLetter((object)mu.MiniUnitOrder).ToUpper() + ")", custName, cmdtyCode + " " + gradeCode, (object)mu.TotalBilled);
numbTotalBefore = (decimal)(numbTotalBefore + mu.TotalBilled);
}
// Set texts.
if (withBlock.cboCargoType.Text.Equals("BULK"))
{
labelTotalSomething.Text = "Total Weight:";
lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("0.###");
numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore;
lblTotaltoBeAsgn.Text = numbToReassign.ToString("0.###");
nucTotal.DecimalPlaces = 3;
}
else
{
labelTotalSomething.Text = "Total Pieces:";
lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("#");
numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore;
lblTotaltoBeAsgn.Text = numbToReassign.ToString("#");
nucTotal.DecimalPlaces = 0;
}
}
}
private void dgvBookings_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
var ServiceCodeCel = dgvBookings.Rows[e.RowIndex].Cells["ServiceCode"];
var BookingNumberCel = dgvBookings.Rows[e.RowIndex].Cells["MinibookingNumber"];
var checkCell = dgvBookings.Rows[e.RowIndex].Cells["check"];
var cans = dgvBookings.Rows[e.RowIndex].Cells["NumberOfContainer"];
checkCell.Style.Font = new Font("Arial", 15.5f, FontStyle.Bold);
checkCell.Style.ForeColor = Color.Black;
checkCell.Style.SelectionForeColor = Color.Black;
if (MdlBookingManagement.IsOdd(e.RowIndex))
{
checkCell.Style.SelectionBackColor = Color.FromKnownColor(KnownColor.Control);
}
else
{
checkCell.Style.SelectionBackColor = Color.White;
}
checkCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
if (Information.IsNothing(checkCell.Value))
{
checkCell.Value = "✔";
}
BookingNumberCel.Style.Font = new Font("Arial", 10f, FontStyle.Bold);
BookingNumberCel.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
cans.Style.Font = new Font("Arial", 10f, FontStyle.Bold);
cans.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
ServiceCodeCel.Style.ForeColor = Color.White;
ServiceCodeCel.Style.SelectionForeColor = Color.White;
ServiceCodeCel.Style.Font = new Font("Arial", 10f, FontStyle.Bold);
ServiceCodeCel.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// REPO Color.Thistle
// EXPORT Color.PowderBlue
switch (ServiceCodeCel.Value)
{
case "BAG":
{
ServiceCodeCel.Style.SelectionBackColor = Color.Olive;
ServiceCodeCel.Style.BackColor = Color.DarkKhaki;
break;
}
case "BGR":
{
ServiceCodeCel.Style.SelectionBackColor = Color.DarkGoldenrod;
ServiceCodeCel.Style.BackColor = Color.Goldenrod;
break;
}
case "BLK":
{
ServiceCodeCel.Style.SelectionBackColor = Color.DarkKhaki;
ServiceCodeCel.Style.BackColor = Color.DarkSeaGreen;
break;
}
}
}
private void btnAsnToMb_Click(object sender, EventArgs e)
{
int mbtempId = 0;
string mbNumb;
string letter;
mbNumb = Conversions.ToString(cboMinibooking.SelectedItem);
for (int i = dgvCansToTransfer.RowCount - 1; i >= 0; i -= 1)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(dgvCansToTransfer.Rows[i].Cells[1].Value, true, false)))
{
tempSelectedCans.RemoveAt(i);
letter = mbNumb.Split('(')[1].Replace(")", "");
mbtempId = MdlBookingManagement.letterToDigit(letter) - 1;
dgvCansAsnMb.Rows.Add(dgvCansToTransfer.Rows[i].Cells[0].Value, false, dgvCansToTransfer.Rows[i].Cells[2].Value, mbNumb, mbtempId);
}
}
updateGgvCansToTransfer();
}
private void dgvVessel_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
var checkCell = dgvVessel.Rows[e.RowIndex].Cells["check"];
checkCell.Style.Font = new Font("Arial", 15.5f, FontStyle.Bold);
checkCell.Style.ForeColor = Color.Black;
checkCell.Style.SelectionForeColor = Color.Black;
if (MdlBookingManagement.IsOdd(e.RowIndex))
{
checkCell.Style.SelectionBackColor = Color.FromKnownColor(KnownColor.Control);
}
else
{
checkCell.Style.SelectionBackColor = Color.White;
}
checkCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
if (Information.IsNothing(checkCell.Value))
{
checkCell.Value = " ";
}
}
private void checkUnit()
{
PictureBox1.Hide();
var fBold = new Font("Segoe UI", 11f, FontStyle.Bold);
var fNormal = new Font("Segoe UI", 11f, FontStyle.Regular);
if (dontAsnRadioButton.Checked)
{
dontAsnLabel.Font = fBold;
chageUnitCustLabel.Font = fNormal;
warningLabel.Text = "";
openFormLinkLabel.Text = "";
saveButton.Enabled = true;
}
else if (changeUnitCustRadioButton.Checked)
{
dontAsnLabel.Font = fNormal;
chageUnitCustLabel.Font = fBold;
if (MdlBookingManagement.isAssignedToOthersMBs(_muID))
{
PictureBox1.Show();
warningLabel.Text = "This unit is already assigned to another booking so the customer can not be changed. Please " + "create a Mini Unit with the desired customer.";
openFormLinkLabel.Text = "Edit Unit Source";
PictureBox1.Image = My.Resources.Resources.icon_not_available;
saveButton.Enabled = false;
}
else
{
PictureBox1.Show();
warningLabel.Text = "Able to change Customer Name";
openFormLinkLabel.Text = "";
PictureBox1.Image = My.Resources.Resources.icon_available;
saveButton.Enabled = true;
}
}
}
private void dgvAllBookings_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
bool value = Conversions.ToBoolean(dgvAllBookings.Rows[e.RowIndex].Cells[0].Value);
VW_BookingMinibooking mbRow;
VW_UnitSourceMiniUnit muRow;
mbRow = (VW_BookingMinibooking)dgvAllBookings.Rows[e.RowIndex].DataBoundItem;
if (value == false)
{
dgvAllBookings.Rows[e.RowIndex].Cells[0].Value = true;
numbSelectMU = +1;
// selectedUnits.Add(muID, MUSource)
// Check if mini unit is already assigned to mini booking
for (int i = 0, loopTo = dgvMiniUnit.Rows.Count - 1; i <= loopTo; i++)
{
muRow = (VW_UnitSourceMiniUnit)dgvMiniUnit.Rows[i].DataBoundItem;
// check if mu was already assigned
if (Information.IsNothing(muRow.CommodityId) || muRow.CommodityId == 0)
{
var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Warning:", "There's no commodity added to the unit '" + muRow.MiniunitNumber + "' Yet. Would you like to add it now? " + "If No is selected, the unit will not be added to the booking", My.Resources.Resources.caution, this);
if (result == DialogResult.Yes)
{
My.MyProject.Forms.FrmEditAddRailList.isNewRecord = false;
var unit = UnitSourceService.GetVWById(muRow.UnitSourceId);
var unitList = new List <VW_UnitSource>();
unitList.Add(unit);
My.MyProject.Forms.FrmEditAddRailList.isMultiEdit = false;
My.MyProject.Forms.FrmEditAddRailList.isNewRecord = false;
My.MyProject.Forms.FrmEditAddRailList.LoadForm(unitList);
Close();
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmEditAddRailList, My.MyProject.Forms.FrmParentScreen);
}
else
{
shouldNotAssignList.Add(muRow.ToString() + "|" + mbRow.MiniBookingId.ToString());
}
}
// If cmdty and grade doesnt exist in mb, ask if should add.
else if (MdlBookingManagement.miniUnitMissingCommodity(mbRow.MiniBookingId, muRow.CommodityId, muRow.GradeId))
{
var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Commodity and Rate doesn't match", "The commodity and grade of the unit '" + muRow.MiniunitNumber + "' (" + muRow.GradeCode + " " + muRow.CommodityCode + ") is not added to the booking '" + mbRow.BookingNumber + "'. Would you like to add it now? " + "If No is selected, the unit will not be added to the booking", My.Resources.Resources.caution, this);
if (result == DialogResult.Yes)
{
MdlBookingManagement.saveBkgCommodity(mbRow.MiniBookingId, muRow.CommodityId, muRow.GradeId);
getCmdyAndGrades(mbRow.MiniBookingId);
// muRow =
//VWUnitSourceMiniUnitBindingSource.DataSource.Item(muRow) = MiniUnitService.GetVWByMUId(muRow.MiniUnitId);
}
else
{
shouldNotAssignList.Add(muRow.MiniUnitId.ToString() + "|" + mbRow.MiniBookingId.ToString());
}
}
else if (MdlBookingManagement.miniUnitAlreadyAssigned(muRow.MiniUnitId, mbRow.MiniBookingId, Conversions.ToBoolean(0)))
{
shouldNotAssignList.Add(muRow.MiniUnitId.ToString() + "|" + mbRow.MiniBookingId.ToString());
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Unit source already added to booking", "Selected Unit source is already added to the booking " + mbRow.BookingNumber + ", so it will not be added again.", this);
}
// If cmdty and grade doesnt exist in mb, ask if should add.
if (mbRow.CustomerId != muRow.CustomerId)
{
var result = My.MyProject.Forms.MessageBoxCustomerMatchingWarning.ShowDialog(mbRow, muRow, this);
if (result == DialogResult.Yes & shouldChangeCustomer == true)
{
muRow.CustomerId = mbRow.CustomerId;
MdlBookingManagement.updateCustomer(MiniUnitService.GetById(muRow.MiniUnitId));
}
else
{
shouldNotAssignList.Add(muRow.MiniUnitId.ToString() + "|" + mbRow.MiniBookingId.ToString());
}
}
}
}
else
{
dgvAllBookings.Rows[e.RowIndex].Cells[0].Value = false;
numbSelectMU = -1;
for (int i = 0, loopTo1 = dgvMiniUnit.Rows.Count - 1; i <= loopTo1; i++)
{
muRow = (VW_UnitSourceMiniUnit)dgvMiniUnit.Rows[i].DataBoundItem;
shouldNotAssignList.Remove(muRow.MiniUnitId.ToString() + "|" + mbRow.MiniBookingId.ToString());
}
}
}
checkAsnButton();
}
private void dgvReleaseDistribution_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
if (inboutTabs.SelectedIndex == 1)
{
var DateRequested = dgvReleaseDistribution.Rows[e.RowIndex].Cells["DataGridViewTextBoxColumn17"];
var checkCell = dgvReleaseDistribution.Rows[e.RowIndex].Cells["checkDist"];
var cansRequested = dgvReleaseDistribution.Rows[e.RowIndex].Cells["QtyRequestedDataGridViewTextBoxColumn4"];
var cansAccepted = dgvReleaseDistribution.Rows[e.RowIndex].Cells["TotalAcceptedOfRequestDataGridViewTextBoxColumn"];
var StatusName = dgvReleaseDistribution.Rows[e.RowIndex].Cells["StatusNameDataGridViewTextBoxColumn2"];
var relNumber = dgvReleaseDistribution.Rows[e.RowIndex].Cells["ReleaseNumberDataGridViewTextBoxColumn2"];
var carrier = dgvReleaseDistribution.Rows[e.RowIndex].Cells["DataGridViewTextBoxColumn18"];
DataGridViewImageCell msgImg = (DataGridViewImageCell)dgvReleaseDistribution.Rows[e.RowIndex].Cells["MessageColumn"];
var msg = dgvReleaseDistribution.Rows[e.RowIndex].Cells["msg"];
checkCell.Style.Font = new Font("Arial", 15.5f, FontStyle.Bold);
checkCell.Style.ForeColor = Color.Black;
checkCell.Style.SelectionForeColor = Color.Black;
if (MdlBookingManagement.IsOdd(e.RowIndex))
{
checkCell.Style.SelectionBackColor = Color.FromKnownColor(KnownColor.Control);
}
else
{
checkCell.Style.SelectionBackColor = Color.White;
}
checkCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
if (Information.IsNothing(checkCell.Value))
{
checkCell.Value = " ";
}
// dgvRequests.Columns(8).Height = 25
DateRequested.Style.Font = new Font("Arial", 10f, FontStyle.Bold);
DateRequested.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
carrier.Style.Font = new Font("Arial", 10f, FontStyle.Bold);
carrier.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
cansRequested.Style.Font = new Font("Arial", 11f, FontStyle.Bold);
cansRequested.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
cansAccepted.Style.Font = new Font("Arial", 11f, FontStyle.Bold);
cansAccepted.Style.ForeColor = Color.DarkGreen;
cansAccepted.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
StatusName.Style.ForeColor = Color.White;
StatusName.Style.SelectionForeColor = Color.White;
StatusName.Style.Font = new Font("Bahnschrift", 9f, FontStyle.Bold);
StatusName.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
int width = dgvReleaseDistribution.Columns["MessageColumn"].Width;
int heght = dgvReleaseDistribution.Rows[e.RowIndex].Height;
// msgImg.Style.BackColor = Color.White
// msgImg.Style.SelectionBackColor = Color.White
msgImg.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
msgImg.Style.SelectionBackColor = Color.FromArgb(64, 64, 64);
msgImg.Style.BackColor = Color.FromArgb(64, 64, 64);
switch (msg.Value)
{
case "New Message":
{
msgImg.Value = newImgMsg;
break;
}
case "Old Message":
{
msgImg.Value = oldImgMsg;
break;
}
default:
{
msgImg.Value = noImgMsg;
break;
}
}
switch (StatusName.Value)
{
case "ACCEPTED":
{
StatusName.Style.SelectionBackColor = Color.DarkGreen;
StatusName.Style.BackColor = Color.Green;
break;
}
case "PENDING REPLY":
{
StatusName.Style.SelectionBackColor = Color.DarkGoldenrod;
StatusName.Style.BackColor = Color.Goldenrod;
break;
}
case "DECLINED":
{
StatusName.Style.SelectionBackColor = Color.DarkRed;
StatusName.Style.BackColor = Color.Red;
break;
}
case "FOLLOW UP":
{
StatusName.Style.SelectionBackColor = Color.DarkOrange;
StatusName.Style.BackColor = Color.Orange;
break;
}
case "PARTIALLY ACCEPTED":
{
StatusName.Style.SelectionBackColor = Color.DarkOliveGreen;
StatusName.Style.BackColor = Color.DarkOliveGreen;
break;
}
}
}
}
private void dgvRequests_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
if (inboutTabs.SelectedIndex == 0)
{
var DateRequested = dgvRequests.Rows[e.RowIndex].Cells["DateRequestedDataGridViewTextBoxColumn2"];
var checkCell = dgvRequests.Rows[e.RowIndex].Cells["check"];
var cansRequested = dgvRequests.Rows[e.RowIndex].Cells["QtyRequestedDataGridViewTextBoxColumn3"];
var cansAccepted = dgvRequests.Rows[e.RowIndex].Cells["TotalQtyAccptOfRequest"];
var StatusName = dgvRequests.Rows[e.RowIndex].Cells["StatusNameDataGridViewTextBoxColumn3"];
DataGridViewButtonCell BtnAction = (DataGridViewButtonCell)dgvRequests.Rows[e.RowIndex].Cells["btnReqAction"];
checkCell.Style.Font = new Font("Arial", 15.5f, FontStyle.Bold);
checkCell.Style.ForeColor = Color.Black;
checkCell.Style.SelectionForeColor = Color.Black;
if (MdlBookingManagement.IsOdd(e.RowIndex))
{
checkCell.Style.SelectionBackColor = Color.FromKnownColor(KnownColor.Control);
}
else
{
checkCell.Style.SelectionBackColor = Color.White;
}
checkCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
if (Information.IsNothing(checkCell.Value))
{
checkCell.Value = " ";
}
BtnAction.Style.Font = new Font("Arial Narrow", 8.5f, FontStyle.Bold);
BtnAction.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
BtnAction.Style.SelectionForeColor = Color.White;
BtnAction.Style.ForeColor = Color.White;
// dgvRequests.Columns(8).Height = 25
DateRequested.Style.Font = new Font("Arial", 10f, FontStyle.Bold);
DateRequested.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
cansRequested.Style.Font = new Font("Arial", 11f, FontStyle.Bold);
cansRequested.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
cansAccepted.Style.Font = new Font("Arial", 11f, FontStyle.Bold);
cansAccepted.Style.ForeColor = Color.DarkGreen;
cansAccepted.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
StatusName.Style.ForeColor = Color.White;
StatusName.Style.SelectionForeColor = Color.White;
StatusName.Style.Font = new Font("Bahnschrift", 9f, FontStyle.Bold);
StatusName.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
BtnAction.Value = "UPDATE STATUS";
BtnAction.Style.BackColor = Color.OliveDrab;
BtnAction.Style.SelectionBackColor = Color.OliveDrab;
switch (StatusName.Value)
{
case "ACCEPTED":
{
StatusName.Style.SelectionBackColor = Color.DarkGreen;
StatusName.Style.BackColor = Color.Green;
break;
}
case "PENDING REPLY":
{
StatusName.Style.SelectionBackColor = Color.DarkGoldenrod;
StatusName.Style.BackColor = Color.Goldenrod;
break;
}
case "DECLINED":
{
StatusName.Style.SelectionBackColor = Color.DarkRed;
StatusName.Style.BackColor = Color.Red; // case "FOLLOW UP"
break;
}
default:
{
// StatusName.Style.Font = New Font("Arial", 10, FontStyle.Bold)
if (StatusName.Value.ToString().Contains("TODAY") | StatusName.Value.ToString().Contains("LATE"))
{
if (StatusName.Value.ToString().Contains("LATE"))
{
// StatusName.Style.Font = New Font("Arial", 8, FontStyle.Bold)
StatusName.Style.BackColor = Color.Red;
}
else
{
StatusName.Style.SelectionBackColor = Color.Maroon;
StatusName.Style.BackColor = Color.OrangeRed;
}
}
else
{
StatusName.Style.SelectionBackColor = Color.DarkOrange;
StatusName.Style.BackColor = Color.Orange;
}
break;
}
}
}
}
private void checkCmdtyAndCustomer(object unitRow)
{
int muID;
string MUSource;
string cmdtyName;
string gradeName;
int cmdtyId;
int gradeId;
VW_BookingMinibooking selectedMBRow;
VW_UnitSourceMiniUnit mu = (VW_UnitSourceMiniUnit)unitRow;
VW_GrainUnitStorage g = new VW_GrainUnitStorage();
try
{
g = (VW_GrainUnitStorage)unitRow;
}
catch { }
muID = mu.MiniUnitId;
MUSource = Conversions.ToString(mu.MiniunitNumber);
// selectedUnits.Add(muID, MUSource)
cmdtyName = Conversions.ToString(mu.CommodityName);
gradeName = Conversions.ToString(mu.GradeName);
cmdtyId = Conversions.ToInteger(mu.CommodityId);
gradeId = Conversions.ToInteger(mu.GradeId);
// Check if mini unit is already assigned to mini booking
for (int i = 0, loopTo = dgvSelectedBkg.Rows.Count - 1; i <= loopTo; i++)
{
selectedMBRow = (VW_BookingMinibooking)dgvSelectedBkg.Rows[i].DataBoundItem;
bool muAlreadyAsn;
// check if mu was already assigned
if (tabUnits.SelectedIndex == 0)
{
muAlreadyAsn = MdlBookingManagement.miniUnitAlreadyAssigned(muID, selectedMBRow.MiniBookingId, false);
}
else
{
g = (VW_GrainUnitStorage)unitRow;
muAlreadyAsn = MdlBookingManagement.miniUnitAlreadyAssigned(g.GrainInvStorageLocationId, selectedMBRow.MiniBookingId, true);
}
if (muAlreadyAsn)
{
shouldNotAssignList.Add(muID.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Unit source already added to booking", "Selected Unit source is already added to the booking " + selectedMBRow.BookingNumber + ", so it will not be added again.", this);
}
// If cmdty doesn't exist, add to unit source.
if (cmdtyId == 0)
{
var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Warning:", "There's no commodity added to the unit '" + MUSource + "' Yet. Would you like to add it now? " + "If No is selected, the unit will not be added to the booking", My.Resources.Resources.caution, this);
if (result == DialogResult.Yes)
{
var unit = UnitSourceService.GetVWById(Conversions.ToInteger(mu.UnitSourceId));
var unitList = new List <VW_UnitSource>();
unitList.Add(unit);
My.MyProject.Forms.FrmEditAddRailList.isNewRecord = false;
My.MyProject.Forms.FrmEditAddRailList.isMultiEdit = false;
My.MyProject.Forms.FrmEditAddRailList.LoadForm(unitList);
Close();
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmEditAddRailList, My.MyProject.Forms.FrmParentScreen);
}
// If tabUnits.SelectedIndex = 0 Then
// VWUnitSourceMiniUnitBindingSource.DataSource.Item(unitRow) = MiniUnitService.GetVWByMUId(unitRow.MiniUnitId)
// 'VWUnitSourceMiniUnitBindingSource.DataSource
// End If
else if (tabUnits.SelectedIndex == 0)
{
shouldNotAssignList.Add(muID.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
else
{
g = (VW_GrainUnitStorage)unitRow;
shouldNotAssignStorageList.Add(g.GrainInvStorageLocationId.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
}
// If cmdty and grade doesnt exist in mb, ask if should add.
else if (MdlBookingManagement.miniUnitMissingCommodity(selectedMBRow.MiniBookingId, cmdtyId, gradeId))
{
var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Commodity and Rate doesn't match", "The commodity and grade of the unit '" + MUSource + "' (" + gradeName + " " + cmdtyName + ") is not added to the booking '" + selectedMBRow.BookingNumber + "'. Would you like to add it now? " + "If No is selected, the unit will not be added to the booking", My.Resources.Resources.caution, this);
if (result == DialogResult.Yes)
{
MdlBookingManagement.saveBkgCommodity(selectedMBRow.MiniBookingId, cmdtyId, gradeId);
}
else if (tabUnits.SelectedIndex == 0)
{
shouldNotAssignList.Add(muID.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
else
{
shouldNotAssignStorageList.Add(g.GrainInvStorageLocationId.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
}
if (mu.CustomerId != selectedMBRow.CustomerId)
{
var result = My.MyProject.Forms.MessageBoxCustomerMatchingWarning.ShowDialog(selectedMBRow, unitRow, this);
if (result == DialogResult.Yes & shouldChangeCustomer == true)
{
MdlBookingManagement.updateCustomer(MiniUnitService.GetById(muID));
// update muDataGridView
VWUnitSourceMiniUnitBindingSource.DataSource = VW_UnitSOurceMiniUnitService.GetByFilter(Conversions.ToString(mu.CustomerName), BkServicesList, Strings.Trim(tbSearchStorageUnit.Text));
}
else if (tabUnits.SelectedIndex == 0)
{
shouldNotAssignList.Add(muID.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
else
{
shouldNotAssignStorageList.Add(g.GrainInvStorageLocationId.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
}
}
}
private string FetchThisBooking(string ThisBookNumber, int railListID)
{
short x = 0;
short cnt = 0;
string SQL = "";
string BookingLine = "";
string BookingNumber = "";
string DeliverBook = "";
string SSLineCode = "";
string DeliverCanTotal = "";
string LRDDate = "";
char LRDTime = '\0';
string TerminalName = "";
string VesselName = "";
char SplitBooking = '\0';
string DeliverBookings = "";
string TempLine = "";
string ChangedMask = "";
string DeliverReadyCans = "";
int BookCount = 0;
short TotalCans = 0;
short DeliverCans = 0;
string bkLetter;
string unit;
string recordKeyQuery;
if (railListID == 0)
{
recordKeyQuery = "[RailListID] is null";
}
else
{
recordKeyQuery = "[RailListID] = '" + railListID.ToString() + "'";
}
SQL = @"select b.*, [MiniBookingOrder], MiniUnitOrder, bus.Unit from Bookings as b
join MiniBooking as mb on b.[Booking Number] = mb.[BookingNumber] and
b.[Booking Number] = '" + ThisBookNumber + @"'
join [Booking Unit Sources] bus on bus.[Minibooking ID] = mb.[MiniBookingId] and " + recordKeyQuery + " and Unit = '" + focusedUnitNumber + @"'
left join MiniUnit as mu on mu.MiniUnitId = bus.MiniUnitID order by [MiniBookingOrder] ";
var DbObjDataTable = new DataTable();
var DbObjAdapter = new System.Data.SqlClient.SqlDataAdapter(SQL, DBConnect);
var DbObjCommand = new System.Data.SqlClient.SqlCommandBuilder(DbObjAdapter);
DbObjAdapter.Fill(DbObjDataTable);
Refresh();
foreach (DataRow BookNum in DbObjDataTable.Rows)
{
bool multiMB = DbObjDataTable.Select(Conversions.ToString(Operators.AddObject(Operators.AddObject("[Booking Number] = '", BookNum["Booking Number"]), "'"))).Length > 1;
if (multiMB)
{
bkLetter = "(" + MdlBookingManagement.digitToLetter(BookNum["MiniBookingOrder"]) + ")";
}
else
{
bkLetter = "";
}
BookingNumber = MdlContainerManagement.DoFunctions.PadToString(Strings.Trim(Conversions.ToString(BookNum["Booking Number"])) + bkLetter, 40);
if (!string.IsNullOrEmpty(Strings.RTrim(BookingNumber)))
{
if (!BookNum.IsNull("LRD") & Information.IsDate(BookNum["LRD"]))
{
LRDDate = MdlContainerManagement.DoFunctions.DateToNum(DateAndTime.DateValue(Conversions.ToString(BookNum["LRD"])));
}
else
{
LRDDate = MdlContainerManagement.DoFunctions.MKL(0);
}
if (BookNum.IsNull("Terminal Name") == true)
{
TerminalName = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(' '), 40);
}
else
{
TerminalName = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(BookNum["Terminal Name"]), 40);
}
if (BookNum.IsNull("Vessel Name") == true)
{
VesselName = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(' '), 50);
}
else
{
VesselName = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(BookNum["Vessel Name"]), 50);
}
if (BookNum.IsNull("Split Booking") == false && Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(BookNum["Split Booking"], true, false)))
{
SplitBooking = '\u0001';
}
else
{
SplitBooking = '\0';
}
if (BookNum.IsNull("SS Line Code") == true)
{
SSLineCode = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(' '), 10);
}
else
{
SSLineCode = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(BookNum["SS Line Code"]), 10);
}
LRDTime = '\0';
ChangedMask = Conversions.ToString('\0') + Conversions.ToString('\0') + Conversions.ToString('\0') + Conversions.ToString('\0');
// DeliverBook = Mid(DeliverBookings, x, 40)
DeliverCanTotal = MdlContainerManagement.DoFunctions.MKL(Conversions.ToInteger(BookNum["Number Of Cans"]));
if (multiMB)
{
if (!Information.IsDBNull(BookNum["MiniUnitOrder"]))
{
bkLetter = "(" + MdlBookingManagement.digitToLetter(BookNum["MiniUnitOrder"]).ToUpper() + ")";
}
else
{
bkLetter = "";
}
}
else
{
bkLetter = "";
}
unit = MdlContainerManagement.DoFunctions.PadToString(Strings.Trim(Conversions.ToString(BookNum["Unit"])) + bkLetter, 40);
TempLine = Conversions.ToString('\0') + BookingNumber + unit + SSLineCode + LRDDate + Conversions.ToString(LRDTime) + TerminalName + VesselName + Conversions.ToString(SplitBooking) + DeliverCanTotal + MdlContainerManagement.DoFunctions.MKL(0) + MdlContainerManagement.DoFunctions.MKL(0) + MdlContainerManagement.DoFunctions.MKL(0) + MdlContainerManagement.DoFunctions.MKL(0) + ChangedMask;
BookingLine += TempLine;
// Next x
// End If
}
}
return(BookingLine);
}