public ManifestMasterData(manifestMaster dat, long id, bool isSelected = false)
{
Command = dat.command;
RequestId = NewGuid(dat.requestId);
if (dat.id != 0)
{
ManifestId = dat.id;
}
else
{
ManifestId = id;
}
Userid = dat.DriverId.ToString();
TRK_CDE = dat.TRK_CDE.UMToString(fldsz_TRK_CDE_Master);
//SHIP_DTE = DateTime.FromBinary(dat.SHIP_DTE).Date;
SHIP_DTE = ExtensionMethods.FromJulianToGregorianDT(dat.SHIP_DTE, "yyyy-MM-dd").Date;
Desc = dat.DESC; //.UMToString(fldsz_DESC);
NOTES = dat.NOTES; //.UMToString(fldsz_NOTES * sizeof(char));
LINK = dat.LINK;
TRUCKISCLOSED = Convert.ToBoolean(dat.TRUCKISCLOSED);
//SEAL_DTE = ;
SHP_QTY = dat.SHP_QTY;
IsSelected = isSelected;
status = Definitions.status.Uploaded;
Status = TruckManifestStatus.New;
//if (dat.md != null)
//{
// md = new ManifestDetailsData(dat.md, 2);
//}
}
void UploadManifestMasterData(ManifestMasterData mm)
{
if (mm.IsSelected)
{
Logger.Info($"ManifestVM UploadManifestMasterData: {mm.ToString()}");
Clear();
var req = new Request()
{
reqGuid = mm.RequestId,
LIds = new Dictionary <long, status>(),
LinkMid = new Dictionary <long, List <long> >(),
ChkIds = new Dictionary <long, status>()
};
dRequests.Add(req.reqGuid, req);
manifestMaster manUp = new manifestMaster(mm);
manUp.command = eCommand.UploadManifest;
ProcessMsgDelegateRXRaw pmRx = new ProcessMsgDelegateRXRaw(ProcessMessage);
Logger.Info($"Upload Manifest reqie: {req.reqGuid}");
manifestMasterThread.OnStartProcess((new manifestRequest()
{
requestId = req.reqGuid.ToByteArray(),
command = manUp.command,
bData = manUp.ToArray(),
id = manUp.id
}), req, pmRx);
}
}
public static isaCommand myQueryData_GetManifest(SqlDataReader reader, Func <byte[], Task> cb)
{
manifestMaster mm = new manifestMaster();
try
{
mm.id = reader.GetInt64(reader.GetOrdinal("ManifestId"));
mm.DriverId = reader.GetInt32(reader.GetOrdinal("DriverId"));
mm.TRK_CDE = reader.GetString(reader.GetOrdinal("TRK_CDE")).GetBytes();
mm.SHIP_DTE = reader.GetDateTime(reader.GetOrdinal("SHP_DTE")).ToBinary();
mm.DESC = reader.GetString(reader.GetOrdinal("DESC$")).StringToByteArray(fldsz_DESC);
mm.NOTES = reader.GetString(reader.GetOrdinal("NOTES")).StringToByteArray(fldsz_NOTES * sizeof(char));;
mm.LINK = reader.GetInt64(reader.GetOrdinal("LINK"));
//mm.command = eCommand.ManifestLoadComplete;
}
catch (Exception ex) { }
return(mm);
}
public IMDMMessage QueryData(Func <byte[], Task> cb, isaCommand dat)
{
IMDMMessage retVal = null;
SPCmds SP;
manifestRequest req; // (manifestRequest)dat;
switch (dat.command)
{
case eCommand.Drivers:
SP = SPCmds.GETAVAILABLEDRIVERS;
break;
case eCommand.Manifest:
SP = SPCmds.GETDRIVERMANIFEST;
break;
case eCommand.Trucks:
SP = SPCmds.GETTRUCKS;
break;
case eCommand.Stops:
SP = SPCmds.GETSTOPS;
break;
case eCommand.Orders:
case eCommand.OrdersLoad:
SP = SPCmds.GETORDERS;
break;
case eCommand.GenerateManifest:
SP = SPCmds.GETMANIFEST;
break;
default:
throw new Exception("Not handled");
}
using (SqlConnection cnn = new SqlConnection(UMDDB.connectionString))
{
using (var adapter = new SqlDataAdapter())
{
using (var command = new SqlCommand(SP.ToString(), cnn))
{
command.CommandType = CommandType.StoredProcedure;
switch (dat.command)
{
case eCommand.Drivers:
req = (manifestRequest)dat;
command.Parameters.AddWithValue("@SHP_DTE", SqlDbType.Date).Value = DateTime.Parse(req.date).Date.ToString("yyyy-MM-dd");
dat.command = eCommand.DriversLoadComplete;
retVal = new DriverData()
{
RequestId = new Guid(req.requestId)
};
Logger.Info($"QueryData Drivers. Cmd:{retVal.Command.ToString()} reqId: {retVal.RequestId.ToString()} SHP_DTE: {DateTime.Parse(req.date).Date.ToString("yyyy-MM-dd")}");
break;
case eCommand.Manifest:
req = (manifestRequest)dat;
command.Parameters.AddWithValue("@DriverId", SqlDbType.Int).Value = req.id;
retVal = new ManifestMasterData()
{
RequestId = new Guid(req.requestId)
};
Logger.Info($"QueryData Manifest. Cmd:{retVal.Command.ToString()} reqId: {retVal.RequestId.ToString()} DriverId: {req.id} ");
dat.command = eCommand.ManifestLoadComplete;
break;
case eCommand.Trucks:
req = (manifestRequest)dat;
command.Parameters.AddWithValue("@SHP_DTE", SqlDbType.Date).Value = DateTime.Parse(req.date).Date.ToString("yyyy-MM-dd");
dat.command = eCommand.TrucksLoadComplete;
Logger.Info($"QueryData Trucks. Cmd:{req.command.ToString()} reqId: {new Guid(req.requestId).ToString()} SHP_DTE: {DateTime.Parse(req.date).Date.ToString("yyyy-MM-dd")}");
retVal = new TruckData()
{
RequestId = new Guid(req.requestId)
};
break;
case eCommand.Stops:
req = (manifestRequest)dat;
command.Parameters.AddWithValue("@ManifestId", SqlDbType.Int).Value = req.id;
dat.command = eCommand.StopsLoadComplete;
Logger.Info($"QueryData Stops. Cmd:{req.command.ToString()} reqId: {new Guid(req.requestId).ToString()} manId: {req.id}");
retVal = new StopData()
{
RequestId = new Guid(req.requestId)
};
break;
case eCommand.Orders:
case eCommand.OrdersLoad:
req = (manifestRequest)dat;
command.Parameters.AddWithValue("@ManifestId", SqlDbType.Int).Value = req.id;
dat.command = eCommand.OrdersLoadComplete;
command.Parameters.AddWithValue("@Stop", SqlDbType.Int).Value = req.Stop;
Logger.Info($"QueryData Orders. Cmd:{req.command.ToString()} reqId: {new Guid(req.requestId).ToString()} stop: {req.Stop.ToString()}");
retVal = new OrderMasterData()
{
RequestId = new Guid(req.requestId)
};
break;
case eCommand.GenerateManifest:
// req = (manifestRequest)dat;
command.Parameters.AddWithValue("@Link", SqlDbType.BigInt).Value = ((manifestMaster)dat).LINK;
dat.command = eCommand.ManifestLoadComplete;
Logger.Info($"QueryData GenerateManifest. " +
$"Cmd:{dat.command.ToString()} " +
$"reqId: {new Guid(dat.requestId).ToString()}" +
$"link: { ((manifestMaster)dat).LINK}");
retVal = new ManifestMasterData()
{
LINK = ((manifestMaster)dat).LINK, RequestId = new Guid(dat.requestId)
};
break;
default:
{
Logger.Error($"QueryData Unkonwn Command. " +
$"Cmd:{retVal.Command.ToString()} " +
$"reqId: {retVal.RequestId.ToString()}");
throw new Exception("Not handled");
}
}
adapter.SelectCommand = command;
SqlDataReader reader = null;
try
{
cnn.Open();
reader = adapter.SelectCommand.ExecuteReader();
}
catch (Exception ex) { }
while (reader.Read())
{
switch (retVal.Command)
{
case eCommand.Drivers:
drivers drv = (drivers)MyQueryReader_Driver(reader, cb);
drv.requestId = dat.requestId;
drv.command = eCommand.Drivers;
Logger.Info($"QueryData Manifest. Cmd:{drv.command.ToString()} reqId: {new Guid(drv.requestId).ToString()} Link: {drv.DriverId} manId: {drv.LastName}, {drv.FirstName} ");
cb(drv.ToArray());
break;
case eCommand.Manifest:
case eCommand.GenerateManifest:
manifestMaster micmd = (manifestMaster)myQueryData_GetManifest(reader, cb);
micmd.requestId = dat.requestId;
micmd.command = eCommand.Manifest;
Logger.Info($"QueryData Manifest. Cmd:{micmd.command.ToString()} reqId: {new Guid(micmd.requestId).ToString()} Link: {micmd.LINK} manId: {micmd.id} ");
cb(micmd.ToArray());
break;
case eCommand.Trucks:
trucks tcmd = (trucks)MyQueryReader_Trucks(reader, cb);
tcmd.requestId = dat.requestId;
tcmd.command = eCommand.Trucks;
Logger.Info($"QueryData Trucks. Cmd:{tcmd.command.ToString()} reqId: {new Guid(tcmd.requestId).ToString()} TRK_CDE: {tcmd.TruckCode} ManId: {tcmd.ManifestId}");
cb(tcmd.ToArray());
break;
case eCommand.Stops:
stops scmd = (stops)MyQueryReader_Stops(reader, cb);
scmd.requestId = dat.requestId;
scmd.command = eCommand.Stops;
Logger.Info($"QueryData Stops. Cmd:{scmd.command.ToString()} reqId: {new Guid(scmd.requestId).ToString()} manId: {scmd.ManifestId}");
cb(scmd.ToArray());
break;
case eCommand.Orders:
case eCommand.OrdersLoad:
var ocmd = (orders)MyQueryReader_Orders(reader, cb);
ocmd.requestId = dat.requestId;
ocmd.command = eCommand.OrdersLoad;
Logger.Info($"QueryData Orders. Cmd:{ocmd.command.ToString()} reqId: {new Guid(ocmd.requestId).ToString()}");
cb(ocmd.ToArray());
break;
default:
throw new Exception("Not handled");
}
}
Logger.Info($"QueryData Completed. Cmd:{dat.command.ToString()} reqId: {new Guid(dat.requestId).ToString()}");
cb(dat.ToArray());
}
}
}
return(retVal);
}
static Dictionary <short, Dictionary <byte, List <long> > > dTruckCodeToDealerNumbers = new Dictionary <short, Dictionary <byte, List <long> > >(); //TruckCode -> <Seq, List<Orders>>
public static isaCommand CommandFactory(byte[] cmdBytes)
{
isaCommand cmd = new Command().FromArray(cmdBytes);
switch (cmd.command)
{
case eCommand.Broadcast:
//Broadcast cmdType = Broadcast.FromArray(cmdBytes);
break;
case eCommand.DeliveryComplete:
//Broadcast cmdType = Broadcast.FromArray(cmdBytes);
break;
case eCommand.CheckManifest:
case eCommand.CheckManifestComplete:
manifestMaster mamr = new manifestMaster();
cmd = mamr.FromArray(cmdBytes);
break;
case eCommand.GenerateManifest:
manifestRequest mr = new manifestRequest();
cmd = mr.FromArray(cmdBytes);
if (cmd == null)
{
manifestMaster mmr = new manifestMaster();
cmd = mmr.FromArray(cmdBytes);
}
//Call ApplicationServer to return the data requested.
//UMDManifest.
break;
case eCommand.OrdersLoad:
//orders ords = new orders();
//cmd = ords.FromArray(cmdBytes);
orderMaster orm = new orderMaster();
cmd = orm.FromArray(cmdBytes);
break;
case eCommand.Trucks:
trucks trks = new trucks();
cmd = trks.FromArray(cmdBytes);
break;
case eCommand.Stops:
stops stps = new stops();
cmd = stps.FromArray(cmdBytes);
break;
case eCommand.OrderDetails:
orderDetails cmdType = new orderDetails();
cmd = cmdType.FromArray(cmdBytes);
break;
case eCommand.Manifest:
manifestMaster mm = new manifestMaster();
cmd = mm.FromArray(cmdBytes);
break;
case eCommand.ManifestDetails:
manifestDetails md = new manifestDetails();
cmd = md.FromArray(cmdBytes);
break;
case eCommand.OrdersUpload:
orderMaster om = new orderMaster();
cmd = om.FromArray(cmdBytes);
OrderMasterData omd = new OrderMasterData(om);
if (!dStopOrders.ContainsKey(omd.DLR_NO))
{
dStopOrders.Add(omd.DLR_NO, new List <long>()
{
omd.ORD_NO
});
}
break;
case eCommand.ScanFile:
scanFile sc = new scanFile();
cmd = sc.FromArray(cmdBytes);
ScanFileData scd = new ScanFileData(sc);
break;
case eCommand.OrderOptions:
orderOptions oo = new orderOptions();
cmd = oo.FromArray(cmdBytes);
//OrderOptionsData ood = new OrderOptionsData(oo);
break;
case eCommand.AccountReceivable:
accountReceivable ar = new accountReceivable();
cmd = ar.FromArray(cmdBytes);
// AccountsReceivableData acr = new AccountsReceivableData((accountReceivable)cmd);
break;
case eCommand.ManifestLoadComplete:
case eCommand.TrucksLoadComplete:
case eCommand.StopsLoadComplete:
case eCommand.OrdersLoadComplete:
case eCommand.OrderUpdatesComplete:
case eCommand.OrderDetailsComplete:
case eCommand.OrderOptionsComplete:
case eCommand.ManifestDetailsComplete:
case eCommand.UploadManifestComplete:
case eCommand.LoadFilesComplete:
Logger.Info($"CommandFactory: {Enum.GetName(typeof(eCommand), cmd.command) + Environment.NewLine}");
manifestRequest req = new manifestRequest();
Logger.Info($"CommandFactory: {req.ToString()}");
cmd = req.FromArray(cmdBytes);
break;
case eCommand.Ping:
//Broadcast cmdType = Broadcast.FromArray(cmdBytes);
//cmd = SendPong();
break;
case eCommand.Pong:
//Broadcast cmdType = Broadcast.FromArray(cmdBytes);
//Broadcast cmdType = Broadcast.FromArray(cmdBytes);
break;
case eCommand.RunQuery:
//Broadcast cmdType = Broadcast.FromArray(cmdBytes);
break;
default:
break;
}
return(cmd);
}
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.GenerateManifest:
Logger.Info($"HandleClientCmd - Generate Manifest:{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 mmd1 = (ManifestMasterData)UMDServer.QueryData(cbsend, mM);
Logger.Info($"API Manager GenerateManifest QueryData Complete. {mmd1.ToString()}");
}
else
{
WinSysSM.SendMessage(cmd);
}
break;
case eCommand.CheckManifest:
Logger.Info($"HandleClientCmd - CheckManifest: {cmd.ToString()}");
manifestMaster mMst = (manifestMaster) new manifestMaster().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd Check Manifest in ManagerAPI/SqlServer: {mMst.ToString()}");
ManifestMasterData mamd = (ManifestMasterData)UMDServer.QueryData(cbsend, mMst);
Logger.Info($"API Manager Check Manifest. {mamd.ToString()}");
break;
case eCommand.Manifest:
Logger.Info($"HandleClientCmd - Manifest: {cmd.ToString()}");
cbsend(cmd.ToArray());
break;
case eCommand.OrdersUpload:
Logger.Info($"HandleClientCmd - Orders: {cmd.ToString()}");
orderMaster om = (orderMaster) new orderMaster().FromArray(bytes_cmd);
List <OrderMasterData> ordList = new List <OrderMasterData>();
Logger.Info($"Persist INSERTORDER {om.ToString()}");
// om.Status = OrderStatus.Shipped;
foreach (OrderMasterData omd in UMDServer.Persist(SPCmds.INSERTORDER, new OrderMasterData(om)))
{
ordList.Add(omd);
Logger.Info($"Orders - drillDown.GetOrderDetailsData: {omd.ToString()}");
omd.Command = eCommand.OrdersLoadComplete;
}
//foreach (var ord in ordList)
//{
// drillDown.GetOrderDetailsData(ord);
// drillDown.GetOrderOptionsData(ord);
//}
drillDown.GetOrderDetailsData(ordList);
drillDown.GetOrderOptionsData(ordList);
Logger.Info($"INSERTORDER Complete. OrdersLoadComplete: {om.ToString()}");
om.command = eCommand.ManifestDetailsComplete;
cbsend(om.ToArray());
break;
case eCommand.CompleteOrder:
Logger.Info($"HandleClientCmd - Close Order: {cmd.ToString()}");
manifestRequest mreq = (manifestRequest) new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - CompleteOrder: {mreq.ToString()}");
orderMaster cs = (orderMaster) new orderMaster().FromArray(mreq.bData);
Logger.Info($"Persist COMPLETEORDER {cs.ToString()}");
var no = new OrderMasterData(cs);
foreach (OrderMasterData omd in UMDServer.Persist(SPCmds.COMPLETEORDER, no))
{
Logger.Info($"Persisted COMPLETEORDER {omd.ToString()}");
cbsend(new orderMaster(omd).ToArray());
}
break;
case eCommand.CompleteStop:
Logger.Info($"HandleClientCmd - Close Stop for Orders: {cmd.ToString()}");
manifestRequest mreqs = (manifestRequest) new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - CompleteStop: {mreqs.ToString()}");
StopData sd = new StopData();
sd.POD = mreqs.bData;
sd.ManifestId = mreqs.id;
sd.DisplaySeq = (int)mreqs.DATA;
sd.Orders = new List <OrderMasterData>();
//temp - uncomment!
// mreqs.valist.ForEach(v => sd.Orders.Add(new OrderMasterData() { DSP_SEQ=sd.DisplaySeq, ManifestId=sd.ManifestId, ORD_NO = v }));
Logger.Info($"Persist COMPLETESTOP {sd.ToString()}");
foreach (StopData omd in UMDServer.Persist(SPCmds.COMPLETESTOP, sd))
{
Logger.Info($"Persisted COMPLETESTOP {sd.ToString()}");
cbsend(new stops(sd).ToArray());
}
break;
case eCommand.OrderOptions:
//throw new Exception("This should be handled by the Receive Message handler.");
Logger.Info($"HandleClientCmd - OrderOptions:{cmd.ToString()}");
manifestRequest mreqoo = (manifestRequest) new manifestRequest().FromArray(bytes_cmd);
OrderOptionsData ood = (OrderOptionsData)UMDServer.QueryData(cbsend, mreqoo);
Logger.Info($"API Manager QueryData OrderOptionsData. {ood.ToString()}");
break;
case eCommand.OrderDetails:
Logger.Info($"HandleClientCmd - OrderDetails:{cmd.ToString()}");
manifestRequest mreqod = (manifestRequest) new manifestRequest().FromArray(bytes_cmd);
OrderDetailsData odd = (OrderDetailsData)UMDServer.QueryData(cbsend, mreqod);
Logger.Info($"API Manager OrderDetailsData QueryData. {odd.ToString()}");
break;
case eCommand.UploadManifest:
Logger.Info($"HandleClientCmd - UploadManifest:{cmd.ToString()}");
mreq = (manifestRequest) new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - UploadManifest: {mreq.ToString()}");
manifestMaster mm = (manifestMaster) new manifestMaster().FromArray(mreq.bData);
if (!dRetCall.ContainsKey(NewGuid(mm.requestId)))
{
dRetCall.Add(NewGuid(mm.requestId), cbsend);
}
Logger.Info($"UploadManifest cb dRetCall: {mm.ToString()}");
try
{
foreach (ManifestMasterData mmdit in UMDServer.Persist(SPCmds.INSERTMANIFEST, new ManifestMasterData(mm, mm.id)))
{
Logger.Info($"HandleClientCmd - UploadManifest Persisted:{mmdit.ToString()}");
Logger.Info($"UploadManifest - Get ManifestDetails: {mmdit.ToString()}");
if (!dManDetails.ContainsKey(mmdit.RequestId.ToString() + mmdit.ManifestId.ToString()))
{
dManDetails.Add(mmdit.RequestId.ToString() + mmdit.ManifestId.ToString(), new List <ManifestDetailsData>());
}
drillDown.GetManifestDetails(mmdit);
}
mm.command = eCommand.UploadManifestComplete;
Logger.Info($"UploadManifest - ManifestLoadComplete: {mm.ToString()}");
cbsend(mm.ToArray());
}
catch (Exception e)
{
Logger.Debug("HandleClientCmd - Error exception = " + e.Message);
dRetCall.Remove(NewGuid(mm.requestId));
}
break;
case eCommand.Trucks:
isaCommand req = new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - Trucks: {req.ToString()}");
TruckData td = (TruckData)UMDServer.QueryData(cbsend, req);
Logger.Info($"HandleClientCmd - Trucks: {td.ToString()}");
break;
case eCommand.Drivers:
req = new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd - Drivers: {req.ToString()}");
DriverData dd = (DriverData)UMDServer.QueryData(cbsend, req);
Logger.Info($"HandleClientCmd - Drivers: {dd.ToString()}");
break;
case eCommand.Stops:
req = new manifestRequest().FromArray(bytes_cmd);
Logger.Info($"HandleClientCmd Stops: {req.ToString()}");
StopData sdt = (StopData)UMDServer.QueryData(cbsend, req);
Logger.Info($"Stops QueryData: {sdt.ToString()}");
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);
Logger.Info($"OrdersLoad QueryData: {od.ToString()}");
break;
case eCommand.AccountReceivable:
req = new manifestRequest().FromArray(bytes_cmd);
manifestRequest mr = (manifestRequest)req;
accountReceivable arecv = (accountReceivable) new accountReceivable().FromArray(mr.bData); Logger.Info($"HandleClientCmd - AccountRecievable");
AccountsReceivableData ard = (AccountsReceivableData)
UMDServer.QueryData(cbsend, arecv);
Logger.Info($"AccountsReceivables Complete.");
break;
default:
Logger.Error("HandleClientCmd - ERROR Unknown command. Parse Error MDM-API");
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;
}
}
