/// <summary>
/// registers the data in the per_details table
/// </summary>
/// <param name="details">object</param>
/// <returns>object</returns>
public static int RegisterDetails(PerDetails details)
{
SqlConnection connection = pchrDB.GetConnection();
try
{
connection.Open();
//insert string
string insertStatement =
"INSERT INTO PER_DETAILS_TBL " +
"(PATIENT_ID, BLOOD_TYPE, ORGAN_DONOR, HIV_STATUS, HEIGHT_INCHES, WEIGHT_LBS) " +
"VALUES (@PatientID, @Type, @Donor, @Status, @Hight, @Weight) ";
SqlCommand insertCommmand = new SqlCommand(insertStatement, connection);
// adds data to the per_details table
insertCommmand.Parameters.AddWithValue("@PatientID", details.IDNumber);
insertCommmand.Parameters.AddWithValue("@Type", details.Type);
insertCommmand.Parameters.AddWithValue("@Donor", Convert.ToBoolean(details.Donor));
insertCommmand.Parameters.AddWithValue("@Status", Convert.ToInt32(details.Hiv));
insertCommmand.Parameters.AddWithValue("@Hight", Convert.ToInt32(details.Hight));
insertCommmand.Parameters.AddWithValue("@Weight", Convert.ToInt32(details.Weight));
insertCommmand.ExecuteNonQuery();
return(details.IDNumber);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
/// <summary>
/// updates the data in the per_details table
/// </summary>
/// <param name="oldDetails">old object</param>
/// <param name="newDetails">new object</param>
public static void UpdateDetails(PerDetails oldDetails,
PerDetails newDetails)
{
SqlConnection connection = pchrDB.GetConnection();
try
{
connection.Open();
// update string
string updateStatement =
"UPDATE PER_DETAILS_TBL SET " +
"BLOOD_TYPE = @NewType, " +
"ORGAN_DONOR = @NewDonor, " +
"HIV_STATUS = @NewStatus, " +
"HEIGHT_INCHES = @NewHeight, " +
"WEIGHT_LBS = @NewWeight " +
"WHERE PATIENT_ID = @oldPatientID " +
"AND BLOOD_TYPE = @oldType " +
"AND ORGAN_DONOR = @oldDonor " +
"AND HIV_STATUS = @oldStatus " +
"AND HEIGHT_INCHES = @oldHeight " +
"AND WEIGHT_LBS = @oldWeight ";
SqlCommand updateCommand =
new SqlCommand(updateStatement, connection);
// updates data in the per_details table
updateCommand.Parameters.AddWithValue("@NewType",
newDetails.Type);
updateCommand.Parameters.AddWithValue("@NewDonor",
newDetails.Donor);
updateCommand.Parameters.AddWithValue("@NewStatus",
newDetails.Hiv);
updateCommand.Parameters.AddWithValue("@NewHeight",
newDetails.Hight);
updateCommand.Parameters.AddWithValue("@NewWeight",
newDetails.Weight);
updateCommand.Parameters.AddWithValue("@oldPatientID",
oldDetails.IDNumber);
updateCommand.Parameters.AddWithValue("@oldType",
oldDetails.Type);
updateCommand.Parameters.AddWithValue("@oldDonor",
oldDetails.Donor);
updateCommand.Parameters.AddWithValue("@oldStatus",
oldDetails.Hiv);
updateCommand.Parameters.AddWithValue("@oldHeight",
oldDetails.Hight);
updateCommand.Parameters.AddWithValue("@oldWeight",
oldDetails.Weight);
updateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
/// <summary>
/// gets the data in the per_details table
/// </summary>
/// <param name="idNumber">patient id</param>
/// <returns></returns>
public static PerDetails GetDetails(int idNumber)
{
SqlConnection connection = pchrDB.GetConnection();
// select string
string selectStatement
= "SELECT PATIENT_ID, BLOOD_TYPE, ORGAN_DONOR, HIV_STATUS, HEIGHT_INCHES, WEIGHT_LBS "
+ "FROM PER_DETAILS_TBL "
+ "WHERE PATIENT_ID = @ID ";
SqlCommand selectCommand =
new SqlCommand(selectStatement, connection);
selectCommand.Parameters.AddWithValue("@ID", idNumber);
try
{
connection.Open();
SqlDataReader custReader =
selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (custReader.Read())
{
PerDetails details = new PerDetails();
//reads data from the per_details table
details.IDNumber = Convert.ToInt32(custReader["PATIENT_ID"]);
details.Type = custReader["BLOOD_TYPE"].ToString();
details.Donor = custReader["ORGAN_DONOR"].ToString();
details.Hiv = Convert.ToInt32(custReader["HIV_STATUS"]);
details.Hight = Convert.ToInt32(custReader["HEIGHT_INCHES"]);
details.Weight = Convert.ToInt32(custReader["WEIGHT_LBS"]);
return(details);
}
else
{
return(null);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
/// <summary>
/// registers the information into the person,primary care, and per_details tables
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void registerButton_Click(object sender, EventArgs e)
{
Person person = new Person();
//construct object and set its values equal to the text boxs
if (Validator.IsPresent(userNameBox) == true)
{
person.UserName = userNameBox.Text;
}
else
{
Validator.Title = "Username";
}
if (Validator.IsPresent(passwordBox) == true)
{
person.Password = passwordBox.Text;
}
else
{
Validator.Title = "Password";
}
if (Validator.IsPresent(confirmBox) == true)
{
person.CnfrmPass = confirmBox.Text;
}
else
{
Validator.Title = "Confirmation";
}
if (Validator.IsPresent(idBox) == true)
{
if (Validator.IsInt32(idBox))
{
person.IdNumber = Convert.ToInt32(idBox.Text);
}
else
{
Validator.Title = "Identity Number";
}
}
else
{
Validator.Title = "Identity Number";
}
if (Validator.IsPresent(initialsBox) == true)
{
person.Initials = initialsBox.Text;
}
else
{
Validator.Title = "Initials";
}
if (Validator.IsPresent(firstNameBox) == true)
{
person.LastName = firstNameBox.Text;
}
else
{
Validator.Title = "First Name";
}
if (Validator.IsPresent(lastNameBox) == true)
{
person.FirstName = lastNameBox.Text;
}
else
{
Validator.Title = "Last Name";
}
person.Date = dateTimePicker1.Text;
if (Validator.IsComboPresent(titleComboBox) == true)
{
person.Title = titleComboBox.Text;
}
else
{
Validator.Title = "Title";
}
if (Validator.IsPresent(idBox) == true)
{
if (Validator.IsInt32(idBox))
{
person.PrimaryID = Convert.ToInt32(primaryCareBox.Text);
}
else
{
Validator.Title = "Primary CareID";
}
}
else
{
Validator.Title = "Primary CareID";
}
if (maleButton.Checked == true)
{
person.Gender = "male";
}
else if (femaleButton.Checked == true)
{
person.Gender = "female";
}
//setting variables that arent yet manipulated by the user blank instead of null
person.WorkPhone = " ";
person.Fax = " ";
person.Email = " ";
person.ContactName = " ";
person.ContactRelation = " ";
person.ContactAddress = " ";
person.ContactState = " ";
person.ContactCity = " ";
person.ContactZip = " ";
person.ContactPhone = " ";
person.ContactMobile = " ";
person.ContactWork = " ";
person.ContactFax = " ";
person.ContactEmail = " ";
person.CareProviderFirst = " ";
person.CareProviderLast = " ";
person.CareProviderMobile = " ";
person.CareProviderWork = " ";
person.CareProviderSpecialty = " ";
//clears the list and then adds new info
string path = System.Environment.GetFolderPath(
System.Environment.SpecialFolder.Personal);
string filename = Path.Combine(path, "Persons.xml");
if (File.Exists(filename))
{
PersonDB.GetPersons().Clear();
PersonDB.GetPersons();
PersonDB.persons.Add(person);
}
else
{
PersonDB.persons.Add(person);
}
//PersonDB.GetPersons().Clear();
//PersonDB.GetPersons();
//PersonDB.persons.Add(person);
if (person.Password != person.CnfrmPass)
{
MessageBox.Show("Passwords do not match");
}
else
{
PersonDB.SavePersons(PersonDB.persons);
}
//creats an object and sets its values so they are not null
PerDetails details = new PerDetails();
details.IDNumber = person.IdNumber;
details.Type = " ";
details.Donor = "false";
details.Hiv = 2;
details.Hight = 0;
details.Weight = 0;
try
{
PersonDB.RegisterPerson(person);
PerDetailsDB.RegisterDetails(details);
PersonDB.RegisterCareProvider(person);
Form newForm2 = new Form2();
newForm2.Show();
this.Close();
}
catch (Exception ex)
{
if (ex.Message.Contains("Cannot insert duplicate key in object"))
{
MessageBox.Show("That identification number is already in use, please choose another.");
}
else if (ex.Message.Contains("Cannot insert duplicate key in object 'dbo.PRIMARY_CARE_TBL'."))
{
MessageBox.Show("That Primary care ID is already in use, please choose another.");
}
}
}
