Example #1
0
 public ClinicalFindings()
 {
     _id = -1;
     _anesthesiaConcerns = new List<AnesthesiaConcern>();
     _priorAnesthesia = new PriorAnesthesia();
     _cardiacAuscultation = new DropdownValue();
     _pulseQuality = new DropdownValue();
     _respiratoryAuscultation = new DropdownValue();
     _physicalStatusClassification = new DropdownValue();
     _mucousMembraneColor = new DropdownValue();
     _capillaryRefillTime = new DropdownValue();
 }
Example #2
0
 public void SavePriorAnesthesia(PriorAnesthesia priors)
 {
     if (service.UpdatePriorAnesthesia(priors) == 0)
         service.CreatePriorAnesthesia(priors);
 }
Example #3
0
        public int UpdatePriorAnesthesia(PriorAnesthesia priorAnes)
        {
            int returnNum = 0;
            using (SqlConnection conn = new SqlConnection(connString))
            {
                string sql = @"UPDATE dbo.Prior_Anesthesia_To_Patient SET
                            DateOfProblem = @DateOfProblem, Problem = @Problem
                            WHERE
                            PatientId = @PatientId";

                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = priorAnes.PatientId;
                if (priorAnes.DateOfProblem != DateTime.MinValue)
                    cmd.Parameters.Add("@DateOfProblem", SqlDbType.DateTime).Value = priorAnes.DateOfProblem;
                else
                    cmd.Parameters.Add("@DateOfProblem", SqlDbType.DateTime).Value = DBNull.Value;
                cmd.Parameters.Add("@Problem", SqlDbType.NVarChar).Value = priorAnes.Problem;
                try
                {
                    conn.Open();
                    returnNum = cmd.ExecuteNonQuery();
                }
                catch (Exception e)
                {
                    throw e;
                }
                finally
                {
                    conn.Close();
                }
            }
            return returnNum;
        }
Example #4
0
        public void CreatePriorAnesthesia(PriorAnesthesia priorAnes)
        {
            using (SqlConnection conn = new SqlConnection(connString))
            {
                string sql = @"INSERT INTO dbo.Prior_Anesthesia_To_Patient (
                            PatientId, DateOfProblem, Problem
                            ) VALUES (
                            @PatientId, @DateOfProblem, @Problem
                            )";

                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = priorAnes.PatientId;
                if (priorAnes.DateOfProblem != DateTime.MinValue)
                    cmd.Parameters.Add("@DateOfProblem", SqlDbType.DateTime).Value = priorAnes.DateOfProblem;
                else
                    cmd.Parameters.Add("@DateOfProblem", SqlDbType.DateTime).Value = DBNull.Value;
                cmd.Parameters.Add("@Problem", SqlDbType.NVarChar).Value = priorAnes.Problem;
                try
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
                catch (Exception e)
                {
                    throw e;
                }
                finally
                {
                    conn.Close();
                }
            }
        }
Example #5
0
        public PriorAnesthesia GetPriorAnesthesia(int patientId)
        {
            PriorAnesthesia priorAnes = new PriorAnesthesia();
            using (SqlConnection conn = new SqlConnection(connString))
            {
                // Abstract database field names as much as possible in case of field name changes
                string sql = BuildPriorAnesthesiaSQL();
                string from = @"FROM dbo.Prior_Anesthesia_To_Patient AS a";
                string where = @" WHERE a.PatientId = @PatientId ";

                sql = sql + from + where;

                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = patientId;
                try
                {
                    conn.Open();
                    SqlDataReader read = cmd.ExecuteReader();
                    while (read.Read())
                    {
                        // Create a callback for everytime you have to read something from database.
                        // We do this, so we only have to change string values in one place if we change things.
                        priorAnes = new PriorAnesthesiaCallback().ProcessRow(read);
                    }
                }
                catch (Exception e)
                {
                    throw e;
                }
                finally
                {
                    conn.Close();
                }
            }
            return priorAnes;
        }