private static void Read(string orderNumber)
{
const string commandString = "exec CDN.PROPROXIAGetOrderinfo @NumerPelny";
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
logger.Log("Opened Connection to DB", LoggingMode.Enhanced);
using (var command = new SqlCommand(commandString, connection))
{
command.Parameters.AddWithValue("@NumerPelny", orderNumber);
using (var reader = command.ExecuteReader())
{
logger.Log("Exequted SQL Server Procedure", LoggingMode.Enhanced);
var order = new Order();
order.Load(reader);
logger.Log("Loaded Order from reader", LoggingMode.Enhanced);
reader.NextResult();
var workCard = new WorkCard();
workCard.Load(reader);
logger.Log("Loaded Work Card from reader", LoggingMode.Enhanced);
var proxia = new ProxiaMessageHandler(Settings.Default.InterfacePath, format, false, logger, ProxiaMessageError.SkipOnError);
logger.Log("Created Proxia instance", LoggingMode.Enhanced);
proxia.WriteMessage(order);
logger.Log("Saved Order to file", LoggingMode.Enhanced);
proxia.WriteMessage(workCard);
logger.Log("Saved Work Card to file", LoggingMode.Enhanced);
}
}
}
logger.Log("Closed all connections, exit", LoggingMode.Enhanced);
}
private static void Czesc()
{
logger.Log("Starting [Czesc]", LoggingMode.Enhanced);
const string commandString = "exec CDN.PROExportProxiaMatstamm";
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
logger.Log("Opened Connection to DB", LoggingMode.Enhanced);
using (var command = new SqlCommand(commandString, connection))
{
using (var reader = command.ExecuteReader())
{
logger.Log("Exequted SQL Server Procedure", LoggingMode.Enhanced);
var materials = new List <DocumentBase>();
while (reader.Read())
{
var material = new Material();
material.Load(reader);
materials.Add(material);
}
logger.Log("Loaded Material from reader", LoggingMode.Enhanced);
var proxia = new ProxiaMessageHandler(Settings.Default.InterfacePath, format, false, logger, ProxiaMessageError.SkipOnError);
logger.Log("Created Proxia instance", LoggingMode.Enhanced);
if (materials.Count != 0)
{
proxia.WriteMessageList(logger, materials);
}
logger.Log("Saved Material to file", LoggingMode.Enhanced);
}
}
}
logger.Log("Closed all connections, exit", LoggingMode.Enhanced);
}
private static void Write()
{
var proxia = new ProxiaMessageHandler(Settings.Default.InterfacePath, format, false, logger, ProxiaMessageError.SkipOnError);
logger.Log("Created ProxiaMessageHandler instance", LoggingMode.Enhanced);
if (!proxia.IsMessage())
{
return;
}
var zp = GetProcessZP();
logger.Log("Loaded ZP instance", LoggingMode.Enhanced);
var doc = proxia.GetMessage();
logger.Log("Loaded first message from ProxiaMessageHandler", LoggingMode.Enhanced);
zp.Run(doc);
logger.Log("Sent data to ZP with \"Run\" method", LoggingMode.Enhanced);
proxia.NextMessage();
logger.Log("Marked message as parsed", LoggingMode.Enhanced);
}
