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;
}
}
}
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);
}
}
}
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);
}
