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;
}