private void simpleButtonDiagnosisAdd_Click(object sender, EventArgs e)
{
if (textBoxDiagnosis.Text.Count() > 0)
{
try
{
using (var context = new LorikeetAppEntities())
{
if (textBoxDiagnosis.Text != "")
{
var diagnosisToAdd = new DiagnosisName();
diagnosisToAdd.DiagnosisName1 = textBoxDiagnosis.Text;
context.DiagnosisNames.Add(diagnosisToAdd);
context.SaveChanges();
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Broadcast, Logging.RefreshCodes.Diagnosis, "Diagnosis Name - " + textBoxDiagnosis.Text + " was added", false);
RefreshListBoxes();
}
}
}
catch (Exception ex)
{
Logging.AddLogEntry(staffID, Logging.ErrorCodes.Error, Logging.RefreshCodes.None, "Diagnosis Name - " + textBoxDiagnosis.Text + " was not added - Error - " + ex.Message, false);
MessageBox.Show(ex.Message);
}
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
try
{
using (var context = new LorikeetAppEntities())
{
if (listBoxDiagnosis.SelectedIndex != -1)
{
var diagnosisToRemove = listBoxDiagnosis.SelectedItem.ToString();
DiagnosisName diagnosisTemp = (from d in context.DiagnosisNames
where d.DiagnosisName1 == diagnosisToRemove
select d).DefaultIfEmpty().First();
if (diagnosisTemp != null)
{
diagnosisToAdd.Add(diagnosisTemp);
diagnosis.RemoveAt(listBoxDiagnosis.SelectedIndex);
RefreshDiagnosis();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void bbiConvert_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DialogResult dr = MessageBox.Show("This will Delete all Member Details in Database. Is this OK?", "WARNING", MessageBoxButtons.YesNo);
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
if (dr == DialogResult.Yes)
{
try
{
using (var context = new LorikeetAppEntities())
{
var membersToRemove = (from m in context.Members
select m).ToList();
var contactToRemove = (from c in context.Contacts
select c).ToList();
var diagnosisToRemove = (from d in context.Diagnosis
select d).ToList();
var diagnosisNamesToRemove = (from dn in context.DiagnosisNames
select dn).ToList();
if (contactToRemove.Any())
{
context.Contacts.RemoveRange(contactToRemove);
context.SaveChanges();
listViewImport.Items.Add("Removed all Contacts", 0);
}
if (diagnosisNamesToRemove.Any())
{
context.DiagnosisNames.RemoveRange(diagnosisNamesToRemove);
context.SaveChanges();
listViewImport.Items.Add("Removed all Diagnosis Names", 0);
}
if (diagnosisToRemove.Any())
{
context.Diagnosis.RemoveRange(diagnosisToRemove);
context.SaveChanges();
listViewImport.Items.Add("Removed all Diagnosis", 0);
}
if (membersToRemove.Any())
{
context.Members.RemoveRange(membersToRemove);
context.SaveChanges();
listViewImport.Items.Add("Removed all Members", 0);
}
}
}
catch (Exception ex)
{
listViewImport.Items.Add("Couldn't wipe Database - Error - " + ex.Message, 2);
SplashScreenManager.CloseForm();
return;
}
SplashScreenManager.CloseForm();
try
{
using (var connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + newFileDirectory + ";Jet OLEDB:Database Password="******";"))
{
connection.Open();
var countquery = "SELECT * FROM [Membership Details]";
var query = "SELECT * FROM [Membership Details] ORDER BY [Membership No]";
var commandCount = new OleDbCommand(countquery, connection);
var readercount = commandCount.ExecuteReader();
while (readercount.Read())
{
maxRowCount++;
}
var progressForm = new FormProgress(maxRowCount);
progressForm.Show();
var command = new OleDbCommand(query, connection);
var reader = command.ExecuteReader();
using (var context = new LorikeetAppEntities())
{
using (var hunspell = new Hunspell("en_us.aff", "en_us.dic"))
{
hunspell.Add("OCD");
hunspell.Add("PTSD");
hunspell.Add("OCD");
hunspell.Add("Cognative");
hunspell.Add("Psychosis");
hunspell.Add("BPAD");
hunspell.Add("BPD");
hunspell.Add("Traumatic");
while (reader.Read())
{
var memberToAdd = new Member();
if (reader["First Name"].ToString().Equals("") && reader["Surname"].ToString().Equals(""))
{
errorRowCount++;
listViewImport.Items.Add("Cannot add Member Number " + reader["Membership No"], 2);
}
else
{
if (reader["Diagnosis"].ToString().Trim().ToLower().Equals("agency"))
{
memberToAdd.Agency = true;
}
else
{
memberToAdd.Agency = false;
}
memberToAdd.FirstName = reader["First Name"].ToString();
memberToAdd.Surname = reader["Surname"].ToString();
memberToAdd.Aboriginal = false;
memberToAdd.Archived = (bool)reader["Archived"];
memberToAdd.BirthdayCard = (bool)reader["Birthday Card"];
memberToAdd.Country = "";
memberToAdd.CountryOfOrigin = "";
memberToAdd.DateAltered = DateTime.Today;
DateTime memberJoinedDate;
if (DateTime.TryParse(reader["When member joined"].ToString(), out memberJoinedDate))
{
memberToAdd.DateJoined = memberJoinedDate;
}
else
{
memberToAdd.DateJoined = DateTime.Today;
}
DateTime tempDOB;
string tempDateOfBirth = reader["DOB"].ToString();
string[] formats = { "dd-MM-yy", "dd-M-yy", "dd-M-yyyy", "d-MM-yy", "d-MM-yyyy", "d-M-yyyy", "dd-MMM-yyyy", "dd/MM/yy", "dd/M/yy", "dd/M/yyyy", "d/MM/yy", "d/MM/yyyy", "d/M/yyyy", "dd MMM yyyy", "dd.MM.yy", "d MMM yyyy", "d MMM yy", "d MMMM yyyy", " d MMMM yy", "d-MMM-yyyy", "d/M/yy", "d/M/yyyy" };
if (DateTime.TryParseExact(tempDateOfBirth, formats, new CultureInfo("en-AU"), DateTimeStyles.None, out tempDOB))
{
memberToAdd.DateOfBirth = tempDOB;
}
else
{
memberToAdd.DateOfBirth = null;
}
memberToAdd.EmailAddress = reader["email"].ToString();
memberToAdd.MemberID = (int)reader["Membership No"];
memberToAdd.MobileNumber = reader["MobilePhone"].ToString();
memberToAdd.PostCode = reader["Postcode"].ToString();
int postCode = 6000;
if (int.TryParse(reader["Postcode"].ToString(), out postCode))
{
if (postCode >= 1000 && postCode < 3000)
{
memberToAdd.State = "New South Wales";
memberToAdd.Country = "Australia";
}
else if ((postCode >= 200 && postCode < 300) || (postCode >= 2600 && postCode < 3000))
{
memberToAdd.State = "ACT";
memberToAdd.Country = "Australia";
}
else if ((postCode >= 3000 && postCode < 4000) || (postCode >= 8000 && postCode < 9000))
{
memberToAdd.State = "Victoria";
memberToAdd.Country = "Australia";
}
else if ((postCode >= 4000 && postCode < 5000) || (postCode >= 9000 && postCode < 10000))
{
memberToAdd.State = "Queensland";
memberToAdd.Country = "Australia";
}
else if (postCode >= 5000 && postCode < 6000)
{
memberToAdd.State = "South Australia";
memberToAdd.Country = "Australia";
}
else if (postCode >= 6000 && postCode < 7000)
{
memberToAdd.State = "Western Australia";
memberToAdd.Country = "Australia";
}
else if (postCode >= 7000 && postCode < 8000)
{
memberToAdd.State = "Tasmania";
memberToAdd.Country = "Australia";
}
else if (postCode >= 800 && postCode < 1000)
{
memberToAdd.State = "Northern Territory";
memberToAdd.Country = "Australia";
}
}
memberToAdd.ReceiveByMail = (bool)reader["Email Newsletter"];
memberToAdd.ReceiveNewsletter = (bool)reader["Newsletter"];
if (reader["Gender"].ToString().ToLower() == "m")
{
memberToAdd.Sex = true;
}
else
{
memberToAdd.Sex = false;
}
memberToAdd.State = "";
memberToAdd.StreetAddress = reader["Street Address"].ToString();
memberToAdd.Suburb = reader["Suburb"].ToString();
memberToAdd.TelephoneNumber = reader["Phone Number"].ToString();
memberToAdd.Studying = false;
memberToAdd.Volunteering = false;
memberToAdd.Working = false;
context.Members.Add(memberToAdd);
context.SaveChanges();
if (!reader["Emergency Contact"].ToString().Equals("") && !reader["Emergency Phone"].ToString().Equals("") && !reader["Emergency Relationship"].ToString().Equals(""))
{
var contactToAdd = new Contact();
contactToAdd.MemberID = (int)reader["Membership No"];
contactToAdd.ContactAddress = "";
contactToAdd.ContactName = reader["Emergency Contact"].ToString();
contactToAdd.ContactPhone = reader["Emergency Phone"].ToString();
contactToAdd.ContactType = "Emergency - " + reader["Emergency Relationship"].ToString();
context.Contacts.Add(contactToAdd);
context.SaveChanges();
}
var contactToAdd2 = new Contact();
contactToAdd2.MemberID = (int)reader["Membership No"];
if (!(reader["HCareAddress"].ToString().Trim().Equals("") && reader["HCareSuburb"].ToString().Trim().Equals("") && reader["HCareState"].ToString().Trim().Equals("") && reader["HealthCareProvider"].ToString().Trim().Equals("") && reader["GPName"].ToString().Trim().Equals("") && reader["HCarePhone"].ToString().Trim().Equals("")))
{
contactToAdd2.ContactAddress = (reader["HCareAddress"].ToString() + ", " + reader["HCareSuburb"].ToString() + ", " + reader["HCareState"].ToString()).Trim(',');
contactToAdd2.ContactName = (reader["HealthCareProvider"].ToString() + ", " + reader["GPName"].ToString()).Trim(',');
contactToAdd2.ContactPhone = reader["HCarePhone"].ToString();
contactToAdd2.ContactType = "Health Care Provider";
context.Contacts.Add(contactToAdd2);
context.SaveChanges();
}
String diagnosis = reader["Diagnosis"].ToString().Trim();
if (!diagnosis.ToLower().Trim().Equals("agency") && !diagnosis.Trim().Equals(""))
{
if (diagnosis.Contains("x"))
{
diagnosis = diagnosis.Replace("X", "");
}
diagnosis = diagnosis.ToLower().Trim();
if (diagnosis.Contains("?"))
{
diagnosis.Replace("?", "");
}
if (diagnosis.Contains("n/a"))
{
diagnosis = diagnosis.Replace("n/a", "");
}
if (diagnosis.Contains("archive box 1"))
{
diagnosis = diagnosis.Replace("archive box 1", "");
}
if (diagnosis.Contains("archived 2014"))
{
diagnosis = diagnosis.Replace("archived 2014", "");
}
if (diagnosis.Contains("archive"))
{
diagnosis = diagnosis.Replace("archive", "");
}
if (diagnosis.Contains("and"))
{
diagnosis = diagnosis.Replace(" and ", ",");
}
if (diagnosis.Contains("="))
{
diagnosis = diagnosis.Replace("=", "-");
}
if (diagnosis.Contains("/"))
{
diagnosis = diagnosis.Replace("/", ",");
}
if (diagnosis.Contains("."))
{
diagnosis = diagnosis.Replace(".", "");
}
if (diagnosis.Contains("with"))
{
diagnosis = diagnosis.Replace("with", ",");
}
if (diagnosis.Contains("***"))
{
diagnosis = diagnosis.Replace("***", "");
}
if (!diagnosis.Trim().Equals("") && diagnosis.Trim().Count() > 2)
{
string[] diagnosisSplit = diagnosis.Split(',');
foreach (var d in diagnosisSplit)
{
string tempString = "";
var sTemp = d.Trim();
string[] stringSplit = sTemp.Split(' ');
if (stringSplit.Count() > 1)
{
foreach (var sp in stringSplit)
{
if (!sp.Equals(""))
{
if (hunspell.Spell(sp))
{
tempString = tempString + " " + sp;
}
else
{
tempString = tempString + " " + hunspell.Suggest(sp)[0];
}
}
}
}
else
{
if (!d.Equals(""))
{
if (hunspell.Spell(d))
{
tempString = d;
}
else
{
tempString = hunspell.Suggest(d)[0];
}
}
}
if (!tempString.Trim().Equals(""))
{
tempString = tempString.Trim();
var diagnosisNames = (from dn in context.DiagnosisNames
where tempString.Contains(dn.DiagnosisName1)
select dn).DefaultIfEmpty().First();
var diagnosisNameToAdd = new DiagnosisName();
if (diagnosisNames == null)
{
diagnosisNameToAdd.DiagnosisName1 = tempString;
context.DiagnosisNames.Add(diagnosisNameToAdd);
context.SaveChanges();
var diagnosisToAdd = new Diagnosi();
diagnosisToAdd.DiagnosisNameID = diagnosisNameToAdd.DiagnosisNameID;
diagnosisToAdd.MemberID = (int)reader["Membership No"];
context.Diagnosis.Add(diagnosisToAdd);
context.SaveChanges();
}
else
{
var diagnosisName = (from dn in context.DiagnosisNames
where tempString.Contains(dn.DiagnosisName1)
select dn).DefaultIfEmpty().First();
if (diagnosisName != null)
{
var diagnosisToAdd = new Diagnosi();
diagnosisToAdd.DiagnosisNameID = diagnosisName.DiagnosisNameID;
diagnosisToAdd.MemberID = (int)reader["Membership No"];
context.Diagnosis.Add(diagnosisToAdd);
context.SaveChanges();
}
}
}
}
}
}
rowCount++;
progressForm.StepProgress();
}
}
listViewImport.Items.Add("Out of a total " + maxRowCount + " " + (rowCount - errorRowCount) + " Members were added", 0);
listViewImport.Items.Add("There were " + errorRowCount + " errors in rows which were not added", 1);
}
progressForm.Hide();
connection.Close();
}
}
}
catch (Exception ex)
{
listViewImport.Items.Add("Error - " + ex.Message, 2);
MessageBox.Show(MiscStuff.GetAllMessages(ex));
}
}
bbiConvert.Enabled = false;
}
private void simpleButtonMergeDiagnosis_Click(object sender, EventArgs e)
{
var itemsSelected = listBoxDiagnosis.SelectedItems;
if (itemsSelected.Count > 1)
{
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
try
{
using (var context = new LorikeetAppEntities())
{
var dr = new DialogResult();
var form = new FormInput();
dr = form.ShowDialog();
if (dr == DialogResult.OK)
{
var diagnosisToAdd = new DiagnosisName();
diagnosisToAdd.DiagnosisName1 = form.inputText;
context.DiagnosisNames.Add(diagnosisToAdd);
context.SaveChanges();
int i = diagnosisToAdd.DiagnosisNameID;
for (int x = 0; x < itemsSelected.Count - 1; x++)
{
string diagnosisString = itemsSelected[x].ToString();
var diagnosisToUpdate = (from d in context.Diagnosis
join dn in context.DiagnosisNames on d.DiagnosisNameID equals dn.DiagnosisNameID
where dn.DiagnosisName1 == diagnosisString
select d).ToList();
if (diagnosisToUpdate.Any())
{
foreach (var dtu in diagnosisToUpdate)
{
dtu.DiagnosisNameID = i;
context.SaveChanges();
}
}
}
foreach (var item in itemsSelected)
{
string itemString = item.ToString();
var diagnosisNamesToRemove = (from dn in context.DiagnosisNames
where dn.DiagnosisName1 == itemString
select dn).ToList();
if (diagnosisNamesToRemove.Any())
{
foreach (var dmtr in diagnosisNamesToRemove)
{
context.DiagnosisNames.Remove(dmtr);
}
context.SaveChanges();
}
}
}
else
{
return;
}
}
}
catch (Exception ex)
{
MessageBox.Show(MiscStuff.GetAllMessages(ex));
}
SplashScreenManager.CloseForm();
}
else
{
MessageBox.Show("You must select at least 2 items");
}
RefreshListBoxes();
}
