public claimantViewForm() { InitializeComponent(); _myClaimant = new tblClaimant(); _controller = new claimantController(this, _myClaimant); _controller.Initialize(); }
public void ApplyChanges() { var newConnection = new dbContextDataContext(); try { if (ClaimantPropertiesChanged()) { _sourceClaimant = (from p in newConnection.tblClaimants where p.ClaimantID == _sourceClaimant.ClaimantID select p).SingleOrDefault(); if (_sourceClaimant != null) { //_sourceClaimant.UpdateClaimant(EditCopyClaimant); _sourceClaimant.setProperty(EditCopyClaimant); newConnection.SubmitChanges(); } else { _sourceClaimant = new tblClaimant(); //_sourceClaimant.UpdateClaimant(EditCopyClaimant); _sourceClaimant.setProperty(EditCopyClaimant); newConnection.tblClaimants.InsertOnSubmit(_sourceClaimant); newConnection.SubmitChanges(); } } } catch(Exception) { MessageBox.Show(@"Database not responding. Please check your connection."); } }
public newAddItemForm(tblPhysio MyPhysio, tblRate MyRate, tblClaimant MyClaimant) { InitializeComponent(); myRate = MyRate; myPhysio = MyPhysio; myClaimant = MyClaimant; }
public cancelCreditViewForm(tblClaimant MyClaimant, DateTime Start, DateTime End) { InitializeComponent(); myClaimant = MyClaimant; startDate = Start; endDate = End; }
public agedTrailBalanceViewForm(tblClaimant MyClaimant, tblPhysio MyPhysio, DateTime StartDate, DateTime EndDate) { InitializeComponent(); myClaimant = MyClaimant; myPhysio = MyPhysio; startDate = StartDate; endDate = EndDate; }
public claimantViewForm(tblClaimant myClaimant) { InitializeComponent(); _myClaimant = myClaimant; _controller = new claimantController(this, _myClaimant); _controller.Initialize(); this.UpdateForm(); }
//View/Edit Existing Claimant public claimantDetailsForm(tblClaimant MyClaimant) { InitializeComponent(); myClaimant = MyClaimant; myController = new claimantController(this, myClaimant); myController.Initialize(); updateForm(); setToCompanyOrPrivate(); }
public addCreditViewForm(tblClaimant MyClaimant) { InitializeComponent(); creditAmountSpinEdit.Properties.ReadOnly = false; creditTypeLookUpEdit.Properties.ReadOnly = false; creditDateEdit.DateTime = System.DateTime.Today; myClaimant = MyClaimant; updateDetails(); }
public newInvoiceForm(tblClaimant MyClaimant, tblPhysio MyPhysio) { InitializeComponent(); this.myLines.ListChanged += new ListChangedEventHandler(updateSummaries); this.myReceipts.ListChanged += new ListChangedEventHandler(updateSummaries); this.myReceiptAmounts.ListChanged += new ListChangedEventHandler(updateSummaries); myPhysio = MyPhysio; myClaimant = MyClaimant; newInvoice(); }
public invoicePrintReport(tblInvoice myInvoice, tblClaimant myClaimant, tblTransaction myTransaction) { InitializeComponent(); Cursor.Current = Cursors.WaitCursor; invoiceDateLabel.Text = "Issued on: " + String.Format("{0:MM/dd/yyyy}", myTransaction.TranDate); InvoiceNoLabel.Text = "Invoice # : " + myInvoice.InvoiceNo.ToString(); claimantNameLabel.Text = myClaimant.FirstNames + " " + myClaimant.LastName; streetLabel.Text = myClaimant.Address1; suburbLabel.Text = myClaimant.Address2; stateLabel.Text = myClaimant.Address3; postCodeLabel.Text = myClaimant.Postcode; if (myClaimant.Terms.GetValueOrDefault() > 0) { claimantTermsLabel.Text = myClaimant.Terms.ToString() + " " + "days"; } else { claimantTermsLabel.Text = "ASAP"; } var Lines = new dbContextDataContext().getInvoiceLines(myInvoice.InvoiceNo).ToList(); tblPhysio myPhysio = new dbContextDataContext().tblPhysios.Where(p => p.PhysioID == myTransaction.PhysioID).SingleOrDefault(); physioProviderNoLabel.Text = myPhysio.ProviderNo; physioNameLabel.Text = myPhysio.PhysioName; var receipts = new dbContextDataContext().getReceiptsOfSingleInvoice(myInvoice.InvoiceNo).ToList(); this.DataSource = Lines; sessionDateTableCell.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.DataSource, "Date", "{0:MM/dd/yyyy}")); dobTableCell.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.DataSource, "DOB", "{0:MM/dd/yyyy}")); feeTableCell.DataBindings.Add("Text", this.DataSource, "Fee", "{0:c2}"); gstTableCell.DataBindings.Add("Text", this.DataSource, "GST", "{0:c2}"); totalTableCell.DataBindings.Add("Text", this.DataSource, "Total", "{0:c2}"); decimal invoiceTotal = decimal.Add( (decimal)Lines.Sum(od => od.Fee), (decimal)Lines.Sum(od => od.GST)); decimal alreadyPaid = (decimal)receipts.Sum(r => r.InvRecAmnt); decimal remaining = decimal.Subtract(invoiceTotal, alreadyPaid); invoiceTotalLabel.Text = string.Format("{0:c2}", invoiceTotal); paidTotalLabel.Text = string.Format("{0:c2}", alreadyPaid); amountToBePaidLabel.Text = string.Format("{0:c2}", remaining); decimal feeTotal = (decimal)Lines.Sum(od => od.Fee); decimal gstTotal = (decimal)Lines.Sum(od => od.GST); //feeTotalLabel.Text = feeTotalLabel.Text + feeTotal; //gstTotalLabel.Text = gstTotalLabel.Text + gstTotal; //totalLabel.Text = totalLabel.Text + decimal.Add(feeTotal, gstTotal); Cursor.Current = Cursors.Default; }
public claimantInvoiceViewForm(tblClaimant MyClaimant, DateTime Start, DateTime End) { InitializeComponent(); myClaimant = MyClaimant; StartDate = Start; EndDate = End; updateForm(); myInvoiceList.AllowEdit = true; claimantDetailMemoEdit.Text = "ID: " + myClaimant.ClaimantID + Environment.NewLine + myClaimant.FirstNames + Environment.NewLine + myClaimant.LastName + Environment.NewLine + myClaimant.Address1 + Environment.NewLine + myClaimant.Address2 + Environment.NewLine + myClaimant.Address3 + " " + myClaimant.Postcode; }
public multiReceiptViewForm(tblClaimant MyClaimant, DateTime Start, DateTime End, tblReceipt MyReceipt, BindingList<tblPayin> MyPayments) { InitializeComponent(); this.myClaimant = MyClaimant; startDate = Start; endDate = End; myUnPaidInvoices.AllowEdit = true; myUnPaidInvoices.AllowNew = true; myUnPaidInvoices.AllowRemove = true; myPayments.ListChanged += new ListChangedEventHandler(myPayments_ListChanged); myReceipt = MyReceipt; foreach (var p in MyPayments) { myPayments.Add(p); } updateForm(); multipleReceiptGridControl.DataSource = myUnPaidInvoices; updateClaimantDetails(); }
public static void UpdateClaimant(this tblClaimant source, tblClaimant copy) { source.AcctStatus = copy.AcctStatus; source.Address1 = copy.Address1; source.Address2 = copy.Address2; source.Address3 = copy.Address3; source.BusPhone = copy.BusPhone; source.ClaimantInActive = copy.ClaimantInActive; source.Comments = copy.Comments; source.Company = copy.Company; source.EmailAddr = copy.EmailAddr; source.FaxNo = copy.FaxNo; source.FirstNames = copy.FirstNames; source.HomePhone = copy.HomePhone; source.LastName = copy.LastName; source.MobileNo = copy.MobileNo; source.MonthlyAcct = copy.MonthlyAcct; source.Postcode = copy.Postcode; source.RateID = copy.RateID; source.Terms = copy.Terms; source.Title = copy.Title; }
public void viewInvoice(tblInvoice thisInvoice) { myForm = new invoiceViewForm(); myInvoice = thisInvoice; var newConnection = new dbContextDataContext(); var Lines = newConnection.tblPatientStats.Where(lines => lines.InvoiceNo == thisInvoice.InvoiceNo); foreach (var line in Lines) { myInvoiceLines.Add(line); } myTransaction = newConnection.tblTransactions. Where(transaction => (transaction.InvoiceNo == thisInvoice.InvoiceNo) && (transaction.TranType == "I")).FirstOrDefault(); myClaimant = newConnection.tblClaimants.Where(claimant => claimant.ClaimantID == myTransaction.ClaimantID).FirstOrDefault(); if (myTransaction == null) { myTransaction = new tblTransaction(); } if (myInvoice == null) { myInvoice = new tblInvoice(); } if (myClaimant == null) { myClaimant = new tblClaimant(); } var receiptAmounts = newConnection.tblInvoiceReceipts.Where(rm => rm.InvoiceNo == myInvoice.InvoiceNo); var receipts = from rm in receiptAmounts from r in newConnection.tblReceipts.Where(r => r.ReceiptNo == rm.ReceiptNo) select r; // Second query to get receipts from another table. I might combine the two tables come deployment. var receiptAmounts2 = from rm in newConnection.tblReceiptInvoices where rm.InvoiceNo == myInvoice.InvoiceNo select new { InvoiceNo = rm.InvoiceNo, ReceiptNo = rm.ReceiptNo, InvRecAmnt = rm.Received }; foreach (var receipt in receiptAmounts2) { var receiptAmount = new tblInvoiceReceipt(); receiptAmount.InvoiceNo = receipt.InvoiceNo; receiptAmount.InvRecAmnt = receipt.InvRecAmnt; receiptAmount.ReceiptNo = receipt.ReceiptNo; myReceiptAmounts.Add(receiptAmount); } foreach (var receipt in receipts) { myReceipts.Add(receipt); } foreach (var receiptAmount in receiptAmounts) { myReceiptAmounts.Add(receiptAmount); } myForm.invoiceDateEdit.DateTime = myTransaction.TranDate.Value; registeFormEvents(); updateInvoiceForm(); makeInvoiceOfficial(); myForm.ShowDialog(); Cursor.Current = Cursors.Default; applyPaid(); }
public claimantController(Form myForm, tblClaimant myClaimant) { MyViewForm = myForm; _sourceClaimant = myClaimant; }
private void NewPatientBtnClick(object sender, EventArgs e) { this._myClaimant = new tblClaimant(); this._controller = new claimantController(this, _myClaimant); this._controller.Initialize(); this.UpdateForm(); this.claimantDetailsGroupBox.Text = @"Enter a new Claimant"; this.rateComboBox.Text = @"P"; this.rateComboBox.Focus(); }
private void SearchFieldTextBoxTextChanged(object sender, EventArgs e) { _myClaimant = null; searchTimer.Stop(); searchTimer.Start(); this.searchResultProgressBar.Value = 0; }
private void UpdateClaimantDetails() { var foo = (tblClaimant)this.displayGridView.GetFocusedRow(); if (foo != null) { _myClaimant = foo; _controller = new claimantController(this, _myClaimant); _controller.Initialize(); this.UpdateForm(); this.claimantDetailsGroupBox.Text = this._controller.EditCopyClaimant.FirstNames + @" " + this._controller.EditCopyClaimant.LastName; } }