public void populateunits()
{
VW_BookingMinibooking selectedMB = (VW_BookingMinibooking)cboBooking.SelectedItem;
tbCustomer.Text = selectedMB.CustomerName;
VWMinibookingMiniUnitAssignmentBindingSource.DataSource = MinibookingMiniUnitAssignmentService.GetByMiniBookingId(selectedMB.MiniBookingId);
}
// Private Sub AssignUnitsToBookingsExcel()
// Dim miniUnits As List(Of VW_MinibookingMiniUnitAssignment), miniUnitIds As New List(Of Integer),
// miniBookingIds As New Dictionary(Of Integer, String), muRow As VW_UnitSourceMiniUnit, mbRow As VW_BookingMinibooking
// Dim muIDmbID As String, railListID As Integer = 0, bus As New MinibookingMiniUnitAssignmentService
// For i = 0 To dgvMiniUnit.Rows.Count - 1
// muRow = dgvMiniUnit.Rows(i).DataBoundItem
// railListID = muRow.RecordKey
// For s = 0 To dgvAllBookings.Rows.Count - 1
// If dgvAllBookings.Rows(s).Cells(0).Value = True Then
// mbRow = dgvAllBookings.Rows(s).DataBoundItem
// muIDmbID = muRow.MiniUnitId.ToString + "|" + mbRow.MiniBookingId.ToString
// If Not shouldNotAssignList.Contains(muIDmbID) Then
// If Not miniBookingIds.ContainsKey(mbRow.MiniBookingId) Then
// miniBookingIds.Add(mbRow.MiniBookingId, mbRow.BookingNumber)
// End If
// End If
// End If
// Next
// Next
// 'For Each mb In miniBookingIds
// ' miniUnits = MinibookingMiniUnitAssignmentService.GetByMiniBookingId(mb.Key)
// ' updateUnitsInExcelFile(mb.Value, miniUnits)
// 'Next
// 'getAsnUnits()
// End Sub
private void getAsnBookings()
{
if (dgvMiniUnit.Rows.Count > 0)
{
int index = dgvMiniUnit.CurrentRow.Index;
var newRowBalToStorage = new VW_MinibookingMiniUnitAssignment();
VW_UnitSourceMiniUnit mu = (VW_UnitSourceMiniUnit)dgvMiniUnit.CurrentRow.DataBoundItem;
var mbmuasnList = MinibookingMiniUnitAssignmentService.GetByMiniUnitId(mu.MiniUnitId);
if (mu.BalanceToStorageAllowed == true == true)
{
newRowBalToStorage.BookingNumber = "BAL. TO STORAGE";
mbmuasnList.Add(newRowBalToStorage);
btnBalToStorage.Text = "RM. BAL. TO STORAGE";
}
else
{
btnBalToStorage.Text = "BAL. TO STORAGE";
}
VWMinibookingMiniUnitAssignmentBindingSource.DataSource = mbmuasnList;
}
else
{
VWMinibookingMiniUnitAssignmentBindingSource.DataSource = MinibookingMiniUnitAssignmentService.GetByMiniUnitId(0);
dgvAsnBookings.DataSource = VWMinibookingMiniUnitAssignmentBindingSource;
}
}
private void getAsnUnits(int mbId)
{
var miniUnitAssign = new List <VW_MinibookingMiniUnitAssignment>();
bool multipleMB;
string bkgLetter = "";
miniUnitAssign = MinibookingMiniUnitAssignmentService.GetByMiniBookingId(mbId);
dgvUnitsAsnToBks.DataSource = miniUnitAssign;
AssignedUnits = miniUnitAssign;
}
private void UnassignUnits()
{
var mbus = new MinibookingMiniUnitAssignmentService();
var isUnassigned = default(bool);
var mbIdList = new Dictionary <int, string>();
List <VW_MinibookingMiniUnitAssignment> assignedCansList;
VW_MinibookingMiniUnitAssignment muAsn;
MdlLoadingSetting.waitForm.Show();
for (int i = 0, loopTo = dgvBookingUnit.Rows.Count - 1; i <= loopTo; i++)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(dgvBookingUnit.Rows[i].Cells[0].Value, true, false)))
{
muAsn = (VW_MinibookingMiniUnitAssignment)dgvBookingUnit.Rows[i].DataBoundItem;
if (!mbIdList.ContainsKey(muAsn.MinibookingId))
{
mbIdList.Add(muAsn.MinibookingId, Strings.Trim(muAsn.BookingNumber));
}
isUnassigned = mbus.Delete(muAsn.AssignmentId, muAsn.isStorageUnit == true);
if (muAsn.isStorageUnit == true)
{
EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, "UnitId: " + muAsn.MiniUnitId.ToString() + " | MbId: " + muAsn.MinibookingId.ToString(), "UNASSIGN", "UNIT", "Storage Unit Source " + muAsn.MiniUnitNumber + " unassigned from booking " + muAsn.BookingNumber);
}
else
{
EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, "UnitId: " + muAsn.MiniUnitId.ToString() + " | MbId: " + muAsn.MinibookingId.ToString(), "UNASSIGN", "UNIT", "Unit Source " + muAsn.MiniUnitNumber + " unassigned from booking " + muAsn.BookingNumber);
}
}
}
foreach (var value in mbIdList)
{
// updateUnitsInExcelFile(value.Value, assignedCansList)
assignedCansList = MinibookingMiniUnitAssignmentService.GetByMiniBookingId(value.Key);
}
dgvBookingUnit.DataSource = MinibookingMiniUnitAssignmentService.GetByUnitSourceId(focusedUnitID);
MdlLoadingSetting.waitForm.Close();
if (isUnassigned)
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Sucess!", "Unit source(s) unassigned with success!", this);
}
btnUnassign.Enabled = false;
}
private void AssignUnitsToBooking()
{
string muIDmbID;
int railListID = 0;
var bus = new MinibookingMiniUnitAssignmentService();
VW_UnitSourceMiniUnit muRow;
var mbRow = default(VW_BookingMinibooking);
for (int i = 0, loopTo = dgvMiniUnit.Rows.Count - 1; i <= loopTo; i++)
{
muRow = (VW_UnitSourceMiniUnit)dgvMiniUnit.Rows[i].DataBoundItem;
railListID = (int)muRow.RecordKey;
for (int s = 0, loopTo1 = dgvAllBookings.Rows.Count - 1; s <= loopTo1; s++)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(dgvAllBookings.Rows[s].Cells[0].Value, true, false)))
{
mbRow = (VW_BookingMinibooking)dgvAllBookings.Rows[s].DataBoundItem;
muIDmbID = muRow.MiniUnitId.ToString() + "|" + mbRow.MiniBookingId.ToString();
if (!shouldNotAssignList.Contains(muIDmbID))
{
bus.Insert(mbRow.MiniBookingId, muRow.MiniUnitId);
EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, "UnitId: " + muRow.MiniUnitId.ToString() + " | MbId: " + mbRow.MiniBookingId.ToString(), "ASSIGN", "UNIT", "Unit Source " + muRow.MiniunitNumber + " assigned to booking " + mbRow.BookingNumber);
}
}
}
var cep = new CeresExcelPendingSync();
cep.RecordId = mbRow.MiniBookingId;
cep.EmployeeId = My.MyProject.Forms.FrmLoginWindow._userID;
cep.SyncType = "UNIT ASSIGNMENT";
cep.ExtraInfo = "";
cep.CurrentStatus = "QUEUE";
cep.QtyOfAttempts = 0;
cep.SyncMessage = "ADDED TO QUEUE";
cep.CreatedAt = DateAndTime.Now;
CeresExcService.AddOrUpdate(cep);
}
}
private void loadDataGrid()
{
switch (unitSourcesTabControl.SelectedIndex)
{
case 0:
{
dgvBookingUnit.DataSource = MinibookingMiniUnitAssignmentService.GetByUnitSourceId(focusedUnitID);
break;
}
case 1:
{
VWUnitSourceMiniUnitBindingSource.DataSource = MiniUnitService.GetUsMuVwByUSId(focusedUnitID);
break;
}
case 2:
{
break;
}
// populateReconciliation()
}
}
private void AssignUnitsToBookings()
{
string muIDmbID;
var bus = new MinibookingMiniUnitAssignmentService();
var gis = new GrainInventoryService();
VW_BookingMinibooking mbRow;
VW_UnitSourceMiniUnit unitRowUnit;
VW_GrainUnitStorage unitRowStorage;
for (int i = 0, loopTo = dgvSelectedBkg.Rows.Count - 1; i <= loopTo; i++)
{
mbRow = (VW_BookingMinibooking)dgvSelectedBkg.Rows[i].DataBoundItem;
if (tabUnits.SelectedIndex == 0)
{
for (int s = 0, loopTo1 = dgvMiniUnits.Rows.Count - 1; s <= loopTo1; s++)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(dgvMiniUnits.Rows[s].Cells[0].Value, true, false)))
{
unitRowUnit = (VW_UnitSourceMiniUnit)dgvMiniUnits.Rows[s].DataBoundItem;
muIDmbID = unitRowUnit.MiniUnitId.ToString() + "|" + mbRow.MiniBookingId.ToString();
// If mini munit key and mini booking key is not on the should not assign list,
// then assign unit to bkg
if (!shouldNotAssignList.Contains(muIDmbID))
{
// 'dbCeres.assignUnitsToMiniBkgs(unitID, mbID, bkgNumber, unitNumber, recordKey)
bus.Insert(mbRow.MiniBookingId, unitRowUnit.MiniUnitId);
EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, "UnitId: " + unitRowUnit.MiniUnitId.ToString() + " | MbId: " + mbRow.MiniBookingId.ToString(), "ASSIGN", "UNIT", "Unit Source " + unitRowUnit.MiniunitNumber + " assigned to booking " + mbRow.BookingNumber);
}
}
}
}
else
{
for (int s = 0, loopTo2 = dgvStorageUnits.Rows.Count - 1; s <= loopTo2; s++)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(dgvStorageUnits.Rows[s].Cells[0].Value, true, false)))
{
unitRowStorage = (VW_GrainUnitStorage)dgvStorageUnits.Rows[s].DataBoundItem;
muIDmbID = unitRowStorage.MiniUnitId.ToString() + "|" + mbRow.MiniBookingId.ToString();
// If mini munit key and mini booking key is not on the should not assign list,
// then assign unit to bkg
if (!shouldNotAssignList.Contains(muIDmbID))
{
gis.InsertGrainInvMinibookingAssignment(mbRow.MiniBookingId, unitRowStorage.GrainInvStorageLocationId, (float)unitRowStorage.QtyInStorage, DateAndTime.Now);
gis.InsertGrainInventoryTransaction(unitRowStorage.GrainInventoryId, (int)MdlEnum.TransactionType.ASSIGNMENT, (float)unitRowStorage.QtyInStorage, DateAndTime.Now);
gis.InsertGrainInvMinibookingTransaction(mbRow.MiniBookingId, gis.GetLastGrainInventoryTransactionId());
EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, "UnitId: " + unitRowStorage.MiniUnitId.ToString() + " | MbId: " + mbRow.MiniBookingId.ToString(), "ASSIGN", "UNIT", "Storage Unit Source " + unitRowStorage.StorageUnitNumber + " assigned to booking " + mbRow.BookingNumber);
}
}
}
}
var cep = new CeresExcelPendingSync();
cep.RecordId = mbRow.MiniBookingId;
cep.EmployeeId = My.MyProject.Forms.FrmLoginWindow._userID;
cep.SyncType = "UNIT ASSIGNMENT";
cep.ExtraInfo = "";
cep.CurrentStatus = "QUEUE";
cep.QtyOfAttempts = 0;
cep.SyncMessage = "ADDED TO QUEUE";
cep.CreatedAt = DateAndTime.Now;
CeresExcService.AddOrUpdate(cep);
}
shouldNotAssignList.Clear();
assignBunifuButton1.Update();
checkAsnButton();
}
