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