private async Task PerformUpdateAsync(DataSet <SalesOrder> salesOrders, CancellationToken ct)
{
salesOrders._.ResetRowIdentifiers();
await SalesOrderHeader.UpdateAsync(salesOrders, ct);
await SalesOrderDetail.DeleteAsync(salesOrders, (s, _) => s.Match(_.FK_SalesOrderHeader), ct);
var salesOrderDetails = salesOrders.GetChild(_ => _.SalesOrderDetails);
salesOrderDetails._.ResetRowIdentifiers();
await SalesOrderDetail.InsertAsync(salesOrderDetails, ct);
}
public async Task UpdateSalesOrderAsync(DataSet <SalesOrderInfo> salesOrders, CancellationToken ct = default(CancellationToken))
{
await EnsureConnectionOpenAsync(ct);
using (var transaction = BeginTransaction())
{
salesOrders._.ResetRowIdentifiers();
await SalesOrderHeader.UpdateAsync(salesOrders, ct);
await SalesOrderDetail.DeleteAsync(salesOrders, (s, _) => s.Match(_.FK_SalesOrderHeader), ct);
var salesOrderDetails = salesOrders.GetChild(_ => _.SalesOrderDetails);
salesOrderDetails._.ResetRowIdentifiers();
await SalesOrderDetail.InsertAsync(salesOrderDetails, ct);
await transaction.CommitAsync(ct);
}
}
public async Task <int?> CreateSalesOrderAsync(DataSet <SalesOrderInfo> salesOrders, CancellationToken ct)
{
await EnsureConnectionOpenAsync(ct);
using (var transaction = BeginTransaction())
{
salesOrders._.ResetRowIdentifiers();
await SalesOrderHeader.InsertAsync(salesOrders, true, ct);
var salesOrderDetails = salesOrders.GetChild(_ => _.SalesOrderDetails);
salesOrderDetails._.ResetRowIdentifiers();
await SalesOrderDetail.InsertAsync(salesOrderDetails, ct);
await transaction.CommitAsync(ct);
return(salesOrders.Count > 0 ? salesOrders._.SalesOrderID[0] : null);
}
}
private static DataSet <SalesOrderHeader> Headers()
{
DataSet <SalesOrderHeader> result = DataSet <SalesOrderHeader> .Create().AddRows(4);
SalesOrderHeader _ = result._;
_.SuspendIdentity();
_.SalesOrderID[0] = 1;
_.SalesOrderID[1] = 2;
_.SalesOrderID[2] = 3;
_.SalesOrderID[3] = 4;
_.RevisionNumber[0] = 2;
_.RevisionNumber[1] = 2;
_.RevisionNumber[2] = 2;
_.RevisionNumber[3] = 2;
_.OrderDate[0] = Convert.ToDateTime("2008-06-01T00:00:00.000");
_.OrderDate[1] = Convert.ToDateTime("2008-06-01T00:00:00.000");
_.OrderDate[2] = Convert.ToDateTime("2008-06-01T00:00:00.000");
_.OrderDate[3] = Convert.ToDateTime("2008-06-01T00:00:00.000");
_.DueDate[0] = Convert.ToDateTime("2008-06-13T00:00:00.000");
_.DueDate[1] = Convert.ToDateTime("2008-06-13T00:00:00.000");
_.DueDate[2] = Convert.ToDateTime("2008-06-13T00:00:00.000");
_.DueDate[3] = Convert.ToDateTime("2008-06-13T00:00:00.000");
_.ShipDate[0] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.ShipDate[1] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.ShipDate[2] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.ShipDate[3] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.Status[0] = SalesOrderStatus.Shipped;
_.Status[1] = SalesOrderStatus.Shipped;
_.Status[2] = SalesOrderStatus.Shipped;
_.Status[3] = SalesOrderStatus.Shipped;
_.OnlineOrderFlag[0] = false;
_.OnlineOrderFlag[1] = false;
_.OnlineOrderFlag[2] = false;
_.OnlineOrderFlag[3] = false;
_.PurchaseOrderNumber[0] = "PO348186287";
_.PurchaseOrderNumber[1] = "PO19952192051";
_.PurchaseOrderNumber[2] = "PO19604173239";
_.PurchaseOrderNumber[3] = "PO19372114749";
_.AccountNumber[0] = "10-4020-000609";
_.AccountNumber[1] = "10-4020-000106";
_.AccountNumber[2] = "10-4020-000340";
_.AccountNumber[3] = "10-4020-000582";
_.CustomerID[0] = 29847;
_.CustomerID[1] = 30072;
_.CustomerID[2] = 30113;
_.CustomerID[3] = 29485;
_.ShipToAddressID[0] = 1092;
_.ShipToAddressID[1] = 640;
_.ShipToAddressID[2] = 653;
_.ShipToAddressID[3] = 1086;
_.BillToAddressID[0] = 1092;
_.BillToAddressID[1] = 640;
_.BillToAddressID[2] = 653;
_.BillToAddressID[3] = 1086;
_.ShipMethod[0] = "CARGO TRANSPORT 5";
_.ShipMethod[1] = "CARGO TRANSPORT 5";
_.ShipMethod[2] = "CARGO TRANSPORT 5";
_.ShipMethod[3] = "CARGO TRANSPORT 5";
_.CreditCardApprovalCode[0] = null;
_.CreditCardApprovalCode[1] = null;
_.CreditCardApprovalCode[2] = null;
_.CreditCardApprovalCode[3] = null;
_.SubTotal[0] = 880.3484M;
_.SubTotal[1] = 78.8100M;
_.SubTotal[2] = 38418.6895M;
_.SubTotal[3] = 39785.3304M;
_.TaxAmt[0] = 70.4279M;
_.TaxAmt[1] = 6.3048M;
_.TaxAmt[2] = 3073.4952M;
_.TaxAmt[3] = 3182.8264M;
_.Freight[0] = 22.0087M;
_.Freight[1] = 1.9703M;
_.Freight[2] = 960.4672M;
_.Freight[3] = 994.6333M;
_.Comment[0] = null;
_.Comment[1] = null;
_.Comment[2] = null;
_.Comment[3] = null;
_.RowGuid[0] = new Guid("89e42cdc-8506-48a2-b89b-eb3e64e3554e");
_.RowGuid[1] = new Guid("8a3448c5-e677-4158-a29b-dd33069be0b0");
_.RowGuid[2] = new Guid("a47665d2-7ac9-4cf3-8a8b-2a3883554284");
_.RowGuid[3] = new Guid("f1be45a5-5c57-4a50-93c6-5f8be44cb7cb");
_.ModifiedDate[0] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.ModifiedDate[1] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.ModifiedDate[2] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.ModifiedDate[3] = Convert.ToDateTime("2008-06-08T00:00:00.000");
_.ResumeIdentity();
return(result);
}
private KeyMapping FK_SalesOrderHeader_Address_ShipTo_AddressID(SalesOrderHeader _)
{
return(_.FK_ShipToCustomerAddress.Join(CustomerAddress._));
}
private KeyMapping FK_SalesOrderHeader_Customer_CustomerID(SalesOrderHeader _)
{
return(_.FK_Customer.Join(Customer._));
}
private DbSet <SalesOrderHeader> GetSalesOrderHeaders(_String filterText)
{
return(SalesOrderHeader.Where(_ => _.SalesOrderNumber.Contains(filterText) | _.PurchaseOrderNumber.Contains(filterText)));
}
public Task <int> DeleteSalesOrderAsync(DataSet <SalesOrderHeader.Key> dataSet, CancellationToken ct = default(CancellationToken))
{
return(SalesOrderHeader.DeleteAsync(dataSet, (s, _) => s.Match(_), ct));
}