// INSERT ASSESSMENT INTO DB
private void insertVisitAssessment(PatientVisit pv)
{
MySqlConnectionStringBuilder builder = DBConnection.Connect();
MySqlConnection conn = new MySqlConnection(builder.ToString());
String qry = "";
if (thisAssessment is BurnsVisit)
{
BurnsVisit v = thisAssessment as BurnsVisit;
qry = $"INSERT INTO burns_visit VALUES('{v.VisitID}','{v.Purpose}','{v.Description}','{v.Manner}'," +
$"'{v.DiabetesMellitus}','{v.Hypertension}','{v.IHD}','{v.Asthma}','{v.Thyroid}','{v.CVA}','{v.DVT}'," +
$"'{v.Allergy}','{v.Smoking}','{v.Pallor}','{v.Jaundice}','{v.Clubbing}','{v.Pulses}','{v.Cardiovascular}'," +
$"'{v.Respiratory}','{v.Abdominal}','{v.Neurological}','{v.BP}','{v.Pulse}','{v.Temperature}','{v.RBS}'," +
$"'{v.Site}','{v.Size}','{v.Depth}','{v.Exudate}','{v.Circumferential}','{v.PeripheralCirculation}'," +
$"'{pv.id}')";
}
else if (thisAssessment is ChronicUlcerVisit)
{
ChronicUlcerVisit v = thisAssessment as ChronicUlcerVisit;
qry = $"INSERT INTO chronic_ulcer_visit VALUES('{v.VisitID}','{v.Purpose}','{v.DurationOfUlcer}','{v.Treatment}'," +
$"'{v.DiabetesMellitus}','{v.Hypertension}','{v.IHD}','{v.Asthma}','{v.Thyroid}','{v.CVA}','{v.DVT}'," +
$"'{v.Allergy}','{v.Smoking}','{v.Pallor}','{v.Jaundice}','{v.Clubbing}','{v.Pulses}','{v.Cardiovascular}'," +
$"'{v.Respiratory}','{v.Abdominal}','{v.Neurological}','{v.BP}','{v.Pulse}','{v.Temperature}','{v.RBS}'," +
$"'{v.Site}','{v.Size}','{v.Depth}','{v.ExtentOfUndermining}','{v.WoundSurface}','{v.Exudate}','{v.PeriwoundTissue}'," +
$"'{pv.id}')";
}
else if (thisAssessment is DiabeticFootVisit)
{
DiabeticFootVisit v = thisAssessment as DiabeticFootVisit;
qry = $"INSERT INTO diabetic_foot_visit VALUES('{v.VisitID}','{v.Purpose}','{v.DurationOfUlcer}','{v.Treatment}'," +
$"'{v.Claudication}','{v.PainAtRest}','{v.Hypesthesia}','{v.Hyperesthesia}','{v.Paraesthesia}','{v.Dysesthesia}'," +
$"'{v.RadicularPain}','{v.Anhydrosis}','{v.DiabetesMellitus}','{v.Hypertension}','{v.IHD}','{v.Asthma}','{v.Thyroid}','{v.CVA}','{v.DVT}'," +
$"'{v.Allergy}','{v.Smoking}','{v.Pallor}','{v.Jaundice}','{v.Clubbing}','{v.Pulses}','{v.Cardiovascular}'," +
$"'{v.Respiratory}','{v.Abdominal}','{v.Neurological}','{v.BP}','{v.Pulse}','{v.Temperature}','{v.RBS}'," +
$"'{v.Site}','{v.Size}','{v.Depth}','{v.ExtentOfUndermining}','{v.WoundSurface}','{v.Exudate}','{v.PeriwoundTissue}'," +
$"'{v.Callus}','{v.BrittleNail}','{v.HammerToe}','{v.Fissures}','{v.HairGrowth}'," +
$"'{v.CyanosisOfToes}','{v.PallorOfFoot}','{pv.id}')";;
}
MySqlCommand cmd = new MySqlCommand(qry, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
private BurnsVisit createBurnsVisit(VisitAssessment commonVisit)
{
string id = IDManager.getNextBurnsVisitID();
string description = TxtDescription.Text;
string manner = TxtManner.Text;
string circumferential = TxtCircumferential.Text;
string circulation = TxtCirculation.Text;
BurnsVisit visit = new BurnsVisit(description, manner, circumferential, circulation, id,
commonVisit.PatientVisitID, commonVisit.Purpose, commonVisit.DiabetesMellitus, commonVisit.Hypertension,
commonVisit.IHD, commonVisit.Asthma, commonVisit.Thyroid, commonVisit.CVA, commonVisit.DVT,
commonVisit.Allergy, commonVisit.Smoking, commonVisit.Pallor, commonVisit.Jaundice,
commonVisit.Clubbing, commonVisit.Pulses, commonVisit.Cardiovascular, commonVisit.Respiratory,
commonVisit.Abdominal, commonVisit.Neurological, commonVisit.BP, commonVisit.Pulse,
commonVisit.Temperature, commonVisit.RBS, commonVisit.Site, commonVisit.Size, commonVisit.Depth,
commonVisit.Exudate);
return(visit);
}
