public Medicine Find(int key)
{
IDatabase db = new MSSqlDatabase();
db.Connect();
db.BeginTransaction();
DbCommand command = db.CreateCommand(sqlSELECT);
command.Parameters.Add(db.CreateParameter("@id", "int"));
command.Parameters["@id"].Value = key;
DbDataReader reader = db.Select(command);
Dictionary<int, Medicine> medicines = this.Read(reader, db);
reader.Close();
db.EndTransaction();
db.Close();
if (medicines.Count == 0)
return null;
else
return medicines.Values.ToList()[0];
}
public List<ExaminationType> SelectAll()
{
IDatabase db = new MSSqlDatabase();
db.Connect();
DbCommand command = db.CreateCommand(sqlSELECT);
DbDataReader reader = db.Select(command);
List<ExaminationType> e = this.Read(reader, db);
reader.Close();
db.Close();
return e;
}
public ExaminationType Find(int id)
{
IDatabase db = new MSSqlDatabase();
db.Connect();
DbCommand command = db.CreateCommand(sqlFIND);
DbDataReader reader = db.Select(command);
ExaminationType e = this.Read(reader, db)[0];
reader.Close();
db.Close();
return e;
}
public List<Request> SelectRequests(string p_id)
{
IDatabase db = new MSSqlDatabase();
db.Connect();
DbCommand command = db.CreateCommand(sqlSELECT);
command.Parameters.Add(db.CreateParameter("@id", "char", p_id.Length));
command.Parameters["@id"].Value = p_id;
DbDataReader reader = db.Select(command);
List<Request> p = this.Read(reader);
reader.Close();
db.Close();
return p;
}
public Dictionary<int, Medicine> LoadAsDict()
{
IDatabase db = new MSSqlDatabase();
db.Connect();
db.BeginTransaction();
DbCommand command = db.CreateCommand(sqlSELECTALL);
DbDataReader reader = db.Select(command);
Dictionary<int, Medicine> medicines = this.Read(reader, db);
reader.Close();
db.EndTransaction();
db.Close();
return medicines;
}