internal static SdataTransactionResult GetSdataTransactionResult(List <TransactionResult> transactions, string endpoint, SupportedResourceKinds resource)
{
if (transactions == null)
{
return(null);
}
if (transactions.Count == 0)
{
return(null);
}
GuidConverter guidConverter = new GuidConverter();
SdataTransactionResult result;
foreach (TransactionResult transaction in transactions)
{
if (transaction.Status != TransactionStatus.Success)
{
result = new SdataTransactionResult();
result.ResourceKind = resource;
result.LocalId = transaction.ID;
try
{
result.Uuid = (Guid)guidConverter.ConvertFromString(transaction.CRMID);
}
catch (Exception)
{ }
result.HttpMessage = transaction.Message;
result.Location = endpoint + "('" + transaction.ID + "')";
result.HttpStatus = Helper.GetHttpStatus(transaction.Status, transaction.Action);
result.HttpMethod = Helper.GetHttpMethod(transaction.Action);
return(result);
}
}
if (transactions.Count == 0)
{
return(null);
}
result = new SdataTransactionResult();
result.ResourceKind = resource;
result.LocalId = transactions[0].ID;
try
{
result.Uuid = (Guid)guidConverter.ConvertFromString(transactions[0].CRMID);
}
catch (Exception)
{ }
result.HttpMessage = transactions[0].Message;
result.Location = endpoint + "('" + transactions[0].ID + "')";
result.HttpStatus = Helper.GetHttpStatus(transactions[0].Status, transactions[0].Action);
result.HttpMethod = Helper.GetHttpMethod(transactions[0].Action);
return(result);
}
public override SdataTransactionResult Delete(string id)
{
SdataTransactionResult tmpTransactionResult;
DataSets.OrderTableAdapters.Order_DetailsTableAdapter detailsTableAdapter = new Order_DetailsTableAdapter();
DataSets.Order order = new DataSets.Order();
int productId;
int orderId;
if (GetLocalIds(id, out orderId, out productId))
{
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
try
{
detailsTableAdapter.Connection = connection;
int recordCount = detailsTableAdapter.FillBy(order.Order_Details, orderId);
if (recordCount == 0)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = id;
tmpTransactionResult.HttpMethod = "DELETE";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder not found");
return tmpTransactionResult;
}
foreach (Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow row in order.Order_Details.Rows)
{
if (row.ProductID == productId)
{
row.Delete();
break;
}
}
detailsTableAdapter.Update(order.Order_Details);
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = id;
tmpTransactionResult.HttpMethod = "DELETE";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK;
return tmpTransactionResult;
}
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = id;
tmpTransactionResult.HttpMethod = "DELETE";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
}
}
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = id;
tmpTransactionResult.HttpMethod = "DELETE";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = "Not found";
return tmpTransactionResult;
}
public override SdataTransactionResult Update(PayloadBase payload, List<SyncFeedEntryLink> links)
{
SdataTransactionResult tmpTransactionResult;
if (!(payload is SalesOrderLinePayload))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
salesOrderLinetype soLine = (payload as SalesOrderLinePayload).SalesOrderLinetype;
DataSets.OrderTableAdapters.Order_DetailsTableAdapter detailsTableAdapter = new Order_DetailsTableAdapter();
DataSets.Order order = new DataSets.Order();
int productId;
int orderId;
if (GetLocalIds(payload.LocalID, out orderId, out productId))
{
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
try
{
detailsTableAdapter.Connection = connection;
int recordCount = detailsTableAdapter.FillBy(order.Order_Details, orderId);
if (recordCount == 0)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = payload.LocalID;
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder not found");
return tmpTransactionResult;
}
foreach (Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow detailsRow in order.Order_Details.Rows)
{
if (detailsRow.ProductID == productId)
{
detailsRow.ModifyUser = _context.Config.CrmUser;
detailsRow.ModifyID = _context.Config.SequenceNumber;
if (soLine.quantitySpecified)
detailsRow.Quantity = Convert.ToInt16(soLine.quantity);
else
detailsRow.Quantity = 0;
if (soLine.initialPriceSpecified)
detailsRow.UnitPrice = (Decimal)soLine.initialPrice;
else
detailsRow.UnitPrice = 0;
if ((!soLine.discountTotalSpecified) || (detailsRow.Quantity == 0) || (detailsRow.UnitPrice == 0))
{
detailsRow.Discount = (float)0;
}
else
{
// discountPC = discountsum / qunatity * listprice
//detailRow.Discount = Convert.ToSingle((decimal)lineItemDoc.discountsum.Value / ((decimal)detailRow.Quantity * detailRow.UnitPrice));
float discount = Convert.ToSingle((decimal)soLine.discountTotal / (detailsRow.UnitPrice));
if (discount > 1)
discount = 0;
detailsRow.Discount = discount;
}
break;
}
}
detailsTableAdapter.Update(order.Order_Details);
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = payload.LocalID;
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK;
return tmpTransactionResult;
}
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = payload.LocalID;
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
}
}
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = payload.LocalID;
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = "Not found";
return tmpTransactionResult;
}
public override SdataTransactionResult Add(PayloadBase payload, List<SyncFeedEntryLink> links)
{
string accountUuid = "";
SdataTransactionResult sdTrResult;
PostalAddressPayload addressPayload = payload as PostalAddressPayload;
if ((addressPayload.PostalAddresstype.primacyIndicatorSpecified) &&
addressPayload.PostalAddresstype.primacyIndicator)
{
// is primary
}
else if (addressPayload.PostalAddresstype.type == postalAddressTypeenum.Correspondance)
{
// is also primary adress
}
else
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Only primary addresses suported";
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = SupportedResourceKinds.postalAddresses;
sdTrResult.Uuid = StringToGuid(addressPayload.PostalAddresstype.uuid);
return sdTrResult;
}
foreach (SyncFeedEntryLink link in links)
{
if ((!String.IsNullOrEmpty(link.PayloadPath)) &&
link.PayloadPath.Equals(_tradingAccountUuidPayloadPath,
StringComparison.InvariantCultureIgnoreCase))
{
accountUuid = link.Uuid;
break;
}
}
if (String.IsNullOrEmpty(accountUuid))
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Trading Account UUID was missing";
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = StringToGuid(addressPayload.PostalAddresstype.uuid);
return sdTrResult;
}
string accountId = GetTradingAccountLocalId(accountUuid);
if (String.IsNullOrEmpty(accountId))
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = String.Format("Trading Account UUID {0} was not linked", accountUuid);
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = StringToGuid(addressPayload.PostalAddresstype.uuid);
return sdTrResult;
}
Account account = new Account();
Identity accIdentity = new Identity(account.EntityName, accountId);
AccountDocument accountDocument = account.GetDocument(
accIdentity, _emptyToken, _context.Config) as AccountDocument;
Document document = null;
bool doAdd = false;
if (accountDocument.addresses.documents.Count == 0)
{
document = GetTransformedDocument(payload, links);
accountDocument.CrmId = GetTradingAccountUuid(document.Id);
accountDocument.addresses.documents.Add(document);
doAdd = true;
}
else
{
AddressDocument addressdocument = accountDocument.addresses.documents[0] as AddressDocument;
if (addressdocument.address1.IsNull &&
addressdocument.address2.IsNull &&
addressdocument.address3.IsNull &&
addressdocument.address4.IsNull &&
addressdocument.City.IsNull)
{
document = GetTransformedDocument(payload, links);
accountDocument.CrmId = GetTradingAccountUuid(document.Id);
accountDocument.addresses.documents[0] = document;
doAdd = true;
}
}
if (!doAdd)
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Trading Account has already a primary address";
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = StringToGuid(addressPayload.PostalAddresstype.uuid);
return sdTrResult;
}
List<TransactionResult> transactionResults = new List<TransactionResult>();
account.Update(accountDocument, _context.Config, ref transactionResults);
sdTrResult = Helper.GetSdataTransactionResult(transactionResults,
_context.OriginEndPoint, SupportedResourceKinds.tradingAccounts);
if (sdTrResult != null)
{
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.HttpMessage = "POST";
}
return sdTrResult;
}
public override SdataTransactionResult Update(PayloadBase payload, List<SyncFeedEntryLink> links)
{
SdataTransactionResult tmpTransactionResult;
salesOrdertype salesorder = null;
#region check input values
if (!(payload is SalesOrderPayload))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
salesorder = (payload as SalesOrderPayload).SalesOrdertype;
if (salesorder == null)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
foreach (SyncFeedEntryLink link in links)
{
if (link.LinkRel != RelEnum.related.ToString())
continue;
string localID = string.Empty;
if (link.Href.StartsWith(_context.DatasetLink, StringComparison.InvariantCultureIgnoreCase))
if (link.Href.LastIndexOf("('") < link.Href.LastIndexOf("')"))
localID = link.Href.Substring(link.Href.LastIndexOf("('") + 2,
link.Href.LastIndexOf("')") - link.Href.LastIndexOf("('") - 2);
SupportedResourceKinds reskind = ResourceKindHelpers.GetResourceKind(link.PayloadPath);
if (localID == string.Empty)
localID = GetLocalId(link.Uuid, reskind);
payload.ForeignIds.Add(link.PayloadPath, localID);
}
if (payload == null)
return null;
string customerID;
if (!payload.ForeignIds.TryGetValue("tradingAccount", out customerID))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Trading Acount Id missing");
return tmpTransactionResult;
}
if (!customerID.StartsWith(Sage.Integration.Northwind.Application.API.Constants.CustomerIdPrefix))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Salesorder submission is only supported by customers");
return tmpTransactionResult;
}
#endregion
DataSets.OrderTableAdapters.OrdersTableAdapter tableAdapter = new OrdersTableAdapter();
DataSets.OrderTableAdapters.Order_DetailsTableAdapter detailsTableAdapter=new Order_DetailsTableAdapter();
DataSets.Order order = new DataSets.Order();
int id;
if (!(Int32.TryParse(payload.LocalID, out id)))
id = 0;
int recordCount;
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
tableAdapter.Connection = connection;
recordCount = tableAdapter.FillBy(order.Orders, id);
if (recordCount == 0)
return null;
detailsTableAdapter.Connection = connection;
detailsTableAdapter.FillBy(order.Order_Details, id);
}
DataSets.Order.OrdersRow row = (DataSets.Order.OrdersRow)order.Orders[0];
#region fill dataset from document
try
{
if (!salesorder.dateSpecified)
row.SetOrderDateNull();
else
row.OrderDate = salesorder.date;
if (!salesorder.dueDateSpecified)
row.SetRequiredDateNull();
else
row.RequiredDate = (DateTime)salesorder.dueDate;
//if (orderDoc.shippedvia.IsNull)
// newOrder.SetShipViaNull();
//else
// newOrder.ShipVia = (int)orderDoc.shippedvia.Value;
if (salesorder.postalAddresses == null || salesorder.postalAddresses.Length == 0)
{
row.SetShipAddressNull();
row.SetShipCityNull();
row.SetShipCountryNull();
row.SetShipPostalCodeNull();
}
else
{
postalAddresstype postadress = salesorder.postalAddresses[0];
row.ShipAddress = postadress.address1;
row.ShipCity = postadress.townCity;
row.ShipPostalCode = postadress.zipPostCode;
row.ShipCountry = postadress.country;
}
if (!salesorder.carrierTotalPriceSpecified)
row.Freight = (decimal)0;
else
row.Freight = (decimal)salesorder.carrierTotalPrice;
//row.CreateUser = _context.Config.CrmUser;
row.ModifyUser = _context.Config.CrmUser;
//row.CreateID = _context.Config.SequenceNumber;
row.ModifyID = _context.Config.SequenceNumber;
Dictionary<Guid, SyncFeedEntryLink> itemLinks = new Dictionary<Guid, SyncFeedEntryLink>();
GuidConverter converter = new GuidConverter();
Guid itemUuid;
foreach (SyncFeedEntryLink link in links)
{
SupportedResourceKinds resKind = ResourceKindHelpers.GetResourceKind(link.PayloadPath);
if (resKind != SupportedResourceKinds.salesOrderLines)
continue;
try
{
itemUuid = (Guid)converter.ConvertFromString(link.Uuid);
if (!Guid.Empty.Equals(itemUuid))
itemLinks.Add(itemUuid, link);
}
catch (Exception)
{
}
}
List<DataSets.Order.Order_DetailsRow> rowsToDelete = new List<DataSets.Order.Order_DetailsRow>();
//foreach (DataSets.Order.Order_DetailsRow detailsRow in rowsToDelete)
//{
// detailsRow.Delete();
//}
foreach (DataSets.Order.Order_DetailsRow detailsRow in order.Order_Details)
{
string itemId = detailsRow.OrderID.ToString() + "-" + detailsRow.ProductID.ToString();
itemUuid = GetUuid(itemId, "", SupportedResourceKinds.salesOrderLines);
SyncFeedEntryLink itemlink;
if (itemLinks.TryGetValue(itemUuid, out itemlink))
{
string lineNumberstring = itemlink.PayloadPath.Substring(itemlink.PayloadPath.IndexOf("[") + 1, itemlink.PayloadPath.IndexOf("]") - itemlink.PayloadPath.IndexOf("[") - 1);
int lineNumber;
if (Int32.TryParse(lineNumberstring, out lineNumber))
{
if (lineNumber < salesorder.salesOrderLines.Length)
{
salesOrderLinetype soLine = salesorder.salesOrderLines[lineNumber];
detailsRow.ModifyUser = _context.Config.CrmUser;
detailsRow.ModifyID = _context.Config.SequenceNumber;
if (soLine.quantitySpecified)
detailsRow.Quantity = Convert.ToInt16(soLine.quantity);
else
detailsRow.Quantity = 0;
if (soLine.initialPriceSpecified)
detailsRow.UnitPrice = (Decimal)soLine.initialPrice;
else
detailsRow.UnitPrice = 0;
if ((!soLine.discountTotalSpecified) || (detailsRow.Quantity == 0) || (detailsRow.UnitPrice == 0))
{
detailsRow.Discount = (float)0;
}
else
{
// discountPC = discountsum / qunatity * listprice
//detailRow.Discount = Convert.ToSingle((decimal)lineItemDoc.discountsum.Value / ((decimal)detailRow.Quantity * detailRow.UnitPrice));
float discount = Convert.ToSingle((decimal)soLine.discountTotal / (detailsRow.UnitPrice));
if (discount > 1)
discount = 0;
detailsRow.Discount = discount;
}
}
}
itemLinks.Remove(itemUuid);
}
else
{
//delete item
rowsToDelete.Add(detailsRow);
}
}
foreach (SyncFeedEntryLink itemlink in itemLinks.Values)
{
{
try
{
int productID;
string productIdString;
string productIdPayload = String.Format("{0}/{1}", itemlink.PayloadPath, "commodity");
if (payload.ForeignIds.TryGetValue(productIdPayload, out productIdString))
{
try
{
productID = Convert.ToInt32(productIdString);
}
catch (Exception)
{
continue;
}
}
else
continue;
string lineNumberstring = itemlink.PayloadPath.Substring(itemlink.PayloadPath.IndexOf("[") + 1, itemlink.PayloadPath.IndexOf("]") - itemlink.PayloadPath.IndexOf("[") - 1);
int lineNumber;
if (Int32.TryParse(lineNumberstring, out lineNumber))
{
if (lineNumber < salesorder.salesOrderLines.Length)
{
salesOrderLinetype soLine = salesorder.salesOrderLines[lineNumber];
DataSets.Order.Order_DetailsRow detailRow = order.Order_Details.NewOrder_DetailsRow();
soLine.applicationID = payload.LocalID + "-" + productID.ToString();
detailRow.OrderID = Convert.ToInt32(payload.LocalID);
detailRow.ProductID = productID;
if (soLine.quantitySpecified)
detailRow.Quantity = Convert.ToInt16(soLine.quantity);
else
detailRow.Quantity = 0;
if (soLine.initialPriceSpecified)
detailRow.UnitPrice = (Decimal)soLine.initialPrice;
else
detailRow.UnitPrice = 0;
if ((!soLine.discountTotalSpecified) || (detailRow.Quantity == 0) || (detailRow.UnitPrice == 0))
{
detailRow.Discount = (float)0;
}
else
{
// discountPC = discountsum / qunatity * listprice
//detailRow.Discount = Convert.ToSingle((decimal)lineItemDoc.discountsum.Value / ((decimal)detailRow.Quantity * detailRow.UnitPrice));
float discount = Convert.ToSingle((decimal)soLine.discountTotal / (detailRow.UnitPrice));
if (discount > 1)
discount = 0;
detailRow.Discount = discount;
}
detailRow.CreateUser = _context.Config.CrmUser;
detailRow.ModifyUser = _context.Config.CrmUser;
detailRow.CreateID = _context.Config.SequenceNumber;
detailRow.ModifyID = _context.Config.SequenceNumber;
order.Order_Details.AddOrder_DetailsRow(detailRow);
}
}
}
// this error occours in case of invalid data types
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
}
}
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
OleDbTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
tableAdapter.Connection = connection;
detailsTableAdapter.Connection = connection;
tableAdapter.SetTransaction(transaction);
detailsTableAdapter.SetTransaction(transaction);
foreach (DataSets.Order.Order_DetailsRow detailsRow in rowsToDelete)
{
detailsTableAdapter.Delete(detailsRow.OrderID,
detailsRow.ProductID,
detailsRow.UnitPrice, detailsRow.Quantity,
detailsRow.Discount, detailsRow.CreateID, detailsRow.CreateUser, detailsRow.ModifyID, detailsRow.ModifyUser);
}
tableAdapter.Update(order.Orders);
detailsTableAdapter.Update(order.Order_Details);
transaction.Commit();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK;
tmpTransactionResult.LocalId = payload.LocalID;
return tmpTransactionResult;
}
catch (Exception transactionException)
{
if (transaction != null)
transaction.Rollback();
throw;
}
}
}
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "PUT";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.ToString();
return tmpTransactionResult;
}
#endregion
}
public override SdataTransactionResult Add(PayloadBase payload, List<SyncFeedEntryLink> links)
{
SdataTransactionResult tmpTransactionResult;
salesOrdertype salesorder = null;
if (!(payload is SalesOrderPayload))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
salesorder = (payload as SalesOrderPayload).SalesOrdertype;
if (salesorder == null)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
foreach (SyncFeedEntryLink link in links)
{
if (link.LinkRel != RelEnum.related.ToString())
continue;
string localID = string.Empty;
if(link.Href.StartsWith(_context.DatasetLink, StringComparison.InvariantCultureIgnoreCase))
if (link.Href.LastIndexOf("('") < link.Href.LastIndexOf("')"))
localID = link.Href.Substring(link.Href.LastIndexOf("('")+2,
link.Href.LastIndexOf("')") - link.Href.LastIndexOf("('") -2);
SupportedResourceKinds reskind = ResourceKindHelpers.GetResourceKind(link.PayloadPath);
if (localID == string.Empty)
localID = GetLocalId(link.Uuid, reskind);
payload.ForeignIds.Add(link.PayloadPath, localID);
}
#region check input values
if (payload == null)
return null;
string customerID;
if (!payload.ForeignIds.TryGetValue("tradingAccount", out customerID))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Trading Acount Id missing");
return tmpTransactionResult;
}
if (!customerID.StartsWith(Sage.Integration.Northwind.Application.API.Constants.CustomerIdPrefix))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Salesorder submission is only supported by customers");
return tmpTransactionResult;
}
#endregion
DataSets.OrderTableAdapters.OrdersTableAdapter tableAdapter;
DataSets.OrderTableAdapters.Order_DetailsTableAdapter detailsTableAdapter;
DataSets.Order order = new DataSets.Order();
DataSets.Order.OrdersRow newOrder = order.Orders.NewOrdersRow();
customerID = customerID.Substring(Sage.Integration.Northwind.Application.API.Constants.CustomerIdPrefix.Length);
newOrder.CustomerID = customerID;
#region get Company Name
DataSet dataSet = new DataSet();
OleDbDataAdapter dataAdapter;
string sqlQuery = "Select CompanyName from Customers where CustomerID = '" + customerID + "'";
try
{
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
dataAdapter = new OleDbDataAdapter(sqlQuery, connection);
if (dataAdapter.Fill(dataSet, "Customers") == 0)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("trading account not found");
return tmpTransactionResult;
}
newOrder.ShipName = dataSet.Tables[0].Rows[0][0].ToString();
}
}
catch (Exception e)
{
throw;
}
#endregion
#region get Sels rep
//if (orderDoc.salesrepr.IsNull)
// newOrder.SetEmployeeIDNull();
//else
//{
// try
// {
// newOrder.EmployeeID = int.Parse((string)orderDoc.salesrepr.Value);
// }
// catch (Exception)
// {
// newOrder.SetEmployeeIDNull();
// }
// if (newOrder.IsEmployeeIDNull())
// {
// try
// {
// dataSet = new DataSet();
// sqlQuery = "SELECT Employees.EmployeeID FROM Employees where Employees.FirstName + ' ' + Employees.LastName = ? ";
// using (OleDbConnection connection = new OleDbConnection(config.ConnectionString))
// {
// dataAdapter = new OleDbDataAdapter(sqlQuery, connection);
// OleDbParameter parameter = new OleDbParameter("Name", (string)orderDoc.salesrepr.Value);
// dataAdapter.SelectCommand.Parameters.Add(parameter);
// if (dataAdapter.Fill(dataSet, "Employees") > 0)
// newOrder.EmployeeID = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]);
// else
// newOrder.EmployeeID = 1;
// }
// }
// catch (Exception e)
// {
// orderDoc.Id = "";
// throw;
// }
// }
//}
#endregion
#region fill dataset from document
try
{
if(!salesorder.dateSpecified)
newOrder.SetOrderDateNull();
else
newOrder.OrderDate = salesorder.date;
if (!salesorder.dueDateSpecified)
newOrder.SetRequiredDateNull();
else
newOrder.RequiredDate = (DateTime)salesorder.dueDate;
//if (orderDoc.shippedvia.IsNull)
// newOrder.SetShipViaNull();
//else
// newOrder.ShipVia = (int)orderDoc.shippedvia.Value;
if (salesorder.postalAddresses == null || salesorder.postalAddresses.Length == 0)
{
newOrder.SetShipAddressNull();
newOrder.SetShipCityNull();
newOrder.SetShipCountryNull();
newOrder.SetShipPostalCodeNull();
}
else
{
postalAddresstype postadress = salesorder.postalAddresses[0];
newOrder.ShipAddress = postadress.address1;
newOrder.ShipCity = postadress.townCity;
newOrder.ShipPostalCode = postadress.zipPostCode;
newOrder.ShipCountry = postadress.country;
}
if (!salesorder.carrierTotalPriceSpecified)
newOrder.Freight = (decimal)0;
else
newOrder.Freight = (decimal)salesorder.carrierTotalPrice;
newOrder.CreateUser = _context.Config.CrmUser;
newOrder.ModifyUser = _context.Config.CrmUser;
newOrder.CreateID = _context.Config.SequenceNumber;
newOrder.ModifyID = _context.Config.SequenceNumber;
}
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.ToString();
return tmpTransactionResult;
}
#endregion
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
OleDbTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
tableAdapter = new DataSets.OrderTableAdapters.OrdersTableAdapter();
tableAdapter.Connection = connection;
detailsTableAdapter = new DataSets.OrderTableAdapters.Order_DetailsTableAdapter();
detailsTableAdapter.Connection = connection;
tableAdapter.SetTransaction(transaction);
detailsTableAdapter.SetTransaction(transaction);
order.Orders.AddOrdersRow(newOrder);
tableAdapter.Update(order.Orders);
OleDbCommand Cmd = new OleDbCommand("SELECT @@IDENTITY", connection);
Cmd.Transaction = transaction;
object lastid = Cmd.ExecuteScalar();
payload.LocalID = ((int)lastid).ToString();
// add line Items
DataSets.Order.Order_DetailsRow detailRow;
Hashtable addedProductsProducts;
addedProductsProducts = new Hashtable();
int productID;
int productIndex= 0;
foreach (salesOrderLinetype salesOrderLine in salesorder.salesOrderLines)
{
try
{
string productIdString;
string productIdPayload = String.Format("salesOrderLines[{0}]/{1}",
productIndex.ToString(),
"commodity");
if (payload.ForeignIds.TryGetValue(productIdPayload, out productIdString))
{
try
{
productID = Convert.ToInt32( productIdString);
}
catch (Exception)
{
#warning only to test unsupported products
productID = 0;
}
}
else
productID = 0;
if (addedProductsProducts.Contains(productID))
{
transaction.Rollback();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = "Order contains a product twice";
return tmpTransactionResult;
}
addedProductsProducts.Add(productID, productID);
detailRow = order.Order_Details.NewOrder_DetailsRow();
salesOrderLine.applicationID = payload.LocalID + "-" + productID.ToString();
detailRow.OrderID = Convert.ToInt32(payload.LocalID);
detailRow.ProductID = productID;
if (salesOrderLine.quantitySpecified)
detailRow.Quantity = Convert.ToInt16(salesOrderLine.quantity);
else
detailRow.Quantity = 0;
if (salesOrderLine.initialPriceSpecified)
detailRow.UnitPrice = (Decimal)salesOrderLine.initialPrice;
else
detailRow.UnitPrice = 0;
if ((!salesOrderLine.discountTotalSpecified) || (detailRow.Quantity == 0) || (detailRow.UnitPrice == 0))
{
detailRow.Discount = (float)0;
}
else
{
// discountPC = discountsum / qunatity * listprice
//detailRow.Discount = Convert.ToSingle((decimal)lineItemDoc.discountsum.Value / ((decimal)detailRow.Quantity * detailRow.UnitPrice));
float discount = Convert.ToSingle((decimal)salesOrderLine.discountTotal / (detailRow.UnitPrice));
if (discount > 1)
discount = 0;
detailRow.Discount = discount;
}
detailRow.CreateUser = _context.Config.CrmUser;
detailRow.ModifyUser = _context.Config.CrmUser;
detailRow.CreateID = _context.Config.SequenceNumber;
detailRow.ModifyID = _context.Config.SequenceNumber;
}
// this error occours in case of invalid data types
catch (Exception e)
{
transaction.Rollback();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
order.Order_Details.AddOrder_DetailsRow(detailRow);
productIndex++;
}
// here could an error ouucour in case on broken database connection
// or of same invalid constraints which are unhandled before
try
{
detailsTableAdapter.Update(order.Order_Details);
}
catch (Exception e)
{
transaction.Rollback();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
transaction.Commit();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = "POST";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.Created;
tmpTransactionResult.LocalId = payload.LocalID;
return tmpTransactionResult;
}
catch (Exception transactionException)
{
if (transaction != null)
transaction.Rollback();
throw;
}
}
}
public override SdataTransactionResult Delete(string localID)
{
SdataTransactionResult tmpTransactionResult;
DataSets.OrderTableAdapters.OrdersTableAdapter tableAdapter = new OrdersTableAdapter();
DataSets.OrderTableAdapters.Order_DetailsTableAdapter detailsTableAdapter = new Order_DetailsTableAdapter();
DataSets.Order order = new DataSets.Order();
int id;
if (!(Int32.TryParse(localID, out id)))
id = 0;
int recordCount;
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
try
{
tableAdapter.Connection = connection;
recordCount = tableAdapter.FillBy(order.Orders, id);
if (recordCount == 0)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = localID;
tmpTransactionResult.HttpMethod = "DELETE";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder not found");
return tmpTransactionResult;
}
detailsTableAdapter.Connection = connection;
detailsTableAdapter.FillBy(order.Order_Details, id);
foreach (DataRow row in order.Order_Details.Rows)
{
row.Delete();
}
order.Orders[0].Delete();
detailsTableAdapter.Update(order.Order_Details);
tableAdapter.Update(order.Orders);
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = localID;
tmpTransactionResult.HttpMethod = "DELETE";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK;
return tmpTransactionResult;
}
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.LocalId = localID;
tmpTransactionResult.HttpMethod = "DELETE";
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
}
}
public virtual FeedEntry GetSyncTargetFeedEntry(SdataTransactionResult transactionResult)
{
FeedEntry result;
if (!String.IsNullOrEmpty(transactionResult.LocalId))
result = GetFeedEntry(transactionResult.LocalId);
else
//result = PayloadFactory.CreateResourcePayload(this._resourceKind);
#warning The Feed Entry should have a type...
result = new FeedEntry();
if (!String.IsNullOrEmpty(transactionResult.Uuid))
result.UUID = new Guid(transactionResult.Uuid);
if (transactionResult.HttpMethod == HttpMethod.DELETE)
result.IsDeleted = true;
return result;
}
public override SdataTransactionResult Add(Sage.Common.Syndication.FeedEntry payload)
{
SdataTransactionResult tmpTransactionResult;
SalesOrderFeedEntry salesorder = null;
if (!(payload is SalesOrderFeedEntry))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
salesorder = (payload as SalesOrderFeedEntry);
if (salesorder == null)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
#region check input values
if (payload == null)
return null;
string customerID = "";
if (salesorder.tradingAccount != null)
customerID = GetLocalId(salesorder.tradingAccount.UUID, SupportedResourceKinds.tradingAccounts);
if (String.IsNullOrEmpty(customerID))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Trading Acount Id missing");
return tmpTransactionResult;
}
if (!customerID.StartsWith(Sage.Integration.Northwind.Application.API.Constants.CustomerIdPrefix))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Salesorder submission is only supported by customers");
return tmpTransactionResult;
}
#endregion
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.OrderTableAdapters.OrdersTableAdapter tableAdapter;
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.OrderTableAdapters.Order_DetailsTableAdapter detailsTableAdapter;
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order order = new Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order();
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.OrdersRow newOrder = order.Orders.NewOrdersRow();
customerID = customerID.Substring(Sage.Integration.Northwind.Application.API.Constants.CustomerIdPrefix.Length);
newOrder.CustomerID = customerID;
#region get Company Name
DataSet dataSet = new DataSet();
OleDbDataAdapter dataAdapter;
string sqlQuery = "Select CompanyName from Customers where CustomerID = '" + customerID + "'";
try
{
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
dataAdapter = new OleDbDataAdapter(sqlQuery, connection);
if (dataAdapter.Fill(dataSet, "Customers") == 0)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("trading account not found");
return tmpTransactionResult;
}
newOrder.ShipName = dataSet.Tables[0].Rows[0][0].ToString();
}
}
catch (Exception e)
{
throw;
}
#endregion
#region fill dataset from document
try
{
if (!salesorder.IsPropertyChanged("date") || salesorder.date==null)
newOrder.SetOrderDateNull();
else
newOrder.OrderDate = salesorder.date;
if (!salesorder.IsPropertyChanged("dueDate") || salesorder.dueDate==null)
newOrder.SetRequiredDateNull();
else
newOrder.RequiredDate = (DateTime)salesorder.dueDate;
//if (orderDoc.shippedvia.IsNull)
// newOrder.SetShipViaNull();
//else
// newOrder.ShipVia = (int)orderDoc.shippedvia.Value;
if (salesorder.postalAddresses == null || salesorder.postalAddresses.Entries.Count == 0)
{
newOrder.SetShipAddressNull();
newOrder.SetShipCityNull();
newOrder.SetShipCountryNull();
newOrder.SetShipPostalCodeNull();
}
else
{
PostalAddressFeedEntry postadress = salesorder.postalAddresses.Entries[0];
newOrder.ShipAddress = postadress.address1;
newOrder.ShipCity = postadress.townCity;
newOrder.ShipPostalCode = postadress.zipPostCode;
newOrder.ShipCountry = postadress.country;
}
if (!salesorder.IsPropertyChanged("carrierTotalPrice"))
newOrder.Freight = (decimal)0;
else
newOrder.Freight = (decimal)salesorder.carrierTotalPrice;
newOrder.CreateUser = _context.Config.CrmUser;
newOrder.ModifyUser = _context.Config.CrmUser;
newOrder.CreateID = _context.Config.SequenceNumber;
newOrder.ModifyID = _context.Config.SequenceNumber;
}
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.ToString();
return tmpTransactionResult;
}
#endregion
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
OleDbTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
tableAdapter = new Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.OrderTableAdapters.OrdersTableAdapter();
tableAdapter.Connection = connection;
detailsTableAdapter = new Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.OrderTableAdapters.Order_DetailsTableAdapter();
detailsTableAdapter.Connection = connection;
tableAdapter.SetTransaction(transaction);
detailsTableAdapter.SetTransaction(transaction);
order.Orders.AddOrdersRow(newOrder);
tableAdapter.Update(order.Orders);
OleDbCommand Cmd = new OleDbCommand("SELECT @@IDENTITY", connection);
Cmd.Transaction = transaction;
object lastid = Cmd.ExecuteScalar();
payload.Key = ((int)lastid).ToString();
// add line Items
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow detailRow;
Hashtable addedProductsProducts;
addedProductsProducts = new Hashtable();
int productID;
int productIndex = 0;
if (salesorder.salesOrderLines != null)
{
foreach (SalesOrderLineFeedEntry salesOrderLine in salesorder.salesOrderLines.Entries)
{
try
{
string productIdString = "";
productID = 0;
if (salesOrderLine.commodity != null && salesOrderLine.commodity.UUID != null && salesOrderLine.commodity.UUID != Guid.Empty)
{
productIdString = GetLocalId(salesOrderLine.commodity.UUID, SupportedResourceKinds.commodities);
if (!int.TryParse(productIdString, out productID))
productID = 0;
}
if (addedProductsProducts.Contains(productID))
{
transaction.Rollback();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = "Order contains a product twice";
return tmpTransactionResult;
}
addedProductsProducts.Add(productID, productID);
detailRow = order.Order_Details.NewOrder_DetailsRow();
salesOrderLine.Key = payload.Key + "-" + productID.ToString();
detailRow.OrderID = Convert.ToInt32(payload.Key);
detailRow.ProductID = productID;
if (salesOrderLine.IsPropertyChanged("quantity"))
detailRow.Quantity = Convert.ToInt16(salesOrderLine.quantity);
else
detailRow.Quantity = 0;
if (salesOrderLine.IsPropertyChanged("initialPrice"))
detailRow.UnitPrice = (Decimal)salesOrderLine.initialPrice;
else
detailRow.UnitPrice = 0;
if ((!salesOrderLine.IsPropertyChanged("discountTotal")) || (detailRow.Quantity == 0) || (detailRow.UnitPrice == 0))
{
detailRow.Discount = (float)0;
}
else
{
// discountPC = discountsum / qunatity * listprice
//detailRow.Discount = Convert.ToSingle((decimal)lineItemDoc.discountsum.Value / ((decimal)detailRow.Quantity * detailRow.UnitPrice));
float discount = Convert.ToSingle((decimal)salesOrderLine.discountTotal / (detailRow.UnitPrice));
if (discount > 1)
discount = 0;
detailRow.Discount = discount;
}
detailRow.CreateUser = _context.Config.CrmUser;
detailRow.ModifyUser = _context.Config.CrmUser;
detailRow.CreateID = _context.Config.SequenceNumber;
detailRow.ModifyID = _context.Config.SequenceNumber;
}
// this error occours in case of invalid data types
catch (Exception e)
{
transaction.Rollback();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
order.Order_Details.AddOrder_DetailsRow(detailRow);
productIndex++;
}
}
// here could an error ouucour in case on broken database connection
// or of same invalid constraints which are unhandled before
try
{
detailsTableAdapter.Update(order.Order_Details);
}
catch (Exception e)
{
transaction.Rollback();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
transaction.Commit();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.Created;
tmpTransactionResult.LocalId = payload.Key;
return tmpTransactionResult;
}
catch (Exception transactionException)
{
if (transaction != null)
transaction.Rollback();
throw;
}
}
}
public virtual SyncFeedEntry GetFeedEntry(SdataTransactionResult transactionResult)
{
SyncFeedEntry result;
if (!String.IsNullOrEmpty(transactionResult.LocalId))
{
result = GetFeedEntry(transactionResult.LocalId);
}
else
{
result = new SyncFeedEntry();
result.Uuid = transactionResult.Uuid;
}
if (result == null)
return null;
//entry.Uuid = transactionResult.Uuid;
result.HttpStatusCode = transactionResult.HttpStatus;
result.HttpMessage = transactionResult.HttpMessage; ;
result.HttpMethod = transactionResult.HttpMethod;
result.HttpLocation = transactionResult.Location;
result.HttpETag = transactionResult.Etag;
return result;
}
private Diagnosis GetDiagnosis(SdataTransactionResult result)
{
Diagnosis d = result.Diagnosis;
if(d == null)
{
d= new Diagnosis();
d.Message = result.HttpMessage;
}
return d;
}
internal static SdataTransactionResult GetSdataTransactionResult(List<TransactionResult> transactions, string endpoint, SupportedResourceKinds resource)
{
if (transactions == null)
return null;
if (transactions.Count == 0)
return null;
GuidConverter guidConverter = new GuidConverter();
SdataTransactionResult result;
foreach (TransactionResult transaction in transactions)
{
if (transaction.Status != TransactionStatus.Success)
{
result = new SdataTransactionResult();
result.ResourceKind = resource;
result.LocalId = transaction.ID;
try
{
result.Uuid = (Guid)guidConverter.ConvertFromString(transaction.CRMID);
}
catch (Exception)
{ }
result.HttpMessage = transaction.Message;
result.Location = endpoint + "('" + transaction.ID + "')";
result.HttpStatus = Helper.GetHttpStatus(transaction.Status, transaction.Action);
result.HttpMethod = Helper.GetHttpMethod(transaction.Action);
return result;
}
}
if (transactions.Count == 0)
return null;
result = new SdataTransactionResult();
result.ResourceKind = resource;
result.LocalId = transactions[0].ID;
try
{
result.Uuid = (Guid)guidConverter.ConvertFromString(transactions[0].CRMID);
}
catch (Exception)
{ }
result.HttpMessage = transactions[0].Message;
result.Location = endpoint + "('" + transactions[0].ID + "')";
result.HttpStatus = Helper.GetHttpStatus(transactions[0].Status, transactions[0].Action);
result.HttpMethod = Helper.GetHttpMethod(transactions[0].Action);
return result;
}
internal SdataTransactionResult GetSdataTransactionResult(
List<TransactionResult> transactions, string EndPoint, SupportedResourceKinds resource)
{
SdataTransactionResult result;
// create default result
result = new SdataTransactionResult();
result.ResourceKind = resource;
result.HttpStatus = HttpStatusCode.BadRequest;
if (transactions == null)
return null;
if (transactions.Count == 0)
return null;
PersistRelations(transactions);
foreach (TransactionResult transaction in transactions)
{
SupportedResourceKinds res = GetSupportedResourceKind(transaction.EntityName);
if (res == resource)
{
result.ResourceKind = resource;
result.LocalId = transaction.ID;
result.Uuid = transaction.CRMID;
result.HttpMessage = transaction.Message;
result.Location = EndPoint + "('" + transaction.ID + "')";
result.HttpStatus = Helper.GetHttpStatus(transaction.Status, transaction.Action);
result.HttpMethod = Helper.GetHttpMethod(transaction.Action);
}
}
foreach (TransactionResult transaction in transactions)
{
if (transaction.Status != TransactionStatus.Success)
{
result = new SdataTransactionResult();
result.ResourceKind = resource;
result.HttpMessage = transaction.Message;
result.HttpStatus = Helper.GetHttpStatus(transaction.Status, transaction.Action);
return result;
}
}
return result;
}
/// <summary>
/// Sets the SdataTransactionResult.Diagnosis Object based on the Information in sdTrResult so the consumer gets a decent Error Message
/// </summary>
/// <param name="sdTrResult"></param>
private static void AttachDiagnosis(SdataTransactionResult sdTrResult)
{
Diagnosis diag = new Diagnosis();
diag.Message = sdTrResult.HttpMessage;
diag.Severity = Severity.Error;
diag.ApplicationCode = sdTrResult.HttpStatus.ToString();
diag.SDataCode = DiagnosisCode.ApplicationDiagnosis;
sdTrResult.Diagnosis = diag;
}
public override SdataTransactionResult Add(FeedEntry entry)
{
string accountUuid = string.Empty;
SdataTransactionResult sdTrResult;
ContactFeedEntry contactEntry = entry as ContactFeedEntry;
if (contactEntry.primacyIndicator)
{
// is primary
}
else
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Only primary contacts supported";
sdTrResult.HttpMethod = HttpMethod.POST;
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = SupportedResourceKinds.contacts;
sdTrResult.Uuid = contactEntry.UUID.ToString();
AttachDiagnosis(sdTrResult);
return sdTrResult;
}
if(contactEntry.tradingAccount != null)
accountUuid = contactEntry.tradingAccount.UUID.ToString();
if (String.IsNullOrEmpty(accountUuid) || Guid.Empty.ToString() == accountUuid)
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Trading Account UUID was missing";
sdTrResult.HttpMethod = HttpMethod.POST;
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = contactEntry.UUID.ToString();
AttachDiagnosis(sdTrResult);
return sdTrResult;
}
string accountId = GetTradingAccountLocalId(accountUuid);
if (String.IsNullOrEmpty(accountId))
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = String.Format("Trading Account UUID {0} was not linked", accountUuid);
sdTrResult.HttpMethod = HttpMethod.POST;
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = contactEntry.UUID.ToString();
AttachDiagnosis(sdTrResult);
return sdTrResult;
}
Account account = new Account();
Identity accIdentity = new Identity(account.EntityName, accountId);
AccountDocument accountDocument = account.GetDocument(
accIdentity, _emptyToken, _context.Config) as AccountDocument;
accountDocument.CrmId = accountUuid;
Document document = null;
bool doAdd = false;
document = GetTransformedDocument(entry);
if (accountDocument.people.documents.Count == 0)
{
accountDocument.people.documents.Add(document);
doAdd = true;
}
else
{
PersonDocument personDocument = accountDocument.people.documents[0] as PersonDocument;
if (personDocument.firstname.IsNull &&
personDocument.lastname.IsNull)
{
accountDocument.people.documents[0] = document;
doAdd = true;
}
}
if (!doAdd)
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Trading Account has already a primary contact";
sdTrResult.HttpMethod = HttpMethod.POST;
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = contactEntry.UUID.ToString();
AttachDiagnosis(sdTrResult);
return sdTrResult;
}
List<TransactionResult> transactionResults = new List<TransactionResult>();
account.Update(accountDocument, _context.Config, ref transactionResults);
sdTrResult = GetSdataTransactionResult(transactionResults,
_context.OriginEndPoint, SupportedResourceKinds.tradingAccounts);
if (sdTrResult != null)
{
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.HttpMessage = "POST";
}
return sdTrResult;
}
public override SdataTransactionResult Add(PayloadBase payload, List<SyncFeedEntryLink> links)
{
string accountUuid = "";
SdataTransactionResult sdTrResult;
PhoneNumberPayload phoneNumberPayload = payload as PhoneNumberPayload;
bool isFax = false; ;
bool isPhone = false;
if (phoneNumberPayload.PhoneNumbertype.type.Equals("general", StringComparison.InvariantCultureIgnoreCase))
isPhone = true;
else if (phoneNumberPayload.PhoneNumbertype.type.Equals("fax", StringComparison.InvariantCultureIgnoreCase))
isFax = true;
else
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Only primary phonenumbers with type general and fax where accepted";
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = phoneNumberPayload.SyncUuid;
return sdTrResult;
}
foreach (SyncFeedEntryLink link in links)
{
if ((!String.IsNullOrEmpty(link.PayloadPath)) &&
link.PayloadPath.Equals(_tradingAccountUuidPayloadPath,
StringComparison.InvariantCultureIgnoreCase))
{
accountUuid = link.Uuid;
break;
}
}
if (String.IsNullOrEmpty(accountUuid))
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Trading Account UUID was missing";
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = phoneNumberPayload.SyncUuid;
return sdTrResult;
}
string accountId = GetTradingAccountLocalId(accountUuid);
if (String.IsNullOrEmpty(accountId))
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = String.Format("Trading Account UUID {0} was not linked", accountUuid);
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = phoneNumberPayload.SyncUuid;
return sdTrResult;
}
Account account = new Account();
Identity accIdentity = new Identity(account.EntityName, accountId);
AccountDocument accountDocument = account.GetDocument(
accIdentity, _emptyToken, _context.Config) as AccountDocument;
Document document = null;
bool doAdd = false;
document = GetTransformedDocument(payload, links);
if (isPhone)
document.Id = accountId + Sage.Integration.Northwind.Application.API.Constants.PhoneIdPostfix;
if (isFax)
document.Id = accountId + Sage.Integration.Northwind.Application.API.Constants.FaxIdPostfix;
if (accountDocument.addresses.documents.Count == 0)
{
accountDocument.CrmId = GetTradingAccountUuid(document.Id);
accountDocument.phones.documents.Add(document);
doAdd = true;
}
else
{
for (int index = 0; index < accountDocument.phones.documents.Count; index++)
{
if (accountDocument.phones.documents[index].Id.Equals(document.Id, StringComparison.InvariantCultureIgnoreCase))
{
if (((PhoneDocument)accountDocument.phones.documents[index]).number.IsNull)
{
doAdd = true;
accountDocument.phones.documents[index] = document;
}
break;
}
}
}
if (!doAdd)
{
sdTrResult = new SdataTransactionResult();
sdTrResult.HttpMessage = "Trading Account has already this primary phone type";
sdTrResult.HttpMethod = "POST";
sdTrResult.HttpStatus = System.Net.HttpStatusCode.Forbidden;
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.Uuid = phoneNumberPayload.SyncUuid;
return sdTrResult;
}
List<TransactionResult> transactionResults = new List<TransactionResult>();
account.Update(accountDocument, _context.Config, ref transactionResults);
sdTrResult = Helper.GetSdataTransactionResult(transactionResults,
_context.OriginEndPoint, SupportedResourceKinds.tradingAccounts);
if (sdTrResult != null)
{
sdTrResult.ResourceKind = _resourceKind;
sdTrResult.HttpMessage = "POST";
}
return sdTrResult;
}
public override SdataTransactionResult Update(Sage.Common.Syndication.FeedEntry payload)
{
SdataTransactionResult tmpTransactionResult;
SalesOrderFeedEntry salesorder = null;
#region check input values
if (!(payload is SalesOrderFeedEntry))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
salesorder = (payload as SalesOrderFeedEntry);
if (salesorder == null)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("salesorder payload missing");
return tmpTransactionResult;
}
string customerID = "";
if (salesorder.tradingAccount != null)
customerID = GetLocalId(salesorder.tradingAccount.UUID, SupportedResourceKinds.tradingAccounts);
if (String.IsNullOrEmpty(customerID))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Trading Acount Id missing");
return tmpTransactionResult;
}
if (!customerID.StartsWith(Sage.Integration.Northwind.Application.API.Constants.CustomerIdPrefix))
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = ("Salesorder submission is only supported by customers");
return tmpTransactionResult;
}
#endregion
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.OrderTableAdapters.OrdersTableAdapter tableAdapter = new OrdersTableAdapter();
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.OrderTableAdapters.Order_DetailsTableAdapter detailsTableAdapter = new Order_DetailsTableAdapter();
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order order = new Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order();
int id;
if (!(Int32.TryParse(payload.Key, out id)))
id = 0;
int recordCount;
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
tableAdapter.Connection = connection;
recordCount = tableAdapter.FillBy(order.Orders, id);
if (recordCount == 0)
return null;
detailsTableAdapter.Connection = connection;
detailsTableAdapter.FillBy(order.Order_Details, id);
}
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.OrdersRow row = (Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.OrdersRow)order.Orders[0];
#region fill dataset from document
try
{
if (!salesorder.IsPropertyChanged("date"))
row.SetOrderDateNull();
else
row.OrderDate = salesorder.date;
if (!salesorder.IsPropertyChanged("dueDate"))
row.SetRequiredDateNull();
else
row.RequiredDate = (DateTime)salesorder.dueDate;
//if (orderDoc.shippedvia.IsNull)
// newOrder.SetShipViaNull();
//else
// newOrder.ShipVia = (int)orderDoc.shippedvia.Value;
if (salesorder.postalAddresses == null || salesorder.postalAddresses.Entries.Count == 0)
{
row.SetShipAddressNull();
row.SetShipCityNull();
row.SetShipCountryNull();
row.SetShipPostalCodeNull();
}
else
{
PostalAddressFeedEntry postadress = salesorder.postalAddresses.Entries[0];
row.ShipAddress = postadress.address1;
row.ShipCity = postadress.townCity;
row.ShipPostalCode = postadress.zipPostCode;
row.ShipCountry = postadress.country;
}
if (!salesorder.IsPropertyChanged("carrierTotalPrice"))
row.Freight = (decimal)0;
else
row.Freight = (decimal)salesorder.carrierTotalPrice;
//row.CreateUser = _context.Config.CrmUser;
row.ModifyUser = _context.Config.CrmUser;
//row.CreateID = _context.Config.SequenceNumber;
row.ModifyID = _context.Config.SequenceNumber;
Guid itemUuid;
List<Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow> rowsToDelete = new List<Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow>();
List<Guid> itemUuids = new List<Guid>();
if (salesorder.salesOrderLines != null)
{
foreach (SalesOrderLineFeedEntry soLine in salesorder.salesOrderLines.Entries)
{
if ((soLine.UUID != null && soLine.UUID != Guid.Empty) && (!itemUuids.Contains(soLine.UUID)))
itemUuids.Add(soLine.UUID);
}
}
foreach (Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow detailsRow in order.Order_Details)
{
string itemId = detailsRow.OrderID.ToString() + "-" + detailsRow.ProductID.ToString();
itemUuid = GetUuid(itemId, "", SupportedResourceKinds.salesOrderLines);
if (itemUuids.Contains(itemUuid))
{
foreach (SalesOrderLineFeedEntry soLine in salesorder.salesOrderLines.Entries)
{
if (soLine.UUID.Equals(itemUuid))
{
if (soLine.IsDeleted)
{
rowsToDelete.Add(detailsRow);
break;
}
/*if (soLine.IsEmpty)
{
break;
}*/
detailsRow.ModifyUser = _context.Config.CrmUser;
detailsRow.ModifyID = _context.Config.SequenceNumber;
if (soLine.IsPropertyChanged("quantity"))
detailsRow.Quantity = Convert.ToInt16(soLine.quantity);
else
detailsRow.Quantity = 0;
if (soLine.IsPropertyChanged("initialPrice"))
detailsRow.UnitPrice = (Decimal)soLine.initialPrice;
else
detailsRow.UnitPrice = 0;
if ((!soLine.IsPropertyChanged("discountTotal")) || (detailsRow.Quantity == 0) || (detailsRow.UnitPrice == 0))
{
detailsRow.Discount = (float)0;
}
else
{
// discountPC = discountsum / qunatity * listprice
//detailRow.Discount = Convert.ToSingle((decimal)lineItemDoc.discountsum.Value / ((decimal)detailRow.Quantity * detailRow.UnitPrice));
float discount = Convert.ToSingle((decimal)soLine.discountTotal / (detailsRow.UnitPrice));
if (discount > 1)
discount = 0;
detailsRow.Discount = discount;
}
break;
}
}
itemUuids.Remove(itemUuid);
}
else
{
//delete item
rowsToDelete.Add(detailsRow);
}
}
if (salesorder.salesOrderLines != null)
{
foreach (SalesOrderLineFeedEntry soLine in salesorder.salesOrderLines.Entries)
{
Guid soUuid = soLine.UUID;
if (itemUuids.Contains(soUuid))
itemUuids.Remove(soUuid);
else
continue;
try
{
Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow detailRow = order.Order_Details.NewOrder_DetailsRow();
Guid productUuid = soLine.commodity.UUID;
string productIdString = GetLocalId(productUuid, SupportedResourceKinds.commodities);
int productID;
if (!int.TryParse(productIdString, out productID))
continue;
string sorderID = payload.Key + "-" + productID.ToString();
detailRow.OrderID = Convert.ToInt32(payload.Key);
detailRow.ProductID = productID;
if (soLine.IsPropertyChanged("quantity"))
detailRow.Quantity = Convert.ToInt16(soLine.quantity);
else
detailRow.Quantity = 0;
if (soLine.IsPropertyChanged("initialPrice"))
detailRow.UnitPrice = (Decimal)soLine.initialPrice;
else
detailRow.UnitPrice = 0;
if ((!soLine.IsPropertyChanged("discountTotal")) || (detailRow.Quantity == 0) || (detailRow.UnitPrice == 0))
{
detailRow.Discount = (float)0;
}
else
{
// discountPC = discountsum / qunatity * listprice
//detailRow.Discount = Convert.ToSingle((decimal)lineItemDoc.discountsum.Value / ((decimal)detailRow.Quantity * detailRow.UnitPrice));
float discount = Convert.ToSingle((decimal)soLine.discountTotal / (detailRow.UnitPrice));
if (discount > 1)
discount = 0;
detailRow.Discount = discount;
}
detailRow.CreateUser = _context.Config.CrmUser;
detailRow.ModifyUser = _context.Config.CrmUser;
detailRow.CreateID = _context.Config.SequenceNumber;
detailRow.ModifyID = _context.Config.SequenceNumber;
order.Order_Details.AddOrder_DetailsRow(detailRow);
}
// this error occours in case of invalid data types
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.POST;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.Message;
return tmpTransactionResult;
}
}
}
using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString))
{
OleDbTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
tableAdapter.Connection = connection;
detailsTableAdapter.Connection = connection;
tableAdapter.SetTransaction(transaction);
detailsTableAdapter.SetTransaction(transaction);
foreach (Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.Order_DetailsRow detailsRow in rowsToDelete)
{
detailsTableAdapter.Delete(detailsRow.OrderID,
detailsRow.ProductID,
detailsRow.UnitPrice, detailsRow.Quantity,
detailsRow.Discount, detailsRow.CreateID, detailsRow.CreateUser, detailsRow.ModifyID, detailsRow.ModifyUser);
}
tableAdapter.Update(order.Orders);
detailsTableAdapter.Update(order.Order_Details);
transaction.Commit();
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK;
tmpTransactionResult.LocalId = payload.Key;
return tmpTransactionResult;
}
catch (Exception transactionException)
{
if (transaction != null)
transaction.Rollback();
throw;
}
}
}
catch (Exception e)
{
tmpTransactionResult = new SdataTransactionResult();
tmpTransactionResult.HttpMethod = HttpMethod.PUT;
tmpTransactionResult.ResourceKind = _resourceKind;
tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest;
tmpTransactionResult.HttpMessage = e.ToString();
return tmpTransactionResult;
}
#endregion
}
