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;
}
