public static Dosage getDosage(int id)
{
long m = -1, n = -1, e = -1;
string reco = null,medname = null;
long mid = -1;
using (SQLiteConnection conn = getConnection())
{
conn.Open();
using (SQLiteCommand command = conn.CreateCommand())
{
command.CommandText = "SELECT id,reco,m,n,e,mid from DOSAGE where id = @id";
command.Parameters.Add(new SQLiteParameter("@id", id));
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
m = (Int64) reader["m"];
n = (Int64) reader["n"];
e = (Int64) reader["e"];
mid = (Int64)reader["mid"];
reco = (string) reader["reco"];
}
}
if (mid > 0)
{
command.CommandText = "SELECT id,medicine from MEDICINES where id = @id";
command.Parameters.Add(new SQLiteParameter("@id", mid));
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
medname = (string)reader["medicine"];
}
}
}
if (mid != -1)
{
Dosage d = new Dosage(reco, new Medicine((int)mid, medname));
d.setDose((int)m, (int)n, (int)e);
return d;
}
}
}
return null;
}
public static List<Dosage> getPrescribedDoses(int prescriptionId)
{
//select M.medicine,D.mid,D.reco,D.m,D.n,D.e from PRESCRIPTION_DOSAGE PD,DOSAGE D,MEDICINES M where PD.did = D.id AND D.mid = M.id AND PD.pid = 23
List<Dosage> doses = new List<Dosage>();
using (SQLiteConnection conn = getConnection())
{
conn.Open();
using (SQLiteCommand command = conn.CreateCommand())
{
command.CommandText = "select M.medicine,D.mid,D.reco,D.m,D.n,D.e from PRESCRIPTION_DOSAGE PD,DOSAGE D,MEDICINES M where PD.did = D.id AND D.mid = M.id AND PD.pid = @prescriptionId";
command.Parameters.Add(new SQLiteParameter("@prescriptionId", prescriptionId));
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Dosage d = new Dosage((string)reader["reco"], new Medicine( (int)((Int64)reader["mid"]) , (string)reader["medicine"]));
d.setDose( (int)(Int64)reader["m"],
(int)(Int64)reader["n"],
(int)(Int64)reader["e"]
);
doses.Add(d);
}
}
}
}
return doses;
}
public void addCurrentDosageToGrid()
{
TextBox t = null;
string mi, ni, ei, di;
textViews.TryGetValue("morningRoot_txt", out t);
mi = t.Text;
textViews.TryGetValue("afternoonRoot_txt", out t);
ni = t.Text;
textViews.TryGetValue("eveningRoot_txt", out t);
ei = t.Text;
textViews.TryGetValue("dosageRoot_txt", out t);
di = t.Text;
if (currentDosage.getMedicine() == null) // we have'nt seen this med before so lets save it.
{
textViews.TryGetValue("medicationRoot_txt", out t);
int medId = DB.addMedicine(t.Text);
Medicine newMed = new Medicine(medId, t.Text);
currentDosage = new Dosage(di, newMed);
currentDosage.setDose(Int32.Parse(mi), Int32.Parse(ni), Int32.Parse(ei));
}
else
{
currentDosage.replaceIfUpdated(di, Int32.Parse(mi), Int32.Parse(ni), Int32.Parse(ei));
}
int[] mne = currentDosage.getDose();
medGrid.Rows.Add(currentDosage.getMedicine().getName(), currentDosage.getRecommended(),
mne[0], mne[1], mne[2]);
patientInView.getCurrentPrescription().add(currentDosage);
currentDosage = new Dosage("", null);
}