public void Insert(string p_id, ExaminationType e)
{
IDatabase db = new MSSqlDatabase();
db.Connect();
DbCommand command = db.CreateCommand(sqlINSERT);
PrepareCommand(db, command, e);
e.Id = db.ExecuteScalar(command);
db.Close();
}
public void Delete(ExaminationType e)
{
IDatabase db = new MSSqlDatabase();
db.Connect();
DbCommand command = db.CreateCommand(sqlDELETE);
command.Parameters.Add(db.CreateParameter("@id", "int"));
command.Parameters["@id"].Value = e.Id;
db.ExecuteNonQuery(command);
db.Close();
}
private List<ExaminationType> Read(DbDataReader reader, IDatabase db)
{
List<ExaminationType> types = new List<ExaminationType>();
while (reader.Read())
{
ExaminationType e = new ExaminationType();
e.Id = reader.GetInt32(0);
e.Name = reader.GetString(1);
e.Description = reader.GetString(2);
e.Prices = this.SelectPrices(e.Id, db);
types.Add(e);
}
return types;
}
private void PrepareCommand(IDatabase db, DbCommand cmd, ExaminationType er)
{
cmd.Parameters.Add(db.CreateParameter("@name", "varchar", er.Name.Length));
cmd.Parameters["@name"].Value = er.Name;
cmd.Parameters.Add(db.CreateParameter("@description", "varchar", er.Description.Length));
cmd.Parameters["@description"].Value = er.Description;
}