void updateForm()
{
Cursor.Current = Cursors.WaitCursor;
var newConnection = new dbContextDataContext();
myInvoiceList = new BindingList<getClaimantInvoicesResult>(newConnection.getClaimantInvoices(myClaimant.ClaimantID, StartDate, EndDate).ToList());
this.claimantInvoiceGridControl.DataSource = myInvoiceList;
decimal? invoiceTotal = 0;
decimal? receiptTotal = 0;
newConnection.getClaimantInvoiceTotal(myClaimant.ClaimantID, StartDate, EndDate, ref invoiceTotal);
newConnection.getClaimantReceiptTotal(myClaimant.ClaimantID, StartDate, EndDate, ref receiptTotal);
invoiceTotalSpinEdit.Value = invoiceTotal.GetValueOrDefault(0.0M);
receiptTotalSpinEdit.Value = receiptTotal.GetValueOrDefault(0.0M);
balanceSpinEdit.Value = decimal.Subtract(invoiceTotal.GetValueOrDefault(0.0M), receiptTotal.GetValueOrDefault(0.0M));
Cursor.Current = Cursors.Default;
}
private void linqInstantFeedbackSource1_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e)
{
var newConnection = new dbContextDataContext();
e.QueryableSource = newConnection.getClaimantInvoices(myClaimant.ClaimantID, StartDate, EndDate).AsQueryable();
e.Tag = newConnection;
}
