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