public DialogResult ShowDialog(VW_BookingMinibooking mbRow, object muRow, Form assgnForm)
{
bkgNumbLabel.Text = mbRow.BookingNumber;
bkgCustomerLabel.Text = mbRow.CustomerName;
VW_UnitSourceMiniUnit mu = (VW_UnitSourceMiniUnit)muRow;
unitSourvceNumbLabel.Text = Conversions.ToString(mu.MiniunitNumber);
try
{
unitSourceCustomLabel.Text = Conversions.ToString(mu.CustomerName);
}
catch
{
unitSourceCustomLabel.Text = Conversions.ToString(mu.CustomerName);
}
_muID = Conversions.ToInteger(mu.MiniUnitId);
PictureBox1.Hide();
changeUnitCustRadioButton.Checked = false;
dontAsnRadioButton.Checked = true;
checkUnit();
MdlLoadingSetting.showDialogForm(this, assgnForm);
return(DialogResult);
}
public void populateunits()
{
VW_BookingMinibooking selectedMB = (VW_BookingMinibooking)cboBooking.SelectedItem;
tbCustomer.Text = selectedMB.CustomerName;
VWMinibookingMiniUnitAssignmentBindingSource.DataSource = MinibookingMiniUnitAssignmentService.GetByMiniBookingId(selectedMB.MiniBookingId);
}
private void bookingComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
SelectedMBObj = (VW_BookingMinibooking)bookingComboBox.SelectedItem;
getBookingInfo();
selectedAssgnContainers.Clear();
selectedContainers.Clear();
containersBunifuDataGridView1.Rows.Clear();
PopulateContainers();
cansLabel.Text = assignedContainersBunifuDataGridView2.Rows.Count.ToString() + " of " + totalNumberOfCans.ToString();
checkContainerButton();
checkAssignButtons();
}
private void populateBookings()
{
string conditionBooking = "";
var vwMB = new MinibookingService();
{
var withBlock = bookingComboBox;
withBlock.DataSource = MinibookingService.GetJointBooking(bookingActivBookingBunifuToggleSwitch2.Value);
withBlock.DisplayMember = "MinibookingNumber";
withBlock.SelectedValue = "MiniBookingId";
withBlock.SelectedIndex = 0;
withBlock.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
withBlock.AutoCompleteSource = AutoCompleteSource.ListItems;
SelectedMBObj = (VW_BookingMinibooking)withBlock.SelectedItem;
}
}
public List <VW_BookingMinibooking> GetJointBooking(bool activeStatus)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
var list = db.VW_BookingMinibooking.Where(mb => mb.ActiveBooking == activeStatus).OrderBy(m => m.MinibookingNumber).ToList();
var emptyItem = new VW_BookingMinibooking();
emptyItem.BookingNumber = "";
list.Insert(0, emptyItem);
return(list.ToList());
}
}
private void dgvSelectedBkg_SelectionChanged(object sender, EventArgs e)
{
if (dgvSelectedBkg.Rows.Count > 0)
{
btnRemoveMB.Enabled = true;
VW_BookingMinibooking mbRow = (VW_BookingMinibooking)dgvSelectedBkg.CurrentRow.DataBoundItem;
getAsnUnits(mbRow.MiniBookingId);
}
else
{
checkAsnButton();
btnRemoveMB.Enabled = false;
getAsnUnits(0);
}
}
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);
}
}
private void proceedButton_Click(object sender, EventArgs e)
{
var mbRowList = new List <VW_BookingMinibooking>();
for (int i = 0, loopTo = miniBkDataGridView.Rows.Count - 1; i <= loopTo; i++)
{
bool value = Conversions.ToBoolean(miniBkDataGridView.Rows[i].Cells[0].Value);
if (value == true)
{
var mbRow = new VW_BookingMinibooking();
mbRow = (VW_BookingMinibooking)miniBkDataGridView.Rows[i].DataBoundItem;
My.MyProject.Forms.FrmAssignToUnits.OriginalMBSelectedList.Add(mbRow);
// FrmAssignToUnits.VWBookingJoinMBBindingSource.DataSource.add(mbRow)
}
}
Close();
MdlLoadingSetting.showDialogForm(My.MyProject.Forms.FrmAssignToUnits, My.MyProject.Forms.FrmParentScreen);
}
private void getMatchingUnits()
{
if (tabUnits.SelectedIndex == 0)
{
// Dim selectedMBRow As VW_BookingMinibooking = dgvSelectedBkg.Rows(0).DataBoundItem
// VWUnitSourceMiniUnitBindingSource.DataSource = VW_UnitSOurceMiniUnitService.GetByFilter(selectedMBRow.CustomerName, BkServicesList, Trim(tbSearchUnits.Text))
foreach (DataGridViewRow row in dgvMiniUnits.Rows)
{
if (row.Cells[1].Value.ToString().Contains(tbSearchUnits.Text))
{
dgvMiniUnits.CurrentCell = row.Cells[1];
}
}
}
else
{
VW_BookingMinibooking selectedMBRow = (VW_BookingMinibooking)dgvSelectedBkg.Rows[0].DataBoundItem;
VWGrainUnitStorageBindingSource.DataSource = GrainInventoryService.GetAllGrainInventoryUnitsByFilter(selectedMBRow.CustomerName, BkServicesList, Strings.Trim(tbSearchStorageUnit.Text));
}
}
private void dgvAllBookings_SelectionChanged(object sender, EventArgs e)
{
var mbID = default(int);
if (dgvAllBookings.Rows.Count > 0)
{
try
{
VW_BookingMinibooking mbRow = (VW_BookingMinibooking)dgvAllBookings.CurrentRow.DataBoundItem;
mbID = mbRow.MiniBookingId;
}
catch
{
}
}
else
{
mbID = 0;
}
getCmdyAndGrades(mbID);
}
private void miniUnitsDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
object selectedRow;
bool value;
DataGridView focusedDgv;
int mbId;
VW_BookingMinibooking selectedMBRow;
if (e.ColumnIndex == 0)
{
if (tabUnits.SelectedIndex == 0)
{
value = Conversions.ToBoolean(dgvMiniUnits.Rows[e.RowIndex].Cells[0].Value);
selectedRow = new VW_UnitSourceMiniUnit();
selectedRow = (VW_UnitSourceMiniUnit)dgvMiniUnits.Rows[e.RowIndex].DataBoundItem;
focusedDgv = dgvMiniUnits;
}
else
{
value = Conversions.ToBoolean(dgvStorageUnits.Rows[e.RowIndex].Cells[0].Value);
selectedRow = new VW_GrainUnitStorage();
selectedRow = (VW_GrainUnitStorage)dgvStorageUnits.Rows[e.RowIndex].DataBoundItem;
focusedDgv = dgvStorageUnits;
}
if (value == false)
{
focusedDgv.Rows[e.RowIndex].Cells[0].Value = true;
numbSelectMU += 1;
checkCmdtyAndCustomer(selectedRow);
}
else
{
focusedDgv.Rows[e.RowIndex].Cells[0].Value = false;
numbSelectMU -= 1;
for (int i = 0, loopTo = dgvSelectedBkg.Rows.Count - 1; i <= loopTo; i++)
{
selectedMBRow = new VW_BookingMinibooking();
selectedMBRow = (VW_BookingMinibooking)dgvSelectedBkg.Rows[i].DataBoundItem;
if (tabUnits.SelectedIndex == 0)
{
VW_UnitSourceMiniUnit r = new VW_UnitSourceMiniUnit();
r = (VW_UnitSourceMiniUnit)dgvMiniUnits.Rows[e.RowIndex].DataBoundItem;
shouldNotAssignList.Remove(r.MiniUnitId.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
else
{
VW_GrainUnitStorage r = new VW_GrainUnitStorage();
r = (VW_GrainUnitStorage)dgvStorageUnits.Rows[e.RowIndex].DataBoundItem;
shouldNotAssignStorageList.Remove(r.GrainInventoryId.ToString() + "|" + selectedMBRow.MiniBookingId.ToString());
}
}
}
checkAsnButton();
// VWUnitSourceMiniUnitBindingSource.DataSource = VW_UnitSOurceMiniUnitService.GetByFilter(selectedMBRow.CustomerName, BkServicesList, "")
}
}
public void getEDIs(BunifuDataGridView ediDataGrid)
{
string condition = "";
string table;
string EDIMode;
decimal GrossWeight = 0m;
string inputSource;
string TruckDriverName = "";
string gateDate;
string gateTime;
string TruckNumber = "";
string contSize = "";
decimal tareWeight;
DateTime ediModDateTime;
DateTime datimeTineInsideFile;
string datimeTineInsideFileStr;
DateTime gateTimeDate;
var ediorgTimeDate = default(DateTime);
DateTime dTRequestSent;
var dTRequestSentStr = default(string);
string ssLineCode;
string bkgnRelNumb;
DateTime tempDateTime, tempTime;
string confHandshakeEdi = "";
string location;
string carrierCode;
string dateAndTimeRequested;
// Set different queries for in-gate EDI and out-gate EDI
if (tabinoutGate.SelectedIndex == 0)
{
EDIMode = "IN-GATE";
InGateDataGridView.Rows.Clear();
condition = "on [In-Out Unique ID] = [Unique ID] ";
table = "(select * from [Containers In-Out] where convert(date,[Gate Date In]) >='" + fromInBunifuDatePicker.Value.ToShortDateString() + @"' AND
convert(date,[Gate Date In]) <= '" + toInBunifuDatePicker.Value.ToShortDateString() + "' and [Trouble In-Gate] = 0 and [In Gate EDI] = 1 and (" + getEDIssLines() + @")) as c lEFT join
(select * from ((select * from[EDI Records] where [Gate Mode] <> 'OUT-GATE') as d LEFT join
(select * from [ManualEDILog] ) as m on d.EDIRecID = m.EDIRecordID))as r " ;
}
else
{
EDIMode = "OUT-GATE";
OutGateDataGridView.Rows.Clear();
string showOutCans = "";
if (cbShowOutGatedCans.Checked == true)
{
showOutCans = "and [Gate Date Out] is not null";
}
VW_CompanyCompanyType c = (VW_CompanyCompanyType)cboSSLine.SelectedItem;
VW_BookingMinibooking b = (VW_BookingMinibooking)bookingComboBox.SelectedItem;
var conditionFilter = Operators.AddObject(Operators.AddObject(Operators.AddObject("and ([SS Line Code Out] like '%" + Strings.Trim(Conversions.ToString(c.CompanyCode)) + "%' or [SS Line Code In] like '%" + Strings.Trim(Conversions.ToString(c.CompanyCode)) + "%') and " + " [Booking Number] is not null and [Booking Number] like '%", b.BookingNumber), "%' "), showOutCans);
table = Conversions.ToString(Operators.AddObject(Operators.AddObject("(select * from [Containers In-Out] where (" + getEDIssLines() + ") ", conditionFilter), @") as c lEFT join
(select * from ((select * from[EDI Records] where [Gate Mode] <> 'IN-GATE') as d LEFT join
(select * from [ManualEDILog] ) as m on d.EDIRecID = m.EDIRecordID))as r " ));
// toOutBunifuDatePicker.Value.Date + "' and [Trouble In-Gate] = 0 and [In Gate EDI] = 1
condition = "on [Unique ID] = [In-Out Unique ID]";
}
if (isRefresh)
{
InOutEDIRecDT = dbCeres.getTableInfo(table, "*", condition);
searchTable = InOutEDIRecDT;
}
foreach (DataRow row in searchTable.Rows)
{
if (tabinoutGate.SelectedIndex == 0)
{
if (row["Yard Code In"] != DBNull.Value)
{
location = Strings.Trim(Conversions.ToString(row["Yard Code In"]));
}
else
{
location = "N/A";
}
if (row["Carrier Truck In"] == DBNull.Value)
{
TruckNumber = "";
}
else
{
TruckNumber = Strings.Trim(Conversions.ToString(row["Carrier Truck In"]));
}
if (row["Carrier DriverName In"] == DBNull.Value)
{
TruckDriverName = Strings.Trim("N/A");
}
else
{
TruckDriverName = Strings.Trim(Conversions.ToString(row["Carrier DriverName In"]));
}
bkgnRelNumb = Strings.Trim(Conversions.ToString(row["Release Number"]));
ssLineCode = Strings.Trim(Conversions.ToString(row["SS Line Code In"]));
carrierCode = Strings.Trim(Conversions.ToString(row["Carrier Code In"]));
if (row["ConfHandShakeDateTime"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
if (row["EDIModDateTime"] != DBNull.Value)
{
datimeTineInsideFile = Conversions.ToDate(row["EDIModDateTime"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
// ediorgTimeDate = row["EDIOriginalDateTime")
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
}
else if (row["In Gate EDI Date Time"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
datimeTineInsideFile = Conversions.ToDate(row["Gate Date In"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
}
else
{
datimeTineInsideFileStr = "N/A";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSent = Conversions.ToDate("N/A");
}
}
else
{
datimeTineInsideFileStr = "N/A";
if (row["In Gate EDI Date Time"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["Gate Date In"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
datimeTineInsideFileStr = confHandshakeEdi;
}
else
{
confHandshakeEdi = "N/A";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSentStr = "N/A";
}
}
gateTimeDate = Conversions.ToDate(row["Gate Date In"]);
gateDate = gateTimeDate.ToString("dd-MMM-yyyy");
gateTime = gateTimeDate.ToString("HH:mm");
}
else
{
if (row["Booking Number"] != DBNull.Value)
{
bkgnRelNumb = Strings.Trim(Conversions.ToString(row["Booking Number"]));
}
else
{
bkgnRelNumb = "N/A";
}
if (row["SS Line Code Out"] == DBNull.Value)
{
ssLineCode = "";
}
else
{
ssLineCode = Strings.Trim(Conversions.ToString(row["SS Line Code Out"]));
}
if (row["Carrier Code Out"] != DBNull.Value)
{
carrierCode = Strings.Trim(Conversions.ToString(row["Carrier Code Out"]));
}
else
{
carrierCode = "";
}
if (row["Yard Code Out"] != DBNull.Value)
{
location = Strings.Trim(Conversions.ToString(row["Yard Code Out"]));
}
else
{
location = "N/A";
}
if (row["Carrier Truck Out"] == DBNull.Value)
{
TruckNumber = "N/A";
}
else
{
TruckNumber = Strings.Trim(Conversions.ToString(row["Carrier Truck Out"]));
}
if (row["Carrier DriverName Out"] == DBNull.Value)
{
TruckDriverName = "N/A";
}
else
{
TruckDriverName = Strings.Trim(Conversions.ToString(row["Carrier DriverName Out"]));
}
if (row["ConfHandShakeDateTime"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
if (row["EDIModDateTime"] != DBNull.Value)
{
datimeTineInsideFile = Conversions.ToDate(row["EDIModDateTime"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
// ediorgTimeDate = row["EDIOriginalDateTime")
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
}
else if (row["Out Gate EDI Date Time"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
if (row["Gate Date Out"] != DBNull.Value)
{
datimeTineInsideFile = Conversions.ToDate(row["Gate Date Out"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
}
else
{
datimeTineInsideFileStr = "N/A";
}
}
else
{
datimeTineInsideFileStr = "N/A";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSent = Conversions.ToDate("N/A");
}
}
else
{
datimeTineInsideFileStr = "N/A";
if (row["Out Gate EDI Date Time"] != DBNull.Value && row["Gate Date Out"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["Gate Date Out"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
datimeTineInsideFileStr = confHandshakeEdi;
}
else
{
confHandshakeEdi = "N/A";
}
}
if (row["Gate Date Out"] != DBNull.Value)
{
gateTimeDate = Conversions.ToDate(row["Gate Date Out"]);
gateDate = gateTimeDate.ToString("dd-MMM-yyyy");
gateTime = gateTimeDate.ToString("HH:mm");
}
else
{
gateDate = "";
gateTime = "";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSentStr = "N/A";
}
}
try
{
contSize = Conversions.ToString(row["ContainerSize"]);
}
catch
{
contSize = "";
}
if (row["Input Source"].Equals("SYSTEM"))
{
inputSource = "SYSTEM";
}
else if (tabinoutGate.SelectedIndex == 1)
{
if (row["Input Source"] == DBNull.Value)
{
if (row["Out Gate EDI Date Time"] == DBNull.Value)
{
inputSource = "";
}
else
{
inputSource = "SYSTEM";
}
}
else
{
inputSource = Conversions.ToString(Operators.AddObject(Operators.AddObject(Operators.AddObject(Operators.AddObject("PRE-SEND " + Constants.vbNewLine + "By: ", row["User Name"]), Constants.vbNewLine), "Date/Time: "), ediorgTimeDate.ToString("dd-MMM-yyyy hh:mm tt")));
}
}
else if (row["Input Source"] == DBNull.Value)
{
if (row["In Gate EDI Date Time"] == DBNull.Value)
{
inputSource = "";
}
else
{
inputSource = "SYSTEM";
}
}
else
{
inputSource = Conversions.ToString(Operators.AddObject(Operators.AddObject(Operators.AddObject(Operators.AddObject("RESEND " + Constants.vbNewLine + "By: ", row["User Name"]), Constants.vbNewLine), "Date/Time: "), ediorgTimeDate.ToString("dd-MMM-yyyy hh:mm tt")));
}
if (row["TARE Weight"] != DBNull.Value)
{
tareWeight = (decimal)MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["TARE Weight"]));
}
else
{
tareWeight = 0m;
}
// GrossWeight = DoFunctions.CVS(row["Gross Weight"])
if (row["Gross Weight"] != DBNull.Value)
{
GrossWeight = (decimal)MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["Gross Weight"]));
}
else
{
GrossWeight = 0m;
}
ediDataGrid.Rows.Add(row["Unique ID"], null, Strings.Trim(Conversions.ToString(row["Container Number"])), location, datimeTineInsideFileStr, confHandshakeEdi, gateDate + " " + gateTime, dTRequestSentStr, inputSource, ssLineCode, bkgnRelNumb, contSize, (object)GrossWeight, (object)tareWeight, carrierCode, TruckNumber, TruckDriverName);
}
}
