public StudentInfoWindow()
{
InitializeComponent();
Firstname.Clear();
Lastname.Clear();
Group.Clear();
BookNum.Clear();
}
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);
}
