private void journalReportViewForm_Load(object sender, EventArgs e)
{
var newDatePickerDialog = new dateIntervalDialog();
var newConnection = new dbContextDataContext();
newDatePickerDialog.ShowDialog();
if (newDatePickerDialog.DialogResult == DialogResult.OK)
{
journalReportGridControl.DataSource = from p in newConnection.tblTransactions
join c in newConnection.tblClaimants
on p.ClaimantID equals c.ClaimantID
where p.TranDate >= newDatePickerDialog.startDate & p.TranDate <= newDatePickerDialog.endDate
select new
{
Date = p.TranDate,
Claimant = c.FirstNames + " " + c.LastName,
InvoiceNo = p.InvoiceNo,
Type = p.TranType,
Physio = p.PhysioID,
Narrative = p.Narrative,
Amount = p.TranAmount
};
newDatePickerDialog.Dispose();
}
else
{
newDatePickerDialog.Dispose();
this.Close();
}
}
private void invoiceDetailsBtn_Click(object sender, EventArgs e)
{
if ((getClaimantInvoicesResult)claimantInvoicesView.GetFocusedRow() != null)
{
var currentRow = (getClaimantInvoicesResult)claimantInvoicesView.GetFocusedRow();
var newConnection = new dbContextDataContext();
var currentInvoice = newConnection.tblInvoices.Where(i => i.InvoiceNo == currentRow.InvoiceNo).SingleOrDefault();
if (currentInvoice != null)
{
var viewInvoice = new Accounting.Invoice.newInvoiceForm(currentInvoice);
viewInvoice.ShowDialog();
if (viewInvoice.DialogResult == DialogResult.OK)
{
updateForm();
}
}
else
{
MessageBox.Show("Data corrupt, can not retrieve invoice.");
}
}
else
this.DialogResult = DialogResult.Retry;
}
private void patientLinqInstantFeedBackSource_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e)
{
var newConnection = new dbContextDataContext();
e.QueryableSource = newConnection.tblPatients;
e.Tag = newConnection;
}
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 void ApplyChanges()
{
if (DoctorPropertiesChanged())
{
var newConnection = new dbContextDataContext();
try
{
_sourceDoctor = (from p in newConnection.tblRefDoctors
where p.RefDoctor == _sourceDoctor.RefDoctor
select p).SingleOrDefault();
//Null = new doctor
if (_sourceDoctor != null)
{
_sourceDoctor.UpdateDoctor(EditCopyDoctor);
newConnection.SubmitChanges();
}
else
{
_sourceDoctor = new tblRefDoctor();
_sourceDoctor.UpdateDoctor(EditCopyDoctor);
newConnection.tblRefDoctors.InsertOnSubmit(_sourceDoctor);
newConnection.SubmitChanges();
}
}
catch (Exception)
{
MessageBox.Show(@"Database not responding. Please check your connection.");
}
}
}
private void patientInvoiceViewForm_Load(object sender, EventArgs e)
{
var newConnection = new dbContextDataContext();
patientInvoiceGridControl.DataSource = (from p in newConnection.tblTransactions
join t in newConnection.tblPatients
on p.PatientID equals t.PatientID
where p.PatientID == 10834
select p).Distinct();
}
public addCreditViewForm(Db.Credit MyCredit)
{
InitializeComponent();
myCredit = MyCredit;
var claimant = new dbContextDataContext().tblClaimants.Where(c => c.ClaimantID == myCredit.ClaimantID).FirstOrDefault();
if (claimant != null)
{
myClaimant = claimant;
}
updateDetails();
}
private void claimantLinqInstantFeedbackSource_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e)
{
try
{
var newConnection = new dbContextDataContext();
newConnection.ObjectTrackingEnabled = false;
e.QueryableSource = newConnection.tblClaimants;
e.Tag = newConnection;
}
catch (Exception)
{
MessageBox.Show("here");
}
}
void updateAppointments(int ID)
{
Cursor.Current = Cursors.WaitCursor;
var newConnection = new dbContextDataContext();
if (futureDateCheckEdit.Checked == false)
{
this.appointmentsGridControl.DataSource = from a in newConnection.PatientAppointments
where (a.PatientID == ID)
from r in newConnection.tblRates
where r.RateID == a.RateID
from p in newConnection.tblPatients
where p.PatientID == a.PatientID
select new AnonAppointments
{
ID = p.PatientID,
AppointmentID = a.UniqueID,
Name = p.FirstNames + @" " + p.LastName,
DOB = p.BirthDate,
Physio = a.PhysioID,
Rate = r.RateDesc,
Date = a.StartDate.Value.Date,
Start = a.StartDate.Value.ToShortTimeString(),
End = a.EndDate.Value.ToShortTimeString()
};
}
else
{
this.appointmentsGridControl.DataSource = from a in newConnection.PatientAppointments
where (a.PatientID == ID) && (a.StartDate > System.DateTime.Today)
from r in newConnection.tblRates
where r.RateID == a.RateID
from p in newConnection.tblPatients
where p.PatientID == a.PatientID
select new AnonAppointments
{
ID = p.PatientID,
AppointmentID = a.UniqueID,
Name = p.FirstNames + @" " + p.LastName,
DOB = p.BirthDate,
Physio = a.PhysioID,
Rate = r.RateDesc,
Date = a.StartDate.Value.Date,
Start = a.StartDate.Value.ToShortTimeString(),
End = a.EndDate.Value.ToShortTimeString()
};
}
Cursor.Current = Cursors.Default;
}
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;
}
private void patientInvoiceView_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
var newTransaction = (tblTransaction)this.patientInvoiceView.GetFocusedRow();
var newConnection = new dbContextDataContext();
var currentInvoice = newConnection.tblInvoices.SingleOrDefault(od => od.InvoiceNo == newTransaction.InvoiceNo);
if (currentInvoice != null)
{
myInvoice = currentInvoice;
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("This invoice was not found.");
this.DialogResult = DialogResult.Retry;
}
}
private void checkOutBtn_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
var currentRow = (AnonWaitingRoom)waitingRoomGridView.GetFocusedRow();
var newConnection = new dbContextDataContext();
var formOpen = false;
if (currentRow != null)
{
var thisApp = newConnection.PatientAppointments.Where(a => a.UniqueID == currentRow.AppointmentID).FirstOrDefault();
foreach (var f in Application.OpenForms)
{
if (f.GetType() == typeof(appointmentViewForm))
{
thisApp.CheckOut = true;
thisApp.Label = 2;
newConnection.SubmitChanges();
((appointmentViewForm)f).RefreshAppointment(thisApp.UniqueID);
formOpen = true;
}
}
if (formOpen == false)
{
thisApp.CheckOut = true;
thisApp.Label = 2;
newConnection.SubmitChanges();
}
updateWaitingRoom();
}
else
{
MessageBox.Show("Please Select a Patient first!");
}
Cursor.Current = Cursors.Default;
}
catch (Exception)
{
MessageBox.Show("Data changed. Waiting room will be reloaded. Please try again.");
}
}
private void referralDocBgWorker_DoWork(object sender, DoWorkEventArgs e)
{
var newConnection = new dbContextDataContext();
try
{
_formIQueryable = (from p in newConnection.tblRefDoctors
where (p.RefDFNames + " " + p.RefDName).Contains(searchFieldTextBox.Text)
select p).Take(10).ToList();
searchTimer.Stop();
}
catch(Exception)
{
MessageBox.Show("Database not responding. Please check your connection.");
}
}
private void receiptsByPhysioRateForm_Load(object sender, EventArgs e)
{
var newDatePickerDialog = new dateIntervalDialog();
var newConnection = new dbContextDataContext();
newDatePickerDialog.ShowDialog();
if (newDatePickerDialog.DialogResult == DialogResult.OK)
{
receiptsPhysioPivotGrid.DataSource = newConnection.RatesAndItemsSummaryReportFunction(newDatePickerDialog.startDate, newDatePickerDialog.endDate);
newDatePickerDialog.Dispose();
}
else
{
newDatePickerDialog.Dispose();
this.Close();
}
}
public void fillData()
{
Cursor.Current = Cursors.WaitCursor;
var newConnection = new dbContextDataContext();
var cid = new object();
var pid = new object();
if ((myClaimant.ClaimantID == 0) && (myPhysio.UniqueID != 0))
this.agedTrailGridControl.DataSource = newConnection.getAgedTrailBalance(null, myPhysio.PhysioID, startDate, endDate);
else if ((myClaimant.ClaimantID != 0) && (myPhysio.UniqueID == 0))
this.agedTrailGridControl.DataSource = newConnection.getAgedTrailBalance(myClaimant.ClaimantID, null, startDate, endDate);
else if ((myClaimant.ClaimantID == 0) && (myPhysio.UniqueID == 0))
this.agedTrailGridControl.DataSource = newConnection.getAgedTrailBalance(null, null, startDate, endDate);
else
this.agedTrailGridControl.DataSource = newConnection.getAgedTrailBalance(myClaimant.ClaimantID, myPhysio.PhysioID, startDate, endDate);
Cursor.Current = Cursors.Default;
}
public override void okBtn_Click(object sender, EventArgs e)
{
base.okBtn_Click(sender, e);
var newConnection = new dbContextDataContext();
foreach(var c in myCreditList)
{
if(c.CreditCancelled == true)
{
var currentCredit = newConnection.Credits.Where(cr => cr.CreditID == c.CreditID).FirstOrDefault();
if (currentCredit != null)
{
currentCredit.setProperty(c);
}
}
}
newConnection.SubmitChanges();
}
private void deleteUserBtn_Click(object sender, EventArgs e)
{
var newConnection = new dbContextDataContext();
var currentUser = newConnection.tblUsers.Where(od => od.UniqueID == myUser.UniqueID).SingleOrDefault();
if (currentUser != null)
{
newConnection.tblUsers.DeleteOnSubmit(currentUser);
newConnection.SubmitChanges();
userLookUp.Properties.DataSource = newConnection.tblUsers;
myUser = new tblUser();
updateForm();
userLookUp.EditValue = null;
}
else
{
myUser = new tblUser();
updateForm();
userLookUp.EditValue = null;
}
}
private void newPatientStatsViewForm_Load(object sender, EventArgs e)
{
var newDatePickerDialog = new dateIntervalDialog();
var newConnection = new dbContextDataContext();
newDatePickerDialog.ShowDialog();
if (newDatePickerDialog.DialogResult == DialogResult.OK)
{
Start = newDatePickerDialog.startDate;
End = newDatePickerDialog.endDate;
newPatientPivotGridControl.DataSource = newConnection.getNewPatients(Start, End);
newDatePickerDialog.Dispose();
}
else
{
newDatePickerDialog.Dispose();
this.Close();
}
}
void saveToDb()
{
var newConnection = new dbContextDataContext();
var currentUser = newConnection.tblUsers.Where(od => od.UniqueID == myUser.UniqueID).SingleOrDefault();
if (currentUser == null)
{
myUser.UserID = userIDTextEdit.Text;
myUser.Password = passwordTextEdit.Text;
myUser.FirstNames = firstNameTextEdit.Text;
myUser.LastName = lastNameTextEdit.Text;
if (accessLevelComboBoxEdit.Text == "Adminstrator")
{
myUser.UserLevel = 1;
}
if (accessLevelComboBoxEdit.Text == "General User")
{
myUser.UserLevel = 3;
}
newConnection.tblUsers.InsertOnSubmit(myUser);
}
else
{
myUser = newConnection.tblUsers.Where(od => od.UniqueID == myUser.UniqueID).SingleOrDefault();
myUser.UserID = userIDTextEdit.Text;
myUser.Password = passwordTextEdit.Text;
myUser.FirstNames = firstNameTextEdit.Text;
myUser.LastName = lastNameTextEdit.Text;
if (accessLevelComboBoxEdit.Text == "Adminstrator")
{
myUser.UserLevel = 1;
}
if (accessLevelComboBoxEdit.Text == "General User")
{
myUser.UserLevel = 3;
}
}
newConnection.SubmitChanges();
}
private void paymentAuditTrail_Load(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
var newDatePickerDialog = new dateIntervalDialog();
var newConnection = new dbContextDataContext();
newDatePickerDialog.ShowDialog();
if (newDatePickerDialog.DialogResult == DialogResult.OK)
{
Start = newDatePickerDialog.startDate;
End = newDatePickerDialog.endDate;
paymentAuditTrialPivotGridControl.DataSource = newConnection.getPaymentAuditTrial(newDatePickerDialog.startDate, newDatePickerDialog.endDate);
newDatePickerDialog.Dispose();
}
else
{
newDatePickerDialog.Dispose();
this.Close();
}
Cursor.Current = Cursors.Default;
}
private void referralInstantFeedBack_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e)
{
var newConnection = new dbContextDataContext();
e.QueryableSource = newConnection.tblRefDoctors;
e.Tag = newConnection;
}
void applyReceipt()
{
var newConnection = new dbContextDataContext();
myReceipt.ReceiptDate = System.DateTime.Today;
myReceipt.ReceiptAmnt = myPayments.Sum(p => p.PayinAmnt);
myReceipt.UserID = staticProperties.userName;
myReceipt.IsMulti = true;
newConnection.tblReceipts.InsertOnSubmit(myReceipt);
newConnection.SubmitChanges();
foreach (var p in myPayments)
{
p.ReceiptNo = myReceipt.ReceiptNo;
if (p.PayinType == "7")
{
var c = new tblReceiptCreditPatient();
c.ClaimantID = myClaimant.ClaimantID;
c.CreditAmnt = p.PayinAmnt;
c.ReceiptNo = myReceipt.ReceiptNo;
c.ReceiptDate = myReceipt.ReceiptDate;
newConnection.tblReceiptCreditPatients.InsertOnSubmit(c);
}
newConnection.tblPayins.InsertOnSubmit(p);
}
newConnection.SubmitChanges();
}
private void ReferralDocBgWorkerDoWork(object sender, DoWorkEventArgs e)
{
var newConnection = new dbContextDataContext();
try
{
if (!string.IsNullOrEmpty(searchFieldTextBox.Text))
{
_doctorList = (from p in newConnection.tblRefDoctors
where (p.RefDFNames + @" " + p.RefDName + @" " + p.RefProviderNo).Contains(searchFieldTextBox.Text)
select p).Take(30).ToList();
}
else
{
searchResultProgressBar.Value = 0;
loadBarTimer.Stop();
}
searchTimer.Stop();
}
catch (Exception)
{
MessageBox.Show(@"Database not responding. Please check your connection.");
}
}
private void PostCodeBgWorkerDoWork(object sender, DoWorkEventArgs e)
{
try
{
var newConnection = new dbContextDataContext();
_postCodeList = (from p in newConnection.tblPostcodes
where p.Location.Contains(_suburbSearchText)
select p
).Take(10).ToList();
}
catch (Exception)
{
MessageBox.Show(@"Something is wrong with your server, Can not retrieve post code / Suburb Data!");
}
this.postCodeTimer.Stop();
}
void updateForm()
{
var newConnection = new dbContextDataContext();
var unpaidlist =
(from u in newConnection.getUnPaidInvoices(myClaimant.ClaimantID)
select new AnonUnPaidInvoice
{
Balance = u.Balance.GetValueOrDefault(u.InvoiceTotal.Value),
InvoiceDate = u.InvoiceDate.Value,
InvoiceTotal = u.InvoiceTotal.GetValueOrDefault(0.0M),
ReceiptTotal = u.ReceiptTotal.GetValueOrDefault(0.0M),
InvoiceNo = u.InvoiceNo,
ReceiptAmount = 0.0M
}).ToList();
myUnPaidInvoices = new BindingList<AnonUnPaidInvoice>(unpaidlist);
}
private void userViewForm_Load(object sender, EventArgs e)
{
var newConnection = new dbContextDataContext();
userLookUp.Properties.DataSource = newConnection.tblUsers;
userLookUp.Properties.DisplayMember = "UserID";
}
private void invoiceDetailsBtn_Click(object sender, EventArgs e)
{
if ((AnonUnPaidInvoice)multipleReceiptView.GetFocusedRow() != null)
{
var currentRow = (AnonUnPaidInvoice)multipleReceiptView.GetFocusedRow();
Cursor.Current = Cursors.WaitCursor;
var newConnection = new dbContextDataContext();
var currentInvoice = newConnection.tblInvoices.Where(i => i.InvoiceNo == currentRow.InvoiceNo).SingleOrDefault();
if (currentInvoice != null)
{
var newInvoice = new Accounting.Invoice.newInvoiceForm(currentInvoice);
newInvoice.ShowDialog();
if (newInvoice.DialogResult == DialogResult.OK)
updateForm();
newInvoice.Dispose();
}
else
{
MessageBox.Show("Data corrupt, can not retrieve invoice.");
}
}
else
this.DialogResult = DialogResult.Retry;
}
private void addCreditViewForm_Load(object sender, EventArgs e)
{
var newConnection = new dbContextDataContext();
creditTypeLookUpEdit.Properties.DataSource = newConnection.CreditTypes;
}
public override void okBtn_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
base.okBtn_Click(sender, e);
if (this.myUnPaidInvoices.Any() != true)
{
MessageBox.Show("Can not process receipt. This claimant have no unpaid invoices.");
this.DialogResult = DialogResult.Retry;
return;
}
if (this.DialogResult == DialogResult.OK)
{
applyReceipt();
var paidlist = new List<int> { };
var newConnection = new dbContextDataContext();
foreach (var i in myUnPaidInvoices)
{
if(!object.Equals(i.ReceiptAmount, default(decimal)))
{
var ir = new tblInvoiceReceipt();
ir.InvRecAmnt = i.ReceiptAmount;
ir.InvoiceNo = i.InvoiceNo;
ir.ReceiptNo = myReceipt.ReceiptNo;
newConnection.tblInvoiceReceipts.InsertOnSubmit(ir);
}
if ((i.ReceiptAmount + i.ReceiptTotal) == i.InvoiceTotal)
{
paidlist.Add(i.InvoiceNo);
}
}
foreach (var p in paidlist)
{
var inv = newConnection.tblInvoices.Where(i => i.InvoiceNo == p).SingleOrDefault();
if(inv !=null)
inv.InvoicePaid = true;
}
if (myPayments.Sum(p => p.PayinAmnt).Value > myUnPaidInvoices.Sum(u => u.ReceiptAmount))
{
var result = MessageBox.Show("Fund remaining, do you want to save this as a credit?", "OVERPAYMENT",
MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
var newCredit = new Db.Credit();
newCredit.CreditComment = "Overpayment on Receipt #: " + myReceipt.ReceiptNo.ToString();
newCredit.CreditDate = System.DateTime.Today;
newCredit.CreditType = 3;
newCredit.ClaimantID = myClaimant.ClaimantID;
newCredit.CreditCancelled = false;
newCredit.CreditAmount = decimal.Subtract(myPayments.Sum(p => p.PayinAmnt).Value, myUnPaidInvoices.Sum(u => u.ReceiptAmount));
newConnection.Credits.InsertOnSubmit(newCredit);
}
if (result == DialogResult.No)
{
//proceed as normal.
}
if (result == DialogResult.Cancel)
{
this.DialogResult = DialogResult.Retry;
return;
}
}
newConnection.SubmitChanges();
}
Cursor.Current = Cursors.Default;
}
void applyCredit()
{
var newConnection = new dbContextDataContext();
var currentCredit = newConnection.Credits.Where(c => c.CreditID == myCredit.CreditID).FirstOrDefault();
if (currentCredit.IsNullOrDefault())
{
if (myCredit.CreditAmount <= 0)
{
MessageBox.Show("Please enter the Credit Amount.");
this.DialogResult = DialogResult.Retry;
return;
}
if (myCredit.CreditType <= 0)
{
MessageBox.Show("Please select the Credit Type.");
this.DialogResult = DialogResult.Retry;
return;
}
newConnection.Credits.InsertOnSubmit(myCredit);
}
else
{
currentCredit.setProperty(myCredit);
}
newConnection.SubmitChanges();
}
