private void GeneratePayment(dsCore ds) { dsCore dt = new dsCore(); dt.EnforceConstraints = false; // copy master record dt.Orders.Rows.Add(ds.Orders[0].ItemArray); // ubah jenis transaksi dt.Orders[0].ParentID = ds.Orders[0].ID; dt.Orders[0].OrderNo = DbHelper.GenerateNewOrderID(TransactionTypes.TX_PURCHASE_PAYMENT, dt.Orders[0].OrderDate.Year); dt.Orders[0].OrderType = TransactionTypes.TX_PURCHASE_PAYMENT; dt.Orders[0].OrderValue = Convert.ToDouble(c1NumericEdit1.Value); // detail payment dsCore.OrderDetailsRow row = dt.OrderDetails.NewOrderDetailsRow(); row.OrderID = dt.Orders[0].ID; row.ReferenceID = InvoiceID; row.UnitPrice = Convert.ToDouble(c1NumericEdit1.Value); row.Quantity = 1; row.TaxPct = 0; if (!dt.Orders[0].IsRemarksNull()) { row.Remarks = ds.Orders[0].Remarks; } dt.OrderDetails.AddOrderDetailsRow(row); // persist changes to database daOrders1.Update(dt.Orders); daOrderDetails1.Update(dt.OrderDetails); // remember result PaymentID = dt.Orders[0].ID; PaymentNum = dt.Orders[0].OrderNo; }
private void c1Combo2_SelectedValueChanged(object sender, EventArgs e) { if (txMode == DataEntryModes.Add) { try { // get data dsCore ds = new dsCore(); OrdersTableAdapter od = new OrdersTableAdapter(); OrderDetailsTableAdapter ta = new OrderDetailsTableAdapter(); ds.EnforceConstraints = false; od.Connection = AppHelper.GetDbConnection(); od.FillByID(ds.Orders, (int)c1Combo2.SelectedValue); ta.Connection = AppHelper.GetDbConnection(); ta.FillNotCompleted(ds.OrderDetails, (int)c1Combo2.SelectedValue); // clear grid dsCore1.OrderDetails.Clear(); // fill grid with new data _grid.Redraw = false; DataRowView dv = (DataRowView)this.BindingContext[dsCore1, "Orders"].Current; dv["CompanyID"] = ds.Orders[0].CompanyID; dv["CurrencyID"] = ds.Orders[0].CurrencyID; if (!ds.Orders[0].IsCompanyIDNull()) { c1Combo1.SelectedValue = ds.Orders[0].CompanyID; } if (!ds.Orders[0].IsCurrencyIDNull()) { c1Combo3.SelectedValue = ds.Orders[0].CurrencyID; } foreach (dsCore.OrderDetailsRow src in ds.OrderDetails.Rows) { dsCore.OrderDetailsRow row = dsCore1.OrderDetails.NewOrderDetailsRow(); row.OrderID = (int)dv["ID"]; row.ItemID = src.ItemID; row.ItemCode = src.ItemCode; row.ItemName = src.ItemName; row.Quantity = src.Quantity; row.UnitPrice = src.UnitPrice; row.TaxPct = src.TaxPct; row.Remarks = src.Remarks; row.MeasureCode = src.MeasureCode; dsCore1.OrderDetails.AddOrderDetailsRow(row); } // redraw grid _grid.Redraw = true; _grid.Refresh(); // recalculate order value c1Label1.Value = CountDetails(); } catch (Exception ex) { // textfile logging Logger.ErrorRoutine(ex); // screen logging RibbonMessageBox.Show("ERROR Retrieving Detail Data: \n" + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
private void c1Combo1_SelectedValueChanged(object sender, EventArgs e) { if (txMode == DataEntryModes.Add) { try { // prevent redraw _grid.Redraw = false; // get data dsCore ds = new dsCore(); OrdersTableAdapter od = new OrdersTableAdapter(); ds.EnforceConstraints = false; od.Connection = AppHelper.GetDbConnection(); od.FillOutstandingSalesInvoices(ds.Orders, (int)c1Combo1.SelectedValue); // clear grid dsCore1.OrderDetails.Clear(); // fill grid with new data DataRowView dv = (DataRowView)this.BindingContext[dsCore1, "Orders"].Current; foreach (dsCore.OrdersRow src in ds.Orders.Rows) { dsCore.OrderDetailsRow row = dsCore1.OrderDetails.NewOrderDetailsRow(); row.OrderID = (int)dv["ID"]; row.ReferenceID = src.ID; row.ReferenceNo = src.OrderNo; row.ReferenceDate = src.OrderDate; row.ReferenceValue = src.OutstandingValue; row.UnitPrice = src.OutstandingValue; row.Quantity = 1; row.TaxPct = 0; if (!src.IsRemarksNull()) { row.Remarks = src.Remarks; } dsCore1.OrderDetails.AddOrderDetailsRow(row); } // recalculate CountDetails(); // redraw grid _grid.Redraw = true; _grid.Refresh(); } catch (Exception ex) { // textfile logging Logger.ErrorRoutine(ex); // screen logging RibbonMessageBox.Show("ERROR Retrieving Detail Data: \n" + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }