private void btnSearch_Click(object sender, EventArgs e) { customer.Clear(); var innerJoin = from cust in NorthwindDataSet.Customers join ord in NorthwindDataSet.Orders on cust.CustomerID equals ord.CustomerID where ord.OrderID == Convert.ToInt32(cb_OrderDetails.Text) select new { name = cust.CompanyName, contact = cust.ContactName, address = cust.Address, city = cust.City }; foreach (var i in innerJoin) { customer.Add(i.name); customer.Add(i.contact); customer.Add(i.address); customer.Add(i.city); } ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("parameterCompanyName", customer[0])); reportParameters.Add(new ReportParameter("parameterContactName", customer[1])); reportParameters.Add(new ReportParameter("parameterAddress", customer[2])); reportParameters.Add(new ReportParameter("parameterCity", customer[3])); reportViewer1.LocalReport.SetParameters(reportParameters); Order_DetailsTableAdapter.FillOrderID(NorthwindDataSet.Order_Details, Convert.ToInt32(cb_OrderDetails.Text)); Order_Details_fill_name(); }
private void Report_Load(object sender, EventArgs e) { productsTableAdapter.Fill(NorthwindDataSet.Products); employeesTableAdapter.Fill(NorthwindDataSet.Employees); customersTableAdapter.Fill(NorthwindDataSet.Customers); OrdersTableAdapter.Fill(NorthwindDataSet.Orders); var q = from em in NorthwindDataSet.Employees where em.EmployeeID == Convert.ToInt32(id) select new { firstName = em.FirstName, lastName = em.LastName }; foreach (var i in q) { employee.Add(i.firstName); employee.Add(i.lastName); } ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("parameterFirstName", employee[0])); reportParameters.Add(new ReportParameter("parameterLastName", employee[1])); reportViewer1.LocalReport.SetParameters(reportParameters); da.Fill(ds.Tables["Orders"]); cb_OrderDetails.DataSource = bs; cb_OrderDetails.DisplayMember = "OrderID"; Order_DetailsTableAdapter.Fill(NorthwindDataSet.Order_Details); Order_Details_fill_name(); }
private void FilterOrderDetails(string productName) { DrillDownDataSet ddds = (Session["DrillDownDataSet"] as DrillDownDataSet); Order_DetailsTableAdapter oda = new Order_DetailsTableAdapter(); ddds.Order_Details.Clear(); oda.FillBy(ddds.Order_Details, productName); }
void InitializeDataSources() { var dataSource = new DataSet1(); var connection = new OleDbConnection(); connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb"; EmployeesTableAdapter employees = new EmployeesTableAdapter(); employees.Connection = connection; employees.Fill(dataSource.Employees); CustomersTableAdapter customers = new CustomersTableAdapter(); customers.Connection = connection; customers.Fill(dataSource.Customers); EmployeeCustomersTableAdapter employeeCustomers = new EmployeeCustomersTableAdapter(); employeeCustomers.Connection = connection; employeeCustomers.Fill(dataSource.EmployeeCustomers); OrdersTableAdapter orders = new OrdersTableAdapter(); orders.Connection = connection; orders.Fill(dataSource.Orders); Order_DetailsTableAdapter orderDetails = new Order_DetailsTableAdapter(); orderDetails.Connection = connection; orderDetails.Fill(dataSource.Order_Details); SnapDocument document = snapControl1.Document; document.BeginUpdateDataSource(); var employeesBinding = new BindingSource() { DataSource = dataSource, DataMember = employeeDataSourceName }; document.DataSources.Add(new DataSourceInfo(employeeDataSourceName, employeesBinding)); var customersBinding = new BindingSource() { DataSource = dataSource, DataMember = customerDataSourceName }; document.DataSources.Add(new DataSourceInfo(customerDataSourceName, customersBinding)); document.EndUpdateDataSource(); }
private void btnFill_Click(object sender, EventArgs e) { ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("parameterCompanyName", " ")); reportParameters.Add(new ReportParameter("parameterContactName", " ")); reportParameters.Add(new ReportParameter("parameterAddress", " ")); reportParameters.Add(new ReportParameter("parameterCity", " ")); reportViewer1.LocalReport.SetParameters(reportParameters); Order_DetailsTableAdapter.Fill(NorthwindDataSet.Order_Details); Order_Details_fill_name(); }
private void CopyOrderDetails(IOdb odb, ref double progress) { //Processing OrderDetails LogMessage("Reading OrderDetails...", false); var adapter1 = new Order_DetailsTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("OrderDetails: " + row.OrderID.ToString() + "/" + row.ProductID.ToString() + " ...", false); var od = new OrderDetail(); LogMessage("linking members...", false); od.Order = NDbUtil.GetByNumericalID <Order>(odb, Order.PK, row.OrderID); od.Product = NDbUtil.GetByNumericalID <Product>(odb, Product.PK, row.ProductID); od.UnitPrice = Convert.ToDouble(row.UnitPrice); od.Quantity = row.Quantity; od.Discount = Convert.ToDouble(row.Discount); odb.Store(od); StepFinished(progress += 0.029); LogMessage("saved (" + od.Order.OrderID.ToString() + "/" + od.Product.ProductID.ToString() + ")", true); } odb.Commit(); long objectCount = NDbUtil.GetAllInstances <OrderDetail>(odb).Count; if (table1.Count == objectCount) { LogMessage(table1.Count + " objects saved", true); } else { LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true); } LogMessage("Done with OrderDetails" + Environment.NewLine, true); }
public Example() { InitializeComponent(); NWindDataSet dataSet = new NWindDataSet(); OrdersTableAdapter ordersAdapter = new OrdersTableAdapter(); ordersAdapter.Fill(dataSet.Orders); Order_DetailsTableAdapter detailAdapter = new Order_DetailsTableAdapter(); detailAdapter.Fill(dataSet.Order_Details); radGridView1.AutoGenerateHierarchyFromDataSet = true; radGridView1.DataMember = dataSet.Tables["Orders"].TableName; radGridView1.ItemsSource = dataSet; }
public override SdataTransactionResult Update(Sage.Common.Syndication.FeedEntry payload) { SdataTransactionResult tmpTransactionResult; if (!(payload is SalesOrderLineFeedEntry)) { tmpTransactionResult = new SdataTransactionResult(); tmpTransactionResult.HttpMethod = HttpMethod.PUT; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest; tmpTransactionResult.HttpMessage = ("salesorder payload missing"); return(tmpTransactionResult); } SalesOrderLineFeedEntry soLine = payload as SalesOrderLineFeedEntry; 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 productId; int orderId; if (GetLocalIds(payload.Key, 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.Key; tmpTransactionResult.HttpMethod = 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.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; } } detailsTableAdapter.Update(order.Order_Details); tmpTransactionResult = new SdataTransactionResult(); tmpTransactionResult.LocalId = payload.Key; tmpTransactionResult.HttpMethod = HttpMethod.PUT; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK; return(tmpTransactionResult); } catch (Exception e) { tmpTransactionResult = new SdataTransactionResult(); tmpTransactionResult.LocalId = payload.Key; tmpTransactionResult.HttpMethod = HttpMethod.PUT; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest; tmpTransactionResult.HttpMessage = e.Message; return(tmpTransactionResult); } } } tmpTransactionResult = new SdataTransactionResult(); tmpTransactionResult.LocalId = payload.Key; tmpTransactionResult.HttpMethod = HttpMethod.PUT; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest; tmpTransactionResult.HttpMessage = "Not found"; return(tmpTransactionResult); }
public override SdataTransactionResult Delete(string id) { SdataTransactionResult tmpTransactionResult; 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 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 = 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 = HttpMethod.DELETE; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK; return(tmpTransactionResult); } catch (Exception e) { tmpTransactionResult = new SdataTransactionResult(); tmpTransactionResult.LocalId = id; tmpTransactionResult.HttpMethod = 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 = HttpMethod.DELETE; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest; tmpTransactionResult.HttpMessage = "Not found"; return(tmpTransactionResult); }
public void CopyOrderDetails() { //Processing OrderDetails LogMessage("Reading OrderDetails...", false); Order_DetailsTableAdapter adapter1 = new Order_DetailsTableAdapter(); NorthwindDb4o.NorthwindDataSet.Order_DetailsDataTable table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (NorthwindDb4o.NorthwindDataSet.Order_DetailsRow row in table1) { LogMessage("OrderDetails: " + row.OrderID.ToString() + "/" + row.ProductID.ToString() + " ...", false); OrderDetail od = new OrderDetail(); LogMessage("linking members...", false); od.OrderID = (Order)Db4oUtil.GetByNumericalID(container, typeof(Order), "orderID", row.OrderID); od.ProductID = (Product)Db4oUtil.GetByNumericalID(container, typeof(Product), "productID", row.ProductID); od.UnitPrice = Convert.ToDouble(row.UnitPrice); od.Quantity = row.Quantity; od.Discount = Convert.ToDouble(row.Discount); container.Store(od); LogMessage("saved ("+od.OrderID.OrderID.ToString()+"/"+od.ProductID.ProductID.ToString()+")", true); } container.Commit(); long objectCount = Db4oUtil.GetAllInstances(container, typeof(OrderDetail)).Count; if (table1.Count == objectCount) LogMessage(table1.Count + " objects saved", true); else LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true); LogMessage("Done with OrderDetails" + Environment.NewLine, true); }
private void CopyOrderDetails(IOdb odb, ref double progress) { //Processing OrderDetails LogMessage("Reading OrderDetails...", false); var adapter1 = new Order_DetailsTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("OrderDetails: " + row.OrderID.ToString() + "/" + row.ProductID.ToString() + " ...", false); var od = new OrderDetail(); LogMessage("linking members...", false); od.Order = NDbUtil.GetByNumericalID<Order>(odb, Order.PK, row.OrderID); od.Product = NDbUtil.GetByNumericalID<Product>(odb, Product.PK, row.ProductID); od.UnitPrice = Convert.ToDouble(row.UnitPrice); od.Quantity = row.Quantity; od.Discount = Convert.ToDouble(row.Discount); odb.Store(od); StepFinished(progress += 0.029); LogMessage("saved (" + od.Order.OrderID.ToString() + "/" + od.Product.ProductID.ToString() + ")", true); } odb.Commit(); long objectCount = NDbUtil.GetAllInstances<OrderDetail>(odb).Count; if (table1.Count == objectCount) LogMessage(table1.Count + " objects saved", true); else LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true); LogMessage("Done with OrderDetails" + Environment.NewLine, true); }
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 }
public override SdataTransactionResult Delete(string localID) { SdataTransactionResult tmpTransactionResult; 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(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 = 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 = HttpMethod.DELETE; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.OK; return(tmpTransactionResult); } catch (Exception e) { tmpTransactionResult = new SdataTransactionResult(); tmpTransactionResult.LocalId = localID; tmpTransactionResult.HttpMethod = HttpMethod.DELETE; tmpTransactionResult.ResourceKind = _resourceKind; tmpTransactionResult.HttpStatus = System.Net.HttpStatusCode.BadRequest; tmpTransactionResult.HttpMessage = e.Message; return(tmpTransactionResult); } } }