Ejemplo n.º 1
0
 //constructor with parameters
 public Case(  //string caseID,
     IndivAtRisk indiv, CareGiver careGiver, PersonOfInterest personOfInterest, SocialWorker socialWorker,
     CaseHistory caseHistory)
 {
     // caseID = _caseID;
     indiv            = _indiv;
     careGiver        = _careGiver;
     personOfInterest = _personOfInterest;
     socialWorker     = _socialWorker;
     caseHistory      = _caseHistory;
 }
Ejemplo n.º 2
0
        //4)Once a case is chosen, this will load the data from the Persons table and data from the IndividualAtRisk table and loads it into the Care Giver tab on the
        //Case View form.
        public CareGiver RetrieveCareGiverData(int indivId)
        {
            var giver = new CareGiver();

            sqlConnection1 = InitializeConnectionString();

            using (sqlConnection1)
            {
                string data = "Select * from Persons, CareGiver, IndividualAtRisk where IndividualAtRisk.IndivId = '" + indivId + "' AND IndividualAtRisk.IndivId = CareGiver.IndivId AND Caregiver.PersonId = Persons.PersonId";
                System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(data, sqlConnection1);
                sqlConnection1.Open();
                using (SqlDataReader read = cmd.ExecuteReader())
                {
                    while (read.Read())
                    {

                        giver.personId = read["PersonId"].ToString();
                        giver.lastName = read["Last_Name"].ToString();
                        giver.firstName = read["First_Name"].ToString();
                        giver.gender = read["Gender"].ToString();
                        giver.race = read["Race"].ToString();
                        giver.dob = read["DOB"].ToString();
                        giver.ssn = read["SSN"].ToString();
                        giver.milDependent = read["Military_Dependent"].ToString();
                        giver.churchConnection = read["Church_Connections"].ToString();
                        giver.streetAddress = read["Street_Address"].ToString();
                        giver.apartment = read["Apartment_Number"].ToString();
                        giver.city = read["City"].ToString();
                        giver.state = read["State"].ToString();
                        giver.zip = read["Zip_Code"].ToString();
                        giver.email = read["Email"].ToString();
                        giver.homePhone = read["Telephone_Home"].ToString();
                        giver.mobilePhone = read["Telephone_Mobile"].ToString();
                        giver.workPhone = read["Telephone_Work"].ToString();
                        giver.type = read["Person_Type"].ToString();
                        giver.relationship = read["Relationship"].ToString();
                    }
                }
            }
            sqlConnection1.Close();
            return giver;
        }
Ejemplo n.º 3
0
        //12)This will pull the individual id in the case so a care giver id can be created in the care giver table.
        public CareGiver CareIndivId()
        {
            var care = new CareGiver();

            sqlConnection1 = InitializeConnectionString();

            using (sqlConnection1)
            {
                string data = "Select IndivId, Last_Value(IndivId) Over (Partition By IndivId Order By IndivId) from IndividualAtRisk";
                System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(data, sqlConnection1);
                sqlConnection1.Open();
                using (SqlDataReader read = cmd.ExecuteReader())
                {
                    while (read.Read())
                    {
                        care.indivId = read["IndivId"].ToString();
                    }
                }
            }
            sqlConnection1.Close();
            return care;
        }