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