public static Prescription getPrescription(int prescriptionId)
{
Prescription pres = null;
using (SQLiteConnection conn = getConnection())
{
conn.Open();
using (SQLiteCommand command = conn.CreateCommand())
{
command.CommandText = "select id,cdate,page,diagnosis,uid from Prescription where id = @prescriptionId";
command.Parameters.Add(new SQLiteParameter("@prescriptionId", prescriptionId));
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
pres = new Prescription(
(string)reader["diagnosis"],
(Int64)reader["id"],
(DateTime)reader["cdate"],
(Int64)reader["page"]
);
pres.updatePatientId((int)(Int64)reader["uid"]);
}
}
}
}
return pres;
}
public Patient(string pName, int dbId, int age)
{
this.id = dbId;
this.currentAge = age;
this.name = pName;
currentPrescription = new Prescription(-1,this.id, this.currentAge);
}
