public string GetJsonContent(int key, IDictionary <string, string> properties)
{
// Get the salesOrderHeader
var orderHeader = zwaluwSalesOrderRepository.GetById(key);
var orderHeaderDto = new ZwaluwSalesOrderDto()
{
CustomerId = orderHeader.CustomerId,
DebtorName = orderHeader.DebtorName,
DebtorNumber = orderHeader.DebtorNumber,
DelAddress = orderHeader.DelAddress,
DelCity = orderHeader.DelCity,
Carrier = orderHeader.Carrier,
DelCountryCode = orderHeader.DelCountryCode,
DelZip = orderHeader.DelZip,
Description = orderHeader.Description,
OrderNumber = orderHeader.OrderNumber,
Reference = orderHeader.Reference,
WarehouseId = orderHeader.WarehouseId,
DeliveryNote = orderHeader.DeliveryNote,
TestIndicator = orderHeader.TestIndicator,
MainDebtorNumber = orderHeader.MainDebtorNumber
};
if (orderHeader != null)
{
if (orderHeader.DelZip == null)
{
orderHeader.DelZip = "Unknown";
}
var salesOrderDto = new ZwaluwSalesOrderHeaderDto();
salesOrderDto.SalesOrderHeaders.Add(orderHeaderDto);
foreach (var orderLine in orderHeader.Lines)
{
if (orderLine.OrderLineDescription == null)
{
orderLine.OrderLineDescription = orderLine.ItemMainItemDescription;
}
var salesOrderLineDto = new ZwaluwSalesOrderLineDto()
{
OrderNumber = orderLine.OrderNumber,
OrderLineDescription = orderLine.OrderLineDescription,
MainItemQuantity = orderLine.MainItemQuantity,
Quantity = orderLine.Quantity,
DeliveryDate = orderLine.DeliveryDate,
OrderLineId = orderLine.OrderLineId,
ItemMainItemCode = orderLine.ItemMainItemCode,
ItemMainItemDescription = orderLine.ItemMainItemDescription,
ItemCode = orderLine.ItemCode,
ItemDescription = orderLine.ItemDescription,
ItemSalesUnit = orderLine.ItemSalesUnit,
ItemEANCode = orderLine.ItemEANCode,
ItemBrand = orderLine.ItemBrand,
ItemProductGroup = orderLine.ItemProductGroup,
ItemColliUnit = orderLine.ItemColliUnit,
ItemSalesUnitsPerColli = orderLine.ItemSalesUnitsPerColli,
ItemVolume = orderLine.ItemVolume,
ItemWeight = orderLine.ItemWeight,
ItemHeight = orderLine.ItemHeight,
ItemLength = orderLine.ItemLength,
ItemWidth = orderLine.ItemWidth
};
salesOrderDto.SalesOrderLines.Add(salesOrderLineDto);
}
return(new JavaScriptSerializer().Serialize(salesOrderDto));
}
else
{
return(null);
}
/*
* string connectionstring = ConfigurationManager.ConnectionStrings["default"].ConnectionString;
*
* using (SqlConnection connection = new SqlConnection(connectionstring))
* {
* SqlDataAdapter adapter = new SqlDataAdapter();
*
* connection.Open();
*
* // Get the salesOrderHeader
* adapter.SelectCommand = new SqlCommand(
* "SELECT * " +
* "FROM EEK_vw_DISTRIBUTION_SALESORDERHEADERS_ZWALUW " +
* "WHERE SalesOrderHeaderId = " + key,
* connection
* );
* DataSet salesOrderHeaders = new DataSet("SALESORDERHEADERS");
* adapter.Fill(salesOrderHeaders);
* DataRow salesOrderHeader = salesOrderHeaders.Tables[0].Rows[0];
*
* var salesOrder = new ZwaluwSalesOrder();
*
* string delZip;
* try
* {
* delZip = (string)salesOrderHeader["DelZip"];
* }
* catch (Exception)
* {
* delZip = "Unknown";
* }
* string mainDebtorNumber;
* try
* {
* mainDebtorNumber = (string)salesOrderHeader["MainDebtorNumber"];
* }
* catch
* {
* mainDebtorNumber = null;
* }
*
* var orderHeader = new Data.ZwaluwSalesOrder
* {
* CustomerId = Convert.ToInt32(salesOrderHeader["CustomerId"]),
* DebtorName = (string)salesOrderHeader["DebtorName"],
* DebtorNumber = (string)salesOrderHeader["DebtorNumber"],
* DelAddress = (string)salesOrderHeader["DelAddress"],
* DelCity = (string)salesOrderHeader["DelCity"],
* Carrier = (string)salesOrderHeader["Carrier"],
* DelCountryCode = (string)salesOrderHeader["DelCountryCode"],
* DelZip = delZip,
* Description = (string)salesOrderHeader["Description"],
* OrderNumber = (string)salesOrderHeader["OrderNumber"],
* Reference = (string)salesOrderHeader["Reference"],
* WarehouseId = Convert.ToInt32(salesOrderHeader["WarehouseId"]),
* DeliveryNote = (string)salesOrderHeader["DeliveryNote"],
* TestIndicator = Convert.ToBoolean(salesOrderHeader["TestIndicator"]),
* MainDebtorNumber = mainDebtorNumber,
* };
*
* // Add the header to the salesorder
* salesOrder.SalesOrderHeaders.Add(orderHeader);
*
* // Get the distribution salesOrderLines
* adapter.SelectCommand = new SqlCommand(
* "SELECT * " +
* "FROM EEK_vw_DISTRIBUTION_SALESORDERLINES_ZWALUW " +
* "WHERE SalesOrderHeaderId = " + key,
* connection
* );
* DataSet salesOrderLines = new DataSet("SALESORDERLINES");
* adapter.Fill(salesOrderLines);
*
* foreach (DataRow salesOrderLine in salesOrderLines.Tables[0].Rows)
* {
* // Initialize values
* float itemVolume;
* try
* {
* itemVolume = (float)Convert.ToDouble(salesOrderLine["ItemVolume"]);
* }
* catch (Exception)
* {
* itemVolume = 0;
* }
* float itemWeight;
* try
* {
* itemWeight = (float)Convert.ToDouble(salesOrderLine["ItemWeight"]);
* }
* catch (Exception)
* {
* itemWeight = 0;
* }
* float itemHeight;
* try
* {
* itemHeight = (float)Convert.ToDouble(salesOrderLine["ItemHeight"]);
* }
* catch (Exception)
* {
* itemHeight = 0;
* }
* float itemLength;
* try
* {
* itemLength = (float)Convert.ToDouble(salesOrderLine["ItemLength"]);
* }
* catch (Exception)
* {
* itemLength = 0;
* }
* float itemWidth;
* try
* {
* itemWidth = (float)Convert.ToDouble(salesOrderLine["ItemWidth"]);
* }
* catch (Exception)
* {
* itemWidth = 0;
* }
* float itemSalesUnitsPerColli;
* try
* {
* itemSalesUnitsPerColli = (float)Convert.ToDouble(salesOrderLine["ItemSalesUnitsPerColli"]);
* }
* catch (Exception)
* {
* itemSalesUnitsPerColli = 1;
* }
* string orderLineDescription;
* try
* {
* orderLineDescription = (string)salesOrderLine["OrderLineDescription"];
* }
* catch (Exception)
* {
* orderLineDescription = (string)salesOrderLine["ItemMainItemDescription"];
* }
* var orderLine = new ZwaluwSalesOrderLine
* {
* OrderNumber = (string)salesOrderLine["OrderNumber"],
* OrderLineDescription = orderLineDescription,
* MainItemQuantity = Convert.ToInt32(salesOrderLine["MainItemQuantity"]),
* Quantity = Convert.ToInt32(salesOrderLine["Quantity"]),
* DeliveryDate = (string)salesOrderLine["DeliveryDate"],
* OrderLineId = Convert.ToInt32(salesOrderLine["OrderLineId"]),
* ItemMainItemCode = (string)salesOrderLine["ItemMainItemCode"],
* ItemMainItemDescription = (string)salesOrderLine["ItemMainItemDescription"],
* ItemCode = (string)salesOrderLine["ItemCode"],
* ItemDescription = (string)salesOrderLine["ItemDescription"],
* ItemSalesUnit = (string)salesOrderLine["ItemSalesUnit"],
* ItemEANCode = (string)salesOrderLine["ItemEANCode"],
* ItemBrand = (string)salesOrderLine["ItemBrand"],
* ItemProductGroup = (string)salesOrderLine["ItemProductGroup"],
* ItemColliUnit = (string)salesOrderLine["ItemColliUnit"],
* ItemSalesUnitsPerColli = itemSalesUnitsPerColli,
* ItemVolume = itemVolume,
* ItemWeight = itemWeight,
* ItemHeight = itemHeight,
* ItemLength = itemLength,
* ItemWidth = itemWidth,
* };
*
* salesOrder.SalesOrderLines.Add(orderLine);
* }
*/
}
public void ZwaluwSalesOrderGetById()
{
var rep = new ZwaluwSalesOrderRepository();
var item = rep.GetById(167214);
}