public IEnumerable <IMDMMessage> UploadOrderDetails(IMDMMessage manOrdDetItem)
{
foreach (var it in Persist(SPCmds.INSERTORDERDETAILS, manOrdDetItem))
{
yield return(it);
}
}
public IEnumerable <IMDMMessage> UploadOrderOptions(IMDMMessage manOrdOptItem)
{
foreach (var it in Persist(SPCmds.INSERTORDEROPTIONS, manOrdOptItem))
{
yield return(it);
}
}
public IEnumerable <IMDMMessage> UploadManifestDetails(IMDMMessage manDetItem)
{
foreach (var it in Persist(SPCmds.INSERTMANIFESTDETAILS, manDetItem))
{
yield return(it);
}
}
public IEnumerable <IMDMMessage> Persist(SPCmds sp, IMDMMessage md)
{
Logger.Info($"Persist {md.ToString()}");
foreach (var it in UMD_Data.InsertData(sp, md))
{
yield return(it);
}
}
public IEnumerable <IMDMMessage> Persist(SPCmds sp, IMDMMessage md)
{
// UMD_Data.InsertData(sp, md);
foreach (var it in UMD_Data.InsertData(sp, md))
{
yield return(it);
}
}
void ProcessMessage(IMDMMessage std, Func <byte[], Task> cbsend = null)
{
if (std.Command == eCommand.StopsLoadComplete)
{
//stopThread.CompleteBackgroundWorker(std.RequestId);
//LoadStopsComplete = true;
return;
}
//AddStop((StopData)std);
}
public ManifestDetails(IMDMMessage mmd)
{
string TRK_CDE = ((ManifestMasterData)mmd).TRK_CDE;
DateTime SHIP_DTE = ((ManifestMasterData)mmd).SHIP_DTE;
InitializeComponent();
//var mvm = new ManifestVM();
//BindingContext = mvm;
}
public void InsertData(String SQL, IMDMMessage msg)
{
using (var cnn = NewConnection())
{
using (var adapter = new OdbcDataAdapter())
{
using (var command = NewCommand(SQL))
{
cnn.Open();
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
}
}
}
}
public void ProcessMessage(IMDMMessage icmd, Func <byte[], Task> cbsend = null)
{
AccountsReceivableData odcmd;
if (icmd.Command == eCommand.AccountReceivable)
{
odcmd = (AccountsReceivableData)icmd;
odcmd.status = status.Init;
Add(odcmd);
//Winsys loading of the Manifest Master update to the original requestId for a ship date
Logger.Info($"ARVM::Process Message For Accounts Receivables: {odcmd.ToString()}");
}
else
{
Logger.Error($"ManifestVM::Process Message For Accounts Receivables: {icmd.ToString()}");
}
}
void ProcessMessage(IMDMMessage trk, Func <byte[], Task> cbsend = null)
{
if (trk.Command == eCommand.TrucksLoadComplete)
{
LoadTruckRequestComplete = trk.RequestId.ToString();
truckThread.CompleteBackgroundWorker(trk.RequestId);
return;
}
Truck newtruck = new Truck((TruckData)trk);
Truck truck = TruckDatabase.GetItem(newtruck);
if (truck == null)
{
TruckDatabase.SaveItem(newtruck);
}
AddTruck((TruckData)trk);
}
void ProcessMessage(IMDMMessage ord, Func <byte[], Task> cbsend = null)
{
if (ord.Command == eCommand.OrdersLoadComplete)
{
LoadOrderRequestComplete = ord.RequestId.ToString();
Logger.Info($"OrdersLoadComplete: {ord.ToString()}");
LoadOrdersComplete = true;
return;
}
// If we are Completing a stop the SP returns a OrderMasterData object
if (ord.GetType() == typeof(OrderMasterData))
{
AddOrder(((OrderMasterData)ord).GetOrderData());
}
else
{
ord.status = status.Uploaded;
AddOrder((OrderData)ord);
}
}
public IMDMMessage QueryData(Func <OdbcDataReader, IMDMMessage> cb, string SQL)
{
IMDMMessage data = null;
try
{
using (var cnn = new OdbcConnection(strConnection))
using (var cmd = new OdbcCommand())
{
Console.WriteLine("Query: " + SQL);
cmd.CommandText = SQL;
cmd.CommandType = CommandType.Text;
cmd.Connection = cnn;
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
OdbcDataReader reader = cmd.ExecuteReader();
data = cb(reader);
}
}
catch (Exception ex) { }
return(data);
}
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 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);
}
public bool InsertData(string sql, IMDMMessage msg)
{
throw new Exception("not impl");
}
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 InsertData(SPCmds sql, IMDMMessage msg)
{
throw new NotImplementedException();
}
