public override Sage.Common.Syndication.FeedEntry GetFeedEntry(string idString) { #region declarations int recordCount; Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order order = new Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order(); CalculatedOrdersTableAdapter tableAdapter; tableAdapter = new CalculatedOrdersTableAdapter(); CalculatedOrderDetailsTableAdapter detailTableAdapter; detailTableAdapter = new CalculatedOrderDetailsTableAdapter(); //DeletedOrderDetailsTableAdapter deletedDetailTableAdapter; //deletedDetailTableAdapter = new DeletedOrderDetailsTableAdapter(); int id; if (!(Int32.TryParse(idString, out id))) id = 0; #endregion #region fill dataset using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString)) { tableAdapter.Connection = connection; recordCount = tableAdapter.FillBy(order.CalculatedOrders, id, id); if (recordCount == 0) return null; detailTableAdapter.Connection = connection; detailTableAdapter.FillBy(order.CalculatedOrderDetails, id); //deletedDetailTableAdapter.Connection = connection; //deletedDetailTableAdapter.Fill(order.DeletedOrderDetails, id.ToString(), lastToken.SequenceNumber, config.CrmUser); } #endregion SalesInvoiceFeedEntry entry; entry = GetPayload((Sage.Integration.Northwind.Adapter.Data.SalesOrders.DataSets.Order.CalculatedOrdersRow)order.CalculatedOrders[0], order.CalculatedOrderDetails, //order.DeletedOrderDetails, _context.Config); return entry; }
public override SyncFeedEntry GetFeedEntry(string idString) { #region declarations int recordCount; DataSets.Order order = new DataSets.Order(); CalculatedOrdersTableAdapter tableAdapter; tableAdapter = new CalculatedOrdersTableAdapter(); CalculatedOrderDetailsTableAdapter detailTableAdapter; detailTableAdapter = new CalculatedOrderDetailsTableAdapter(); //DeletedOrderDetailsTableAdapter deletedDetailTableAdapter; //deletedDetailTableAdapter = new DeletedOrderDetailsTableAdapter(); int id; if (!(Int32.TryParse(idString, out id))) id = 0; #endregion #region fill dataset using (OleDbConnection connection = new OleDbConnection(_context.Config.ConnectionString)) { tableAdapter.Connection = connection; recordCount = tableAdapter.FillBy(order.CalculatedOrders, id); if (recordCount == 0) return null; detailTableAdapter.Connection = connection; detailTableAdapter.FillBy(order.CalculatedOrderDetails, id); //deletedDetailTableAdapter.Connection = connection; //deletedDetailTableAdapter.Fill(order.DeletedOrderDetails, id.ToString(), lastToken.SequenceNumber, config.CrmUser); } #endregion SyncFeedEntry entry = new SyncFeedEntry(); entry.Id = String.Format("{0}{1}('{2}')", _context.DatasetLink, _resourceKind.ToString(), idString); entry.Title = String.Format("{0}: {1}", _resourceKind.ToString(), idString); entry.Updated = DateTime.Now; entry.Payload = GetPayload((DataSets.Order.CalculatedOrdersRow)order.CalculatedOrders[0], order.CalculatedOrderDetails, //order.DeletedOrderDetails, _context.Config); entry.SyncLinks.AddRange(GetLinks(entry.Payload.ForeignIds)); return entry; }