public void GetTruckData(ManifestDetailsData mdd)
{
var req = new manifestRequest()
{
command = eCommand.Trucks,
requestId = mdd.RequestId.ToByteArray(),
valist = new List <long>()
{
mdd.DLR_NO
}
};
sm(req);
}
public IEnumerable <IMDMMessage> InsertData(SPCmds SP, IMDMMessage dat)
{
if (dat != null)
{
switch (SP)
{
case SPCmds.INSERTMANIFEST:
ManifestMasterData mst = (ManifestMasterData)dat;
using (cnn = NewConnection())
{
using (var adapter = new SqlDataAdapter())
{
long manid;
using (var command = new SqlCommand(SP.ToString(), cnn))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@DriverId", SqlDbType.Int).Value = 9; //use mst.UserId query the Driver table
command.Parameters.AddWithValue("@TRK_CDE", SqlDbType.VarChar).Value = mst.TRK_CDE;
command.Parameters.AddWithValue("@SHP_DTE", SqlDbType.Date).Value = mst.SHIP_DTE.Date;
command.Parameters.AddWithValue("@DESC$", SqlDbType.VarChar).Value = mst.Desc;
command.Parameters.AddWithValue("@LINK", SqlDbType.BigInt).Value = mst.LINK;
command.Parameters.AddWithValue("@NOTES", SqlDbType.VarChar).Value = mst.NOTES;
var retVal = command.Parameters.Add("@ManifestId", SqlDbType.BigInt);
retVal.Direction = ParameterDirection.Output;
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
manid = (long)retVal.Value;
mst.ManifestId = manid;
yield return(mst);
}
}
}
break;
case SPCmds.INSERTMANIFESTDETAILS:
ManifestDetailsData mdd = (ManifestDetailsData)dat;
//SQL = @"";
using (cnn = NewConnection())
{
using (var adapter = new SqlDataAdapter())
{
using (var command = new SqlCommand(SP.ToString(), cnn))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ManifestId", SqlDbType.Int).Value = mdd.ManId;
command.Parameters.AddWithValue("@DSP_SEQ", SqlDbType.Int).Value = mdd.DSP_SEQ;
command.Parameters.AddWithValue("@DLR_NO", SqlDbType.BigInt).Value = mdd.DLR_NO;
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
yield return(mdd);
}
}
}
break;
case SPCmds.INSERTORDER:
OrderMasterData omd = (OrderMasterData)dat;
//SQL = @"";
using (cnn = NewConnection())
{
using (var adapter = new SqlDataAdapter())
{
using (var command = new SqlCommand(SP.ToString(), cnn))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ORD_NO", SqlDbType.BigInt).Value = omd.ORD_NO;
command.Parameters.AddWithValue("@DLR_NO", SqlDbType.BigInt).Value = omd.DLR_NO;
command.Parameters.AddWithValue("@SHP_DTE", SqlDbType.Date).Value = omd.SHP_DTE.Date;
command.Parameters.AddWithValue("@DLR_NME", SqlDbType.VarChar).Value = omd.DLR_NME;
command.Parameters.AddWithValue("@SHP_NME", SqlDbType.VarChar).Value = omd.SHP_NME;
command.Parameters.AddWithValue("@SHP_ADDR", SqlDbType.VarChar).Value = omd.SHP_ADDR;
command.Parameters.AddWithValue("@SHP_ADDR2", SqlDbType.VarChar).Value = omd.SHP_ADDR2;
command.Parameters.AddWithValue("@SHP_TEL", SqlDbType.VarChar).Value = omd.SHP_TEL;
command.Parameters.AddWithValue("@SHP_ZIP", SqlDbType.VarChar).Value = omd.SHP_ZIP;
command.Parameters.AddWithValue("@CUS_NME", SqlDbType.VarChar).Value = omd.CUS_NME;
command.Parameters.AddWithValue("@RTE_CDE", SqlDbType.VarChar).Value = omd.RTE_CDE;
command.Parameters.AddWithValue("@SHP_QTY", SqlDbType.Int).Value = omd.SHP_QTY;
command.Parameters.AddWithValue("@MAN_ID", SqlDbType.Int).Value = omd.ManId;
var retVal = command.Parameters.Add("@CustomerIdOut", SqlDbType.Int);
retVal.Direction = ParameterDirection.Output;
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
yield return(omd);
}
}
}
break;
case SPCmds.INSERTORDERDETAILS:
OrderDetailsData odd = (OrderDetailsData)dat;
//SQL = @"";
using (cnn = NewConnection())
{
using (var adapter = new SqlDataAdapter())
{
using (var command = new SqlCommand(SP.ToString(), cnn))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ORD_NO", SqlDbType.BigInt).Value = odd.ORD_NO;
command.Parameters.AddWithValue("@MDL_NO", SqlDbType.Int).Value = odd.MDL_NO;
command.Parameters.AddWithValue("@DESC", SqlDbType.VarChar).Value = odd.DESC;
command.Parameters.AddWithValue("@CLR", SqlDbType.Int).Value = odd.CLR;
command.Parameters.AddWithValue("@WIDTH", SqlDbType.BigInt).Value = odd.WIDTH;
command.Parameters.AddWithValue("@HEIGHT", SqlDbType.BigInt).Value = odd.HEIGHT;
command.Parameters.AddWithValue("@MDL_CNT", SqlDbType.Int).Value = odd.MDL_CNT;
command.Parameters.AddWithValue("@WIN_CNT", SqlDbType.Int).Value = odd.WIN_CNT;
command.Parameters.AddWithValue("@Status", SqlDbType.VarChar).Value = "LOADED";
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
yield return(odd);
}
}
}
break;
case SPCmds.INSERTORDEROPTIONS:
OrderOptionsData oop = (OrderOptionsData)dat;
//SQL = @"";
using (cnn = NewConnection())
{
using (var adapter = new SqlDataAdapter())
{
using (var command = new SqlCommand(SP.ToString(), cnn))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ORD_NO", SqlDbType.BigInt).Value = oop.ORD_NO;
command.Parameters.AddWithValue("@MDL_NO", SqlDbType.Int).Value = oop.MDL_NO;
command.Parameters.AddWithValue("@DESC", SqlDbType.VarChar).Value = oop.DESC;
command.Parameters.AddWithValue("@CLR", SqlDbType.Int).Value = oop.CLR;
command.Parameters.AddWithValue("@MDL_CNT", SqlDbType.Int).Value = oop.MDL_CNT;
// command.Parameters.AddWithValue("@WIN_CNT", SqlDbType.Int).Value = oop.WIN_CNT;
command.Parameters.AddWithValue("@Status", SqlDbType.VarChar).Value = "LOADED";
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
yield return(oop);
}
}
}
break;
default:
throw new Exception("UM SQL Server Stored Procedure Not Found.");
}
}
yield break;
}
public isaCommand ReceiveMessage(isaCommand cmd)
{
switch (cmd.command)
{
case eCommand.Ping:
Logger.Debug($"ReceiveMessage - Received Ping / Replying Pong..");
WinSysSM.SendMessage(new Command()
{
command = eCommand.Pong
});
break;
case eCommand.Pong:
Logger.Debug($"ReceiveMessage - Received Pong");
break;
case eCommand.LoadFiles:
Logger.Info($"ReceiveMessage - Copy Files from Winsys Server Paths top App Server Paths:{cmd.ToString()}");
//CopyFilesToServer(DateTime.Today);
Logger.Info($"ReceiveMessage - Replying LoadFilesComplete...");
WinSysSM.SendMessage(new Command()
{
command = eCommand.LoadFilesComplete
});
//cbsend(new Command() { command = eCommand.LoadFilesComplete }.ToArray());
break;
case eCommand.GenerateManifest:
Logger.Info($"ReceiveMessage - Generate Manifest from Winsys and SqlServer:{cmd.ToString()}");
manifestRequest req = (manifestRequest)cmd;
WinSysSM.SendMessage(req);
break;
case eCommand.ManifestDetails:
Logger.Info($"ReceiveMessage - Generate Manifest Details from Winsys - API Drill Down:{cmd.ToString()}");
manifestDetails manDet = (manifestDetails)cmd;
ManifestDetailsData manDetData = new ManifestDetailsData(manDet);
Logger.Info($"INSERTMANIFESTDETAILS (Persist): {manDetData.ToString()}");
if (!dManDetails.ContainsKey(manDetData.RequestId.ToString() + manDetData.ManId.ToString()))
{
dManDetails.Add(manDetData.RequestId.ToString() + manDetData.ManId.ToString(), new List <ManifestDetailsData>());
}
foreach (var omdit in UMDServer.Persist(SPCmds.INSERTMANIFESTDETAILS, manDetData))
{
dManDetails[manDetData.RequestId.ToString() + manDetData.ManId.ToString()].Add(manDetData);
}
Logger.Info($"ManifestDetails Complete: {manDet.ToString()}");
break;
case eCommand.ManifestDetailsComplete:
Logger.Info($"ReceiveMessage - ManifestDetailsComplete:{cmd.ToString()}");
req = (manifestRequest)cmd;
List <ManifestDetailsData> mdd = null;
if (dManDetails.ContainsKey(NewGuid(req.requestId).ToString() + req.id.ToString()))
{
mdd = dManDetails[NewGuid(req.requestId).ToString() + req.id.ToString()];
dManDetails.Remove(NewGuid(req.requestId).ToString() + req.id.ToString());
}
if (!dManDetails.ContainsKey(NewGuid(req.requestId).ToString()) && mdd != null && mdd.Count > 0)
{
drillDown.GetOrderMasterData(new manifestRequest()
{
valist = req.valist, requestId = req.requestId, date = req.date, id = req.id
});
}
dRetCall[NewGuid(cmd.requestId)](req.ToArray());
//drillDown.reportMDProgressChanged(100, cmd);
break;
case eCommand.OrdersUpload:
Logger.Info($"ReceiveMessage - Orders reqId: {cmd.requestId}");
List <IMDMMessage> lstOrd = new List <IMDMMessage>();
OrderMasterData omd = new OrderMasterData(((orderMaster)cmd));
orderMaster om = new orderMaster(omd);
//omd.Status = OrderStatus.Shipped;
lock (dOrdLock)
{
if (!dOrdersMaster.ContainsKey(omd.RequestId.ToString() + omd.ManId.ToString()))
{
dOrdersMaster.Add(omd.RequestId.ToString() + omd.ManId.ToString(), new List <OrderMasterData>());
}
}
if (!dOrdersMaster[omd.RequestId.ToString() + omd.ManId.ToString()].Contains(omd))
{
foreach (var omdit in UMDServer.Persist(SPCmds.INSERTORDER, omd))
{
lock (dOrdLock)
dOrdersMaster[omd.RequestId.ToString() + omd.ManId.ToString()].Add((OrderMasterData)omdit);
}
}
break;
case eCommand.OrdersLoad:
Logger.Info($"ReceiveMessage - OrdersLoad reqId: {cmd.requestId}");
orderMaster ord = (orderMaster)cmd;
OrderMasterData omdata = new OrderMasterData(ord);
lock (dOrdLock)
{
if (!dOrdersMaster.ContainsKey(NewGuid(ord.requestId).ToString() + ord.ManId.ToString()))
{
dOrdersMaster.Add(NewGuid(ord.requestId).ToString() + ord.ManId.ToString(), new List <OrderMasterData>());
}
}
if (!dOrdersMaster[omdata.RequestId.ToString() + omdata.ManId.ToString()].Contains(omdata))
{
foreach (var omdit in UMDServer.Persist(SPCmds.INSERTORDER, omdata))
{
lock (dOrdLock)
dOrdersMaster[omdata.RequestId.ToString() + omdata.ManId.ToString()].Add((OrderMasterData)omdit);
}
}
break;
case eCommand.OrdersLoadComplete:
Logger.Info($"ReceiveMessage - OrdersLoadComplete:{cmd.ToString()}");
req = (manifestRequest)cmd;
if (dOrdersMaster.ContainsKey(NewGuid(cmd.requestId).ToString() + req.id))
{
List <OrderMasterData> lMOrd = dOrdersMaster[NewGuid(cmd.requestId).ToString() + req.id.ToString()].Distinct().ToList();
lMOrd.ForEach(x => Logger.Info($"ordldcmp{x.ORD_NO}"));
drillDown.GetDrillDownData(req.valist, eCommand.OrderDetails, req.requestId, 1);
drillDown.GetDrillDownData(req.valist, eCommand.OrderOptions, req.requestId);
lock (dOrdLock)
dOrdersMaster.Remove(NewGuid(cmd.requestId).ToString() + req.id);
}
else
{
Logger.Info($"No Orders for {cmd.ToString()}");
}
// throw new Exception("OrdersLoadComplete - response not mapped in dOrderMaster. " +
// "Request Id: {NewGuid(cmd.requestId).ToString()} , id: {req.id}. ");
dRetCall[NewGuid(cmd.requestId)](req.ToArray());
break;
case eCommand.OrderDetails:
Logger.Info($"ReceiveMessage - OrderDetails:{cmd.ToString()}");
try
{
orderDetails od = (orderDetails)cmd;
OrderDetailsData odd = new OrderDetailsData(od);
lock (dOrdLock)
{
if (!dOrdersDetails.ContainsKey(odd.RequestId))
{
dOrdersDetails.Add(odd.RequestId, new List <OrderDetailsData>());
}
}
foreach (var odit in UMDServer.Persist(SPCmds.INSERTORDERDETAILS, odd))
{
Logger.Info($"INSERTORDERDETAILS Complete: {odit.ToString()}");
}
//dRetCall[NewGuid(od.requestId)](cmd.ToArray());
}
catch (Exception ex) { Logger.Error($"eCommand.OrderDetails {ex.Message}"); }
break;
case eCommand.OrderDetailsComplete:
Logger.Info($"ReceiveMessage - OrderDetailsComplete:{cmd.ToString()}");
// Can we detrmine the completed transaction at this point from the cmd in order to clean the completed tx for dRetCall
req = (manifestRequest)cmd;
lock (dOrdLock)
{
if (dOrdersDetails.ContainsKey(NewGuid(cmd.requestId)))
{
// drillDown.GetOrderOptionsData(dOrdersDetails[NewGuid(cmd.requestId)].Distinct().ToList());
//drillDown.GetOrderOptionsData(ordersToRequestDetails[NewGuid(cmd.requestId)]);
dOrdersDetails.Remove(NewGuid(cmd.requestId));
}
}
//dRetCall[NewGuid(cmd.requestId)](req.ToArray());
break;
case eCommand.OrderOptions:
Logger.Info($"ReceiveMessage - OrderOptions reqId:{cmd.ToString()}");
try
{
orderOptions oo = (orderOptions)cmd;
OrderOptionsData ood = new OrderOptionsData(oo);
foreach (var oodit in UMDServer.Persist(SPCmds.INSERTORDEROPTIONS, ood))
{
Logger.Info($"INSERTORDEROPTIONS Complete: {oodit.ToString()}");
}
//oo.command = eCommand.OrderOptionsComplete;
//dRetCall[NewGuid(oo.requestId)](cmd.ToArray());
}
catch (Exception ex) { Logger.Error($"eCommand.OrderOptions {ex.Message}"); }
break;
case eCommand.OrderOptionsComplete:
Logger.Info($"ReceiveMessage - OrderOptionsComplete:{cmd.ToString()}");
// Can we detrmine the completed transaction at this point from the cmd in order to clean the completed tx for dRetCall
req = (manifestRequest)cmd;
dRetCall[NewGuid(cmd.requestId)](req.ToArray());
break;
case eCommand.OrderUpdatesComplete:
Logger.Info($"ReceiveMessage - OrderUpdatesComplete:{cmd.ToString()}");
req = (manifestRequest)cmd;
dRetCall[NewGuid(cmd.requestId)](req.ToArray());
break;
case eCommand.ManifestLoadComplete:
Logger.Info($"ReceiveMessage - OrdersLoadComplete:{cmd.ToString()}");
Logger.Info($"ReceiveMessage - OrderDetailsComplete:{cmd.ToString()}");
req = (manifestRequest)cmd;
dRetCall[NewGuid(cmd.requestId)](req.ToArray());
break;
case eCommand.ScanFile:
Logger.Info($"ReceiveMessage Cached Success - ScanFile:{cmd.ToString()}");
scanFile sf = (scanFile)cmd;
ScanFileData sfd = new ScanFileData(sf);
foreach (var scnfle in UMDServer.Persist(SPCmds.INSERTSCANFILE, sfd))
{
Logger.Info($"INSERTSCNFLE Complete: {scnfle.ToString()}");
}
//if(cmd.requestId==null)
// dRetCall.FirstOrDefault().Value(sf.ToArray());
//else
// dRetCall[NewGuid(cmd.requestId)](sf.ToArray());
break;
default:
Logger.Error("ReceiveMessage - ERROR Unknown command. Parse Error MDM-API");
break;
}
return(cmd);
}
void bgWorker_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
object[] parameters = e.UserState as object[];
isaCommand cmd = (isaCommand )parameters[0];
Func <byte[], Task> cbsend = null;
if (parameters.Length == 3)
{
cbsend = (Func <byte[], Task>)parameters[2];
}
IMDMMessage mcmd = null;
switch (cmd.command)
{
case eCommand.Manifest:
mcmd = new ManifestMasterData((manifestMaster)cmd, ((manifestMaster)cmd).id);
Sendback((O)mcmd, cbsend);
break;
case eCommand.ManifestLoadComplete:
manifestRequest mreq = (manifestRequest)cmd;
if (mreq.valist != null)
{
foreach (var it in mreq.valist)
{
mcmd = new ManifestMasterData()
{
RequestId = new Guid(cmd.requestId),
LINK = it,
SHIP_DTE = DateTime.Today,
Command = eCommand.ManifestLoadComplete
};
Sendback((O)mcmd, cbsend);
}
}
else
{
mcmd = new ManifestMasterData()
{
RequestId = new Guid(cmd.requestId),
LINK = -1,
SHIP_DTE = DateTime.Today,
Command = eCommand.ManifestLoadComplete
};
Sendback((O)mcmd, cbsend);
}
break;
case eCommand.CheckManifestComplete:
mcmd = new ManifestMasterData((manifestMaster)cmd, ((manifestMaster)cmd).id, false);
Sendback((O)mcmd, cbsend);
break;
case eCommand.CheckManifest:
mcmd = new ManifestMasterData((manifestMaster)cmd, ((manifestMaster)cmd).id, false);
Sendback((O)mcmd, cbsend);
break;
case eCommand.Drivers:
mcmd = new DriverData()
{
Command = cmd.command
};
Sendback((O)mcmd, cbsend);
break;
case eCommand.DriversLoadComplete:
mcmd = (DriverData)cmd;
Sendback((O)mcmd, cbsend);
CompleteBackgroundWorker(new Guid(cmd.requestId));
break;
case eCommand.ManifestDetails:
mcmd = new ManifestDetailsData()
{
Command = cmd.command
};
Sendback((O)mcmd, cbsend);
break;
case eCommand.AccountReceivable:
mcmd = new AccountsReceivableData((accountReceivable)cmd);
Sendback((O)mcmd, cbsend);
break;
case eCommand.ManifestDetailsComplete:
mreq = (manifestRequest)cmd;
if (mreq.valist != null)
{
foreach (var it in mreq.valist)
{
mcmd = new ManifestDetailsData()
{
RequestId = new Guid(cmd.requestId),
DLR_NO = it,
Command = eCommand.ManifestDetailsComplete
};
Sendback((O)mcmd, cbsend);
}
}
else
{
mcmd = new ManifestMasterData()
{
RequestId = new Guid(cmd.requestId),
LINK = -1,
SHIP_DTE = DateTime.Today,
Command = eCommand.ManifestLoadComplete
};
Sendback((O)mcmd, cbsend);
}
//mcmd = new ManifestDetailsData((manifestDetails)cmd);
//Sendback((O)mcmd, cbsend);
//CompleteBackgroundWorker(new Guid(cmd.requestId));
break;
//case eCommand.OrdersLoad:
// mcmd = new OrderMasterData() {
// Command = cmd.command,
// ORD_NO=((orderMaster)cmd).ORD_NO,
// Status = ((orderMaster)cmd).Status
// };
// Sendback((O)mcmd, cbsend);
// break;
case eCommand.OrdersUpload:
mcmd = new OrderMasterData()
{
Command = cmd.command,
ORD_NO = ((orderMaster)cmd).ORD_NO,
Status = ((orderMaster)cmd).Status
};
Sendback((O)mcmd, cbsend);
break;
case eCommand.OrderUpdatesComplete:
mreq = (manifestRequest)cmd;
if (mreq.valist != null)
{
foreach (var it in mreq.valist)
{
mcmd = new OrderMasterData()
{
RequestId = new Guid(cmd.requestId),
ORD_NO = (int)it,
Command = eCommand.ManifestDetailsComplete
};
Sendback((O)mcmd, cbsend);
}
}
break;
case eCommand.OrderDetails:
mcmd = new OrderDetailsData((orderDetails)cmd);
Sendback((O)mcmd, cbsend);
break;
case eCommand.OrderDetailsComplete:
mreq = (manifestRequest)cmd;
if (mreq.valist != null)
{
foreach (var it in mreq.valist)
{
mcmd = new OrderDetailsData()
{
RequestId = new Guid(cmd.requestId),
ORD_NO = it,
LineNumber = mreq.Stop, // using as the count (number of OrderDetail Records Expected)
Command = eCommand.OrderDetailsComplete
};
Sendback((O)mcmd, cbsend);
}
}
break;
case eCommand.OrderOptions:
mcmd = new OrderOptionsData((orderOptions)cmd);
Sendback((O)mcmd, cbsend);
break;
case eCommand.OrderOptionsComplete:
mreq = (manifestRequest)cmd;
if (mreq.valist != null)
{
foreach (var it in mreq.valist)
{
mcmd = new OrderOptionsData()
{
RequestId = new Guid(cmd.requestId),
ORD_NO = (int)it,
Count = mreq.Stop, // using as the count (number of OrderDetail Records Expected)
Command = eCommand.OrderOptionsComplete
};
Sendback((O)mcmd, cbsend);
}
}
break;
case eCommand.ScanFile:
mcmd = new ScanFileData((scanFile)cmd);
Sendback((O)mcmd, cbsend);
break;
case eCommand.Trucks:
mcmd = new TruckData((trucks)cmd);
Sendback((O)mcmd, cbsend);
break;
case eCommand.TrucksLoadComplete:
mreq = (manifestRequest)cmd;
mcmd = new TruckData()
{
RequestId = new Guid(cmd.requestId),
ManifestId = mreq.id,
Command = eCommand.TrucksLoadComplete
};
Sendback((O)mcmd, cbsend);
break;
case eCommand.Stops:
mcmd = new StopData((stops)cmd);
Sendback((O)mcmd, cbsend);
break;
case eCommand.StopsLoadComplete:
mcmd = new StopData()
{
Command = cmd.command, RequestId = new Guid(cmd.requestId)
};
mreq = (manifestRequest)cmd;
if (mreq.valist != null)
{
foreach (var id in mreq.valist)
{
mcmd = new StopData()
{
Command = cmd.command,
//TruckCode = TRK_CDE,
RequestId = new Guid(cmd.requestId)
};
Sendback((O)mcmd, cbsend);
}
}
else
{
mcmd = new StopData()
{
Command = cmd.command,
//TruckCode = TRK_CDE,
RequestId = new Guid(cmd.requestId)
};
Sendback((O)mcmd, cbsend);
}
break;
case eCommand.OrdersLoad:
mcmd = new OrderData((orders)cmd);
Sendback((O)mcmd, cbsend);
break;
case eCommand.OrdersLoadComplete:
mreq = (manifestRequest)cmd;
if (mreq.valist != null)
{
foreach (var id in mreq.valist)
{
mcmd = new OrderData()
{
Command = cmd.command,
DLR_NO = (int)id,
RequestId = new Guid(cmd.requestId)
};
Sendback((O)mcmd, cbsend);
}
}
else
{
Logger.Info($"OrdersLoadComplete: {cmd.ToString()}");
mcmd = new OrderData()
{
Command = cmd.command,
// DLR_NO = id,
RequestId = new Guid(cmd.requestId)
};
Sendback((O)mcmd, cbsend);
}
break;
case eCommand.UploadManifestComplete:
mcmd = new ManifestMasterData()
{
Command = cmd.command, RequestId = NewGuid(cmd.requestId)
};
Sendback((O)mcmd, cbsend);
break;
default:
Logger.Error($"Unhandled command Backgrtound worker handler {Enum.GetName(typeof(eCommand), cmd.command)}.");
break;
}
}
public void HandleClientCmd(byte[] bytes_cmd, Func <byte[], Task> cbsend)
{
isaCommand cmd = new Command().FromArray(bytes_cmd);
switch (cmd.command)
{
case eCommand.Ping:
Logger.Debug("HandleClientCmd - Received Ping / Replying Pong..");
cbsend(new Command()
{
command = eCommand.Pong
}.ToArray());
break;
case eCommand.Pong:
Logger.Debug("HandleClientCmd - Received Pong");
break;
case eCommand.LoadFiles:
Logger.Info("HandleClientCmd - Copy Files from Winsys Server Paths top App Server Paths:{cmd.ToString()}");
//CopyFilesToServer(DateTime.Today);
Logger.Info("HandleClientCmd - Replying LoadFilesComplete...");
cbsend(new Command()
{
command = eCommand.LoadFilesComplete
}.ToArray());
break;
case eCommand.GenerateManifest:
Logger.Info($"HandleClientCmd - ManifestDetails:{cmd.ToString()}");
manifestMaster mM = (manifestMaster) new manifestMaster().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd Generate Manifest from Winsys and SqlServer:{mM.ToString()}");
if (mM.LINK != 0)
{
ManifestMasterData mmd = (ManifestMasterData)UMDServer.QueryData(cbsend, mM);
Logger.Info($"API Manager GenerateManifest. {mmd.ToString()}");
}
else
{
WinSysSM.SendMessage(cmd);
}
break;
case eCommand.CheckManifest:
Logger.Info($"HandleClientCmd - CheckManifest:{cmd.ToString()}");
//ManifestMasterData mMstData = (ManifestMasterData)new ManifestMasterData(bytes_cmd);
manifestMaster mMst = (manifestMaster) new manifestMaster().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd Compare Manifest from Winsys to SqlServer: {mMst.ToString()}");
ManifestMasterData mamd = (ManifestMasterData)UMDServer.QueryData(cbsend, mMst);
Logger.Info($"API Manager GenerateManifest. {mamd.ToString()}");
break;
case eCommand.RunQuery:
Logger.Info($"HandleClientCmd - ManifestDetails: {cmd.ToString()}");
//DriverData dd = (DriverData)GetDrivers(cbsend);
break;
case eCommand.Manifest:
Logger.Info($"HandleClientCmd - Manifest from Winsys and SqlServer:{cmd.ToString()}");
cbsend(cmd.ToArray());
break;
case eCommand.Trucks:
Logger.Info($"HandleClientCmd - Trucks: {cmd.ToString()}");
isaCommand req = new manifestRequest().FromArray(bytes_cmd);
TruckData td = (TruckData)UMDServer.QueryData(cbsend, req);
Logger.Info($"HandleClientCmd - Trucks. reqId:{req.ToString()}");
break;
case eCommand.ManifestDetails:
Logger.Info($"HandleClientCmd - ManifestDetails:{cmd.ToString()}");
isaCommand reqmd = new manifestRequest().FromArray(bytes_cmd);
// ManifestDetailsData mdd =
manifestDetails manDet = new manifestDetails();
ManifestDetailsData manDetData = (ManifestDetailsData)manDet.FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - ManifestDetails:{manDetData.ToString()}");
foreach (var mmd in UMDServer.Persist(SPCmds.INSERTMANIFESTDETAILS, manDetData))
{
drillDown.GetOrderMasterData((ManifestDetailsData)mmd);
mmd.Command = eCommand.ManifestDetails;
mmd.RequestId = new Guid(manDet.requestId);
Logger.Info($"HandleClientCmd - ManifestDetails. Sending GetOrderMasterData:{mmd.ToString()}");
cbsend(((manifestDetails)mmd).ToArray());
}
break;
case eCommand.Orders:
Logger.Info($"HandleClientCmd - ManifestDetails:{cmd.ToString()}");
var om = (orderMaster) new orderMaster().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - Orders. reqId: {om.ToString()}");
foreach (var omd in UMDServer.Persist(SPCmds.INSERTORDER, new OrderMasterData(om)))
{
drillDown.GetOrderDetailsData((OrderMasterData)omd);
}
break;
case eCommand.OrderOptions:
Logger.Info($"HandleClientCmd - ManifestDetails:{cmd.ToString()}");
var oo = (orderOptions) new orderOptions().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - OrderOptions:{cmd.ToString()}");
foreach (var mmd in UMDServer.Persist(SPCmds.INSERTORDEROPTIONS, new OrderOptionsData(oo)))
{
var oopt = new orderOptions((OrderOptionsData)mmd);
oopt.command = eCommand.OrderOptionsComplete;
cbsend(oopt.ToArray());
}
break;
case eCommand.OrderDetails:
Logger.Info($"HandleClientCmd - ManifestDetails:{cmd.ToString()}");
var odt = (orderDetails) new orderDetails().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - OrderDetails: {odt.ToString()}");
foreach (var mmd in UMDServer.Persist(SPCmds.INSERTORDERDETAILS, new OrderDetailsData(odt)))
{
orderDetails odd = new orderDetails((OrderDetailsData)mmd);
odd.command = eCommand.OrderDetailsComplete;
cbsend(odd.ToArray());
}
break;
case eCommand.Drivers:
Logger.Info($"HandleClientCmd - ManifestDetails:{cmd.ToString()}");
req = new manifestRequest().FromArray(bytes_cmd);
DriverData dd = (DriverData)UMDServer.QueryData(cbsend, req);
//drivers drvs = new drivers(dd);
//drvs.command = eCommand.DriversLoadComplete;
//cbsend(drvs.ToArray());
//cbsend(new Command() { command = eCommand.DriversLoadComplete, value = dd.DriverId.ToString() }.ToArray());
break;
case eCommand.UploadManifest:
Logger.Info($"HandleClientCmd - UploadManifest:{cmd.ToString()}");
manifestRequest mreq = (manifestRequest) new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - UploadManifest: {mreq.ToString()}");
//ManifestMasterData Mmd = (ManifestMasterData)cmd;
manifestMaster mm = (manifestMaster) new manifestMaster().FromArray(mreq.bData);
IEnumerable <IMDMMessage> mmdata = UMDServer.Persist(SPCmds.INSERTMANIFEST, new ManifestMasterData(mm, mm.id));
Logger.Info($"HandleClientCmd - UploadManifest Persisted:{mm.ToString()}");
try
{
ManifestMasterData mmd = null;
foreach (var mmdIt in mmdata)
{
mmd = (ManifestMasterData)mmdIt;
Logger.Info($"HandleClientCmd - UploadManifest - Get ManifestDetails sending ManMastData Trk:{mmd.ToString()}");
drillDown.GetManifestDetails(mmd, cbsend);
}
if (mmd != null)
{
manifestMaster mmRet = new manifestMaster(mmd);
mmRet.command = eCommand.ManifestLoadComplete;
Logger.Info($"HandleClientCmd - UploadManifest - Done (ManifestLoadComplete):{mreq.ToString()}");
cbsend(mmRet.ToArray());
}
}
catch (Exception e)
{
Logger.Debug("HandleClientCmd - Error exception = " + e.Message);
}
break;
case eCommand.Stops:
Logger.Info($"HandleClientCmd - Stops. reqId:{cmd.ToString()}");
req = new manifestRequest().FromArray(bytes_cmd);
StopData sd = (StopData)UMDServer.QueryData(cbsend, req);
stops stps = new stops(sd);
stps.command = eCommand.StopsLoadComplete;
cbsend(stps.ToArray());
break;
case eCommand.OrdersLoad:
req = new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - OrdersLoad (Start QueryData): {req.ToString()}");
OrderData od = (OrderData)UMDServer.QueryData(cbsend, req);
orders odrs = new orders(od);
odrs.command = eCommand.OrdersLoadComplete;
Logger.Info($"HandleClientCmd - OrdersLoad (OrdersLoadComplete): {odrs.ToString()}");
cbsend(odrs.ToArray());
break;
default:
Logger.Error("HandleClientCmd - ERROR Unknown command. Parse Error MDM-API");
break;
}
}
