protected void showUserInformation()
{
connect.Open();
SqlCommand cmd = connect.CreateCommand();
//Check if the ID exists in the database:
cmd.CommandText = "select count(*) from registrations where registerId = '" + registerId.Replace("'", "''") + "' ";
int countUser = Convert.ToInt32(cmd.ExecuteScalar());
if (countUser > 0)//if ID exists, countUser = 1
{
//Get first name:
cmd.CommandText = "select register_firstname from [Registrations] where [registerId] = '" + registerId + "' ";
string firstName = cmd.ExecuteScalar().ToString();
//Get last name and add it to the first name:
cmd.CommandText = "select register_lastname from [Registrations] where [registerId] = '" + registerId + "' ";
string lastName = cmd.ExecuteScalar().ToString();
//Get email:
cmd.CommandText = "select register_email from [Registrations] where [registerId] = '" + registerId + "' ";
string email = cmd.ExecuteScalar().ToString();
//Get city:
cmd.CommandText = "select register_city from [Registrations] where [registerId] = '" + registerId + "' ";
string city = cmd.ExecuteScalar().ToString();
//Get state:
cmd.CommandText = "select register_state from [Registrations] where [registerId] = '" + registerId + "' ";
string state = cmd.ExecuteScalar().ToString();
//Get zip code:
cmd.CommandText = "select register_zip from [Registrations] where [registerId] = '" + registerId + "' ";
string zip = cmd.ExecuteScalar().ToString();
//Get address:
cmd.CommandText = "select register_address from [Registrations] where [registerId] = '" + registerId + "' ";
string address = cmd.ExecuteScalar().ToString();
//Get role ID as int:
cmd.CommandText = "select register_roleId from [Registrations] where [registerId] = '" + registerId + "' ";
int int_roleId = Convert.ToInt32(cmd.ExecuteScalar());
string patientOrPhysicianId = "";
//Convert role ID to string:
string role = "";
if (int_roleId == 1)
{
role = "Admin";
}
else if (int_roleId == 2)
{
role = "Physician";
//Get Physician ID:
cmd.CommandText = "select register_physicianId from [Registrations] where [registerId] = '" + registerId + "' ";
patientOrPhysicianId = cmd.ExecuteScalar().ToString();
}
else if (int_roleId == 3)
{
role = "Patient";
//Get patient ID:
cmd.CommandText = "select register_patientId from [Registrations] where [registerId] = '" + registerId + "' ";
patientOrPhysicianId = cmd.ExecuteScalar().ToString();
}
//Get phone:
cmd.CommandText = "select register_phone from [Registrations] where [registerId] = '" + registerId + "' ";
string phone = cmd.ExecuteScalar().ToString();
//Get Country:
cmd.CommandText = "select register_country from [Registrations] where [registerId] = '" + registerId + "' ";
string country = cmd.ExecuteScalar().ToString();
string phoneFormat = "";
if (country.Equals("United States"))
{
phoneFormat = Layouts.phoneFormat(phone);
}
else
{
phoneFormat = phone;
}
//Create an informative message containing all information for the selected user:
lblUserInformation.Text =
"<table>" +
"<tr><td>Name: </td><td>" + firstName + " " + lastName + "</td></tr>" +
"<tr><td>Email: </td><td>" + email + "</td></tr>" +
"<tr><td>Address: </td><td>" + address + "</td></tr>" +
"<tr><td>City: </td><td>" + city + "</td></tr>" +
"<tr><td>State: </td><td>" + state + "</td></tr>" +
"<tr><td>Zip code: </td><td>" + zip + "</td></tr>" +
"<tr><td>Phone#: </td><td>" + phoneFormat + "</td></tr>" +
"<tr><td>Role: </td><td>" + role + "</td></tr>";
if (!string.IsNullOrWhiteSpace(patientOrPhysicianId))
{
if (int_roleId == 3)
{
lblUserInformation.Text += "<tr><td>Patient ID: </td><td>" + patientOrPhysicianId + "</td></tr>";
}
else if (int_roleId == 2)
{
lblUserInformation.Text += "<tr><td>Physician ID: </td><td>" + patientOrPhysicianId + "</td></tr>";
}
}
lblUserInformation.Text += "</table>";
lblUserInformation.Visible = true;
//Copy values to globals:
g_firstName = firstName; g_lastName = lastName; g_email = email; g_city = city; g_state = state;
g_zip = zip; g_address = address; g_phone = phone; g_roleId = int_roleId; g_patientOrPhysicianId = patientOrPhysicianId; g_country = country;
}
else
{
goBack();
}
connect.Close();
}
protected void getCompleteProfileInformation()
{
string newLine = "<br/>";
string col_start = "<td>", col_end = "</td>", row_start = "<tr>", row_end = "</tr>";
connect.Open();
SqlCommand cmd = connect.CreateCommand();
cmd.CommandText = "select userId from Users where loginId = '" + loginId + "' ";
string userId = cmd.ExecuteScalar().ToString();
CompleteProfile completeProfile = new CompleteProfile(userId, userId);
string completeProfileId = completeProfile.Id;
string onDialysis = completeProfile.OnDialysis;
string kidneyDisease = completeProfile.KidneyDisease;
string issueDate = completeProfile.IssueStartDate;
string bloodType = completeProfile.BloodType;
string address = completeProfile.Address + newLine + " " + completeProfile.City + ", " + completeProfile.State + " " + completeProfile.Zip +
"<br/>" + completeProfile.Country;
int counter = 0;
string row = "";
row += row_start + col_start + col_end + col_start + col_end + row_end;
row += row_start + col_start + col_end + col_start + col_end + row_end;
row += row_start + col_start + "Complete Profile Information: " + col_end + row_end;
if (!string.IsNullOrWhiteSpace(onDialysis))
{
row += row_start + col_start + "On dialysis: " + col_end + col_start + onDialysis + col_end + row_end;
}
if (!string.IsNullOrWhiteSpace(kidneyDisease))
{
row += row_start + col_start + "Kidney disease stage: " + col_end + col_start + kidneyDisease + col_end + row_end;
}
if (!string.IsNullOrWhiteSpace(issueDate))
{
row += row_start + col_start + "Health issue started on: " + col_end + col_start + issueDate + col_end + row_end;
}
if (!string.IsNullOrWhiteSpace(bloodType))
{
row += row_start + col_start + "Blood type: " + col_end + col_start + bloodType + col_end + row_end;
}
row += row_start + col_start + "Address: " + col_end + col_start + address + col_end + row_end;
List <Insurance> insurances = completeProfile.Insurances;
if (insurances.Count > 0)
{
row += row_start + col_start + "Insurances: " + col_end + col_start + col_end + row_end;
}
foreach (Insurance ins in insurances)
{
row += row_start + col_start + "Insurance #:" + col_end + col_start + ++counter + col_end + row_end;
row += row_start + col_start + "Member ID:" + col_end + col_start + ins.MemberId + col_end + row_end;
row += row_start + col_start + "Group ID:" + col_end + col_start + ins.GroupId + col_end + row_end;
row += row_start + col_start + "Insurance name: " + col_end + col_start + ins.CompanyName + col_end + row_end;
row += row_start + col_start + "Insurance phone1 : " + col_end + col_start + Layouts.phoneFormat(ins.Phone1) + col_end + row_end;
row += row_start + col_start + "Insurance phone2 : " + col_end + col_start + Layouts.phoneFormat(ins.Phone2) + col_end + row_end;
row += row_start + col_start + "Insurance email: " + col_end + col_start + ins.Email + col_end + row_end;
row += row_start + col_start + "Insurance address: " + col_end + col_start +
ins.Address + newLine + ins.City + ", " + ins.State + " " + ins.Zip + newLine + ins.Country +
col_end + row_end;
}
ArrayList allergies = completeProfile.Allergies;
if (allergies.Count > 0)
{
row += row_start + col_start + "Allergies: " + col_end + col_start + col_end + row_end;
}
counter = 0;
foreach (var a in allergies)
{
row += row_start + col_start + col_end + col_start + ++counter + ". " + a.ToString() + col_end + row_end;
}
ArrayList majorDiagnoses = completeProfile.MajorDiagnoses;
if (majorDiagnoses.Count > 0)
{
row += row_start + col_start + "Major diagnoses: " + col_end + col_start + col_end + row_end;
}
counter = 0;
foreach (var a in majorDiagnoses)
{
row += row_start + col_start + col_end + col_start + ++counter + ". " + a.ToString() + col_end + row_end;
}
ArrayList pastHealthConditions = completeProfile.PastHealthConditions;
if (pastHealthConditions.Count > 0)
{
row += row_start + col_start + "Past health conditions: " + col_end + col_start + col_end + row_end;
}
counter = 0;
foreach (var a in pastHealthConditions)
{
row += row_start + col_start + "" + col_end + col_start + ++counter + ". " + a.ToString() + col_end + row_end;
}
List <EmailObject> emails = completeProfile.Emails;
if (emails.Count > 0)
{
row += row_start + col_start + "Emails: " + col_end + col_start + col_end + row_end;
}
counter = 0;
foreach (EmailObject e in emails)
{
row += row_start + col_start + "" + col_end + col_start + ++counter + ". Email Address: " + e.EmailAddress;
if (e.IsDefault == 1)
{
row += " (default)" + col_end + row_end;
}
else
{
row += col_end + row_end;
}
}
List <Phone> phones = completeProfile.Phones;
if (phones.Count > 0)
{
row += row_start + col_start + "Phone numbers: " + col_end + col_start + col_end + row_end;
}
counter = 0;
foreach (Phone e in phones)
{
row += row_start + col_start + "" + col_end + col_start + ++counter + ". Phone number: " + Layouts.phoneFormat(e.PhoneNumber);
if (e.IsDefault == 1)
{
row += " (default)" + col_end + row_end;
}
else
{
row += col_end + row_end;
}
}
List <EmergencyContact> emergnecyContacts = completeProfile.EmergencyContacts;
if (emergnecyContacts.Count > 0)
{
row += row_start + col_start + "Emergency contacts: " + col_end + col_start + col_end + row_end;
}
counter = 0;
foreach (EmergencyContact e in emergnecyContacts)
{
row += row_start + col_start + "Contact #:" + col_end + col_start + ++counter + col_end + row_end;
row += row_start + col_start + "Name: " + col_end + col_start + e.Firstname + " " + e.Lastname + col_end + row_end;
row += row_start + col_start + "Phone 1: " + col_end + col_start + Layouts.phoneFormat(e.Phone1) + col_end + row_end;
row += row_start + col_start + "Phone 2: " + col_end + col_start + Layouts.phoneFormat(e.Phone2) + col_end + row_end;
row += row_start + col_start + "Phone 3: " + col_end + col_start + Layouts.phoneFormat(e.Phone3) + col_end + row_end;
row += row_start + col_start + "Email: " + col_end + col_start + e.Email + col_end + row_end;
row += row_start + col_start + "Address: " + col_end + col_start +
e.Address + newLine + e.City + ", " + e.State + " " + e.Zip + newLine + e.Country +
col_end + row_end;
}
List <PastPatientID> pastPatientIds = completeProfile.PastPatientIds;
if (pastPatientIds.Count > 0)
{
row += row_start + col_start + "Past patient IDs: " + col_end + col_start + col_end + row_end;
}
counter = 0;
int treatment_count = 0;
foreach (PastPatientID p in pastPatientIds)
{
//row += row_start + col_start + "" + col_end + col_start + "" + col_end + row_end;
row += row_start + col_start + "Medical Record Number: " + col_end + col_start + p.MRN + col_end + row_end;
List <Treatment> treatments = completeProfile.Treatments;
string str_treatments = "";
if (treatments.Count > 0)
{
str_treatments = "Treatments: " + newLine;
}
foreach (Treatment t in treatments)
{
if (t.PastPatientId.Equals(p.ID))
{
row += row_start + col_start + "Treatment #: " + col_end + col_start + ++treatment_count + col_end + row_end;
row += row_start + col_start + "Physician name: " + col_end + col_start + t.PhysicianFirstName + " " + t.PhysicianLastName + col_end + row_end;
row += row_start + col_start + "Treatment started on: " + col_end + col_start + t.StartDate + col_end + row_end;
row += row_start + col_start + "Hospital name: " + col_end + col_start + t.HospitalName + col_end + row_end;
row += row_start + col_start + "Hospital address: " + col_end + col_start +
t.HospitalAddress + newLine +
t.HospitalCity + ", " + t.HospitalState + " " + t.HospitalZip + newLine +
t.HospitalCountry +
col_end + row_end;
}
}
}
lblRow.Text += row;
connect.Close();
}
