private DataTable GetDistAcceptedList()
{
var acptList = new DataTable();
var Db = new DatabaseHelperCeres();
string fields;
fields = @"[ReleaseNumber] as [Release Number]
,[QtyRequested] as [Qty Requested]
,[FromDateReq] as [From Date Req]
,[ToDateReq] as [To Date Req]
,[QtyAccepted] as [Qty Acpt]
,[FromDateAcpt] as [From Date Acpt]
,[ToDateAcpt] as [To Date Acpt]
,[DateAccepted] as [Date Accepted]
,[StatusNameSch] [Status]";
acptList = Db.getTableInfo("VW_RelDistReqSchRelDistSchAccpt", fields, "where ReleaseDistributionRequestId = " + SelecDistReq.ReleaseDistributionRequestId.ToString(0.ToString()));
return(acptList);
}
public void unassignbooking(string bookingBumber, List <int> selectedCountainers, bool isBookingChange)
{
// My.MyProject.Forms.FrmParentScreen.showLOadForm();
string ThisXLSFile = "";
var dbCeres = new DatabaseHelperCeres();
try
{
// unassign on database
var canInOut = new Containers_In_OutService();
foreach (var contNum in selectedCountainers)
{
dbCeres.unassignBooking(contNum, false);
canInOut.UnassignContainerFromMinibooking(contNum, SelectedMBObj.MiniBookingId, false);
EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, "CanID: " + contNum.ToString() + " | MbID: " + SelectedMBObj.MiniBookingId.ToString(), "UNASSIGN", "CONTAINER", "Container unassigned from booking");
}
var cep = new CeresExcelPendingSync();
cep.RecordId = SelectedMBObj.MiniBookingId;
cep.EmployeeId = My.MyProject.Forms.FrmLoginWindow._userID;
cep.SyncType = "CONTAINER ASSIGNMENT";
cep.ExtraInfo = "";
cep.CurrentStatus = "QUEUE";
cep.QtyOfAttempts = 0;
cep.SyncMessage = "ADDED TO QUEUE";
cep.CreatedAt = DateAndTime.Now;
CeresExcService.AddOrUpdate(cep);
// My.MyProject.Forms.FrmParentScreen.HideLoadForm();
}
catch (Exception ex)
{
MessageBox.Show("An unexpected error occured. Please close this tab and try again. Error: " + ex.Message);
// My.MyProject.Forms.FrmParentScreen.HideLoadForm();
}
selectedAssgnContainers.Clear();
}
