static void Main(string[] args)
{
TableHandler tableHandler = new TableHandler();
DataTable newTable = tableHandler.CreateTable("AAA");
newTable.Rows.Add();
newTable.Rows.Add();
newTable.Rows[0]["Jahr"] = 2020;
newTable.Rows[1]["Jahr"] = 2009;
Console.WriteLine("Tabelle vorher:");
PrintTable(newTable);
tableHandler.AddRow(ref newTable);
tableHandler.AddRow(ref newTable);
tableHandler.AddRow(ref newTable);
Console.WriteLine("Tabelle sortiert:");
newTable.DefaultView.Sort = "Jahr Asc";
newTable = newTable.DefaultView.ToTable();
PrintTable(newTable);
Console.WriteLine("\nTabelle speichern.\n");
tableHandler.SaveTable(newTable);
Console.WriteLine("\nTabelle ausgeben.\n");
var tableList = tableHandler.GetTableNames();
PrintTableList(tableList);
Console.WriteLine("AAA");
PrintTable(tableHandler.LoadDataTable("AAA"));
Console.WriteLine("\nZeile löschen.\n");
tableHandler.DeleteRow(newTable, 2020);
Console.WriteLine("\nTabelle speichern.\n");
tableHandler.SaveTable(newTable);
Console.WriteLine("\nTabelle ausgeben.\n");
PrintTable(tableHandler.LoadDataTable("AAA"));
Console.WriteLine("\nTabelle wieder löschen.\n");
tableHandler.DeleteTable(newTable);
tableList = tableHandler.GetTableNames();
PrintTableList(tableList);
}
public OrderDTO CreateSalesOrder(OrderDTO order)
{
GenericServiceClient client = null;
var success = false;
try
{
client = ServiceFactory.GetGenericClient();
var request = new RequestBuilder();
var context = ServiceFactory.CreateContext(request);
var orderTable = context.UseTable((long)T.Order);
var orderRow = orderTable.AddRow();
orderRow.SuggestValue((long)C.Order.OrderNo);
orderRow.SetIntegerValue((long)C.Order.TransactionType, (long)V.TransactionType.Sales);
orderRow.Set(order, o => o.CustomerNo);
orderRow.SetIntegerValue((long)C.Order.CurrencyNo, 47L);
orderRow.Set(order, o => o.Label);
orderRow.Set(order, o => o.DeliveryAddress1);
orderRow.Set(order, o => o.DeliveryAddress2);
orderRow.Set(order, o => o.DeliveryPostCode);
orderRow.Set(order, o => o.DeliveryPostalArea);
orderRow.Set(order, o => o.YourReference);
orderRow.Set(order, o => o.OurReference);
orderRow.Set(order, o => o.OrderDate);
orderRow.Set(order, o => o.RequestedDeliveryDate);
orderRow.Set(order, o => o.OriginalConfirmedDeliveryDate);
orderRow.Set(order, o => o.ConfirmedDeliveryDate);
TableHandler orderLineTable = orderRow.JoinTable((long)Fk.OrderLine.Order);
// Add orderline row and assign values to the row
foreach (var orderline in order.OrderLines)
{
Row orderLineRow = orderLineTable.AddRow();
orderLineRow.Set(orderline, o => o.ProductNo);
orderLineRow.Set(orderline, o => o.ExternalProductNo);
orderLineRow.Set(orderline, o => o.ExternalReference);
orderLineRow.Set(orderline, o => o.ExternalId);
orderLineRow.Set(orderline, o => o.Description);
orderLineRow.Set(orderline, o => o.Quantity);
orderLineRow.Set(orderline, o => o.UnitType);
orderLineRow.Set(orderline, o => o.UnitPrice);
orderLineRow.Set(orderline, o => o.Discount);
orderLineRow.SetIntegerValue((long)C.OrderLine.SourceType, 16L);
}
// Add a projection on the order row and add columns to the projection
var orderProjection = orderRow.ProjectColumns();
orderProjection.AddColumns <OrderDTO>();
var orderLineProjection = orderProjection.ProjectChildren((long)Fk.OrderLine.Order);
orderLineProjection.AddColumns <OrderLineDTO>();
var response = request.Dispatch(client);
client.Close();
success = true;
if (response.AllSucceeded)
{
foreach (OperationResult res in response.OperationResultDictionary.Values)
{
if (res is ProjectionResult)
{
var projectionResult = res as ProjectionResult;
var projectionResultRow = projectionResult.ResultSet.ResultRows[0];
var item = DTOMapper.MapToDTO <OrderDTO>(projectionResultRow);
item.OrderLines = projectionResultRow.ChildResultSets.First().ResultRows
.Select(DTOMapper.MapToDTO <OrderLineDTO>).ToList();
return(item);
}
}
}
}
catch (Exception e)
{
//Log error
throw;
}
finally
{
if (!success)
{
client?.Abort();
}
}
return(null);
}
