public Patient() { _patientId = -1; _patientInfo = new PatientInformation(); _monitoring = new List<Monitoring>(); _bloodwork = new Bloodwork(); _clinicalFindings = new ClinicalFindings(); _anestheticPlan = new AnestheticPlan(); _maintenance = new Maintenance(); }
public Bloodwork GetBloodwork(int patientId) { Bloodwork blood = new Bloodwork(); List<Bloodwork> bloodGroup = service.GetBloodwork(patientId); foreach (Bloodwork b in bloodGroup) { if (b.Albumin != -1) blood.Albumin = b.Albumin; else if (b.ALP != -1) blood.ALP = b.ALP; else if (b.ALT != -1) blood.ALT = b.ALT; else if (b.BUN != -1) blood.BUN = b.BUN; else if (b.Ca != -1) blood.Ca = b.Ca; else if (b.Cl != -1) blood.Cl = b.Cl; else if (b.CREAT != -1) blood.CREAT = b.CREAT; else if (b.Globulin != -1) blood.Globulin = b.Globulin; else if (b.Glucose != -1) blood.Glucose = b.Glucose; else if (b.iCa != -1) blood.iCa = b.iCa; else if (b.K != -1) blood.K = b.K; else if (b.NA != -1) blood.NA = b.NA; else if (b.PCV != -1) blood.PCV = b.PCV; else if (b.TP != -1) blood.TP = b.TP; else if (b.USG != -1) blood.USG = b.USG; else if (b.WBC != -1) blood.WBC = b.WBC; else if (b.OtherType != "" && b.OtherValue != -1) { blood.OtherType = b.OtherType; blood.OtherValue = b.OtherValue; } } return blood; }
public void SaveBloodwork(Bloodwork blood) { service.DeleteBloodwork(blood.PatientId); if (blood.Albumin != -1) //if (service.UpdateBloodwork(blood, "Albumin", blood.Albumin) == 0) service.CreateBloodwork(blood, "Albumin", blood.Albumin); if (blood.ALP != -1) //if (service.UpdateBloodwork(blood, "ALP", blood.ALP) == 0) service.CreateBloodwork(blood, "ALP", blood.ALP); if (blood.ALT != -1) //if (service.UpdateBloodwork(blood, "ALT", blood.ALT) == 0) service.CreateBloodwork(blood, "ALT", blood.ALT); if (blood.BUN != -1) //if (service.UpdateBloodwork(blood, "BUN", blood.BUN) == 0) service.UpdateBloodwork(blood, "BUN", blood.BUN); if (blood.Ca != -1) //if (service.UpdateBloodwork(blood, "Ca", blood.Ca) == 0) service.CreateBloodwork(blood, "Ca", blood.Ca); if (blood.Cl != -1) //if (service.UpdateBloodwork(blood, "Cl", blood.Cl) == 0) service.CreateBloodwork(blood, "Cl", blood.Cl); if (blood.CREAT != -1) if (service.UpdateBloodwork(blood, "CREAT", blood.CREAT) == 0) service.CreateBloodwork(blood, "CREAT", blood.CREAT); if (blood.Globulin != -1) //if (service.UpdateBloodwork(blood, "Globulin", blood.Globulin) == 0) service.CreateBloodwork(blood, "Globulin", blood.Globulin); if (blood.Glucose != -1) //if (service.UpdateBloodwork(blood, "Glucose", blood.Glucose) == 0) service.CreateBloodwork(blood, "Glucose", blood.Glucose); if (blood.iCa != -1) //if (service.UpdateBloodwork(blood, "iCa", blood.iCa) == 0) service.CreateBloodwork(blood, "iCa", blood.iCa); if (blood.K != -1) //if (service.UpdateBloodwork(blood, "K", blood.K) == 0) service.CreateBloodwork(blood, "K", blood.K); if (blood.NA != -1) //if (service.UpdateBloodwork(blood, "NA", blood.NA) == 0) service.CreateBloodwork(blood, "NA", blood.NA); if (blood.PCV != -1) //if (service.UpdateBloodwork(blood, "PCV", blood.PCV) == 0) service.CreateBloodwork(blood, "PCV", blood.PCV); if (blood.TP != -1) //if (service.UpdateBloodwork(blood, "TP", blood.TP) == 0) service.CreateBloodwork(blood, "TP", blood.TP); if (blood.USG != -1) //if (service.UpdateBloodwork(blood, "USG", blood.USG) == 0) service.CreateBloodwork(blood, "USG", blood.USG); if (blood.WBC != -1) //if (service.UpdateBloodwork(blood, "WBC", blood.WBC) == 0) service.CreateBloodwork(blood, "WBC", blood.WBC); if (blood.OtherType != null && blood.OtherValue != -1) //if (service.UpdateBloodwork(blood, blood.OtherType, blood.OtherValue) == 0) service.CreateBloodwork(blood, blood.OtherType, blood.OtherValue); }
public void CreateBloodwork(Bloodwork blood, string bloodworkName, decimal bloodworkValue) { using (SqlConnection conn = new SqlConnection(connString)) { string sql = @"INSERT INTO dbo.Bloodwork_To_Patient ( PatientId, BloodworkName, Value ) VALUES ( @PatientId, @BloodworkName, @Value )"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = blood.PatientId; cmd.Parameters.Add("@BloodworkName", SqlDbType.NVarChar).Value = bloodworkName; cmd.Parameters.Add("@Value", SqlDbType.Decimal).Value = bloodworkValue; try { conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { conn.Close(); } } }
public int UpdateBloodwork(Bloodwork blood, string bloodworkName, decimal bloodworkValue) { int returnNum = 0; using (SqlConnection conn = new SqlConnection(connString)) { string sql = @"UPDATE dbo.Bloodwork_To_Patient SET BloodworkName = @BloodworkName, Value = @Value WHERE PatientId = @PatientId"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = blood.Id; cmd.Parameters.Add("@BloodworkName", SqlDbType.NVarChar).Value = bloodworkName; cmd.Parameters.Add("@Value", SqlDbType.Decimal).Value = bloodworkValue; try { conn.Open(); returnNum = cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { conn.Close(); } } return returnNum; }