private void buttonAdd_Click(object sender, EventArgs e)
{
try
{
using (var context = new LorikeetAppEntities())
{
decimal number;
if (textBoxDebit.Text == "" && decimal.TryParse(textBoxCredit.Text, out number))
{
var creditToAdd = new DebitSystem();
creditToAdd.StaffID = this.staffID;
creditToAdd.MemberID = this.memberID;
creditToAdd.Credit = number;
creditToAdd.Debit = 0;
creditToAdd.Details = textBoxDetails.Text;
creditToAdd.Date = DateTime.Now;
decimal?runTotal = 0m;
var runningTotal = (from dc in context.DebitSystems
where dc.MemberID == this.memberID
select dc).ToList();
if (runningTotal.Any())
{
runTotal = runningTotal.Last().RunningTotal + number;
}
else
{
runTotal = number;
}
creditToAdd.RunningTotal = runTotal;
context.DebitSystems.Add(creditToAdd);
context.SaveChanges();
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.DebitCredit, "Credit for member - " + MiscStuff.GetMemberName(memberID) + " of $" + number + " Added", false);
}
else if (textBoxCredit.Text == "" && decimal.TryParse(textBoxDebit.Text, out number))
{
var debitToAdd = new DebitSystem();
debitToAdd.StaffID = this.staffID;
debitToAdd.MemberID = this.memberID;
debitToAdd.Credit = 0;
debitToAdd.Debit = number;
debitToAdd.Details = textBoxDetails.Text;
debitToAdd.Date = DateTime.Now;
decimal?runTotal = 0m;
var runningTotal = (from dc in context.DebitSystems
where dc.MemberID == this.memberID
select dc).ToList();
if (runningTotal.Any())
{
runTotal = runningTotal.Last().RunningTotal - number;
}
else
{
runTotal = 0 - number;
}
debitToAdd.RunningTotal = runTotal;
context.DebitSystems.Add(debitToAdd);
context.SaveChanges();
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.DebitCredit, "Debit for member - " + MiscStuff.GetMemberName(memberID) + " of $" + number + " Added", false);
}
}
}
catch (Exception ex)
{
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Error, Logging.RefreshCodes.None, "Debit / Credit not added - " + ex.Message, false);
MessageBox.Show(MiscStuff.GetAllMessages(ex));
}
textBoxCredit.Text = "";
textBoxDebit.Text = "";
textBoxDetails.Text = "";
this.debitSystemTableAdapter.FillByMemberID(this.lorikeetAppDataSet.DebitSystem, memberID);
}
private void bbiSaveAndClose_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
using (var context = new LorikeetAppEntities())
{
var diagnosisToRemove = (from dtr in context.Diagnosis
where dtr.MemberID == memberID
select dtr).ToList();
if (diagnosisToRemove.Count > 0)
{
foreach (var dtr in diagnosisToRemove)
{
context.Diagnosis.Remove(dtr);
context.SaveChanges();
}
}
foreach (var dta in diagnosisToAdd)
{
Diagnosi diagnosisToAdd = new Diagnosi();
diagnosisToAdd.MemberID = memberID;
diagnosisToAdd.DiagnosisNameID = dta.DiagnosisNameID;
context.Diagnosis.Add(diagnosisToAdd);
context.SaveChanges();
}
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.Diagnosis, MiscStuff.GetMemberName(memberID) + " Diagnosis has been edited", false);
}
}
catch (Exception ex)
{
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Error, Logging.RefreshCodes.None, MiscStuff.GetMemberName(memberID) + " had a problem when editing Diagnosis - Error - " + ex.Message, false);
MessageBox.Show(ex.Message);
}
this.Close();
}
private void bbiDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (editable && noteID != -1)
{
try
{
using (var context = new LorikeetAppEntities())
{
var noteToDelete = (from n in context.Notes
where n.NotesID == noteID
orderby n.Date
select n).DefaultIfEmpty().First();
if (noteToDelete != null)
{
context.Notes.Remove(noteToDelete);
context.SaveChanges();
}
}
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.Notes, "Notes on " + MiscStuff.GetMemberName(memberID) + " have been deleted", false);
}
catch (Exception ex)
{
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Error, Logging.RefreshCodes.None, "Notes on " + MiscStuff.GetMemberName(memberID) + " has not been deleted - Error - " + ex.Message, false);
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Note is not directly Editable");
}
RefreshNotesGrid();
bbiAdd.Enabled = false;
bbiEdit.Enabled = false;
bbiDelete.Enabled = false;
}
private void bbiEdit_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (textBoxAddNote.Text != "")
{
try
{
using (var context = new LorikeetAppEntities())
{
var noteToEdit = (from n in context.Notes
where n.NotesID == noteID
select n).DefaultIfEmpty().First();
if (noteToEdit != null)
{
noteToEdit.Notes = textBoxAddNote.Text;
noteToEdit.Date = dateEditNote.DateTime;
context.SaveChanges();
}
}
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.Notes, "Notes on " + MiscStuff.GetMemberName(memberID) + " has been edited", false);
}
catch (Exception ex)
{
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Error, Logging.RefreshCodes.None, "Notes on " + MiscStuff.GetMemberName(memberID) + " has not been edited - Error - " + ex.Message, false);
MessageBox.Show(ex.Message);
}
RefreshNotesGrid();
textBoxAddNote.Text = "";
bbiAdd.Enabled = false;
bbiEdit.Enabled = false;
bbiDelete.Enabled = false;
}
}
private void bbiAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (textBoxAddNote.Text != "")
{
try
{
using (var context = new LorikeetAppEntities())
{
var noteToAdd = new Note();
noteToAdd.Date = dateEditNote.DateTime;
noteToAdd.Editable = true;
noteToAdd.MemberID = memberID;
noteToAdd.Notes = textBoxAddNote.Text;
noteToAdd.StaffID = this.staffID;
context.Notes.Add(noteToAdd);
context.SaveChanges();
}
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.Notes, "Notes on " + MiscStuff.GetMemberName(memberID) + " has been added", false);
}
catch (Exception ex)
{
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Error, Logging.RefreshCodes.None, "Notes on " + MiscStuff.GetMemberName(memberID) + " has not been added - Error - " + ex.Message, false);
MessageBox.Show(ex.Message);
}
RefreshNotesGrid();
textBoxAddNote.Text = "";
bbiAdd.Enabled = false;
bbiEdit.Enabled = false;
bbiDelete.Enabled = false;
}
}
private void bbiSaveAndClose_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
using (var context = new LorikeetAppEntities())
{
var medicationToRemove = (from dtr in context.Medications
where dtr.MemberID == memberID
select dtr).ToList();
if (medicationToRemove.Count > 0)
{
foreach (var dtr in medicationToRemove)
{
context.Medications.Remove(dtr);
context.SaveChanges();
}
}
foreach (var dta in medicationToAdd)
{
Medication medicationToAdd = new Medication();
medicationToAdd.MemberID = memberID;
medicationToAdd.MedicationNameID = dta.MedicationNameID;
context.Medications.Add(medicationToAdd);
context.SaveChanges();
}
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.Medication, MiscStuff.GetMemberName(memberID) + " Medications have been changed", false);
}
}
catch (Exception ex)
{
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Error, Logging.RefreshCodes.None, MiscStuff.GetMemberName(memberID) + " Medications have not been changed - Error - " + ex.Message, false);
MessageBox.Show(ex.Message);
}
this.Close();
}
