public People getPersonGeneral(short keyfield) { People p = new People(); using (SqlConnection conn = new SqlConnection(DBConnect.GetSchoolConnStr())) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "uspGetPersonGeneral"; cmd.Parameters.Add("@keyfield", SqlDbType.SmallInt).Value = keyfield; conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //tblAddresses.Adr1, tblAddresses.Adr2, tblAddresses.City, tblAddresses.St, tblAddresses.ZIP p.keyfield = DbUtilities.GetShort(rdr, "KeyField"); p.FirstName = rdr["FirstName"].ToString(); p.LastName = rdr["LastName"].ToString(); p.age = DbUtilities.GetByte(rdr, "age"); p.DOB = DbUtilities.GetNullableDateTime(rdr, "DOB"); p.Gender = rdr["Gender"].ToString(); p.SSN = rdr["SSN"].ToString(); p.PrimaryPhone = rdr["PrimaryPhone"].ToString(); p.SecondaryPhone = rdr["SecondaryPhone"].ToString(); } rdr.NextResult(); if (rdr.HasRows) { while (rdr.Read()) { Addresses a = new Addresses(); a.Adr1 = rdr["adr1"].ToString(); a.Adr2 = rdr["adr2"].ToString(); a.City = rdr["City"].ToString(); a.St = rdr["St"].ToString(); a.ZIP = rdr["ZIP"].ToString(); p.Addresses.Add(a); // professional way //p.Addresses.Add(new Addresses() //{ // Adr1 = rdr["adr1"].ToString(), // Adr2 = rdr["adr2"].ToString(), // City = rdr["city"].ToString(), // St = rdr["St"].ToString(), // ZIP = rdr["ZIP"].ToString() //}); } } } return(p); } }
public People getPersonHealth(short keyfield) { People p = new People(); using (SqlConnection conn = new SqlConnection(DBConnect.GetSchoolConnStr())) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "uspGetPersonHealth"; cmd.Parameters.Add("@keyfield", SqlDbType.SmallInt).Value = keyfield; conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Allergies a = new Allergies(); a.Keyfield = DbUtilities.GetShort(rdr, "KeyField"); a.allergyDescription = rdr["Description"].ToString(); p.Allergies.Add(a); } rdr.NextResult(); if (rdr.HasRows) { while (rdr.Read()) { Insurances i = new Insurances(); i.keyfield = DbUtilities.GetShort(rdr, "keyfield"); i.InsuranceCo = rdr["InsuranceCo"].ToString(); i.PolicyNum = rdr["PolicyNum"].ToString(); i.SubscriberName = rdr["SubscriberName"].ToString(); i.SubscriberNum = rdr["SubscriberNum"].ToString(); i.SubscriberEmployer = rdr["SubscriberEmployer"].ToString(); i.SubscriberJob = rdr["SubscriberJob"].ToString(); i.SubscriberWorkPhone = rdr["SubscriberWorkPhone"].ToString(); p.Insurances.Add(i); } } rdr.NextResult(); if (rdr.HasRows) { while (rdr.Read()) { MedHist mh = new MedHist(); mh.keyfield = DbUtilities.GetShort(rdr, "KeyField"); mh.HealthCondition = DbUtilities.GetByte(rdr, "HealthCondition"); mh.ConditionExplanation = rdr["ConditionExplanation"].ToString(); mh.HealthTreatment = rdr["HealthTreatment"].ToString(); mh.HasAsthma = DbUtilities.GetBool(rdr, "HasAsthma"); mh.HasSinusitis = DbUtilities.GetBool(rdr, "HasSinusitis"); mh.HasBronchitis = DbUtilities.GetBool(rdr, "HasBronchitis"); mh.HasKidneyTrouble = DbUtilities.GetBool(rdr, "HasKidneyTrouble"); mh.HasHeartTrouble = DbUtilities.GetBool(rdr, "HasHeartTrouble"); mh.HasDiabetes = DbUtilities.GetBool(rdr, "HasDiabetes"); mh.HasDizziness = DbUtilities.GetBool(rdr, "HasDizziness"); mh.HasStomachUpset = DbUtilities.GetBool(rdr, "HasStomachUpset"); mh.HasHayFever = DbUtilities.GetBool(rdr, "HasHayFever"); mh.Explanation = rdr["Explanation"].ToString(); mh.PastOperationsOrIllnesses = rdr["PastOperationsOrIllnesses"].ToString(); mh.CurrentMeds = rdr["CurrentMeds"].ToString(); mh.SpecialDietOrNeeds = rdr["SpecialDietOrNeeds"].ToString(); mh.HadChickenPox = DbUtilities.GetBool(rdr, "HadChickenPox"); mh.HadMeasles = DbUtilities.GetBool(rdr, "HadMeasles"); mh.HadMumps = DbUtilities.GetBool(rdr, "HadMumps"); mh.HadWhoopingCough = DbUtilities.GetBool(rdr, "HadWhoopingCough"); mh.OtherChildhoodDiseases = rdr["OtherChildhoodDiseases"].ToString(); mh.DateOfTetanusShot = DbUtilities.GetDateTime(rdr, "DateOfTetanusShot"); mh.FamilyDoctor = rdr["FamilyDoctor"].ToString(); mh.FamilyDoctorPhone = rdr["FamilyDoctorPhone"].ToString(); p.MedHist.Add(mh); } } } return(p); } }